You use MySQL monitors to check metrics of your MySQL databases.
Requirements
-
Download the MySQL Connector and put it in the ReadyAPI\bin\ext directory.
-
Create a database user account to connect to the MySQL database. For instructions on creating a new database user, see Preparing Servers For Monitoring.
Monitor Settings
-
Port – The port used to communicate with the server.
-
UserName – The user account ReadyAPI uses to connect to the database.
-
Password – The password used to connect to the server.
Frequently Used Metrics
MySQL database metrics contain information about the database usage during the test run. ReadyAPI displays the following statistics in charts by default:
-
Query count – Queries – The total number of queries to the database during the test run. Database queries usually involve reading data from the hard drive and can take some time. The queries that hit cached data are much faster.
-
Query count – Slow_queries – The number of queries that took longer than specified in the
long_query_timeparameter. Slow queries affect overall server response time.
Here are some other frequently used metrics:
-
Query cache – Qcache_hits – The number of queries that match to cached files. Matching cached files is faster, but your server cannot keep everything cached, so the ratio is important.
-
IO – Bytes sent and IO – Bytes received – These values show the number of bytes that your server sent and received. If there are too many requests, your server may be unable to handle the necessary throughput. In this case, you will need a wider Internet connection.
Other Metrics
The available statistics are a subset of MySQL built-in Server Status Variables presented here. You can find a full list of server status variables on the MySQL website. Note: Some metrics may be unavailable on some MySQL server versions.
| Category | Description | Metrics |
|---|---|---|
|
Connections |
Provides information about connections to the server. |
Aborted_clients Threads_connected Threads_cached Threads_running Slow_launch_threads |
|
Command count |
Provides information about commands sent to the server. |
Flush_commands Handler_commit Handler_delete Handler_rollback Handler_savepoint Handler_savepoint_rollback Handler_update Handler_write |
|
InnoDB |
Provides information from the MInnoDB storage engine. |
Innodb_buffer_pool_wait_free Innodb_pages_created Innodb_pages_read Innodb_pages_written Innodb_row_lock_current_waits Innodb_row_lock_time_avg Innodb_row_lock_waits |
|
IO |
Provides information about the input/output operations. |
Bytes_received Bytes_sent Open_files |
|
Key rates |
Provides information about the efficiency of using index caches from MySQL memory. |
Key_blocks_not_flushed Key_blocks_unused Key_blocks_used Key_read_requests Key_reads Key_write_requests Key_writes |
|
Query cache |
Provides information about the server cache query. |
Qcache_free_blocks Qcache_total_blocks Qcache_hits Qcache_inserts Qcache_lowmem_prunes Qcache_not_cached Qcache_queries_in_cache |
|
Query count |
Provides information about the server queries. |
Queries Slow_queries Select_full_join Select_range Select_range_check |
|
Read rates |
Shows the read reliability of the server. |
Handler_read_first Handler_read_key Handler_read_next Handler_read_prev Handler_read_rnd Handler_read_rnd_next |
|
Sort count |
Shows a reference to sorted objects. |
Sort_merge_passes Sort_range Sort_rows Sort_scan |
|
Tables |
Provides information about tables in the database. |
Open_tables Opened_tables Table_locks_immediate Table_locks_waited Created_tmp_disk_tables |
See Also
Preparing Servers for Monitoring
Server Inspector
Load Testing Templates