15.15.9.2. Graph Definition Reference

Individual graphs are defined below.

avg_row_accesses.name

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.

Nameavg_row_accesses.name
Range Labelavg_row_accesses.rangeLabel
SeriesExpression
avg_row_accesses.series1 ((first+key+next+prev+hread_rnd+hread_rnd_next+sort_rows) / questions)
VariablesData Item
firstmysql:status:Handler_read_first
keymysql:status:Handler_read_key
nextmysql:status:Handler_read_next
prevmysql:status:Handler_read_prev
hread_rndmysql:status:Handler_read_rnd
hread_rnd_nextmysql:status:Handler_read_rnd_next
sort_rowsmysql:status:Sort_rows
questionsmysql:status:Questions

binlog_cache.name

Namebinlog_cache.name
Range Labelbinlog_cache.rangeLabel
SeriesExpression
binlog_cache.series1(binlog_memory/60)
binlog_cache.series2(binlog_disk/60)
VariablesData Item
binlog_memorymysql:status:Binlog_cache_use
binlog_diskmysql:status:Binlog_cache_disk_use

binlog_space_usage.name

Namebinlog_space_usage.name
Range Labelbinlog_space_usage.rangeLabel
SeriesExpression
binlog_space_usage.series1(fileSum / (1024*1024))
VariablesData Item
fileSummysql:masterlogs:filesizesum

cluster_data_node_data_memory_usage.name

Namecluster_data_node_data_memory_usage.name
Range Labelcluster_data_node_data_memory_usage.rangeLabel
SeriesExpression
cluster_data_node_data_memory_usage.series1cluster_data_node_used_data_memory/1024/1024
cluster_data_node_data_memory_usage.series2cluster_data_node_config_data_memory/1024/1024
VariablesData Item
cluster_data_node_used_data_memorymysql:cluster_data_node_data_memory:data_mem_used
cluster_data_node_config_data_memorymysql:cluster_data_node_data_memory:data_mem_total

cluster_data_node_index_memory_usage.name

Namecluster_data_node_index_memory_usage.name
Range Labelcluster_data_node_index_memory_usage.rangeLabel
SeriesExpression
cluster_data_node_index_memory_usage.series1cluster_data_node_used_index_memory/1024/1024
cluster_data_node_index_memory_usage.series2cluster_data_node_config_index_memory/1024/1024
VariablesData Item
cluster_data_node_used_index_memorymysql:cluster_data_node_index_memory:index_mem_used
cluster_data_node_config_index_memorymysql:cluster_data_node_index_memory:index_mem_total

cluster_data_node_redo_buffer_usage.name

Namecluster_data_node_redo_buffer_usage.name
Range Labelcluster_data_node_redo_buffer_usage.rangeLabel
SeriesExpression
cluster_data_node_redo_buffer_usage.series1cluster_data_node_used_redo_buffer/1024/1024
cluster_data_node_redo_buffer_usage.series2cluster_data_node_config_redo_buffer/1024/1024
VariablesData Item
cluster_data_node_used_redo_buffermysql:cluster_data_node_redo_buffer:redo_buffer_used
cluster_data_node_config_redo_buffermysql:cluster_data_node_redo_buffer:redo_buffer_total

cluster_data_node_redo_logspace_usage.name

Namecluster_data_node_redo_logspace_usage.name
Range Labelcluster_data_node_redo_logspace_usage.rangeLabel
SeriesExpression
cluster_data_node_redo_logspace_usage.series1cluster_data_node_used_redo_logspace/1024/1024
cluster_data_node_redo_logspace_usage.series2cluster_data_node_config_redo_logspace/1024/1024
VariablesData Item
cluster_data_node_used_redo_logspacemysql:cluster_data_node_redo_logspace:redo_logspace_used
cluster_data_node_config_redo_logspacemysql:cluster_data_node_redo_logspace:redo_logspace_total

cluster_data_node_undo_buffer_usage.name

Namecluster_data_node_undo_buffer_usage.name
Range Labelcluster_data_node_undo_buffer_usage.rangeLabel
SeriesExpression
cluster_data_node_undo_buffer_usage.series1cluster_data_node_used_undo_buffer/1024/1024
cluster_data_node_undo_buffer_usage.series2cluster_data_node_config_undo_buffer/1024/1024
VariablesData Item
cluster_data_node_used_undo_buffermysql:cluster_data_node_undo_buffer:undo_buffer_used
cluster_data_node_config_undo_buffermysql:cluster_data_node_undo_buffer:undo_buffer_total

cluster_data_node_undo_logspace_usage.name

