B.9.2 Graph Definition Reference

The following items describe individual graphs.

Agent Reporting Delay

NameAgent Reporting Delay
Range Labelmilliseconds
SeriesExpression
Delayagent_delay
VariablesData Item
agent_delaymysql:Agent:agent.latency

Backup Locked Time

NameBackup Locked Time
Range Labelseconds
SeriesExpression
Locked Timelock_time
VariablesData Item
lock_timemysql:meb_timing:lock_time

Backup Run Time

NameBackup Run Time
Range Labelseconds
SeriesExpression
Total Timetotal_time
VariablesData Item
total_timemysql:meb_timing:total_time

Binlog Cache Efficiency

NameBinlog Cache Efficiency
Range Labelavg cache ops/sec
SeriesExpression
Cache Writes(binlog_memory/60)
Disk Writes(binlog_disk/60)
VariablesData Item
binlog_diskmysql:status:Binlog_cache_disk_use
binlog_memorymysql:status:Binlog_cache_use

Binlog IO Usage

NameBinlog IO Usage
Range Labelavg MB/sec
SeriesExpression
Read((bytes_read / (1024*1024))/60)
Total(((bytes_read + bytes_written) / (1024*1024))/60)
Write((bytes_written / (1024*1024))/60)
VariablesData Item
bytes_readmysql:binary_log_io:bytes_read
bytes_writtenmysql:binary_log_io:bytes_written

Binlog Space Usage

NameBinlog Space Usage
Range LabelMB
SeriesExpression
Total Size(fileSum / (1024*1024))
VariablesData Item
fileSummysql:masterlogs:filesizesum

Cluster Data Node Data Memory Use

NameCluster Data Node Data Memory Use
Range LabelMB
SeriesExpression
Availcluster_data_node_config_data_memory/1024/1024
Usedcluster_data_node_used_data_memory/1024/1024
VariablesData Item
cluster_data_node_config_data_memorymysql:cluster_data_node_data_memory:data_mem_total
cluster_data_node_used_data_memorymysql:cluster_data_node_data_memory:data_mem_used

Cluster Data Node DiskPageBuffer Hit Ratio

NameCluster Data Node DiskPageBuffer Hit Ratio
Range Label%
SeriesExpression
DiskPageBuffer(cluster_data_node_hits/(cluster_data_node_hits+cluster_data_node_miss))*100
VariablesData Item
cluster_data_node_hitsmysql:cluster_data_node_diskpagebuffer_total_hits_period:buffer_hit_per
cluster_data_node_missmysql:cluster_data_node_diskpagebuffer_total_hits_period:buffer_missed_per

Cluster Data Node Index Memory Use

NameCluster Data Node Index Memory Use
Range LabelMB
SeriesExpression
Availcluster_data_node_config_index_memory/1024/1024
Usedcluster_data_node_used_index_memory/1024/1024
VariablesData Item
cluster_data_node_config_index_memorymysql:cluster_data_node_index_memory:index_mem_total
cluster_data_node_used_index_memorymysql:cluster_data_node_index_memory:index_mem_used

Cluster Data Node Redo Buffer Use

NameCluster Data Node Redo Buffer Use
Range LabelMB
SeriesExpression
Availcluster_data_node_config_redo_buffer/1024/1024
Usedcluster_data_node_used_redo_buffer/1024/1024
VariablesData Item
cluster_data_node_config_redo_buffermysql:cluster_data_node_redo_buffer:redo_buffer_total
cluster_data_node_used_redo_buffermysql:cluster_data_node_redo_buffer:redo_buffer_used

Cluster Data Node Redo Log Space Use

NameCluster Data Node Redo Log Space Use
Range LabelMB
SeriesExpression
Availcluster_data_node_config_redo_logspace/1024/1024
Usedcluster_data_node_used_redo_logspace/1024/1024
VariablesData Item
cluster_data_node_config_redo_logspacemysql:cluster_data_node_redo_logspace:redo_logspace_total
cluster_data_node_used_redo_logspacemysql:cluster_data_node_redo_logspace:redo_logspace_used

Cluster Data Node Undo Buffer Use

NameCluster Data Node Undo Buffer Use
Range LabelMB
SeriesExpression
Availcluster_data_node_config_undo_buffer/1024/1024
Usedcluster_data_node_used_undo_buffer/1024/1024
VariablesData Item
cluster_data_node_config_undo_buffermysql:cluster_data_node_undo_buffer:undo_buffer_total
cluster_data_node_used_undo_buffermysql:cluster_data_node_undo_buffer:undo_buffer_used

Cluster Data Node Undo Log Space Use

NameCluster Data Node Undo Log Space Use
Range LabelMB
SeriesExpression
Availcluster_data_node_config_undo_logspace/1024/1024
Usedcluster_data_node_used_undo_logspace/1024/1024
VariablesData Item
cluster_data_node_config_undo_logspacemysql:cluster_data_node_undo_logspace:undo_logspace_total
cluster_data_node_used_undo_logspacemysql:cluster_data_node_undo_logspace:undo_logspace_used

