MySQL has a neat way of showing what current queries are being run against your database. It allows you to monitor and track down queries that are taking up server resources.

All you have to type is:

show PROCESSLIST;

You can submit this statement to the MySQL instance via the MySQL client utility or under the SQL tab in phpMyAdmin.

MySQL show PROCESSLIST result

Leave a comment

Your email address will not be published. Required fields are marked *