Namecluster_data_node_undo_logspace_usage.name
Range Labelcluster_data_node_undo_logspace_usage.rangeLabel
SeriesExpression
cluster_data_node_undo_logspace_usage.series1cluster_data_node_used_undo_logspace/1024/1024
cluster_data_node_undo_logspace_usage.series2cluster_data_node_config_undo_logspace/1024/1024
VariablesData Item
cluster_data_node_used_undo_logspacemysql:cluster_data_node_undo_logspace:undo_logspace_used
cluster_data_node_config_undo_logspacemysql:cluster_data_node_undo_logspace:undo_logspace_total

connections.name

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

Nameconnections.name
Range Labelconnections.rangeLabel
SeriesExpression
connections.series1.labelconnected
connections.series2.labelrunning
connections.series3.labelcached
VariablesData Item
connectedmysql:status:Threads_connected
runningmysql:status:Threads_running
cachedmysql:status:Threads_cached

connections_aborted.name

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.name
Range Labelconnections_aborted.rangeLabel
SeriesExpression
connections_aborted.series1.labelclients
connections_aborted.series2.labelconnections
VariablesData Item
clientsmysql:status:Aborted_clients
connectionsmysql:status:Aborted_connects

connections_max.name

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

Nameconnections_max.name
Range Labelconnections_max.rangeLabel
SeriesExpression
connections_max.series1.labelmax_connections_allowed
connections_max.series2.labelmax_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.

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
useros:cpu:cpu_user
waitos:cpu:cpu_wait
idleos:cpu:cpu_idle
sysos:cpu:cpu_sys

database_activity.name

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.name
Range Labeldatabase_activity.rangeLabel
SeriesExpression
database_activity.series1.label(selects/60)
database_activity.series2.label((inserts+insert_selects)/60)
database_activity.series3.label((updates+update_multi)/60)
database_activity.series4.label((replaces+replace_selects)/60)
database_activity.series5.label((deletes+delete_multi)/60)
database_activity.series6.label((call_proc)/60)
VariablesData Item
call_procmysql:status:Com_call_procedure
selectsmysql:status:Com_select
insertsmysql:status:Com_insert
insert_selectsmysql:status:Com_insert_select
updatesmysql:status:Com_update
update_multimysql:status:Com_update_multi
replacesmysql:status:Com_replace
replace_selectsmysql:status:Com_replace_select
deletesmysql:status:Com_delete
delete_multimysql:status:Com_delete_multi

database_transactions.name

Namedatabase_transactions.name
Range Labeldatabase_transactions.rangeLabel
SeriesExpression
database_transactions.series1(begin/60)
database_transactions.series2(commit/60)
database_transactions.series3(rollback/60)
VariablesData Item
beginmysql:status:com_begin
commitmysql:status:com_commit
rollbackmysql:status:com_rollback

Disk IO Usage

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.name

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.name
Range Labelhit_ratios.rangeLabel
SeriesExpression
hit_ratios.series1.label100-((iReads / (iReadRequests+1))*100)
hit_ratios.series2.label(qHits/(qHits+qInserts+1))*100
hit_ratios.series3.label(100-((keyReads / (keyReadRequests+1))*100)) * (keyReadRequests >= keyReads)
hit_ratios.series4.label100-((tcreated / (connections+1))*100)
VariablesData Item
keyReadsmysql:status:Key_reads
keyReadRequestsmysql:status:Key_read_requests
iReadsmysql:status:Innodb_buffer_pool_reads
iReadRequestsmysql:status:Innodb_buffer_pool_read_requests
tcreatedmysql:status:Threads_created
connectionsmysql:status:Connections
qHitsmysql:status:Qcache_hits
qInsertsmysql:status:Qcache_inserts

innodb_adaptive_hash_memory.name

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_memory.name
Range Labelinnodb_adaptive_hash_memory.rangeLabel
SeriesExpression
innodb_adaptive_hash_memory.series1( hash_size * 16384 ) / 1024 / 1024
VariablesData Item
hash_sizemysql:innodbstatus:innodb_hash_node_heap

innodb_adaptive_hash_searches.name

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_searches.name
Range Labelinnodb_adaptive_hash_searches.rangeLabel
SeriesExpression
innodb_adaptive_hash_searches.series1hash
innodb_adaptive_hash_searches.series2nonhash
VariablesData Item
hashmysql:innodbstatus:innodb_hash_searches_per_sec
nonhashmysql:innodbstatus:innodb_non_hash_searches_per_sec

innodb_buffer_pool.name

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.name
Range Labelinnodb_buffer_pool.rangeLabel
SeriesExpression
innodb_buffer_pool.series1.label(size*16384)/(1024*1024)
innodb_buffer_pool.series2.label(used*16384)/(1024*1024)
innodb_buffer_pool.series3.label(modified*16384)/(1024*1024)
innodb_buffer_pool.series4.label(dict)/(1024*1024)
VariablesData Item
sizemysql:innodbstatus:innodb_bp_size
usedmysql:innodbstatus:innodb_bp_db_pages
modifiedmysql:innodbstatus:innodb_bp_modified_pages
dictmysql:innodbstatus:innodb_bp_dictionary_alloc