Cluster Data Nodes in Ready State

NameCluster Data Nodes in Ready State
Range Label# Nodes
SeriesExpression
NodesNdb_number_of_ready_data_nodes
VariablesData Item
Ndb_number_of_ready_data_nodesmysql:status:Ndb_number_of_ready_data_nodes

Connections

Displays the number of client connections by displaying the number of connected threads, active threads, and cached threads.

NameConnections
Range Label# connections
SeriesExpression
Cachedcached
Runningrunning
Totalconnected
VariablesData Item
cachedmysql:status:Threads_cached
connectedmysql:status:Threads_connected
runningmysql:status:Threads_running

Connections - Aborted

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.

NameConnections - Aborted
Range Labeltotal/min
SeriesExpression
Clientsclients
Connectionsconnections
VariablesData Item
clientsmysql:status:Aborted_clients
connectionsmysql:status:Aborted_connects

Connections - Cache

Displays the thread cache information, comparing new thread creations against all database connections.

NameConnections - Cache
Range Labeltotal/min
SeriesExpression
Connectionsconnections
Threads Createdtcreated
VariablesData Item
connectionsmysql:status:Connections
tcreatedmysql:status:Threads_created

Connections - Maximum

Shows the maximum number of connections, and the maximum number of used connections.

NameConnections - Maximum
Range Labeltotal
SeriesExpression
Allowedmax_connections_allowed
Usedmax_connections_used
VariablesData Item
max_connections_allowedmysql:variables:max_connections
max_connections_usedmysql:status:Max_used_connections

CPU Utilization

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.

Note

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.

NameCPU Utilization
Range Label%
SeriesExpression
Kernelsys/(sys+user+wait+idle)*100
Total(sys+user+wait)/(sys+user+wait+idle)*100
Useruser/(sys+user+wait+idle)*100
Wait I/Owait/(sys+user+wait+idle)*100
VariablesData Item
idleos:cpu:cpu_idle
sysos:cpu:cpu_sys
useros:cpu:cpu_user
waitos:cpu:cpu_wait

Database Activity

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.

NameDatabase Activity
Range Labelavg statements/sec
SeriesExpression
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)
VariablesData Item
call_procmysql:status:Com_call_procedure
delete_multimysql:status:Com_delete_multi
deletesmysql:status:Com_delete
insert_selectsmysql:status:Com_insert_select
insertsmysql:status:Com_insert
replace_selectsmysql:status:Com_replace_select
replacesmysql:status:Com_replace
selectsmysql:status:Com_select
update_multimysql:status:Com_update_multi
updatesmysql:status:Com_update

Database Transactions

NameDatabase Transactions
Range Labelavg statements/sec
SeriesExpression
Begin(begin/60)
Commit(commit/60)
Release Savepoint(releaseSavepoint/60)
Rollback(rollback/60)
Rollback Savepoint(rollbackSavepoint/60)
Savepoint(savepoint/60)
VariablesData Item
beginmysql:status:com_begin
commitmysql:status:com_commit
releaseSavepointmysql:status:com_release_savepoint
rollbackmysql:status:com_rollback
rollbackSavepointmysql:status:com_rollback_to_savepoint
savepointmysql:status:com_savepoint

Disk IO Operations

NameDisk IO Operations
Range Labelavg ops/sec
SeriesExpression
Readread / 60
Total((read+write) / 60)
Writewrite / 60
VariablesData Item
reados:disk:disk_reads
writeos:disk:disk_writes

Disk IO Usage

Displays the disk usage activity, by showing the disk input and output ratios over time.

Note

The FreeBSD and Windows operating systems do not provide this information.

NameDisk IO Usage
Range Labelavg MB/sec
SeriesExpression
Read((read / (1024*1024))/60)
Total(((read+write) / (1024*1024))/60)
Write((write / (1024*1024))/60)
VariablesData Item
reados:disk:disk_bytes_read
writeos:disk:disk_bytes_written

Disk Space Usage

NameDisk Space Usage
Range LabelGB
SeriesExpression
Total Size(total / (1024*1024*1024))
Used(used / (1024*1024*1024))
VariablesData Item
totalos:fs:fs_total
usedos:fs:fs_used

Hit Ratios

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.

NameHit Ratios
Range Label%
SeriesExpression
InnoDB Buffer100-((iReads / (iReadRequests+1))*100)
Key Cache(100-((keyReads / (keyReadRequests+1))*100)) * (keyReadRequests >= keyReads)
Query Cache(qHits/(qHits+qInserts+1))*100
Thread Cache100-((tcreated / (connections+1))*100)
VariablesData Item
connectionsmysql:status:Connections
iReadRequestsmysql:status:Innodb_buffer_pool_read_requests
iReadsmysql:status:Innodb_buffer_pool_reads
keyReadRequestsmysql:status:Key_read_requests
keyReadsmysql:status:Key_reads
qHitsmysql:status:Qcache_hits
qInsertsmysql:status:Qcache_inserts
tcreatedmysql: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.

