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 (2)

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