The following items describe individual graphs.
| Name | Agent Reporting Delay |
| Range Label | milliseconds |
| Series | Expression |
| Delay | agent_delay |
| Variables | Data Item |
| agent_delay | mysql:Agent:agent.latency |
| Name | Backup Locked Time |
| Range Label | seconds |
| Series | Expression |
| Locked Time | lock_time |
| Variables | Data Item |
| lock_time | mysql:meb_timing:lock_time |
| Name | Backup Run Time |
| Range Label | seconds |
| Series | Expression |
| Total Time | total_time |
| Variables | Data Item |
| total_time | mysql:meb_timing:total_time |
| Name | Binlog Cache Efficiency |
| Range Label | avg cache ops/sec |
| Series | Expression |
| Cache Writes | (binlog_memory/60) |
| Disk Writes | (binlog_disk/60) |
| Variables | Data Item |
| binlog_disk | mysql:status:Binlog_cache_disk_use |
| binlog_memory | mysql:status:Binlog_cache_use |
| Name | Binlog IO Usage |
| Range Label | avg MB/sec |
| Series | Expression |
| Read | ((bytes_read / (1024*1024))/60) |
| Total | (((bytes_read + bytes_written) / (1024*1024))/60) |
| Write | ((bytes_written / (1024*1024))/60) |
| Variables | Data Item |
| bytes_read | mysql:binary_log_io:bytes_read |
| bytes_written | mysql:binary_log_io:bytes_written |
| Name | Binlog Space Usage |
| Range Label | MB |
| Series | Expression |
| Total Size | (fileSum / (1024*1024)) |
| Variables | Data Item |
| fileSum | mysql:masterlogs:filesizesum |
Cluster Data Node Data Memory Use
| Name | Cluster Data Node Data Memory Use |
| Range Label | MB |
| Series | Expression |
| Avail | cluster_data_node_config_data_memory/1024/1024 |
| Used | cluster_data_node_used_data_memory/1024/1024 |
| Variables | Data Item |
| cluster_data_node_config_data_memory | mysql:cluster_data_node_data_memory:data_mem_total |
| cluster_data_node_used_data_memory | mysql:cluster_data_node_data_memory:data_mem_used |
Cluster Data Node DiskPageBuffer Hit Ratio
| Name | Cluster Data Node DiskPageBuffer Hit Ratio |
| Range Label | % |
| Series | Expression |
| DiskPageBuffer | (cluster_data_node_hits/(cluster_data_node_hits+cluster_data_node_miss))*100 |
| Variables | Data Item |
| cluster_data_node_hits | mysql:cluster_data_node_diskpagebuffer_total_hits_period:buffer_hit_per |
| cluster_data_node_miss | mysql:cluster_data_node_diskpagebuffer_total_hits_period:buffer_missed_per |
Cluster Data Node Index Memory Use
| Name | Cluster Data Node Index Memory Use |
| Range Label | MB |
| Series | Expression |
| Avail | cluster_data_node_config_index_memory/1024/1024 |
| Used | cluster_data_node_used_index_memory/1024/1024 |
| Variables | Data Item |
| cluster_data_node_config_index_memory | mysql:cluster_data_node_index_memory:index_mem_total |
| cluster_data_node_used_index_memory | mysql:cluster_data_node_index_memory:index_mem_used |
Cluster Data Node Redo Buffer Use
| Name | Cluster Data Node Redo Buffer Use |
| Range Label | MB |
| Series | Expression |
| Avail | cluster_data_node_config_redo_buffer/1024/1024 |
| Used | cluster_data_node_used_redo_buffer/1024/1024 |
| Variables | Data Item |
| cluster_data_node_config_redo_buffer | mysql:cluster_data_node_redo_buffer:redo_buffer_total |
| cluster_data_node_used_redo_buffer | mysql:cluster_data_node_redo_buffer:redo_buffer_used |
Cluster Data Node Redo Log Space Use
| Name | Cluster Data Node Redo Log Space Use |
| Range Label | MB |
| Series | Expression |
| Avail | cluster_data_node_config_redo_logspace/1024/1024 |
| Used | cluster_data_node_used_redo_logspace/1024/1024 |
| Variables | Data Item |
| cluster_data_node_config_redo_logspace | mysql:cluster_data_node_redo_logspace:redo_logspace_total |
| cluster_data_node_used_redo_logspace | mysql:cluster_data_node_redo_logspace:redo_logspace_used |
Cluster Data Node Undo Buffer Use
| Name | Cluster Data Node Undo Buffer Use |
| Range Label | MB |
| Series | Expression |
| Avail | cluster_data_node_config_undo_buffer/1024/1024 |
| Used | cluster_data_node_used_undo_buffer/1024/1024 |
| Variables | Data Item |
| cluster_data_node_config_undo_buffer | mysql:cluster_data_node_undo_buffer:undo_buffer_total |
| cluster_data_node_used_undo_buffer | mysql:cluster_data_node_undo_buffer:undo_buffer_used |
Cluster Data Node Undo Log Space Use
| Name | Cluster Data Node Undo Log Space Use |
| Range Label | MB |
| Series | Expression |
| Avail | cluster_data_node_config_undo_logspace/1024/1024 |
| Used | cluster_data_node_used_undo_logspace/1024/1024 |
| Variables | Data Item |
| cluster_data_node_config_undo_logspace | mysql:cluster_data_node_undo_logspace:undo_logspace_total |
| cluster_data_node_used_undo_logspace | mysql:cluster_data_node_undo_logspace:undo_logspace_used |
Cluster Data Nodes in Ready State
| Name | Cluster Data Nodes in Ready State |
| Range Label | # Nodes |
| Series | Expression |
| Nodes | Ndb_number_of_ready_data_nodes |
| Variables | Data Item |
| Ndb_number_of_ready_data_nodes | mysql:status:Ndb_number_of_ready_data_nodes |
Displays the number of client connections by displaying the number of connected threads, active threads, and cached threads.
| Name | Connections |
| Range Label | # connections |
| Series | Expression |
| Cached | cached |
| Running | running |
| Total | connected |
| Variables | Data Item |
| cached | mysql:status:Threads_cached |
| connected | mysql:status:Threads_connected |
| running | mysql:status:Threads_running |
Shows the number of client connections that have been aborted, either during connection, or aborted active connections. This information is useful to determine if your server is overloaded (and therefore aborting connections), or if there is a network fault. Aborted connections also indicate those which did not disconnect properly, for example during a timeout.
| Name | Connections - Aborted |
| Range Label | total/min |
| Series | Expression |
| Clients | clients |
| Connections | connections |
| Variables | Data Item |
| clients | mysql:status:Aborted_clients |
| connections | mysql:status:Aborted_connects |
Displays the thread cache information, comparing new thread creations against all database connections.
| Name | Connections - Cache |
| Range Label | total/min |
| Series | Expression |
| Connections | connections |
| Threads Created | tcreated |
| Variables | Data Item |
| connections | mysql:status:Connections |
| tcreated | mysql:status:Threads_created |
Shows the maximum number of connections, and the maximum number of used connections.
| Name | Connections - Maximum |
| Range Label | total |
| Series | Expression |
| Allowed | max_connections_allowed |
| Used | max_connections_used |
| Variables | Data Item |
| max_connections_allowed | mysql:variables:max_connections |
| max_connections_used | mysql:status:Max_used_connections |
Displays the CPU usage statistics over time for the machine hosting the MySQL server. The graph shows the aggregate system, user, wait and idle times for your CPU(s). You can use this information to help determine your CPU utilization and whether you are getting the most efficient use of your CPU power.
The FreeBSD and Windows operating systems do not provide
information for the IO-wait component of these graphs, so they
will always yield 0 in the CPU utilization
graph.
| Name | CPU Utilization |
| Range Label | % |
| Series | Expression |
| Kernel | sys/(sys+user+wait+idle)*100 |
| Total | (sys+user+wait)/(sys+user+wait+idle)*100 |
| User | user/(sys+user+wait+idle)*100 |
| Wait I/O | wait/(sys+user+wait+idle)*100 |
| Variables | Data Item |
| idle | os:cpu:cpu_idle |
| sys | os:cpu:cpu_sys |
| user | os:cpu:cpu_user |
| wait | os:cpu:cpu_wait |
Displays the database activity, by showing the individual counts
over time of different DML statements per minute. For example, you
can monitor the number of SELECT statements
executed per minute over time and gain an understanding of your
server throughput. This information can be used to monitor the
activity level, and provide a useful quick reference for your
server operation.
| Name | Database Activity |
| Range Label | avg statements/sec |
| Series | Expression |
| Call | ((call_proc)/60) |
| Delete | ((deletes+delete_multi)/60) |
| Insert | ((inserts+insert_selects)/60) |
| Replace | ((replaces+replace_selects)/60) |
| Select | (selects/60) |
| Update | ((updates+update_multi)/60) |
| Variables | Data Item |
| call_proc | mysql:status:Com_call_procedure |
| delete_multi | mysql:status:Com_delete_multi |
| deletes | mysql:status:Com_delete |
| insert_selects | mysql:status:Com_insert_select |
| inserts | mysql:status:Com_insert |
| replace_selects | mysql:status:Com_replace_select |
| replaces | mysql:status:Com_replace |
| selects | mysql:status:Com_select |
| update_multi | mysql:status:Com_update_multi |
| updates | mysql:status:Com_update |
| Name | Database Transactions |
| Range Label | avg statements/sec |
| Series | Expression |
| Begin | (begin/60) |
| Commit | (commit/60) |
| Release Savepoint | (releaseSavepoint/60) |
| Rollback | (rollback/60) |
| Rollback Savepoint | (rollbackSavepoint/60) |
| Savepoint | (savepoint/60) |
| Variables | Data Item |
| begin | mysql:status:com_begin |
| commit | mysql:status:com_commit |
| releaseSavepoint | mysql:status:com_release_savepoint |
| rollback | mysql:status:com_rollback |
| rollbackSavepoint | mysql:status:com_rollback_to_savepoint |
| savepoint | mysql:status:com_savepoint |
| Name | Disk IO Operations |
| Range Label | avg ops/sec |
| Series | Expression |
| Read | read / 60 |
| Total | ((read+write) / 60) |
| Write | write / 60 |
| Variables | Data Item |
| read | os:disk:disk_reads |
| write | os:disk:disk_writes |
Displays the disk usage activity, by showing the disk input and output ratios over time.
The FreeBSD and Windows operating systems do not provide this information.
| Name | Disk IO Usage |
| Range Label | avg MB/sec |
| Series | Expression |
| Read | ((read / (1024*1024))/60) |
| Total | (((read+write) / (1024*1024))/60) |
| Write | ((write / (1024*1024))/60) |
| Variables | Data Item |
| read | os:disk:disk_bytes_read |
| write | os:disk:disk_bytes_written |
| Name | Disk Space Usage |
| Range Label | GB |
| Series | Expression |
| Total Size | (total / (1024*1024*1024)) |
| Used | (used / (1024*1024*1024)) |
| Variables | Data Item |
| total | os:fs:fs_total |
| used | os:fs:fs_used |
Shows the cache hit ratios (as a percentage) for the query cache, MyISAM and InnoDB tables, and the connection and thread cache information. The information provided by the hit ratios can provide indicators of whether your cache is working effectively, or is of a size suitable for the data that you are storing and retrieving. Low hit ratios indicate that your cache are inefficient and may need to be investigated.
| Name | Hit Ratios |
| Range Label | % |
| Series | Expression |
| InnoDB Buffer | 100-((iReads / (iReadRequests+1))*100) |
| Key Cache | (100-((keyReads / (keyReadRequests+1))*100)) * (keyReadRequests
>= keyReads) |
| Query Cache | (qHits/(qHits+qInserts+1))*100 |
| Thread Cache | 100-((tcreated / (connections+1))*100) |
| Variables | Data Item |
| connections | mysql:status:Connections |
| iReadRequests | mysql:status:Innodb_buffer_pool_read_requests |
| iReads | mysql:status:Innodb_buffer_pool_reads |
| keyReadRequests | mysql:status:Key_read_requests |
| keyReads | mysql:status:Key_reads |
| qHits | mysql:status:Qcache_hits |
| qInserts | mysql:status:Qcache_inserts |
| tcreated | mysql:status:Threads_created |
InnoDB Adaptive Hash Index Memory
Shows the size of the InnoDB adaptive hash index. These are used to hold the data from tables in memory providing the size of the indexes is small enough to fit in memory. The graph shows the memory usage of the adaptive hash index.
| Name | InnoDB Adaptive Hash Index Memory |
| Range Label | MB |
| Series | Expression |
| Hash Node Size | ( hash_size * 16384 ) / 1024 / 1024 |
| Variables | Data Item |
| hash_size | mysql:innodbstatus:innodb_hash_node_heap |
InnoDB Adaptive Hash Index Searches
Displays the number of InnoDB adaptive hash index searches and those searches not using the adaptive hash index. You can use this to determine if your adaptive hash index is being used correctly, and is of a suitable size of the information and tables that are being accessed.
| Name | InnoDB Adaptive Hash Index Searches |
| Range Label | searches/sec |
| Series | Expression |
| Hash Searches | hash |
| Non-Hash Searches | nonhash |
| Variables | Data Item |
| hash | mysql:innodbstatus:innodb_hash_searches_per_sec |
| nonhash | mysql:innodbstatus:innodb_non_hash_searches_per_sec |
Displays the size and page usage of the InnoDB buffer pool, providing information on the cache usage and performance. The graph shows the buffer pool size, active pages, and the number of modified pages.
| Name | InnoDB Buffer Pool |
| Range Label | MB |
| Series | Expression |
| Modified | (modified*16384)/(1024*1024) |
| Old | (old*16384)/(1024*1024) |
| Total Size | (size*16384)/(1024*1024) |
| Used | (used*16384)/(1024*1024) |
| Variables | Data Item |
| modified | mysql:innodbstatus:innodb_bp_modified_pages |
| old | mysql:innodbstatus:innodb_bp_old_db_pages |
| size | mysql:innodbstatus:innodb_bp_size |
| used | mysql:innodbstatus:innodb_bp_db_pages |
InnoDB Buffer Pool Page Activity
| Name | InnoDB Buffer Pool Page Activity |
| Range Label | avg pages/sec |
| Series | Expression |
| Created | created / 60 |
| Read | reads / 60 |
| Written | written / 60 |
| Variables | Data Item |
| created | mysql:innodbstatus:innodb_bp_pages_created |
| reads | mysql:innodbstatus:innodb_bp_pages_read |
| written | mysql:innodbstatus:innodb_bp_pages_written |
InnoDB Buffer Pool Pending Operations
| Name | InnoDB Buffer Pool Pending Operations |
| Range Label | pending ops |
| Series | Expression |
| Reads | reads |
| Write Flush List | write_flush_list |
| Write LRU | write_lru |
| Write Single Page | write_single_page |
| Variables | Data Item |
| reads | mysql:innodbstatus:innodb_bp_pending_pages |
| write_flush_list | mysql:innodbstatus:innodb_bp_pending_writes_flush_list |
| write_lru | mysql:innodbstatus:innodb_bp_pending_writes_lru |
| write_single_page | mysql:innodbstatus:innodb_bp_pending_writes_single_page |
| Name | InnoDB Change Buffer Activity |
| Range Label | avg operations/sec |
| Series | Expression |
| Inserts | inserts / 60 |
| Merges | merges / 60 |
| Variables | Data Item |
| inserts | mysql:innodbstatus:innodb_ibuf_inserts |
| merges | mysql:innodbstatus:innodb_ibuf_merges |
| Name | InnoDB Change Buffer Activity |
| Range Label | avg operations/sec |
| Series | Expression |
| Delete Discarded | delete_discarded / 60 |
| Delete Mark Discarded | delete_mark_discarded / 60 |
| Delete Mark Merges | delete_mark_merges / 60 |
| Delete Merges | delete_merges / 60 |
| Insert Discarded | insert_discarded / 60 |
| Insert Merges | insert_merges / 60 |
| Variables | Data Item |
| delete_discarded | mysql:innodbstatus:innodb_cbuf_delete_discarded |
| delete_mark_discarded | mysql:innodbstatus:innodb_cbuf_delete_mark_discarded |
| delete_mark_merges | mysql:innodbstatus:innodb_cbuf_delete_mark_merges |
| delete_merges | mysql:innodbstatus:innodb_cbuf_delete_merges |
| insert_discarded | mysql:innodbstatus:innodb_cbuf_insert_discarded |
| insert_merges | mysql:innodbstatus:innodb_cbuf_insert_merges |
| Name | InnoDB Change Buffer Usage |
| Range Label | MB |
| Series | Expression |
| Total Size | (total * 16384) / (1024 * 1024) |
| Used | ((total - free) * 16384) / (1024 * 1024) |
| Variables | Data Item |
| free | mysql:innodbstatus:innodb_ibuf_free_list_len |
| total | mysql:innodbstatus:innodb_ibuf_seg_size |
Shows the time spent by InnoDB compressing and uncompressing data in compressed tables.
| Name | InnoDB Compression Time |
| Range Label | secs per min |
| Series | Expression |
| Compressing | compress |
| Uncompressing | uncompress |
| Variables | Data Item |
| compress | mysql:innodb_compression_time:compress_seconds |
| uncompress | mysql:innodb_compression_time:uncompress_seconds |
| Name | InnoDB Data Dictionary Memory |
| Range Label | MB |
| Series | Expression |
| Dictionary Memory Allocated | (dict)/(1024*1024) |
| Variables | Data Item |
| dict | mysql:innodbstatus:innodb_bp_dictionary_alloc |
| Name | InnoDB Datafile IO Usage |
| Range Label | avg MB/sec |
| Series | Expression |
| Read | ((bytes_read / (1024*1024))/60) |
| Total | (((bytes_read + bytes_written) / (1024*1024))/60) |
| Write | ((bytes_written / (1024*1024))/60) |
| Variables | Data Item |
| bytes_read | mysql:innodb_datafile_io:bytes_read |
| bytes_written | mysql:innodb_datafile_io:bytes_written |
InnoDB Doublewrite Buffer Activity
| Name | InnoDB Doublewrite Buffer Activity |
| Range Label | avg/sec |
| Series | Expression |
| Pages Written | pages_written |
| Writes | writes |
| Variables | Data Item |
| pages_written | mysql:status:Innodb_dblwr_pages_written |
| writes | mysql:status:Innodb_dblwr_writes |
| Name | InnoDB Open Files |
| Range Label | total |
| Series | Expression |
| Currently Open | open |
| Max Allowed | max |
| Variables | Data Item |
| max | mysql:variables:innodb_open_files |
| open | mysql:status:innodb_num_open_files |
Displays the InnoDB I/O counts showing the number of
fsync, read, and write operations used to
support InnoDB tables.
| Name | InnoDB OS File Access |
| Range Label | avg operations/sec |
| Series | Expression |
| File fsync() | (fsync/60) |
| File Reads | (read/60) |
| File Writes | (write/60) |
| Redo Log | (log/60) |
| Variables | Data Item |
| fsync | mysql:innodbstatus:innodb_io_os_file_fsyncs |
| log | mysql:innodbstatus:innodb_log_io_total |
| read | mysql:innodbstatus:innodb_io_os_file_reads |
| write | mysql:innodbstatus:innodb_io_os_file_writes |
InnoDB Redo Log Checkpoint Lag
| Name | InnoDB Redo Log Checkpoint Lag |
| Range Label | MB |
| Series | Expression |
| Not Checkpointed | (lsn - checkpointed) / (1024 * 1024) |
| Not Flushed | (lsn - flushed) / (1024 * 1024) |
| Total Redo Log Size | (log_size * log_count) / (1024 * 1024) |
| Variables | Data Item |
| checkpointed | mysql:innodbstatus:innodb_log_checkpoint_lsn64 |
| flushed | mysql:innodbstatus:innodb_log_flushed_lsn64 |
| log_count | mysql:variables:innodb_log_files_in_group |
| log_size | mysql:variables:innodb_log_file_size |
| lsn | mysql:innodbstatus:innodb_log_sequence_lsn64 |
| Name | InnoDB Redo Log IO Usage |
| Range Label | avg MB/sec |
| Series | Expression |
| Read | ((bytes_read / (1024*1024))/60) |
| Total | (((bytes_read + bytes_written) / (1024*1024))/60) |
| Write | ((bytes_written / (1024*1024))/60) |
| Variables | Data Item |
| bytes_read | mysql:innodb_log_io:bytes_read |
| bytes_written | mysql:innodb_log_io:bytes_written |
InnoDB Redo Log Pending Writes
| Name | InnoDB Redo Log Pending Writes |
| Range Label | I/O ops |
| Series | Expression |
| Checkpoint Writes | checkpoint |
| Log Writes | log |
| Variables | Data Item |
| checkpoint | mysql:innodbstatus:innodb_log_pending_checkpoint_writes |
| log | mysql:innodbstatus:innodb_log_pending_log_writes |
Shows the row counts per minute for individual SQL operations
(READ, INSERT,
UPDATE and DELETE).
| Name | InnoDB Row Details |
| Range Label | avg rows/sec |
| Series | Expression |
| Rows Deleted | (deleted/60) |
| Rows Inserted | (inserted/60) |
| Rows Read | (read/60) |
| Rows Updated | (updated/60) |
| Variables | Data Item |
| deleted | mysql:innodbstatus:innodb_rows_deleted |
| inserted | mysql:innodbstatus:innodb_rows_inserted |
| read | mysql:innodbstatus:innodb_rows_read |
| updated | mysql:innodbstatus:innodb_rows_updated |
| Name | InnoDB Row Lock Time |
| Range Label | milliseconds |
| Series | Expression |
| Total | lock_time_total |
| Variables | Data Item |
| lock_time_total | mysql:status:Innodb_row_lock_time |
InnoDB Row Lock Time Statistics
| Name | InnoDB Row Lock Time Statistics |
| Range Label | milliseconds |
| Series | Expression |
| Avg | lock_time_avg |
| Max | lock_time_max |
| Variables | Data Item |
| lock_time_avg | mysql:status:Innodb_row_lock_time_avg |
| lock_time_max | mysql:status:Innodb_row_lock_time_max |
| Name | InnoDB Row Lock Waits |
| Range Label | total |
| Series | Expression |
| Row Lock Waits | row_lock_waits |
| Variables | Data Item |
| row_lock_waits | mysql:status:Innodb_row_lock_waits |
| Name | InnoDB Row Locks Current |
| Range Label | total |
| Series | Expression |
| Rows Locked | rows_locked |
| Rows Modified | rows_modified |
| Rows Waiting Lock | rows_waited |
| Variables | Data Item |
| rows_locked | mysql:innodb_current_trxs:rows_locked_total |
| rows_modified | mysql:innodb_current_trxs:rows_modified_total |
| rows_waited | mysql:innodb_current_trxs:row_locks_current_waits |
Displays the InnoDB semaphore status. The graph indicates the amount of time that different InnoDB threads have spent waiting due to the locks used to prevent the same structures being updated at the same time. A large number of threads waiting for the semaphores may be a result of disk I/O or connection problems inside InnoDB. You may want to modify your InnoDB thread concurrency.
| Name | InnoDB Semaphores |
| Range Label | avg waits/sec |
| Series | Expression |
| OS Waits | (oswaits/60) |
| Spin Rounds | (srounds/60) |
| Spin Waits | (swaits/60) |
| Variables | Data Item |
| oswaits | mysql:innodbstatus:innodb_sem_mutex_os_waits |
| srounds | mysql:innodbstatus:innodb_sem_mutex_rounds |
| swaits | mysql:innodbstatus:innodb_sem_mutex_spin_waits |
The size of the InnoDB transaction history. A high number may indicate a large number of open (uncommitted) transactions.
| Name | InnoDB Transaction History |
| Range Label | Undo Entries |
| Series | Expression |
| Undo Log Size | hist_len |
| Variables | Data Item |
| hist_len | mysql:innodbstatus:innodb_trx_history_list_length |
InnoDB Transaction Lock Memory
| Name | InnoDB Transaction Lock Memory |
| Range Label | MB |
| Series | Expression |
| Total Lock Memory | (bytes_total / (1024*1024)) |
| Variables | Data Item |
| bytes_total | mysql:innodb_current_trxs:lock_memory_bytes_total |
The number of blocked, locked, and active transactions. You can use this to determine the contention on tables for InnoDB transactions.
| Name | InnoDB Transactions |
| Range Label | total |
| Series | Expression |
| Committing | committing |
| Lock Waiting | lock_waiting |
| Rolling Back | rolling_back |
| Running | running |
| Variables | Data Item |
| committing | mysql:innodb_transactions:committing_count |
| lock_waiting | mysql:innodb_transactions:lock_wait_count |
| rolling_back | mysql:innodb_transactions:rolling_back_count |
| running | mysql:innodb_transactions:running_count |
| Name | InnoDB Undo Logs |
| Range Label | total |
| Series | Expression |
| Total | total |
| Used | (total - avail) |
| Variables | Data Item |
| avail | mysql:status:innodb_available_undo_logs |
| total | mysql:variables:innodb_undo_logs |
The load average of the server hosting the MySQL server. The load average shows the number of processes using or waiting for CPU time in the last 1, 5 and 15 minutes. Load averages showing a load highe than the number of CPU cores may indicate an overloaded server.
| Name | Load Average |
| Range Label | Load Average |
| Series | Expression |
| 1 | zero |
| 15 | two |
| 5 | one |
| Variables | Data Item |
| one | os:loadavg:1 |
| two | os:loadavg:2 |
| zero | os:loadavg:0 |
Displays the current amount of memory used by the agent, and by the Lua component of the agent.
| Name | Memory Usage - Agent |
| Range Label | MB |
| Series | Expression |
| Agent | agent_mem_size / 1024 / 1024 |
| Lua | lua_mem_size / 1024 / 1024 |
| Variables | Data Item |
| agent_mem_size | agent:proc:mem_resident |
| lua_mem_size | agent:lua:mem_size |
Displays the RAM usage on the server for the monitored MySQL instance. You should compare the total and used RAM values to ensure that you are not exceeding your available RAM, which will lead to swapping and performance issues.
| Name | Memory Usage - OS Resident |
| Range Label | MB |
| Series | Expression |
| Total | ram_total/(1024*1024) |
| Used | (ram_total-ram_unused)/(1024*1024) |
| Variables | Data Item |
| ram_total | os:mem:ram_total |
| ram_unused | os:mem:ram_unused |
Displays the use of swap space on the server for the monitored MySQL instance. High swap usage may indicate that your server needs more RAM or that your MySQL configuration needs to be modified, as high levels of swap will have a negative impact on performance.
| Name | Memory Usage - OS Virtual |
| Range Label | MB |
| Series | Expression |
| Total | swap_total/(1024*1024) |
| Used | (swap_total-swap_unused)/(1024*1024) |
| Variables | Data Item |
| swap_total | os:mem:swap_total |
| swap_unused | os:mem:swap_unused |
| Name | MyISAM Data File IO Usage |
| Range Label | avg MB/sec |
| Series | Expression |
| Read | ((bytes_read / (1024*1024))/60) |
| Total | (((bytes_read + bytes_written) / (1024*1024))/60) |
| Write | ((bytes_written / (1024*1024))/60) |
| Variables | Data Item |
| bytes_read | mysql:myisam_data_file_io:bytes_read |
| bytes_written | mysql:myisam_data_file_io:bytes_written |
| Name | MyISAM Index File IO Usage |
| Range Label | avg MB/sec |
| Series | Expression |
| Read | ((bytes_read / (1024*1024))/60) |
| Total | (((bytes_read + bytes_written) / (1024*1024))/60) |
| Write | ((bytes_written / (1024*1024))/60) |
| Variables | Data Item |
| bytes_read | mysql:myisam_index_file_io:bytes_read |
| bytes_written | mysql:myisam_index_file_io:bytes_written |
| Name | MyISAM Key Buffer Activity |
| Range Label | avg cache ops/sec |
| Series | Expression |
| Disk Reads | (reads/60) |
| Disk Writes | (writes/60) |
| Read Requests | (read_requests/60) |
| Write Requests | (write_requests/60) |
| Variables | Data Item |
| read_requests | mysql:status:Key_read_requests |
| reads | mysql:status:Key_reads |
| write_requests | mysql:status:Key_write_requests |
| writes | mysql:status:Key_writes |
Displays the efficiency of the MyISAM key index buffer usage. On a system using a lot of MyISAM tables, low usage indicates that your MyISAM key buffer size is too high (reducing the RAM available for other buffering). High usage may indicate that you need to increase your MyISAM key buffer size to help improve performance.
| Name | MyISAM Key Buffer Usage |
| Range Label | MB |
| Series | Expression |
| Modified | (blk_size*not_flushed)/1024/1024 |
| Total Size | key_buffer/1024/1024 |
| Used | (key_buffer - (blk_size*unused))/1024/1024 |
| Variables | Data Item |
| blk_size | mysql:variables:key_cache_block_size |
| key_buffer | mysql:variables:key_buffer_size |
| not_flushed | mysql:status:Key_blocks_not_flushed |
| unused | mysql:status:Key_blocks_unused |
Displays the total Kilobytes per minute of bytes transferred to/from the server by client applications. Spikes in this output may indicate an unusual application operation or connection.
| Name | Network - Database Throughput |
| Range Label | avg kbytes/sec |
| Series | Expression |
| Received | ((bytesIn/1024)/60) |
| Sent | ((bytesOut/1024)/60) |
| Total | (((bytesIn+bytesOut)/1024)/60) |
| Variables | Data Item |
| bytesIn | mysql:status:Bytes_received |
| bytesOut | mysql:status:Bytes_sent |
Network - Interface Throughput
| Name | Network - Interface Throughput |
| Range Label | avg kbytes/sec |
| Series | Expression |
| Received | ((read / 1024)/60) |
| Sent | ((write / 1024)/60) |
| Total | (((read+write) / 1024)/60) |
| Variables | Data Item |
| read | os:net:rx_bytes |
| write | os:net:tx_bytes |
The number of tables in the open state per minute.
| Name | Opened Tables |
| Range Label | total/min |
| Series | Expression |
| Opened Table Definitions | openedTableDefs |
| Opened Tables | openedTables |
| Variables | Data Item |
| openedTableDefs | mysql:status:Opened_table_definitions |
| openedTables | mysql:status:Opened_tables |
| Name | Prepared Statement API |
| Range Label | total/min |
| Series | Expression |
| stmt_close | (close_api - dealloc_sql) |
| stmt_execute | (execute_api - execute_sql) |
| stmt_fetch | fetch_api |
| stmt_prepare | ((prepare_api - reprepare_api) - prepare_sql) |
| Variables | Data Item |
| close_api | mysql:status:Com_stmt_close |
| dealloc_sql | mysql:status:Com_dealloc_sql |
| execute_api | mysql:status:Com_stmt_execute |
| execute_sql | mysql:status:Com_execute_sql |
| fetch_api | mysql:status:Com_stmt_fetch |
| prepare_api | mysql:status:Com_stmt_prepare |
| prepare_sql | mysql:status:Com_prepare_sql |
| reprepare_api | mysql:status:Com_stmt_reprepare |
Prepared Statement API Invalidations
| Name | Prepared Statement API Invalidations |
| Range Label | total/min |
| Series | Expression |
| stmt_reprepare | reprepare_api |
| Variables | Data Item |
| reprepare_api | mysql:status:Com_stmt_reprepare |
| Name | Prepared Statement SQL |
| Range Label | total/min |
| Series | Expression |
| DEALLOCATE PREPARE | dealloc_sql |
| EXECUTE | execute_sql |
| PREPARE | prepare_sql |
| Variables | Data Item |
| dealloc_sql | mysql:status:Com_dealloc_sql |
| execute_sql | mysql:status:Com_execute_sql |
| prepare_sql | mysql:status:Com_prepare_sql |
Prepared Statement Utilization
| Name | Prepared Statement Utilization |
| Range Label | total |
| Series | Expression |
| Max Prepared Statements | max_allowed |
| Open Prepared Statements | open |
| Variables | Data Item |
| max_allowed | mysql:variables:max_prepared_stmt_count |
| open | mysql:status:Prepared_stmt_count |
Query Cache Average Free Block Size
| Name | Query Cache Average Free Block Size |
| Range Label | kBytes |
| Series | Expression |
| Average Free Block Size | free_memory/free_blocks/1024 |
| Variables | Data Item |
| free_blocks | mysql:status:Qcache_free_blocks |
| free_memory | mysql:status:Qcache_free_memory |
Query Cache Average Query Size
| Name | Query Cache Average Query Size |
| Range Label | kBytes |
| Series | Expression |
| Average Query Size | ((size - free)/queries)/1024 |
| Min Block Size | min_res_unit/1024 |
| Variables | Data Item |
| free | mysql:status:Qcache_free_memory |
| min_res_unit | mysql:variables:query_cache_min_res_unit |
| queries | mysql:status:Qcache_queries_in_cache |
| size | mysql:variables:query_cache_size |
Displays the hits, inserts and queries not cacheable in the query cache. Low cache hits may indicate that your queries are being expired from the cache before they can be used, which may mean they are unsuitable for storing in the query cache.
| Name | Query Cache Efficiency |
| Range Label | avg cache ops/sec |
| Series | Expression |
| Hits | (hits/60) |
| Inserts | (inserts/60) |
| Not Cached | (not_cached/60) |
| Variables | Data Item |
| hits | mysql:status:Qcache_hits |
| inserts | mysql:status:Qcache_inserts |
| not_cached | mysql:status:Qcache_not_cached |
| Name | Query Cache Fragmentation |
| Range Label | # of Free Blocks |
| Series | Expression |
| Free Blocks | QCache_free_blocks |
| Variables | Data Item |
| QCache_free_blocks | mysql:status:QCache_free_blocks |
Displays the number of queries removed from the cache because the size of the query cache was not large enough to store the queries that can be cached. Try increasing your query cache size.
| Name | Query Cache Lowmem Prunes |
| Range Label | avg cache ops/sec |
| Series | Expression |
| Lowmem Prunes | (deletes/60) |
| Variables | Data Item |
| deletes | mysql:status:Qcache_lowmem_prunes |
Displays the free space and total size of the query cache.
| Name | Query Cache Memory |
| Range Label | MB |
| Series | Expression |
| Total Size | size/(1024*1024) |
| Used | ((size-free)/(1024*1024)) |
| Variables | Data Item |
| free | mysql:status:Qcache_free_memory |
| size | mysql:variables:query_cache_size |
Shows the number of queries stored in the query cache. In normal operation this should be a relatively constant figure. A large number of switches between high and low numbers may indicate that differently sized queries are being inserted into the query cache, and then later removed as a high number of smaller queries are added to the cache. Try increasing the size of your query cache.
| Name | Query Cache Queries |
| Range Label | num queries |
| Series | Expression |
| Queries in Cache | queries |
| Variables | Data Item |
| queries | mysql:status:Qcache_queries_in_cache |
Replication Master Semi-Sync Transactions
| Name | Replication Master Semi-Sync Transactions |
| Range Label | # of trxs |
| Series | Expression |
| Transactions Acknowledged | trxs_yes |
| Transactions Unacknowledged | trxs_no |
| Variables | Data Item |
| trxs_no | mysql:rpl_semi_sync_status:Rpl_semi_sync_master_no_tx |
| trxs_yes | mysql:rpl_semi_sync_status:Rpl_semi_sync_master_yes_tx |
Replication Master Semi-Sync Wait Time Averages
| Name | Replication Master Semi-Sync Wait Time Averages |
| Range Label | milliseconds |
| Series | Expression |
| Average Slave Wait Time | slave_waits / 1000 |
| Average Transaction Wait Time | trx_waits / 1000 |
| Variables | Data Item |
| slave_waits | mysql:rpl_semi_sync_status:Rpl_semi_sync_master_net_avg_wait_time |
| trx_waits | mysql:rpl_semi_sync_status:Rpl_semi_sync_master_tx_avg_wait_time |
Replication Master Semi-Sync Waiting Sessions
| Name | Replication Master Semi-Sync Waiting Sessions |
| Range Label | # of sessions |
| Series | Expression |
| Waiting Sessions | sessions_waiting |
| Variables | Data Item |
| sessions_waiting | mysql:rpl_semi_sync_status:Rpl_semi_sync_master_wait_sessions |
Replication Master Semi-Sync Waits
| Name | Replication Master Semi-Sync Waits |
| Range Label | # waits |
| Series | Expression |
| Slave Waits | slave_waits |
| Transaction Waits | trx_waits |
| Variables | Data Item |
| slave_waits | mysql:rpl_semi_sync_status:Rpl_semi_sync_master_net_waits |
| trx_waits | mysql:rpl_semi_sync_status:Rpl_semi_sync_master_tx_waits |
Displays the number of seconds behind the master for a given slave in a replication scenario. An increasing value means that your slave is unable to keep up with your master.
| Name | Replication Slave Delay |
| Range Label | total seconds |
| Series | Expression |
| Seconds Behind Master | sbehind |
| Variables | Data Item |
| sbehind | mysql:slavestatus:Seconds_Behind_Master |
Replication Slave Relay Log Space Usage
| Name | Replication Slave Relay Log Space Usage |
| Range Label | MB |
| Series | Expression |
| Total Size | (fileSum / (1024*1024)) |
| Variables | Data Item |
| fileSum | mysql:slavestatus:Relay_Log_Space |
Shows the average of the number of accesses for data for different query operations for all table reads, regardless of the storage engine being using, against the number of queries being executed.
| Name | Row Access Statistics |
| Range Label | rows |
| Series | Expression |
| Average Rows Per Query | ((first+key+next+prev+hread_rnd+hread_rnd_next+sort_rows) /
questions) |
| Variables | Data Item |
| first | mysql:status:Handler_read_first |
| hread_rnd | mysql:status:Handler_read_rnd |
| hread_rnd_next | mysql:status:Handler_read_rnd_next |
| key | mysql:status:Handler_read_key |
| next | mysql:status:Handler_read_next |
| prev | mysql:status:Handler_read_prev |
| questions | mysql:status:Questions |
| sort_rows | mysql:status:Sort_rows |
Displays the aggregated row access statistics per minute. Information is shown both in terms of the full table scans (which are expensive to perform), and index based accesses.
| Name | Row Accesses |
| Range Label | avg rows/sec |
| Series | Expression |
| Rows Read via Full Scan | ((hread_rnd+hread_rnd_next)/60) |
| Rows Read via Indexes | ((first+key+next+prev)/60) |
| Variables | Data Item |
| first | mysql:status:Handler_read_first |
| hread_rnd | mysql:status:Handler_read_rnd |
| hread_rnd_next | mysql:status:Handler_read_rnd_next |
| key | mysql:status:Handler_read_key |
| next | mysql:status:Handler_read_next |
| prev | mysql:status:Handler_read_prev |
Row Accesses Index Usage Ratio
| Name | Row Accesses Index Usage Ratio |
| Range Label | % |
| Series | Expression |
| Index Usage | (100-(((hread_rnd_next + hread_rnd) / (hread_rnd_next +
hread_rnd + first + next + key + prev))*100)) |
| Variables | Data Item |
| first | mysql:status:Handler_read_first |
| hread_rnd | mysql:status:Handler_read_rnd |
| hread_rnd_next | mysql:status:Handler_read_rnd_next |
| key | mysql:status:Handler_read_key |
| next | mysql:status:Handler_read_next |
| prev | mysql:status:Handler_read_prev |
Shows the number of delete, write (INSERT), and
update operations on rows per minute on all tables regardless of
storage engine.
| Name | Row Writes |
| Range Label | avg rows/sec |
| Series | Expression |
| Rows Deleted | (delete/60) |
| Rows Inserted | (write/60) |
| Rows Updated | (update/60) |
| Variables | Data Item |
| delete | mysql:status:Handler_delete |
| update | mysql:status:Handler_update |
| write | mysql:status:Handler_write |
| Name | Rows Returned |
| Range Label | avg rows/sec |
| Series | Expression |
| Rows Returned | rows/60 |
| Variables | Data Item |
| rows | mysql:statement_digest_statistics:total_rows_returned |
| Name | Slow Queries |
| Range Label | total/min |
| Series | Expression |
| Slow Queries | slow_queries/60 |
| Variables | Data Item |
| slow_queries | mysql:status:Slow_queries |
Shows the number of different sort operations performed on queries.
| Name | Sort Activity |
| Range Label | total/min |
| Series | Expression |
| Merge Passes | Sort_merge_passes |
| Range | Sort_range |
| Scan | Sort_scan |
| Variables | Data Item |
| Sort_merge_passes | mysql:status:Sort_merge_passes |
| Sort_range | mysql:status:Sort_range |
| Sort_scan | mysql:status:Sort_scan |
| Name | Statement Errors and Warnings |
| Range Label | Count |
| Series | Expression |
| Errors | errors |
| Warnings | warnings |
| Variables | Data Item |
| errors | mysql:statement_digest_statistics:total_errors |
| warnings | mysql:statement_digest_statistics:total_warnings |
| Name | Statement Statistics |
| Range Label | milliseconds |
| Series | Expression |
| Avg Lock Time | (total_lock_time/statements) |
| Avg Response Time | (total_wait_time/statements) |
| Variables | Data Item |
| statements | mysql:statement_digest_statistics:total_statements |
| total_lock_time | mysql:statement_digest_statistics:total_lock_time_ms |
| total_wait_time | mysql:statement_digest_statistics:total_wait_time_ms |
| Name | Swap IO Operations |
| Range Label | avg pages/sec |
| Series | Expression |
| Pages In | in / 60 |
| Pages Out | out / 60 |
| Total Pages | ((in+out) / 60) |
| Variables | Data Item |
| in | os:mem:swap_page_in |
| out | os:mem:swap_page_out |
Shows the percentage of table locks that have had to wait before an operation can continue. High lock ratios can indicate high contention in your tables, with too many operations having to wait, affecting the performance.
| Name | Table Lock Wait Ratio |
| Range Label | lock wait % |
| Series | Expression |
| Wait Ratio | ((lock_waits/lock_immediate)*100) |
| Variables | Data Item |
| lock_immediate | mysql:status:Table_locks_immediate |
| lock_waits | mysql:status:Table_locks_waited |
Shows the average number of table locks per second.
| Name | Table Locks |
| Range Label | avg locks/sec |
| Series | Expression |
| Immediate | (locks_immediate/60) |
| Waited | (locks_waited/60) |
| Variables | Data Item |
| locks_immediate | mysql:status:Table_locks_immediate |
| locks_waited | mysql:status:Table_locks_waited |
Displays the number of memory temporary tables and disk temporary tables. Disk temporary tables are slower to create, populate, and read back. You may want to increase your memory temporary table size or check your queries to determine whether the use of temporary tables can be minimized.
| Name | Temporary Tables |
| Range Label | total/min |
| Series | Expression |
| Disk Temp Tables | diskTempTables |
| Memory Temp Tables | memoryTempTables |
| Variables | Data Item |
| diskTempTables | mysql:status:Created_tmp_disk_tables |
| memoryTempTables | mysql:status:Created_tmp_tables |
| Name | Thread Pool Current Threads |
| Range Label | thread count |
| Series | Expression |
| Active | active_threads |
| Consumable | consumer_thread |
| Reserved | reserve_threads |
| Stalled | stalled_threads |
| Total | total_threads |
| Variables | Data Item |
| active_threads | mysql:thread_pool_state:active_threads |
| consumer_threads | mysql:thread_pool_state:consumer_threads |
| reserve_threads | mysql:thread_pool_state:reserve_threads |
| stalled_threads | mysql:thread_pool_state:stalled_threads |
| total_threads | mysql:thread_pool_state:total_threads |
| Name | Thread Pool Queue Age |
| Range Label | milliseconds |
| Series | Expression |
| Oldest Query Wait Time | oldest_queued_ms |
| Variables | Data Item |
| oldest_queued_ms | mysql:thread_pool_state:oldest_queued_ms |
| Name | Thread Pool Queues |
| Range Label | # of statements |
| Series | Expression |
| High-Priority Queue | queued_queries |
| Low-Priority Queue | queued_trxs |
| Variables | Data Item |
| queued_queries | mysql:thread_pool_state:queued_queries |
| queued_trxs | mysql:thread_pool_state:queued_trxs |
| Name | Thread Pool Stall Rate |
| Range Label | % |
| Series | Expression |
| Last Interval | (stalled_queries_executed / queries_executed) * 100 |
| Since Start | stalled_pct |
| Variables | Data Item |
| queries_executed | mysql:thread_pool_stats:queries_executed |
| stalled_pct | mysql:thread_pool_stats:stalled_pct |
| stalled_queries_executed | mysql:thread_pool_stats:stalled_queries_executed |
Thread Pool Statement Activity
| Name | Thread Pool Statement Activity |
| Range Label | avg statements/sec |
| Series | Expression |
| Executed | (executed / 60) |
| Immediately Queued | (queued / 60) |
| Marked Stalled | (stalled / 60) |
| Variables | Data Item |
| executed | mysql:thread_pool_stats:queries_executed |
| queued | mysql:thread_pool_stats:queries_queued |
| stalled | mysql:thread_pool_stats:stalled_queries_executed |