NameInnoDB Adaptive Hash Index Memory
Range LabelMB
SeriesExpression
Hash Node Size( hash_size * 16384 ) / 1024 / 1024
VariablesData Item
hash_sizemysql: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.

NameInnoDB Adaptive Hash Index Searches
Range Labelsearches/sec
SeriesExpression
Hash Searcheshash
Non-Hash Searchesnonhash
VariablesData Item
hashmysql:innodbstatus:innodb_hash_searches_per_sec
nonhashmysql:innodbstatus:innodb_non_hash_searches_per_sec

InnoDB Buffer Pool

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.

NameInnoDB Buffer Pool
Range LabelMB
SeriesExpression
Modified(modified*16384)/(1024*1024)
Old(old*16384)/(1024*1024)
Total Size(size*16384)/(1024*1024)
Used(used*16384)/(1024*1024)
VariablesData Item
modifiedmysql:innodbstatus:innodb_bp_modified_pages
oldmysql:innodbstatus:innodb_bp_old_db_pages
sizemysql:innodbstatus:innodb_bp_size
usedmysql:innodbstatus:innodb_bp_db_pages

InnoDB Buffer Pool Page Activity

NameInnoDB Buffer Pool Page Activity
Range Labelavg pages/sec
SeriesExpression
Createdcreated / 60
Readreads / 60
Writtenwritten / 60
VariablesData Item
createdmysql:innodbstatus:innodb_bp_pages_created
readsmysql:innodbstatus:innodb_bp_pages_read
writtenmysql:innodbstatus:innodb_bp_pages_written

InnoDB Buffer Pool Pending Operations

NameInnoDB Buffer Pool Pending Operations
Range Labelpending ops
SeriesExpression
Readsreads
Write Flush Listwrite_flush_list
Write LRUwrite_lru
Write Single Pagewrite_single_page
VariablesData Item
readsmysql:innodbstatus:innodb_bp_pending_pages
write_flush_listmysql:innodbstatus:innodb_bp_pending_writes_flush_list
write_lrumysql:innodbstatus:innodb_bp_pending_writes_lru
write_single_pagemysql:innodbstatus:innodb_bp_pending_writes_single_page

InnoDB Change Buffer Activity

NameInnoDB Change Buffer Activity
Range Labelavg operations/sec
SeriesExpression
Insertsinserts / 60
Mergesmerges / 60
VariablesData Item
insertsmysql:innodbstatus:innodb_ibuf_inserts
mergesmysql:innodbstatus:innodb_ibuf_merges

InnoDB Change Buffer Activity

NameInnoDB Change Buffer Activity
Range Labelavg operations/sec
SeriesExpression
Delete Discardeddelete_discarded / 60
Delete Mark Discardeddelete_mark_discarded / 60
Delete Mark Mergesdelete_mark_merges / 60
Delete Mergesdelete_merges / 60
Insert Discardedinsert_discarded / 60
Insert Mergesinsert_merges / 60
VariablesData Item
delete_discardedmysql:innodbstatus:innodb_cbuf_delete_discarded
delete_mark_discardedmysql:innodbstatus:innodb_cbuf_delete_mark_discarded
delete_mark_mergesmysql:innodbstatus:innodb_cbuf_delete_mark_merges
delete_mergesmysql:innodbstatus:innodb_cbuf_delete_merges
insert_discardedmysql:innodbstatus:innodb_cbuf_insert_discarded
insert_mergesmysql:innodbstatus:innodb_cbuf_insert_merges

InnoDB Change Buffer Usage

NameInnoDB Change Buffer Usage
Range LabelMB
SeriesExpression
Total Size(total * 16384) / (1024 * 1024)
Used((total - free) * 16384) / (1024 * 1024)
VariablesData Item
freemysql:innodbstatus:innodb_ibuf_free_list_len
totalmysql:innodbstatus:innodb_ibuf_seg_size

InnoDB Compression Time

Shows the time spent by InnoDB compressing and uncompressing data in compressed tables.

NameInnoDB Compression Time
Range Labelsecs per min
SeriesExpression
Compressingcompress
Uncompressinguncompress
VariablesData Item
compressmysql:innodb_compression_time:compress_seconds
uncompressmysql:innodb_compression_time:uncompress_seconds

InnoDB Data Dictionary Memory

NameInnoDB Data Dictionary Memory
Range LabelMB
SeriesExpression
Dictionary Memory Allocated(dict)/(1024*1024)
VariablesData Item
dictmysql:innodbstatus:innodb_bp_dictionary_alloc

