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

Learn how to install MySQL plugin. Download the plugin from Site24x7 MySQL GitHub repository  

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:
Reply 1
Replies (5)

Re: Monitor the performance of your MySQL database servers

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

Reply 0

Re: Re: Monitor the performance of your MySQL database servers

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.

 

Thanks!

Reply 1

Re: Re: Re: Monitor the performance of your MySQL database servers

This plugin does not work with mysql 8+ 

 

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

Reply 0

Re: Monitor the performance of your MySQL database servers

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.


Re: Re: Monitor the performance of your MySQL database servers

Hi

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,

  Sriram

Reply 1