innodb_compression_time.name

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

Nameinnodb_compression_time.name
Range Labelinnodb_compression_time.rangeLabel
SeriesExpression
innodb_compression_time.series1compress
innodb_compression_time.series2uncompress
VariablesData Item
compressmysql:innodb_compression_time:compress_seconds
uncompressmysql:innodb_compression_time:uncompress_seconds

innodb_hist_length.name

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

Nameinnodb_hist_length.name
Range Labelinnodb_hist_length.rangeLabel
SeriesExpression
innodb_hist_length.series1hist_len
VariablesData Item
hist_lenmysql:innodbstatus:innodb_trx_history_list_length

innodb_os_file_access.name

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

Nameinnodb_os_file_access.name
Range Labelinnodb_os_file_access.rangeLabel
SeriesExpression
innodb_os_file_access.series1.label(read/60)
innodb_os_file_access.series2.label(write/60)
innodb_os_file_access.series3.label(fsync/60)
VariablesData Item
readmysql:innodbstatus:innodb_io_os_file_reads
writemysql:innodbstatus:innodb_io_os_file_writes
fsyncmysql:innodbstatus:innodb_io_os_file_fsyncs

innodb_row_details.name

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

Nameinnodb_row_details.name
Range Labelinnodb_row_details.rangeLabel
SeriesExpression
innodb_row_details.series1.label(read/60)
innodb_row_details.series2.label(inserted/60)
innodb_row_details.series3.label(updated/60)
innodb_row_details.series4.label(deleted/60)
VariablesData Item
readmysql:innodbstatus:innodb_rows_read
insertedmysql:innodbstatus:innodb_rows_inserted
updatedmysql:innodbstatus:innodb_rows_updated
deletedmysql:innodbstatus:innodb_rows_deleted

innodb_semaphores.name

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.name
Range Labelinnodb_semaphores.rangeLabel
SeriesExpression
innodb_semaphores.series1.label(swaits/60)
innodb_semaphores.series2.label(srounds/60)
innodb_semaphores.series3.label(oswaits/60)
VariablesData Item
swaitsmysql:innodbstatus:innodb_sem_mutex_spin_waits
sroundsmysql:innodbstatus:innodb_sem_mutex_rounds
oswaitsmysql:innodbstatus:innodb_sem_mutex_os_waits

innodb_transactions.name

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

Nameinnodb_transactions.name
Range Labelinnodb_transactions.rangeLabel
SeriesExpression
innodb_transactions.series1running
innodb_transactions.series2lock_waiting
innodb_transactions.series3committing
innodb_transactions.series4rolling_back
VariablesData Item
runningmysql:innodb_transactions:running_count
lock_waitingmysql:innodb_transactions:lock_wait_count
committingmysql:innodb_transactions:committing_count
rolling_backmysql:innodb_transactions:rolling_back_count

kbytes_in_out.name

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.

Namekbytes_in_out.name
Range Labelkbytes_in_out.rangeLabel
SeriesExpression
kbytes_in_out.series1.label((bytesIn/1024)/60)
kbytes_in_out.series2.label((bytesOut/1024)/60)
kbytes_in_out.series3.label(((bytesIn+bytesOut)/1024)/60)
VariablesData Item
bytesInmysql:status:Bytes_received
bytesOutmysql:status:Bytes_sent

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
zeroos:loadavg:0
oneos:loadavg:1
twoos:loadavg:2

lock_wait_ratio.name

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.

Namelock_wait_ratio.name
Range Labellock_wait_ratio.rangeLabel
SeriesExpression
lock_wait_ratio.series1.label((lock_waits/lock_immediate)*100)
VariablesData Item
lock_waitsmysql:status:Table_locks_waited
lock_immediatemysql:status:Table_locks_immediate

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
lua_mem_sizeagent:lua:mem_size
agent_mem_sizeagent:proc:mem_resident

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_key_buffer_activity.name