InnoDB Datafile IO Usage

NameInnoDB Datafile IO Usage
Range Labelavg MB/sec
SeriesExpression
Read((bytes_read / (1024*1024))/60)
Total(((bytes_read + bytes_written) / (1024*1024))/60)
Write((bytes_written / (1024*1024))/60)
VariablesData Item
bytes_readmysql:innodb_datafile_io:bytes_read
bytes_writtenmysql:innodb_datafile_io:bytes_written

InnoDB Doublewrite Buffer Activity

NameInnoDB Doublewrite Buffer Activity
Range Labelavg/sec
SeriesExpression
Pages Writtenpages_written/60
Writeswrites/60
VariablesData Item
pages_writtenmysql:status:Innodb_dblwr_pages_written
writesmysql:status:Innodb_dblwr_writes

InnoDB Open Files

NameInnoDB Open Files
Range Labeltotal
SeriesExpression
Currently Openopen
Max Allowedmax
VariablesData Item
maxmysql:variables:innodb_open_files
openmysql:status:innodb_num_open_files

InnoDB OS File Access

Displays the InnoDB I/O counts showing the number of fsync, read, and write operations used to support InnoDB tables.

NameInnoDB OS File Access
Range Labelavg operations/sec
SeriesExpression
File fsync()(fsync/60)
File Reads(read/60)
File Writes(write/60)
Redo Log(log/60)
VariablesData Item
fsyncmysql:innodbstatus:innodb_io_os_file_fsyncs
logmysql:innodbstatus:innodb_log_io_total
readmysql:innodbstatus:innodb_io_os_file_reads
writemysql:innodbstatus:innodb_io_os_file_writes

InnoDB Redo Log Checkpoint Lag

NameInnoDB Redo Log Checkpoint Lag
Range LabelMB
SeriesExpression
Not Checkpointed(lsn - checkpointed) / (1024 * 1024)
Not Flushed(lsn - flushed) / (1024 * 1024)
Total Redo Log Size(log_size * log_count) / (1024 * 1024)
VariablesData Item
checkpointedmysql:innodbstatus:innodb_log_checkpoint_lsn64
flushedmysql:innodbstatus:innodb_log_flushed_lsn64
log_countmysql:variables:innodb_log_files_in_group
log_sizemysql:variables:innodb_log_file_size
lsnmysql:innodbstatus:innodb_log_sequence_lsn64

InnoDB Redo Log IO Usage

NameInnoDB Redo Log IO Usage
Range Labelavg MB/sec
SeriesExpression
Read((bytes_read / (1024*1024))/60)
Total(((bytes_read + bytes_written) / (1024*1024))/60)
Write((bytes_written / (1024*1024))/60)
VariablesData Item
bytes_readmysql:innodb_log_io:bytes_read
bytes_writtenmysql:innodb_log_io:bytes_written

InnoDB Redo Log Pending Writes

NameInnoDB Redo Log Pending Writes
Range LabelI/O ops
SeriesExpression
Checkpoint Writescheckpoint
Log Writeslog
VariablesData Item
checkpointmysql:innodbstatus:innodb_log_pending_checkpoint_writes
logmysql:innodbstatus:innodb_log_pending_log_writes

InnoDB Row Details

Shows the row counts per minute for individual SQL operations (READ, INSERT, UPDATE and DELETE).

NameInnoDB Row Details
Range Labelavg rows/sec
SeriesExpression
Rows Deleted(deleted/60)
Rows Inserted(inserted/60)
Rows Read(read/60)
Rows Updated(updated/60)
VariablesData Item
deletedmysql:innodbstatus:innodb_rows_deleted
insertedmysql:innodbstatus:innodb_rows_inserted
readmysql:innodbstatus:innodb_rows_read
updatedmysql:innodbstatus:innodb_rows_updated

InnoDB Row Lock Time

NameInnoDB Row Lock Time
Range Labelmilliseconds
SeriesExpression
Totallock_time_total
VariablesData Item
lock_time_totalmysql:status:Innodb_row_lock_time

InnoDB Row Lock Time Statistics

NameInnoDB Row Lock Time Statistics
Range Labelmilliseconds
SeriesExpression
Avglock_time_avg
Maxlock_time_max
VariablesData Item
lock_time_avgmysql:status:Innodb_row_lock_time_avg
lock_time_maxmysql:status:Innodb_row_lock_time_max

InnoDB Row Lock Waits

NameInnoDB Row Lock Waits
Range Labeltotal
SeriesExpression
Row Lock Waitsrow_lock_waits
VariablesData Item
row_lock_waitsmysql:status:Innodb_row_lock_waits

InnoDB Row Locks Current

