MySQL Process List is used to display currently active MySQL connections. It can be useful to view current queries, detect sleep connections, and if some connection limits are reached.
If on your hosting server, you have access to the terminal, you can u list MySQL processes using the command:
mysql> SHOW FULL PROCESSLIST
Here is a simple WordPress plugin that will allow you to view the current MySQL process list in real-time directly from wp-admin:
The plugin uses SHOW FULL PROCESSLIST to display the full query and will handle the AJAX request every 10 seconds to refresh the MySQL process list and display the updated process list in the table.
Activate the plugin from the WordPress admin panel. Navigate to Tools > MySQL Process List to view current processes.
Was this post helpful?
Let me know if you liked the post. That’s the only way I can improve. 🙂
