MySQL Troubleshooting

From ben.goodacre.name/tech

Contents 1 Get current processes and queries 2 Get number of queries currently running 3 Get number of queries since the server was started 4 See Also

Get current processes and queries

mysql> show processlist;

Get number of queries currently running

mysql> show status like 'Threads_connected';

Get number of queries since the server was started

mysql> show status like 'Threads_created';

See Also

Linux Troubleshooting