Namemyisam_key_buffer_activity.name
Range Labelmyisam_key_buffer_activity.rangeLabel
SeriesExpression
myisam_key_buffer_activity.series1(read_requests/60)
myisam_key_buffer_activity.series2(reads/60)
myisam_key_buffer_activity.series3(write_requests/60)
myisam_key_buffer_activity.series4(writes/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.name

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.name
Range Labelmyisam_key_buffer_usage.rangeLabel
SeriesExpression
myisam_key_buffer_usage.series1.labelkey_buffer/1024/1024
myisam_key_buffer_usage.series2.label(key_buffer - (blk_size*unused))/1024/1024
myisam_key_buffer_usage.series3.label(blk_size*not_flushed)/1024/1024
VariablesData Item
key_buffermysql:variables:key_buffer_size
blk_sizemysql:variables:key_cache_block_size
unusedmysql:status:Key_blocks_unused
not_flushedmysql:status:Key_blocks_not_flushed

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.name

The number of tables in the open state per minute.

Nameopened_tables.name
Range Labelopened_tables.rangeLabel
SeriesExpression
opened_tables.series1.labelopenedTables
opened_tables.series2.labelopenedTableDefs
VariablesData Item
openedTablesmysql:status:Opened_tables
openedTableDefsmysql:status:Opened_table_definitions

query_cache_efficiency.name

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.name
Range Labelquery_cache_efficiency.rangeLabel
SeriesExpression
query_cache_efficiency.series1.label(hits/60)
query_cache_efficiency.series2.label(inserts/60)
query_cache_efficiency.series3.label(not_cached/60)
VariablesData Item
hitsmysql:status:Qcache_hits
insertsmysql:status:Qcache_inserts
not_cachedmysql:status:Qcache_not_cached

query_cache_lowmem_prunes.name

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.name
Range Labelquery_cache_lowmem_prunes.rangeLabel
SeriesExpression
query_cache_lowmem_prunes.series1.label(deletes/60)
VariablesData Item
deletesmysql:status:Qcache_lowmem_prunes

query_cache_memory.name

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

Namequery_cache_memory.name
Range Labelquery_cache_memory.rangeLabel
SeriesExpression
query_cache_memory.series1.labelsize/(1024*1024)
query_cache_memory.series2.label((size-free)/(1024*1024))
VariablesData Item
sizemysql:variables:query_cache_size
freemysql:status:Qcache_free_memory

query_cache_queries_in_cache.name

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_in_cache.name
Range Labelquery_cache_queries_in_cache.rangeLabel
SeriesExpression
query_cache_queries_in_cache.series1.labelqueries
VariablesData Item
queriesmysql:status:Qcache_queries_in_cache

row_accesses.name

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.name
Range Labelrow_accesses.rangeLabel
SeriesExpression
row_accesses.series2.label ((first+key+next+prev)/60)
row_accesses.series3.label ((hread_rnd+hread_rnd_next)/60)
VariablesData Item
firstmysql:status:Handler_read_first
keymysql:status:Handler_read_key
nextmysql:status:Handler_read_next
prevmysql:status:Handler_read_prev
hread_rndmysql:status:Handler_read_rnd
hread_rnd_nextmysql:status:Handler_read_rnd_next

row_writes.name

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

Namerow_writes.name
Range Labelrow_writes.rangeLabel
SeriesExpression
row_writes.series1.label(write/60)
row_writes.series2.label(update/60)
row_writes.series3.label(delete/60)
VariablesData Item
deletemysql:status:Handler_delete
updatemysql:status:Handler_update
writemysql:status:Handler_write

slave_seconds_behind.name

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.

Nameslave_seconds_behind.name
Range Labelslave_seconds_behind.rangeLabel
SeriesExpression
slave_seconds_behind.series1.labelsbehind
VariablesData Item
sbehindmysql:slavestatus:Seconds_Behind_Master

sorting.name

Shows the number of different sort operations performed on queries.

Namesorting.name
Range Labelsorting.rangeLabel
SeriesExpression
sorting.series1.labelSort_merge_passes
sorting.series2.labelSort_range
sorting.series3.labelSort_scan
VariablesData Item
Sort_merge_passesmysql:status:Sort_merge_passes
Sort_rangemysql:status:Sort_range
Sort_scanmysql:status:Sort_scan

table_locks.name

Shows the average number of table locks per second.

Nametable_locks.name
Range Labeltable_locks.rangeLabel
SeriesExpression
table_locks.series1.label(locks_waited/60)
table_locks.series2.label(locks_immediate/60)
VariablesData Item
locks_waitedmysql:status:Table_locks_waited
locks_immediatemysql:status:Table_locks_immediate

temporary_tables.name

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.name
Range Labeltemporary_tables.rangeLabel
SeriesExpression
temporary_tables.series1.labelmemoryTempTables
temporary_tables.series2.labeldiskTempTables
VariablesData Item
memoryTempTablesmysql:status:Created_tmp_tables
diskTempTablesmysql:status:Created_tmp_disk_tables

thread_cache.name

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

Namethread_cache.name
Range Labelthread_cache.rangeLabel
SeriesExpression
thread_cache.series1.labeltcreated
thread_cache.series2.labelconnections
VariablesData Item
tcreatedmysql:status:Threads_created
connectionsmysql:status:Connections
Copyright © 2010-2020 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout