Aborted clients![Documentation Documentation](themes/dot.gif) | 00 | The number of connections that were aborted because the client died without closing the connection properly. |
---|
Aborted connects![Documentation Documentation](themes/dot.gif) | 150 150 | The number of failed attempts to connect to the MySQL server. |
---|
Binlog cache disk use![Documentation Documentation](themes/dot.gif) | 00 | The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction. |
---|
Binlog cache use![Documentation Documentation](themes/dot.gif) | 00 | The number of transactions that used the temporary binary log cache. |
---|
Binlog stmt cache disk use![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Binlog stmt cache use![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Bytes received![Documentation Documentation](themes/dot.gif) | 2.7 G2701742551 | |
---|
Bytes sent![Documentation Documentation](themes/dot.gif) | 12.4 G12435617937 | |
---|
Com admin commands![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com assign to keycache![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com alter db![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com alter db upgrade![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com alter event![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com alter function![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com alter procedure![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com alter server![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com alter table![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com alter tablespace![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com alter user![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com analyze![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com begin![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com binlog![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com call procedure![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com change db![Documentation Documentation](themes/dot.gif) | 1.6 M1596777 | |
---|
Com change master![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com check![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com checksum![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com commit![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create db![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create event![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create function![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create index![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create procedure![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create server![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create table![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create trigger![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create udf![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create user![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com create view![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com delete![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com delete multi![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com do![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com drop db![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com drop event![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com drop function![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com drop index![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com drop procedure![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com drop server![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com drop table![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com drop trigger![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com drop user![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com drop view![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com empty query![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com flush![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com get diagnostics![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com grant![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com ha close![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com ha open![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com ha read![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com help![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com insert![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com insert select![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com install plugin![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com kill![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com load![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com lock tables![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com optimize![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com preload keys![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com purge![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com purge before date![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com release savepoint![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com rename table![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com rename user![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com repair![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com replace![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com replace select![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com reset![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com resignal![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com revoke![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com revoke all![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com rollback![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com rollback to savepoint![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com savepoint![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com select![Documentation Documentation](themes/dot.gif) | 9 M8954757 | |
---|
Com set option![Documentation Documentation](themes/dot.gif) | 1.6 M1615826 | |
---|
Com signal![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show binlog events![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show binlogs![Documentation Documentation](themes/dot.gif) | 525.5 k525492 | |
---|
Com show charsets![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show collations![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show create db![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show create event![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show create func![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show create proc![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show create table![Documentation Documentation](themes/dot.gif) | 103.1 k103092 | |
---|
Com show create trigger![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show databases![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show engine logs![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show engine mutex![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show engine status![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show events![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show errors![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show fields![Documentation Documentation](themes/dot.gif) | 1.3 M1287799 | |
---|
Com show function code![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show function status![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show grants![Documentation Documentation](themes/dot.gif) | 147.6 k147637 | |
---|
Com show keys![Documentation Documentation](themes/dot.gif) | 813 k813041 | |
---|
Com show master status![Documentation Documentation](themes/dot.gif) | 133.5 k133527 | |
---|
Com show open tables![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show plugins![Documentation Documentation](themes/dot.gif) | 10.4 k10414 | |
---|
Com show privileges![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show procedure code![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show procedure status![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show processlist![Documentation Documentation](themes/dot.gif) | 9.3 k9280 | |
---|
Com show profile![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show profiles![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show relaylog events![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show slave hosts![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show slave status![Documentation Documentation](themes/dot.gif) | 133.5 k133527 | |
---|
Com show status![Documentation Documentation](themes/dot.gif) | 12.2 k12249 | |
---|
Com show storage engines![Documentation Documentation](themes/dot.gif) | 21.4 k21424 | |
---|
Com show table status![Documentation Documentation](themes/dot.gif) | 39.2 k39219 | |
---|
Com show tables![Documentation Documentation](themes/dot.gif) | 1.3 M1286834 | |
---|
Com show triggers![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com show variables![Documentation Documentation](themes/dot.gif) | 353.2 k353202 | |
---|
Com show warnings![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com slave start![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com slave stop![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com stmt close![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com stmt execute![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com stmt fetch![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com stmt prepare![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com stmt reprepare![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com stmt reset![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com stmt send long data![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com truncate![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com uninstall plugin![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com unlock tables![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com update![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com update multi![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com xa commit![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com xa end![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com xa prepare![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com xa recover![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com xa rollback![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Com xa start![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Compression![Documentation Documentation](themes/dot.gif) | OFFOFF | |
---|
Connection errors accept![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Connection errors internal![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Connection errors max connections![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Connection errors peer address![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Connection errors select![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Connection errors tcpwrap![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Connections![Documentation Documentation](themes/dot.gif) | 836.7 k836652 | The number of connection attempts (successful or not) to the MySQL server. |
---|
Created tmp disk tables![Documentation Documentation](themes/dot.gif) | 3.3 M3317576 | The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based. |
---|
Created tmp files![Documentation Documentation](themes/dot.gif) | 5 5 | How many temporary files mysqld has created. |
---|
Created tmp tables![Documentation Documentation](themes/dot.gif) | 21 M20951083 | The number of in-memory temporary tables created automatically by the server while executing statements. |
---|
Delayed errors![Documentation Documentation](themes/dot.gif) | 00 | The number of rows written with INSERT DELAYED for which some error occurred (probably duplicate key). |
---|
Delayed insert threads![Documentation Documentation](themes/dot.gif) | 00 | The number of INSERT DELAYED handler threads in use. Every different table on which one uses INSERT DELAYED gets its own thread. |
---|
Delayed writes![Documentation Documentation](themes/dot.gif) | 00 | The number of INSERT DELAYED rows written. |
---|
Flush commands![Documentation Documentation](themes/dot.gif) | 1 1 | The number of executed FLUSH statements. |
---|
Handler commit![Documentation Documentation](themes/dot.gif) | 10 k10009 | The number of internal COMMIT statements. |
---|
Handler delete![Documentation Documentation](themes/dot.gif) | 00 | The number of times a row was deleted from a table. |
---|
Handler discover![Documentation Documentation](themes/dot.gif) | 00 | The MySQL server can ask the NDB Cluster storage engine if it knows about a table with a given name. This is called discovery. Handler_discover indicates the number of time tables have been discovered. |
---|
Handler external lock![Documentation Documentation](themes/dot.gif) | 907.9 k907892 | |
---|
Handler mrr init![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Handler prepare![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Handler read first![Documentation Documentation](themes/dot.gif) | 206.8 k206839 | The number of times the first entry was read from an index. If this is high, it suggests that the server is doing a lot of full index scans; for example, SELECT col1 FROM foo, assuming that col1 is indexed. |
---|
Handler read key![Documentation Documentation](themes/dot.gif) | 10 k10009 | The number of requests to read a row based on a key. If this is high, it is a good indication that your queries and tables are properly indexed. |
---|
Handler read last![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Handler read next![Documentation Documentation](themes/dot.gif) | 194.4 k194396 | The number of requests to read the next row in key order. This is incremented if you are querying an index column with a range constraint or if you are doing an index scan. |
---|
Handler read prev![Documentation Documentation](themes/dot.gif) | 00 | The number of requests to read the previous row in key order. This read method is mainly used to optimize ORDER BY … DESC. |
---|
Handler read rnd![Documentation Documentation](themes/dot.gif) | 11.8 M11795170 | The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly. |
---|
Handler read rnd next![Documentation Documentation](themes/dot.gif) | 452.8 M452847211 | The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have. |
---|
Handler rollback![Documentation Documentation](themes/dot.gif) | 00 | The number of internal ROLLBACK statements. |
---|
Handler savepoint![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Handler savepoint rollback![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Handler update![Documentation Documentation](themes/dot.gif) | 00 | The number of requests to update a row in a table. |
---|
Handler write![Documentation Documentation](themes/dot.gif) | 442.2 M442175824 | The number of requests to insert a row in a table. |
---|
Innodb buffer pool dump status![Documentation Documentation](themes/dot.gif) | not startednot started | |
---|
Innodb buffer pool load status![Documentation Documentation](themes/dot.gif) | not startednot started | |
---|
Innodb buffer pool pages data![Documentation Documentation](themes/dot.gif) | 354 354 | The number of pages containing data (dirty or clean). |
---|
Innodb buffer pool bytes data![Documentation Documentation](themes/dot.gif) | 5.8 M5799936 | |
---|
Innodb buffer pool pages dirty![Documentation Documentation](themes/dot.gif) | 00 | The number of pages currently dirty. |
---|
Innodb buffer pool bytes dirty![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Innodb buffer pool pages flushed![Documentation Documentation](themes/dot.gif) | 40 40 | The number of buffer pool pages that have been requested to be flushed. |
---|
Innodb buffer pool pages free![Documentation Documentation](themes/dot.gif) | 7.8 k7838 | The number of free pages. |
---|
Innodb buffer pool pages misc![Documentation Documentation](themes/dot.gif) | 00 | The number of pages busy because they have been allocated for administrative overhead such as row locks or the adaptive hash index. This value can also be calculated as Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data. |
---|
Innodb buffer pool pages total![Documentation Documentation](themes/dot.gif) | 8.2 k8192 | Total size of buffer pool, in pages. |
---|
Innodb buffer pool read ahead rnd![Documentation Documentation](themes/dot.gif) | 00 | The number of "random" read-aheads InnoDB initiated. This happens when a query is to scan a large portion of a table but in random order. |
---|
Innodb buffer pool read ahead![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Innodb buffer pool read ahead evicted![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Innodb buffer pool read requests![Documentation Documentation](themes/dot.gif) | 2.7 M2677992 | The number of logical read requests InnoDB has done. |
---|
Innodb buffer pool reads![Documentation Documentation](themes/dot.gif) | 355 355 | The number of logical reads that InnoDB could not satisfy from buffer pool and had to do a single-page read. |
---|
Innodb buffer pool wait free![Documentation Documentation](themes/dot.gif) | 00 | Normally, writes to the InnoDB buffer pool happen in the background. However, if it's necessary to read or create a page and no clean pages are available, it's necessary to wait for pages to be flushed first. This counter counts instances of these waits. If the buffer pool size was set properly, this value should be small. |
---|
Innodb buffer pool write requests![Documentation Documentation](themes/dot.gif) | 40 40 | The number writes done to the InnoDB buffer pool. |
---|
Innodb data fsyncs![Documentation Documentation](themes/dot.gif) | 161 161 | The number of fsync() operations so far. |
---|
Innodb data pending fsyncs![Documentation Documentation](themes/dot.gif) | 00 | The current number of pending fsync() operations. |
---|
Innodb data pending reads![Documentation Documentation](themes/dot.gif) | 00 | The current number of pending reads. |
---|
Innodb data pending writes![Documentation Documentation](themes/dot.gif) | 00 | The current number of pending writes. |
---|
Innodb data read![Documentation Documentation](themes/dot.gif) | 8 M7983104 | The amount of data read so far, in bytes. |
---|
Innodb data reads![Documentation Documentation](themes/dot.gif) | 511 511 | The total number of data reads. |
---|
Innodb data writes![Documentation Documentation](themes/dot.gif) | 161 161 | The total number of data writes. |
---|
Innodb data written![Documentation Documentation](themes/dot.gif) | 1.4 M1352704 | The amount of data written so far, in bytes. |
---|
Innodb dblwr pages written![Documentation Documentation](themes/dot.gif) | 40 40 | The number of pages that have been written for doublewrite operations. |
---|
Innodb dblwr writes![Documentation Documentation](themes/dot.gif) | 40 40 | The number of doublewrite operations that have been performed. |
---|
Innodb have atomic builtins![Documentation Documentation](themes/dot.gif) | ONON | |
---|
Innodb log waits![Documentation Documentation](themes/dot.gif) | 00 | The number of waits we had because log buffer was too small and we had to wait for it to be flushed before continuing. |
---|
Innodb log write requests![Documentation Documentation](themes/dot.gif) | 1 1 | The number of log write requests. |
---|
Innodb log writes![Documentation Documentation](themes/dot.gif) | 40 40 | The number of physical writes to the log file. |
---|
Innodb os log fsyncs![Documentation Documentation](themes/dot.gif) | 81 81 | The number of fsync() writes done to the log file. |
---|
Innodb os log pending fsyncs![Documentation Documentation](themes/dot.gif) | 00 | The number of pending log file fsyncs. |
---|
Innodb os log pending writes![Documentation Documentation](themes/dot.gif) | 00 | Pending log file writes. |
---|
Innodb os log written![Documentation Documentation](themes/dot.gif) | 21 k20992 | The number of bytes written to the log file. |
---|
Innodb page size![Documentation Documentation](themes/dot.gif) | 16.4 k16384 | The compiled-in InnoDB page size (default 16KB). Many values are counted in pages; the page size allows them to be easily converted to bytes. |
---|
Innodb pages created![Documentation Documentation](themes/dot.gif) | 00 | The number of pages created. |
---|
Innodb pages read![Documentation Documentation](themes/dot.gif) | 354 354 | The number of pages read. |
---|
Innodb pages written![Documentation Documentation](themes/dot.gif) | 40 40 | The number of pages written. |
---|
Innodb row lock current waits![Documentation Documentation](themes/dot.gif) | 00 | The number of row locks currently being waited for. |
---|
Innodb row lock time![Documentation Documentation](themes/dot.gif) | 00 | The total time spent in acquiring row locks, in milliseconds. |
---|
Innodb row lock time avg![Documentation Documentation](themes/dot.gif) | 00 | The average time to acquire a row lock, in milliseconds. |
---|
Innodb row lock time max![Documentation Documentation](themes/dot.gif) | 00 | The maximum time to acquire a row lock, in milliseconds. |
---|
Innodb row lock waits![Documentation Documentation](themes/dot.gif) | 00 | The number of times a row lock had to be waited for. |
---|
Innodb rows deleted![Documentation Documentation](themes/dot.gif) | 00 | The number of rows deleted from InnoDB tables. |
---|
Innodb rows inserted![Documentation Documentation](themes/dot.gif) | 00 | The number of rows inserted in InnoDB tables. |
---|
Innodb rows read![Documentation Documentation](themes/dot.gif) | 21.5 k21509 | The number of rows read from InnoDB tables. |
---|
Innodb rows updated![Documentation Documentation](themes/dot.gif) | 00 | The number of rows updated in InnoDB tables. |
---|
Innodb num open files![Documentation Documentation](themes/dot.gif) | 12 12 | |
---|
Innodb truncated status writes![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Innodb available undo logs![Documentation Documentation](themes/dot.gif) | 128 128 | |
---|
Key blocks not flushed![Documentation Documentation](themes/dot.gif) | 00 | The number of key blocks in the key cache that have changed but haven't yet been flushed to disk. It used to be known as Not_flushed_key_blocks. |
---|
Key blocks unused![Documentation Documentation](themes/dot.gif) | 14.3 k14342 | The number of unused blocks in the key cache. You can use this value to determine how much of the key cache is in use. |
---|
Key blocks used![Documentation Documentation](themes/dot.gif) | 5 5 | The number of used blocks in the key cache. This value is a high-water mark that indicates the maximum number of blocks that have ever been in use at one time. |
---|
Key read requests![Documentation Documentation](themes/dot.gif) | 173.3 k173288 | The number of requests to read a key block from the cache. |
---|
Key reads![Documentation Documentation](themes/dot.gif) | 5 5 | The number of physical reads of a key block from disk. If Key_reads is big, then your key_buffer_size value is probably too small. The cache miss rate can be calculated as Key_reads/Key_read_requests. |
---|
Key write requests![Documentation Documentation](themes/dot.gif) | 00 | The number of requests to write a key block to the cache. |
---|
Key writes![Documentation Documentation](themes/dot.gif) | 00 | The number of physical writes of a key block to disk. |
---|
Last query cost![Documentation Documentation](themes/dot.gif) | 00.000000 | The total cost of the last compiled query as computed by the query optimizer. Useful for comparing the cost of different query plans for the same query. The default value of 0 means that no query has been compiled yet. |
---|
Last query partial plans![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Max used connections![Documentation Documentation](themes/dot.gif) | 30 30 | The maximum number of connections that have been in use simultaneously since the server started. |
---|
Not flushed delayed rows![Documentation Documentation](themes/dot.gif) | 00 | The number of rows waiting to be written in INSERT DELAYED queues. |
---|
Open files![Documentation Documentation](themes/dot.gif) | 76 76 | The number of files that are open. |
---|
Open streams![Documentation Documentation](themes/dot.gif) | 00 | The number of streams that are open (used mainly for logging). |
---|
Open table definitions![Documentation Documentation](themes/dot.gif) | 84 84 | |
---|
Open tables![Documentation Documentation](themes/dot.gif) | 170 170 | The number of tables that are open. |
---|
Opened files![Documentation Documentation](themes/dot.gif) | 13.3 M13270499 | |
---|
Opened table definitions![Documentation Documentation](themes/dot.gif) | 84 84 | |
---|
Opened tables![Documentation Documentation](themes/dot.gif) | 3.2 M3206487 | The number of tables that have been opened. If opened tables is big, your table cache value is probably too small. |
---|
Performance schema accounts lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema cond classes lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema cond instances lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema digest lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema file classes lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema file handles lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema file instances lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema hosts lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema locker lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema mutex classes lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema mutex instances lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema rwlock classes lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema rwlock instances lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema session connect attrs lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema socket classes lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema socket instances lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema stage classes lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema statement classes lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema table handles lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema table instances lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema thread classes lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema thread instances lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Performance schema users lost![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Prepared stmt count![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Qcache free blocks![Documentation Documentation](themes/dot.gif) | 1 1 | The number of free memory blocks in query cache. High numbers can indicate fragmentation issues, which may be solved by issuing a FLUSH QUERY CACHE statement. |
---|
Qcache free memory![Documentation Documentation](themes/dot.gif) | 1 M1039896 | The amount of free memory for query cache. |
---|
Qcache hits![Documentation Documentation](themes/dot.gif) | 00 | The number of cache hits. |
---|
Qcache inserts![Documentation Documentation](themes/dot.gif) | 00 | The number of queries added to the cache. |
---|
Qcache lowmem prunes![Documentation Documentation](themes/dot.gif) | 00 | The number of queries that have been removed from the cache to free up memory for caching new queries. This information can help you tune the query cache size. The query cache uses a least recently used (LRU) strategy to decide which queries to remove from the cache. |
---|
Qcache not cached![Documentation Documentation](themes/dot.gif) | 9 M8954556 | The number of non-cached queries (not cachable, or not cached due to the query_cache_type setting). |
---|
Qcache queries in cache![Documentation Documentation](themes/dot.gif) | 00 | The number of queries registered in the cache. |
---|
Qcache total blocks![Documentation Documentation](themes/dot.gif) | 1 1 | The total number of blocks in the query cache. |
---|
Queries![Documentation Documentation](themes/dot.gif) | 17.9 M17882098 | |
---|
Questions![Documentation Documentation](themes/dot.gif) | 17.9 M17882097 | |
---|
Select full join![Documentation Documentation](themes/dot.gif) | 00 | The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables. |
---|
Select full range join![Documentation Documentation](themes/dot.gif) | 00 | The number of joins that used a range search on a reference table. |
---|
Select range![Documentation Documentation](themes/dot.gif) | 00 | The number of joins that used ranges on the first table. (It's normally not critical even if this is big.) |
---|
Select range check![Documentation Documentation](themes/dot.gif) | 00 | The number of joins without keys that check for key usage after each row. (If this is not 0, you should carefully check the indexes of your tables.) |
---|
Select scan![Documentation Documentation](themes/dot.gif) | 10.8 M10816070 | The number of joins that did a full scan of the first table. |
---|
Slave heartbeat period![Documentation Documentation](themes/dot.gif) | 00.000 | |
---|
Slave last heartbeat![Documentation Documentation](themes/dot.gif) | | |
---|
Slave open temp tables![Documentation Documentation](themes/dot.gif) | 00 | The number of temporary tables currently open by the slave SQL thread. |
---|
Slave received heartbeats![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Slave retried transactions![Documentation Documentation](themes/dot.gif) | 00 | Total (since startup) number of times the replication slave SQL thread has retried transactions. |
---|
Slave running![Documentation Documentation](themes/dot.gif) | OFFOFF | This is ON if this server is a slave that is connected to a master. |
---|
Slow launch threads![Documentation Documentation](themes/dot.gif) | 00 | The number of threads that have taken more than slow_launch_time seconds to create. |
---|
Slow queries![Documentation Documentation](themes/dot.gif) | 18 18 | The number of queries that have taken more than long_query_time seconds.![Documentation Documentation](themes/dot.gif) |
---|
Sort merge passes![Documentation Documentation](themes/dot.gif) | 00 | The number of merge passes the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable. |
---|
Sort range![Documentation Documentation](themes/dot.gif) | 00 | The number of sorts that were done with ranges. |
---|
Sort rows![Documentation Documentation](themes/dot.gif) | 11.8 M11795170 | The number of sorted rows. |
---|
Sort scan![Documentation Documentation](themes/dot.gif) | 1.2 M1202642 | The number of sorts that were done by scanning the table. |
---|
Ssl accept renegotiates![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl accepts![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl callback cache hits![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl cipher![Documentation Documentation](themes/dot.gif) | | |
---|
Ssl cipher list![Documentation Documentation](themes/dot.gif) | | |
---|
Ssl client connects![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl connect renegotiates![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl ctx verify depth![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl ctx verify mode![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl default timeout![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl finished accepts![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl finished connects![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl server not after![Documentation Documentation](themes/dot.gif) | | |
---|
Ssl server not before![Documentation Documentation](themes/dot.gif) | | |
---|
Ssl session cache hits![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl session cache misses![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl session cache mode![Documentation Documentation](themes/dot.gif) | NONENONE | |
---|
Ssl session cache overflows![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl session cache size![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl session cache timeouts![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl sessions reused![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl used session cache entries![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl verify depth![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl verify mode![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Ssl version![Documentation Documentation](themes/dot.gif) | | |
---|
Table locks immediate![Documentation Documentation](themes/dot.gif) | 453.9 k453946 | The number of times that a table lock was acquired immediately. |
---|
Table locks waited![Documentation Documentation](themes/dot.gif) | 00 | The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication. |
---|
Table open cache hits![Documentation Documentation](themes/dot.gif) | 9.8 M9767472 | |
---|
Table open cache misses![Documentation Documentation](themes/dot.gif) | 177 177 | |
---|
Table open cache overflows![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Tc log max pages used![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Tc log page size![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Tc log page waits![Documentation Documentation](themes/dot.gif) | 00 | |
---|
Threads cached![Documentation Documentation](themes/dot.gif) | 8 8 | The number of threads in the thread cache. The cache hit rate can be calculated as Threads_created/Connections. If this value is red you should raise your thread_cache_size. |
---|
Threads connected![Documentation Documentation](themes/dot.gif) | 1 1 | The number of currently open connections. |
---|
Threads created![Documentation Documentation](themes/dot.gif) | 130 130 | The number of threads created to handle connections. If Threads_created is big, you may want to increase the thread_cache_size value. (Normally this doesn't give a notable performance improvement if you have a good thread implementation.) |
---|
Threads running![Documentation Documentation](themes/dot.gif) | 1 1 | The number of threads that are not sleeping. |
---|
Uptime![Documentation Documentation](themes/dot.gif) | 1 days, 22 hours, 38 minutes and 18 seconds167898 | |
---|
Uptime since flush status![Documentation Documentation](themes/dot.gif) | 1 days, 22 hours, 38 minutes and 18 seconds167898 | |
---|
Key buffer fraction % | 12.46 %12.46337890625 | Percentage of used key cache (calculated value) |
---|
Key read ratio % | <0.01 %0.0028853700198513 | Key cache miss calculated as rate of physical reads compared to read requests (calculated value) |
---|
Threads cache hitrate % | 99.98 %99.984461879013 | Thread cache hit rate (calculated value) |
---|