MySQL Database Monitoring
These monitors collect the main performance statistics for MySQL database servers. The data collected will help you evaluate your database's performance during the load test and pinpoint any problems related either to the application's development or to the various server parameter settings.
An application server's default settings for database access, and the default settings of the databases themselves (connection pools, dedicated memory allocation, table indexation etc.), are not always suited to the application itself and often need to be adjusted. The load test, with the MySQL server monitoring, allows you to tweak these settings and observe any subsequent improvement or deterioration in performance.
As monitoring is carried out non-intrusively; no special configuration is required for the server.
Supported versions: MySQL 4.1, 5.x and 6.0.
Performance Counters
Monitors are classified by category, each category providing several performance counters for memory, call speed, cache use ratios etc.
The monitor categories are:
-
Connections. Shows the number of open, system and idle connections for the database.
-
IO requests. Shows the number of bytes received and sent to the server.
-
Select Rates. Shows the select rate sent to the server.
-
Read Rates. Shows the read rate sent to the server.
-
Key Rates.Shows the key rate sent to the server.
-
Commands Rates. Shows the rate of the different commands sent to the server.
-
Query Cache. Shows the query cache state.
-
Tables. Shows the usage of the tables of the server.
-
Memory. Shows the memory allocated to the various pools and buffers.
-
Miscellaneous. Provides various ratios to help optimize database settings for the requests made to it.
Neotys News