DB Management — MySQL

There are some useful commands that you can run on mysql server to monitor and manage server efficiently and debug errors.

1. show processlist; — here time show the time since it is open and info == NULL means it is idle
2. show full processlist;
3. kill <pid> (CAUTION: use this with utmost care)
4. SHOW VARIABLES LIKE “max_connections”;
5. show status like 'Con%'