Blog Archives

How to see whats running in MySQL

Short List Show Processlist; Detailed List Show full Processlist; If you like the linux TOP or HTOP try this: watch -n1 ‘echo “show processlist” | mysql -uyourusername -pyourpass | grep -v “show processlist”‘ Save it as a .file. but make

Tagged with:
Posted in Data Warehouse, ETL, Linux, MySQL, SQL

How to restart MySQL

FEDORA/REDHAT sudo /etc/init.d/mysqld restart Ubuntu sudo /etc/init.d/mysql restart WINDOWS Install Linux

Tagged with:
Posted in Linux, MySQL