NameInnoDB Row Locks Current
Range Labeltotal
SeriesExpression
Rows Lockedrows_locked
Rows Modifiedrows_modified
Rows Waiting Lockrows_waited
VariablesData Item
rows_lockedmysql:innodb_current_trxs:rows_locked_total
rows_modifiedmysql:innodb_current_trxs:rows_modified_total
rows_waitedmysql:innodb_current_trxs:row_locks_current_waits

InnoDB Semaphores

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.

NameInnoDB Semaphores
Range Labelavg waits/sec
SeriesExpression
OS Waits(oswaits/60)
Spin Rounds(srounds/60)
Spin Waits(swaits/60)
VariablesData Item
oswaitsmysql:innodbstatus:innodb_sem_mutex_os_waits
sroundsmysql:innodbstatus:innodb_sem_mutex_rounds
swaitsmysql:innodbstatus:innodb_sem_mutex_spin_waits

InnoDB Transaction History

The size of the InnoDB transaction history. A high number may indicate a large number of open (uncommitted) transactions.

NameInnoDB Transaction History
Range LabelUndo Entries
SeriesExpression
Undo Log Sizehist_len
VariablesData Item
hist_lenmysql:innodbstatus:innodb_trx_history_list_length

InnoDB Transaction Lock Memory

NameInnoDB Transaction Lock Memory
Range LabelMB
SeriesExpression
Total Lock Memory(bytes_total / (1024*1024))
VariablesData Item
bytes_totalmysql:innodb_current_trxs:lock_memory_bytes_total

InnoDB Transactions

The number of blocked, locked, and active transactions. You can use this to determine the contention on tables for InnoDB transactions.

NameInnoDB Transactions
Range Labeltotal
SeriesExpression
Committingcommitting
Lock Waitinglock_waiting
Rolling Backrolling_back
Runningrunning
VariablesData Item
committingmysql:innodb_transactions:committing_count
lock_waitingmysql:innodb_transactions:lock_wait_count
rolling_backmysql:innodb_transactions:rolling_back_count
runningmysql:innodb_transactions:running_count

InnoDB Undo Logs

NameInnoDB Undo Logs
Range Labeltotal
SeriesExpression
Totaltotal
Used(total - avail)
VariablesData Item
availmysql:status:innodb_available_undo_logs
totalmysql:variables:innodb_undo_logs

Load Average

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.

NameLoad Average
Range LabelLoad Average
SeriesExpression
1zero
15two
5one
VariablesData Item
oneos:loadavg:1
twoos:loadavg:2
zeroos:loadavg:0

Memory Usage - Agent

Displays the current amount of memory used by the agent, and by the Lua component of the agent.

NameMemory Usage - Agent
Range LabelMB
SeriesExpression
Agentagent_mem_size / 1024 / 1024
Lualua_mem_size / 1024 / 1024
VariablesData Item
agent_mem_sizeagent:proc:mem_resident
lua_mem_sizeagent:lua:mem_size

Memory Usage - OS Resident

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.

NameMemory Usage - OS Resident
Range LabelMB
SeriesExpression
Totalram_total/(1024*1024)
Used(ram_total-ram_unused)/(1024*1024)
VariablesData Item
ram_totalos:mem:ram_total
ram_unusedos:mem:ram_unused

Memory Usage - OS Virtual

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.

NameMemory Usage - OS Virtual
Range LabelMB
SeriesExpression
Totalswap_total/(1024*1024)
Used(swap_total-swap_unused)/(1024*1024)
VariablesData Item
swap_totalos:mem:swap_total
swap_unusedos:mem:swap_unused

MyISAM Data File IO Usage

NameMyISAM Data File IO Usage
Range Labelavg MB/sec
SeriesExpression
Read((bytes_read / (1024*1024))/60)
Total(((bytes_read + bytes_written) / (1024*1024))/60)
Write((bytes_written / (1024*1024))/60)
VariablesData Item
bytes_readmysql:myisam_data_file_io:bytes_read
bytes_writtenmysql:myisam_data_file_io:bytes_written

MyISAM Index File IO Usage

NameMyISAM Index File IO Usage
Range Labelavg MB/sec
SeriesExpression
Read((bytes_read / (1024*1024))/60)
Total(((bytes_read + bytes_written) / (1024*1024))/60)
Write((bytes_written / (1024*1024))/60)
VariablesData Item
bytes_readmysql:myisam_index_file_io:bytes_read
bytes_writtenmysql:myisam_index_file_io:bytes_written

MyISAM Key Buffer Activity

NameMyISAM Key Buffer Activity
Range Labelavg cache ops/sec
SeriesExpression
Disk Reads(reads/60)
Disk Writes(writes/60)
Read Requests(read_requests/60)
Write Requests(write_requests/60)
VariablesData Item
read_requestsmysql:status:Key_read_requests
readsmysql:status:Key_reads
write_requestsmysql:status:Key_write_requests
writesmysql:status:Key_writes

