Applies to ReadyAPI 3.0, last modified on November 19, 2019

You use MySQL monitors to check metrics of your MySQL databases.

Requirements

Monitor Settings

  • Port – The port used to communicate with the server.

  • UserName – The user account LoadUI 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. LoadUI 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_time parameter. 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 Scenarios

Highlight search results