Go to All Forums

Monitor the performance of your MySQL database servers

Configure MySQL plugin to monitor the performance metrics of your MySQL database. Use these key indicators to ensure continuous functioning of your MySQL database. Take informed troubleshooting decisions by keeping track of critical metrics including:
  • Connection Usage
  • Slow Queries
  • Reads/Writes
  • Aborted Connections
  • Threads Connected
  • Maximum Used Connections
  • Aborted Clients
  • Open Files
  • Running Threads
  • Temporary Threads Created

Also, monitor the metrics of tables in a MySQL database using the MySql table monitoring plugin. Get the following metrics:
  • The average length of data present in the table
  • The average row length of the table
  • The maximum length of the data present in the table
  • The average index length required for the table
  • The number of rows present in the table at that time

Related resources:
Like (1) Reply
Replies (6)

What type of permissions does the MySQL user need for this plugin to function properly?

Like (0) Reply

Hi Robert,

       The MySQL user does not require any special privileges. It requires only the capability to connect to the MySQL server.

Please refer our help documentation for further assistance.



Like (0) Reply

This plugin does not work with mysql 8+ 


See github.com/PyMySQL/PyMySQL/issues/651

Like (0) Reply

Could you please fix github.com/site24x7/plugins/issues/9. This way the my.cnf can be used for authentication information thus easier to deploy on large scale.

Like (0) Reply


The MySQL configurations can be read from the my.cnf file. The changes have been done and updated in our GitHub Repository.

Please follow the steps below to start monitoring via the my.cnf file:

#1) Download the mysql.py file from our GitHub repository.

#2) Set USE_MYSQL_CONF_FILE to True.

#3) Provide the my.cnf file location in the field MY_CNF_FILE_LOCATION.

 Hope this helps. For any other queries, please comment in the below thread.


- Regards,


Like (0) Reply

Hi everyone, 

Here's the updated MySQL plugin, which you can download and install from our GitHub repository,
Like (0) Reply

Was this post helpful?