MyISAM Key Buffer Usage

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.

NameMyISAM Key Buffer Usage
Range LabelMB
SeriesExpression
Modified(blk_size*not_flushed)/1024/1024
Total Sizekey_buffer/1024/1024
Used(key_buffer - (blk_size*unused))/1024/1024
VariablesData Item
blk_sizemysql:variables:key_cache_block_size
key_buffermysql:variables:key_buffer_size
not_flushedmysql:status:Key_blocks_not_flushed
unusedmysql:status:Key_blocks_unused

Network - Database Throughput

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.

NameNetwork - Database Throughput
Range Labelavg kbytes/sec
SeriesExpression
Received((bytesIn/1024)/60)
Sent((bytesOut/1024)/60)
Total(((bytesIn+bytesOut)/1024)/60)
VariablesData Item
bytesInmysql:status:Bytes_received
bytesOutmysql:status:Bytes_sent

Network - Interface Throughput

NameNetwork - Interface Throughput
Range Labelavg kbytes/sec
SeriesExpression
Received((read / 1024)/60)
Sent((write / 1024)/60)
Total(((read+write) / 1024)/60)
VariablesData Item
reados:net:rx_bytes
writeos:net:tx_bytes

Opened Tables

The number of tables in the open state per minute.

NameOpened Tables
Range Labeltotal/min
SeriesExpression
Opened Table DefinitionsopenedTableDefs
Opened TablesopenedTables
VariablesData Item
openedTableDefsmysql:status:Opened_table_definitions
openedTablesmysql:status:Opened_tables

Prepared Statement API

NamePrepared Statement API
Range Labeltotal/min
SeriesExpression
stmt_close(close_api - dealloc_sql)
stmt_execute(execute_api - execute_sql)
stmt_fetchfetch_api
stmt_prepare((prepare_api - reprepare_api) - prepare_sql)
VariablesData Item
close_apimysql:status:Com_stmt_close
dealloc_sqlmysql:status:Com_dealloc_sql
execute_apimysql:status:Com_stmt_execute
execute_sqlmysql:status:Com_execute_sql
fetch_apimysql:status:Com_stmt_fetch
prepare_apimysql:status:Com_stmt_prepare
prepare_sqlmysql:status:Com_prepare_sql
reprepare_apimysql:status:Com_stmt_reprepare

Prepared Statement API Invalidations

NamePrepared Statement API Invalidations
Range Labeltotal/min
SeriesExpression
stmt_repreparereprepare_api
VariablesData Item
reprepare_apimysql:status:Com_stmt_reprepare

Prepared Statement SQL

NamePrepared Statement SQL
Range Labeltotal/min
SeriesExpression
DEALLOCATE PREPAREdealloc_sql
EXECUTEexecute_sql
PREPAREprepare_sql
VariablesData Item
dealloc_sqlmysql:status:Com_dealloc_sql
execute_sqlmysql:status:Com_execute_sql
prepare_sqlmysql:status:Com_prepare_sql

Prepared Statement Utilization

NamePrepared Statement Utilization
Range Labeltotal
SeriesExpression
Max Prepared Statementsmax_allowed
Open Prepared Statementsopen
VariablesData Item
max_allowedmysql:variables:max_prepared_stmt_count
openmysql:status:Prepared_stmt_count

Query Cache Average Free Block Size

NameQuery Cache Average Free Block Size
Range LabelkBytes
SeriesExpression
Average Free Block Sizefree_memory/free_blocks/1024
VariablesData Item
free_blocksmysql:status:Qcache_free_blocks
free_memorymysql:status:Qcache_free_memory

Query Cache Average Query Size

NameQuery Cache Average Query Size
Range LabelkBytes
SeriesExpression
Average Query Size((size - free)/queries)/1024
Min Block Sizemin_res_unit/1024
VariablesData Item
freemysql:status:Qcache_free_memory
min_res_unitmysql:variables:query_cache_min_res_unit
queriesmysql:status:Qcache_queries_in_cache
sizemysql:variables:query_cache_size

Query Cache Efficiency

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.

NameQuery Cache Efficiency
Range Labelavg cache ops/sec
SeriesExpression
Hits(hits/60)
Inserts(inserts/60)
Not Cached(not_cached/60)
VariablesData Item
hitsmysql:status:Qcache_hits
insertsmysql:status:Qcache_inserts
not_cachedmysql:status:Qcache_not_cached

Query Cache Fragmentation

NameQuery Cache Fragmentation
Range Label# of Free Blocks
SeriesExpression
Free BlocksQCache_free_blocks
VariablesData Item
QCache_free_blocksmysql:status:QCache_free_blocks

Query Cache Lowmem Prunes

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.

NameQuery Cache Lowmem Prunes
Range Labelavg cache ops/sec
SeriesExpression
Lowmem Prunes(deletes/60)
VariablesData Item
deletesmysql:status:Qcache_lowmem_prunes

