wp-content » plugins » View current MySQL Processes in WordPress

View current MySQL Processes in WordPress

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
image 24 - View current MySQL Processes in WordPress
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.

image 6 1024x502 - View current MySQL Processes in WordPress
MySQL Process List WordPress plugin

Was this post helpful?

Leave a Comment

I enjoy constructive responses and professional comments to my posts, and invite anyone to comment or link to my site.

Recommended