Configure MySQL plugin to monitor the performance metrics of your MySQL database. Ensure an efficient and easy to use MySQL databse monitoring experience through vital actionable information. Take informed troubleshooting decisions with our database monitoring service using critical metrics like connection usage, slow queries, reads/writes and lot more. Learn how the plugin works.
MySQL performance monitoring metrics:
Use our wide array of metrics and get notified of hazardous errors that require your attention. Keep track of unexpected trends through our metric graphs and troubleshoot as quickly as possible. Various out-of-the-box metrics we support are:
Total connection count with respect to the percentage of maximum connections in the database. This information can be used to tune database connections for better performance.
Number of reads done in a MySQL server. Technically, it is the number of selected queries and number of query cache hits.
Number of writes done in a MySQL server. It is the sum of inserted queries, replaced queries, updated queries and deleted queries.
Number of slow queries running on the MySQL server. Slow queries generate excessive disk reads, memory and CPU usage.
Maximum Used Connections
Maximum number of connections at a given time, since the start of the server. If your server reaches the maximum connections limit, it will start to refuse additional connection requests.
The total number of connections that were aborted because the client died without closing the connection properly. If a client is unable to connect, the server increments the Aborted Connects status variable.
Number of failed attempts to connect to the MySQL server. If this counter is increasing, your clients are trying and failing to connect to the database.
The number of files that are open. This count includes regular files opened by the server. It does not include other types of files such as sockets or pipes. Also, the count does not include files that storage engines open using their own internal functions rather than asking the server level to do so.
Number of threads that are currently running in the database. This number also signifies the total number of threads that are not sleeping.
Number of currently open connections. It can also refer to the number of clients currently connected. If the value is zero or too high, something is wrong.
Temporary Threads Created
Number of internal temporary tables created by the MySQL server. If the value is high, you may want to increase the thread cache size value.
Temporary Tables Created on the Disk
The number of internal on-disk temporary tables created by the server while executing statements.
How it works?
- Log-in to your Site24x7 account. Sign up here if you don't have one.
- Download and install the latest version of Site24x7 Linux Agent
- Install the MySQL plugin
- The agent will execute the MySQL plugin and push the data to the Site24x7 server
- Site24x7 MySQL plugin uses "pymysql" module to get the performance metrics of MySQL server
Note: Site24x7 Linux agent will automatically try to install "pymysql" using the "pip" command. If the installations fails, users can manually install the module following the steps mentioned under the section "How to install pymysql?".