Query Cache Memory

Displays the free space and total size of the query cache.

NameQuery Cache Memory
Range LabelMB
SeriesExpression
Total Sizesize/(1024*1024)
Used((size-free)/(1024*1024))
VariablesData Item
freemysql:status:Qcache_free_memory
sizemysql:variables:query_cache_size

Query Cache Queries

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.

NameQuery Cache Queries
Range Labelnum queries
SeriesExpression
Queries in Cachequeries
VariablesData Item
queriesmysql:status:Qcache_queries_in_cache

Replication Master Semi-Sync Transactions

NameReplication Master Semi-Sync Transactions
Range Label# of trxs
SeriesExpression
Transactions Acknowledgedtrxs_yes
Transactions Unacknowledgedtrxs_no
VariablesData Item
trxs_nomysql:rpl_semi_sync_status:Rpl_semi_sync_master_no_tx
trxs_yesmysql:rpl_semi_sync_status:Rpl_semi_sync_master_yes_tx

Replication Master Semi-Sync Wait Time Averages

NameReplication Master Semi-Sync Wait Time Averages
Range Labelmilliseconds
SeriesExpression
Average Slave Wait Timeslave_waits / 1000
Average Transaction Wait Timetrx_waits / 1000
VariablesData Item
slave_waitsmysql:rpl_semi_sync_status:Rpl_semi_sync_master_net_avg_wait_time
trx_waitsmysql:rpl_semi_sync_status:Rpl_semi_sync_master_tx_avg_wait_time

Replication Master Semi-Sync Waiting Sessions

NameReplication Master Semi-Sync Waiting Sessions
Range Label# of sessions
SeriesExpression
Waiting Sessionssessions_waiting
VariablesData Item
sessions_waitingmysql:rpl_semi_sync_status:Rpl_semi_sync_master_wait_sessions

Replication Master Semi-Sync Waits

NameReplication Master Semi-Sync Waits
Range Label# waits
SeriesExpression
Slave Waitsslave_waits
Transaction Waitstrx_waits
VariablesData Item
slave_waitsmysql:rpl_semi_sync_status:Rpl_semi_sync_master_net_waits
trx_waitsmysql:rpl_semi_sync_status:Rpl_semi_sync_master_tx_waits

Replication Slave Delay

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.

NameReplication Slave Delay
Range Labeltotal seconds
SeriesExpression
Seconds Behind Mastersbehind
VariablesData Item
sbehindmysql:slavestatus:Seconds_Behind_Master

Replication Slave Relay Log Space Usage

NameReplication Slave Relay Log Space Usage
Range LabelMB
SeriesExpression
Total Size(fileSum / (1024*1024))
VariablesData Item
fileSummysql:slavestatus:Relay_Log_Space

Row Access Statistics

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.

NameRow Access Statistics
Range Labelrows
SeriesExpression
Average Rows Per Query ((first+key+next+prev+hread_rnd+hread_rnd_next+sort_rows) / questions)
VariablesData Item
firstmysql:status:Handler_read_first
hread_rndmysql:status:Handler_read_rnd
hread_rnd_nextmysql:status:Handler_read_rnd_next
keymysql:status:Handler_read_key
nextmysql:status:Handler_read_next
prevmysql:status:Handler_read_prev
questionsmysql:status:Questions
sort_rowsmysql:status:Sort_rows

Row Accesses

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.

NameRow Accesses
Range Labelavg rows/sec
SeriesExpression
Rows Read via Full Scan ((hread_rnd+hread_rnd_next)/60)
Rows Read via Indexes ((first+key+next+prev)/60)
VariablesData Item
firstmysql:status:Handler_read_first
hread_rndmysql:status:Handler_read_rnd
hread_rnd_nextmysql:status:Handler_read_rnd_next
keymysql:status:Handler_read_key
nextmysql:status:Handler_read_next
prevmysql:status:Handler_read_prev

Row Accesses Index Usage Ratio

NameRow Accesses Index Usage Ratio
Range Label%
SeriesExpression
Index Usage (100-(((hread_rnd_next + hread_rnd) / (hread_rnd_next + hread_rnd + first + next + key + prev))*100))
VariablesData Item
firstmysql:status:Handler_read_first
hread_rndmysql:status:Handler_read_rnd
hread_rnd_nextmysql:status:Handler_read_rnd_next
keymysql:status:Handler_read_key
nextmysql:status:Handler_read_next
prevmysql:status:Handler_read_prev

Row Writes

Shows the number of delete, write (INSERT), and update operations on rows per minute on all tables regardless of storage engine.

NameRow Writes
Range Labelavg rows/sec
SeriesExpression
Rows Deleted(delete/60)
Rows Inserted(write/60)
Rows Updated(update/60)
VariablesData Item
deletemysql:status:Handler_delete
updatemysql:status:Handler_update
writemysql:status:Handler_write

Rows Returned

NameRows Returned
Range Labelavg rows/sec
SeriesExpression
Rows Returnedrows/60
VariablesData Item
rowsmysql:statement_digest_statistics:total_rows_returned

Slow Queries

NameSlow Queries
Range Labeltotal/min
SeriesExpression
Slow Queriesslow_queries/60
VariablesData Item
slow_queriesmysql:status:Slow_queries

Sort Activity

Shows the number of different sort operations performed on queries.

NameSort Activity
Range Labeltotal/min
SeriesExpression
Merge PassesSort_merge_passes
RangeSort_range
ScanSort_scan
VariablesData Item
Sort_merge_passesmysql:status:Sort_merge_passes
Sort_rangemysql:status:Sort_range
Sort_scanmysql:status:Sort_scan

Statement Errors and Warnings

NameStatement Errors and Warnings
Range LabelCount
SeriesExpression
Errorserrors
Warningswarnings
VariablesData Item
errorsmysql:statement_digest_statistics:total_errors
warningsmysql:statement_digest_statistics:total_warnings

Statement Statistics

NameStatement Statistics
Range Labelmilliseconds
SeriesExpression
Avg Lock Time(total_lock_time/statements)
Avg Response Time(total_wait_time/statements)
VariablesData Item
statementsmysql:statement_digest_statistics:total_statements
total_lock_timemysql:statement_digest_statistics:total_lock_time_ms
total_wait_timemysql:statement_digest_statistics:total_wait_time_ms

Swap IO Operations

NameSwap IO Operations
Range Labelavg pages/sec
SeriesExpression
Pages Inin / 60
Pages Outout / 60
Total Pages((in+out) / 60)
VariablesData Item
inos:mem:swap_page_in
outos:mem:swap_page_out

Table Lock Wait Ratio

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.

NameTable Lock Wait Ratio
Range Labellock wait %
SeriesExpression
Wait Ratio((lock_waits/lock_immediate)*100)
VariablesData Item
lock_immediatemysql:status:Table_locks_immediate
lock_waitsmysql:status:Table_locks_waited

Table Locks

Shows the average number of table locks per second.

NameTable Locks
Range Labelavg locks/sec
SeriesExpression
Immediate(locks_immediate/60)
Waited(locks_waited/60)
VariablesData Item
locks_immediatemysql:status:Table_locks_immediate
locks_waitedmysql:status:Table_locks_waited

Temporary Tables

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.

NameTemporary Tables
Range Labeltotal/min
SeriesExpression
Disk Temp TablesdiskTempTables
Memory Temp TablesmemoryTempTables
VariablesData Item
diskTempTablesmysql:status:Created_tmp_disk_tables
memoryTempTablesmysql:status:Created_tmp_tables

Thread Pool Current Threads

NameThread Pool Current Threads
Range Labelthread count
SeriesExpression
Activeactive_threads
Consumableconsumer_thread
Reservedreserve_threads
Stalledstalled_threads
Totaltotal_threads
VariablesData Item
active_threadsmysql:thread_pool_state:active_threads
consumer_threadsmysql:thread_pool_state:consumer_threads
reserve_threadsmysql:thread_pool_state:reserve_threads
stalled_threadsmysql:thread_pool_state:stalled_threads
total_threadsmysql:thread_pool_state:total_threads

Thread Pool Queue Age

NameThread Pool Queue Age
Range Labelmilliseconds
SeriesExpression
Oldest Query Wait Timeoldest_queued_ms
VariablesData Item
oldest_queued_msmysql:thread_pool_state:oldest_queued_ms

Thread Pool Queues

NameThread Pool Queues
Range Label# of statements
SeriesExpression
High-Priority Queuequeued_queries
Low-Priority Queuequeued_trxs
VariablesData Item
queued_queriesmysql:thread_pool_state:queued_queries
queued_trxsmysql:thread_pool_state:queued_trxs

Thread Pool Stall Rate

NameThread Pool Stall Rate
Range Label%
SeriesExpression
Last Interval(stalled_queries_executed / queries_executed) * 100
Since Startstalled_pct
VariablesData Item
queries_executedmysql:thread_pool_stats:queries_executed
stalled_pctmysql:thread_pool_stats:stalled_pct
stalled_queries_executedmysql:thread_pool_stats:stalled_queries_executed

Thread Pool Statement Activity

NameThread Pool Statement Activity
Range Labelavg statements/sec
SeriesExpression
Executed(executed / 60)
Immediately Queued(queued / 60)
Marked Stalled(stalled / 60)
VariablesData Item
executedmysql:thread_pool_stats:queries_executed
queuedmysql:thread_pool_stats:queries_queued
stalledmysql:thread_pool_stats:stalled_queries_executed