• There are no recent tables.
  • There are no favorite tables.
Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Filters
Variable Value Description
Aborted clients Documentation 20.7 k 20707 The number of connections that were aborted because the client died without closing the connection properly.
Aborted connects Documentation 21 k 20982 The number of failed attempts to connect to the MySQL server.
Aborted connects preauth Documentation 1.9 k 1933
Access denied errors Documentation 51.1 k 51148
Acl column grants Documentation 0 0
Acl database grants Documentation 7.8 k 7753
Acl function grants Documentation 0 0
Acl procedure grants Documentation 0 0
Acl package spec grants Documentation 0 0
Acl package body grants Documentation 0 0
Acl proxy users Documentation 3 3
Acl role grants Documentation 0 0
Acl roles Documentation 0 0
Acl table grants Documentation 1 1
Acl users Documentation 5.7 k 5732
Aria pagecache blocks not flushed Documentation 0 0
Aria pagecache blocks unused Documentation 15.6 k 15644
Aria pagecache blocks used Documentation 15.5 k 15536
Aria pagecache read requests Documentation 1.3 G 1298826725
Aria pagecache reads Documentation 382.7 k 382714
Aria pagecache write requests Documentation 116.2 M 116220824
Aria pagecache writes Documentation 232 k 231959
Aria transaction log syncs Documentation 3.5 k 3542
Binlog commits Documentation 0 0
Binlog group commits Documentation 0 0
Binlog group commit trigger count Documentation 0 0
Binlog group commit trigger lock wait Documentation 0 0
Binlog group commit trigger timeout Documentation 0 0
Binlog snapshot file Documentation
Binlog snapshot position Documentation 0 0
Binlog bytes written Documentation 0 0
Binlog cache disk use Documentation 0 0 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 0 0 The number of transactions that used the temporary binary log cache.
Binlog stmt cache disk use Documentation 0 0
Binlog stmt cache use Documentation 0 0
Busy time Documentation 0 0.000000
Bytes received Documentation 117.2 G 117231727125
Bytes sent Documentation 3.1 T 3122464086173
Column compressions Documentation 0 0
Column decompressions Documentation 0 0
Com admin commands Documentation 30.4 k 30414
Com alter db Documentation 0 0
Com alter db upgrade Documentation 0 0
Com alter event Documentation 0 0
Com alter function Documentation 0 0
Com alter procedure Documentation 0 0
Com alter server Documentation 0 0
Com alter sequence Documentation 0 0
Com alter table Documentation 27.7 k 27734
Com alter user Documentation 1.3 k 1293
Com analyze Documentation 0 0
Com assign to keycache Documentation 0 0
Com backup Documentation 0 0
Com backup lock Documentation 0 0
Com begin Documentation 11.4 k 11407
Com binlog Documentation 0 0
Com call procedure Documentation 2 2
Com change db Documentation 4.1 M 4074515
Com change master Documentation 0 0
Com check Documentation 386 386
Com checksum Documentation 0 0
Com commit Documentation 9.3 k 9302
Com compound sql Documentation 0 0
Com create db Documentation 95 95
Com create event Documentation 0 0
Com create function Documentation 0 0
Com create index Documentation 0 0
Com create package Documentation 0 0
Com create package body Documentation 0 0
Com create procedure Documentation 0 0
Com create role Documentation 0 0
Com create sequence Documentation 0 0
Com create server Documentation 0 0
Com create table Documentation 19.4 k 19358
Com create temporary table Documentation 6 6
Com create trigger Documentation 0 0
Com create udf Documentation 0 0
Com create user Documentation 291 291
Com create view Documentation 136 136
Com delete Documentation 852.8 k 852832
Com delete multi Documentation 9.8 k 9795
Com do Documentation 42 42
Com drop db Documentation 107 107
Com drop event Documentation 0 0
Com drop function Documentation 0 0
Com drop index Documentation 0 0
Com drop procedure Documentation 0 0
Com drop package Documentation 0 0
Com drop package body Documentation 0 0
Com drop role Documentation 0 0
Com drop server Documentation 0 0
Com drop sequence Documentation 0 0
Com drop table Documentation 2.5 k 2542
Com drop temporary table Documentation 0 0
Com drop trigger Documentation 0 0
Com drop user Documentation 292 292
Com drop view Documentation 76 76
Com empty query Documentation 2.1 k 2075
Com enable governor Documentation 0 0
Com enable governor reconn Documentation 0 0
Com enable governor lve Documentation 3.1 k 3092
Com enable governor reconn lve Documentation 17 17
Com execute immediate Documentation 0 0
Com flush Documentation 256 256
Com get diagnostics Documentation 0 0
Com grant Documentation 1.3 k 1322
Com grant role Documentation 0 0
Com ha close Documentation 0 0
Com ha open Documentation 0 0
Com ha read Documentation 0 0
Com help Documentation 0 0
Com insert Documentation 2.6 M 2608608
Com insert select Documentation 177.4 k 177409
Com install plugin Documentation 0 0
Com kill Documentation 0 0
Com load Documentation 0 0
Com lock tables Documentation 3.8 k 3843
Com optimize Documentation 0 0
Com preload keys Documentation 0 0
Com purge Documentation 0 0
Com purge before date Documentation 0 0
Com release savepoint Documentation 2.1 k 2094
Com rename table Documentation 4 4
Com rename user Documentation 0 0
Com repair Documentation 70.3 k 70281
Com replace Documentation 365.1 k 365062
Com replace select Documentation 0 0
Com reset Documentation 0 0
Com resignal Documentation 0 0
Com revoke Documentation 0 0
Com revoke all Documentation 0 0
Com revoke role Documentation 0 0
Com rollback Documentation 10 10
Com rollback to savepoint Documentation 68.7 k 68698
Com savepoint Documentation 7.8 k 7777
Com select Documentation 760 M 760035210
Com set option Documentation 12.9 M 12904112
Com show authors Documentation 0 0
Com show binlog events Documentation 0 0
Com show binlogs Documentation 935 935
Com show charsets Documentation 95 95
Com show collations Documentation 0 0
Com show contributors Documentation 0 0
Com show create db Documentation 1 k 1044
Com show create event Documentation 0 0
Com show create func Documentation 15 15
Com show create package Documentation 0 0
Com show create package body Documentation 0 0
Com show create proc Documentation 38 38
Com show create table Documentation 118.4 k 118427
Com show create trigger Documentation 441 441
Com show create user Documentation 0 0
Com show databases Documentation 70.8 k 70820
Com show engine logs Documentation 0 0
Com show engine mutex Documentation 0 0
Com show engine status Documentation 185.9 k 185921
Com show errors Documentation 0 0
Com show events Documentation 1.1 k 1072
Com show explain Documentation 0 0
Com show analyze Documentation 0 0
Com show fields Documentation 3 M 2962997
Com show function status Documentation 1.1 k 1098
Com show generic Documentation 185.9 k 185908
Com show grants Documentation 10.2 k 10183
Com show keys Documentation 20.7 k 20713
Com show binlog status Documentation 262 262
Com show open tables Documentation 0 0
Com show package status Documentation 1.1 k 1050
Com show package body status Documentation 1.1 k 1050
Com show plugins Documentation 0 0
Com show privileges Documentation 0 0
Com show procedure status Documentation 1.1 k 1098
Com show processlist Documentation 50.2 k 50231
Com show profile Documentation 10.4 k 10412
Com show profiles Documentation 654 654
Com show relaylog events Documentation 0 0
Com show slave hosts Documentation 0 0
Com show slave status Documentation 265 265
Com show status Documentation 406.5 k 406503
Com show storage engines Documentation 608 608
Com show table status Documentation 2.9 k 2850
Com show tables Documentation 952.9 k 952853
Com show triggers Documentation 41 41
Com show variables Documentation 194.7 k 194741
Com show warnings Documentation 538 538
Com shutdown Documentation 0 0
Com signal Documentation 0 0
Com start all slaves Documentation 0 0
Com start slave Documentation 0 0
Com stmt close Documentation 8.2 M 8210237
Com stmt execute Documentation 8.2 M 8215317
Com stmt fetch Documentation 0 0
Com stmt prepare Documentation 8.2 M 8217846
Com stmt reprepare Documentation 0 0
Com stmt reset Documentation 0 0
Com stmt send long data Documentation 659 659
Com stop all slaves Documentation 0 0
Com stop slave Documentation 0 0
Com truncate Documentation 3.3 k 3346
Com uninstall plugin Documentation 0 0
Com unlock tables Documentation 6 k 5989
Com update Documentation 7.1 M 7144783
Com update multi Documentation 65.9 k 65924
Com xa commit Documentation 0 0
Com xa end Documentation 0 0
Com xa prepare Documentation 0 0
Com xa recover Documentation 0 0
Com xa rollback Documentation 0 0
Com xa start Documentation 0 0
Compression Documentation OFF OFF
Connection errors accept Documentation 0 0
Connection errors internal Documentation 0 0
Connection errors max connections Documentation 112 112
Connection errors peer address Documentation 0 0
Connection errors select Documentation 0 0
Connection errors tcpwrap Documentation 0 0
Connections Documentation 4.5 M 4545168 The number of connection attempts (successful or not) to the MySQL server.
Cpu time Documentation 0 0.000000
Created tmp disk tables Documentation 9 M 8958637 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 34.2 k 34204 How many temporary files mysqld has created.
Created tmp tables Documentation 38.4 M 38449889 The number of in-memory temporary tables created automatically by the server while executing statements.
Delayed errors Documentation 0 0 The number of rows written with INSERT DELAYED for which some error occurred (probably duplicate key).
Delayed insert threads Documentation 0 0 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 0 0 The number of INSERT DELAYED rows written.
Delete scan Documentation 73.7 k 73710
Empty queries Documentation 244.1 M 244065542
Enable governor Documentation 2 2
Executed events Documentation 0 0
Executed triggers Documentation 1.7 M 1721798
Feature application time periods Documentation 0 0
Feature check constraint Documentation 326.2 k 326192
Feature custom aggregate functions Documentation 0 0
Feature delay key write Documentation 0 0
Feature dynamic columns Documentation 0 0
Feature fulltext Documentation 7 7
Feature gis Documentation 15.4 k 15412
Feature insert returning Documentation 0 0
Feature invisible columns Documentation 0 0
Feature json Documentation 2 M 1957849
Feature locale Documentation 6.2 k 6231
Feature subquery Documentation 2.6 M 2573075
Feature system versioning Documentation 0 0
Feature timezone Documentation 99.1 k 99134
Feature trigger Documentation 138.3 k 138258
Feature window functions Documentation 429 429
Feature xml Documentation 0 0
Handler commit Documentation 547.5 M 547484429 The number of internal COMMIT statements.
Handler delete Documentation 2.2 M 2228697 The number of times a row was deleted from a table.
Handler discover Documentation 163.2 k 163224 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 0 0
Handler icp attempts Documentation 1.6 G 1595358899
Handler icp match Documentation 1.5 G 1517000372
Handler mrr init Documentation 0 0
Handler mrr key refills Documentation 0 0
Handler mrr rowid refills Documentation 0 0
Handler prepare Documentation 0 0
Handler read first Documentation 10.7 M 10671278 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 5.1 G 5144664524 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 1.8 M 1809875
Handler read next Documentation 7.3 G 7308222311 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 1.3 G 1281559697 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 retry Documentation 0 0
Handler read rnd Documentation 2.5 G 2464722548 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 deleted Documentation 277.3 k 277334
Handler read rnd next Documentation 28.5 G 28462880608 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 14 k 14000 The number of internal ROLLBACK statements.
Handler savepoint Documentation 7.8 k 7777
Handler savepoint rollback Documentation 68.7 k 68698
Handler tmp delete Documentation 0 0
Handler tmp update Documentation 82.3 M 82316407
Handler tmp write Documentation 3.6 G 3644131168
Handler update Documentation 7.2 M 7214326 The number of requests to update a row in a table.
Handler write Documentation 4.4 M 4406498 The number of requests to insert a row in a table.
Innodb adaptive hash hash searches Documentation 0 0
Innodb adaptive hash non hash searches Documentation 0 0
Innodb background log sync Documentation 185.6 k 185589
Innodb buffer pool dump status Documentation
Innodb buffer pool load status Documentation Buffer pool(s) load completed at 260311 4:21:01 Buffer pool(s) load completed at 260311 4:21:01
Innodb buffer pool resize status Documentation
Innodb buffer pool load incomplete Documentation OFF OFF
Innodb buffer pool pages data Documentation 820.6 k 820569 The number of pages containing data (dirty or clean).
Innodb buffer pool bytes data Documentation 12.7 G 12745064448
Innodb buffer pool pages dirty Documentation 5.4 k 5423 The number of pages currently dirty.
Innodb buffer pool bytes dirty Documentation 84.8 M 84811776
Innodb buffer pool pages flushed Documentation 2.2 M 2169930 The number of buffer pool pages that have been requested to be flushed.
Innodb buffer pool pages free Documentation 855 855 The number of free pages.
Innodb buffer pool pages made not young Documentation 44.4 M 44409067
Innodb buffer pool pages made young Documentation 1.8 M 1844488
Innodb buffer pool pages misc Documentation 18.4 E 18446744073709508944 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 old Documentation 302.9 k 302885
Innodb buffer pool pages total Documentation 778.8 k 778752 Total size of buffer pool, in pages.
Innodb buffer pool pages lru flushed Documentation 2.2 k 2204
Innodb buffer pool pages lru freed Documentation 2.7 M 2697568
Innodb buffer pool pages split Documentation 104.9 k 104884
Innodb buffer pool read ahead rnd Documentation 0 0 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 1.1 M 1111247
Innodb buffer pool read ahead evicted Documentation 0 0
Innodb buffer pool read requests Documentation 12.9 G 12888622329 The number of logical read requests InnoDB has done.
Innodb buffer pool reads Documentation 3.5 M 3493867 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 0 0 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 122.6 M 122563444 The number writes done to the InnoDB buffer pool.
Innodb checkpoint age Documentation 43.5 M 43513537
Innodb checkpoint max age Documentation 80.8 M 80819529
Innodb data fsyncs Documentation 8.4 M 8382658 The number of fsync() operations so far.
Innodb data pending fsyncs Documentation 0 0 The current number of pending fsync() operations.
Innodb data pending reads Documentation 0 0 The current number of pending reads.
Innodb data pending writes Documentation 0 0 The current number of pending writes.
Innodb data read Documentation 49.9 G 49885306880 The amount of data read so far, in bytes.
Innodb data reads Documentation 3.7 M 3661625 The total number of data reads.
Innodb data writes Documentation 2.3 M 2284041 The total number of data writes.
Innodb data written Documentation 63.1 G 63080824832 The amount of data written so far, in bytes.
Innodb dblwr pages written Documentation 1.8 M 1807697 The number of pages that have been written for doublewrite operations.
Innodb dblwr writes Documentation 25 k 24993 The number of doublewrite operations that have been performed.
Innodb deadlocks Documentation 0 0
Innodb history list length Documentation 2 2
Innodb ibuf discarded delete marks Documentation 0 0
Innodb ibuf discarded deletes Documentation 0 0
Innodb ibuf discarded inserts Documentation 0 0
Innodb ibuf free list Documentation 0 0
Innodb ibuf merged delete marks Documentation 0 0
Innodb ibuf merged deletes Documentation 0 0
Innodb ibuf merged inserts Documentation 0 0
Innodb ibuf merges Documentation 0 0
Innodb ibuf segment size Documentation 1.1 T 1103806595074
Innodb ibuf size Documentation 836.2 T 836178592923649
Innodb log waits Documentation 1 1 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 64.8 M 64787339 The number of log write requests.
Innodb log writes Documentation 7.8 M 7811592 The number of physical writes to the log file.
Innodb lsn current Documentation 12.8 T 12761099009679
Innodb lsn flushed Documentation 12.8 T 12761099009679
Innodb lsn last checkpoint Documentation 12.8 T 12761055496142
Innodb master thread active loops Documentation 131 131
Innodb master thread idle loops Documentation 185.5 k 185460
Innodb max trx id Documentation 11.3 G 11349399123
Innodb mem adaptive hash Documentation 0 0
Innodb mem dictionary Documentation 97.5 M 97457464
Innodb os log written Documentation 29.2 G 29175921272 The number of bytes written to the log file.
Innodb page size Documentation 16.4 k 16384 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 769.8 k 769772 The number of pages created.
Innodb pages read Documentation 3.5 M 3493867 The number of pages read.
Innodb pages written Documentation 2.2 M 2169930 The number of pages written.
Innodb row lock current waits Documentation 0 0 The number of row locks currently being waited for.
Innodb row lock time Documentation 5.7 k 5694 The total time spent in acquiring row locks, in milliseconds.
Innodb row lock time avg Documentation 0 0 The average time to acquire a row lock, in milliseconds.
Innodb row lock time max Documentation 1.2 k 1173 The maximum time to acquire a row lock, in milliseconds.
Innodb row lock waits Documentation 8.8 k 8783 The number of times a row lock had to be waited for.
Innodb num open files Documentation 4.1 k 4095
Innodb truncated status writes Documentation 0 0
Innodb available undo logs Documentation 128 128
Innodb undo truncations Documentation 0 0
Innodb page compression saved Documentation 0 0
Innodb num pages page compressed Documentation 0 0
Innodb num page compressed trim op Documentation 0 0
Innodb num pages page decompressed Documentation 0 0
Innodb num pages page compression error Documentation 0 0
Innodb num pages encrypted Documentation 0 0
Innodb num pages decrypted Documentation 0 0
Innodb have lz4 Documentation OFF OFF
Innodb have lzo Documentation OFF OFF
Innodb have lzma Documentation OFF OFF
Innodb have bzip2 Documentation OFF OFF
Innodb have snappy Documentation OFF OFF
Innodb have punch hole Documentation ON ON
Innodb defragment compression failures Documentation 0 0
Innodb defragment failures Documentation 0 0
Innodb defragment count Documentation 0 0
Innodb instant alter column Documentation 11 11
Innodb onlineddl rowlog rows Documentation 0 0
Innodb onlineddl rowlog pct used Documentation 0 0
Innodb onlineddl pct progress Documentation 0 0
Innodb encryption rotation pages read from cache Documentation 0 0
Innodb encryption rotation pages read from disk Documentation 0 0
Innodb encryption rotation pages modified Documentation 0 0
Innodb encryption rotation pages flushed Documentation 0 0
Innodb encryption rotation estimated iops Documentation 0 0
Innodb encryption n merge blocks encrypted Documentation 0 0
Innodb encryption n merge blocks decrypted Documentation 0 0
Innodb encryption n rowlog blocks encrypted Documentation 0 0
Innodb encryption n rowlog blocks decrypted Documentation 0 0
Innodb encryption n temp blocks encrypted Documentation 0 0
Innodb encryption n temp blocks decrypted Documentation 0 0
Innodb encryption num key requests Documentation 0 0
Innodb bulk operations Documentation 1.8 k 1769
Key blocks not flushed Documentation 0 0 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 24.4 k 24416 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 14.9 k 14894 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 blocks warm Documentation 1.2 k 1234
Key read requests Documentation 4.6 G 4639726852 The number of requests to read a key block from the cache.
Key reads Documentation 7.4 M 7373143 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 672.3 k 672291 The number of requests to write a key block to the cache.
Key writes Documentation 628.5 k 628480 The number of physical writes of a key block to disk.
Last query cost Documentation 0 0.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.
Master gtid wait count Documentation 0 0
Master gtid wait time Documentation 0 0
Master gtid wait timeouts Documentation 0 0
Max memory used Documentation NULL NULL
Max statement time exceeded Documentation 81 81
Max used connections Documentation 513 513 The maximum number of connections that have been in use simultaneously since the server started.
Memory used Documentation 13.3 G 13335584112
Memory used initial Documentation 13.1 G 13096628944
Not flushed delayed rows Documentation 0 0 The number of rows waiting to be written in INSERT DELAYED queues.
Open files Documentation 707 707 The number of files that are open.
Open streams Documentation 4 4 The number of streams that are open (used mainly for logging).
Open table definitions Documentation 4.1 k 4096
Open tables Documentation 4.1 k 4096 The number of tables that are open.
Opened files Documentation 186.6 M 186634853
Opened plugin libraries Documentation 203 203
Opened table definitions Documentation 131.1 M 131093381
Opened tables Documentation 80.9 M 80897860 The number of tables that have been opened. If opened tables is big, your table_open_cache value is probably too small.
Opened views Documentation 429 k 428950
Optimizer join prefixes check calls Documentation 308.8 M 308756842
Performance schema accounts lost Documentation 0 0
Performance schema cond classes lost Documentation 0 0
Performance schema cond instances lost Documentation 0 0
Performance schema digest lost Documentation 0 0
Performance schema file classes lost Documentation 0 0
Performance schema file handles lost Documentation 0 0
Performance schema file instances lost Documentation 0 0
Performance schema hosts lost Documentation 0 0
Performance schema index stat lost Documentation 0 0
Performance schema locker lost Documentation 0 0
Performance schema memory classes lost Documentation 0 0
Performance schema metadata lock lost Documentation 0 0
Performance schema mutex classes lost Documentation 0 0
Performance schema mutex instances lost Documentation 0 0
Performance schema nested statement lost Documentation 0 0
Performance schema prepared statements lost Documentation 0 0
Performance schema program lost Documentation 0 0
Performance schema rwlock classes lost Documentation 0 0
Performance schema rwlock instances lost Documentation 0 0
Performance schema session connect attrs lost Documentation 0 0
Performance schema socket classes lost Documentation 0 0
Performance schema socket instances lost Documentation 0 0
Performance schema stage classes lost Documentation 0 0
Performance schema statement classes lost Documentation 0 0
Performance schema table handles lost Documentation 0 0
Performance schema table instances lost Documentation 0 0
Performance schema table lock stat lost Documentation 0 0
Performance schema thread classes lost Documentation 0 0
Performance schema thread instances lost Documentation 0 0
Performance schema users lost Documentation 0 0
Prepared stmt count Documentation 0 0
Qcache free blocks Documentation 0 0 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 0 0 The amount of free memory for query cache.
Qcache hits Documentation 0 0 The number of cache hits.
Qcache inserts Documentation 0 0 The number of queries added to the cache.
Qcache lowmem prunes Documentation 0 0 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 0 0 The number of non-cached queries (not cachable, or not cached due to the query_cache_type setting).
Qcache queries in cache Documentation 0 0 The number of queries registered in the cache.
Qcache total blocks Documentation 0 0 The total number of blocks in the query cache.
Queries Documentation 817 M 816958664
Query time Documentation 161.2 k 161237.895385
Questions Documentation 797.1 M 797088102
Resultset metadata skipped Documentation 4.8 M 4751750
Rows read Documentation 37.1 G 37104327221
Rows sent Documentation 5.3 G 5325321302
Rows tmp read Documentation 5.3 G 5265378400
Rpl semi sync master clients Documentation 0 0
Rpl semi sync master get ack Documentation 0 0
Rpl semi sync master net avg wait time Documentation 0 0
Rpl semi sync master net wait time Documentation 0 0
Rpl semi sync master net waits Documentation 0 0
Rpl semi sync master no times Documentation 0 0
Rpl semi sync master no tx Documentation 0 0
Rpl semi sync master request ack Documentation 0 0
Rpl semi sync master status Documentation OFF OFF
Rpl semi sync master timefunc failures Documentation 0 0
Rpl semi sync master tx avg wait time Documentation 0 0
Rpl semi sync master tx wait time Documentation 0 0
Rpl semi sync master tx waits Documentation 0 0
Rpl semi sync master wait pos backtraverse Documentation 0 0
Rpl semi sync master wait sessions Documentation 0 0
Rpl semi sync master yes tx Documentation 0 0
Rpl semi sync slave send ack Documentation 0 0
Rpl semi sync slave status Documentation OFF OFF
Rpl status Documentation AUTH_MASTER AUTH_MASTER The status of failsafe replication (not yet implemented).
Rpl transactions multi engine Documentation 0 0
Select full join Documentation 7.9 M 7853046 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 1 M 1009403 The number of joins that used a range search on a reference table.
Select range Documentation 50.6 M 50579447 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 203.4 k 203357 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 35 M 35033431 The number of joins that did a full scan of the first table.
Slave connections Documentation 0 0
Slave heartbeat period Documentation 0 0.000
Slave open temp tables Documentation 0 0 The number of temporary tables currently open by the replica SQL thread.
Slave received heartbeats Documentation 0 0
Slave retried transactions Documentation 0 0 Total (since startup) number of times the replication replica SQL thread has retried transactions.
Slave running Documentation OFF OFF This is ON if this server is a replica that is connected to a primary.
Slave skipped errors Documentation 0 0
Slaves connected Documentation 0 0
Slaves running Documentation 0 0
Slow launch threads Documentation 1 1 The number of threads that have taken more than slow_launch_time seconds to create.
Slow queries Documentation 97 97 The number of queries that have taken more than long_query_time seconds. Documentation
Sort merge passes Documentation 17.1 k 17084 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 priority queue sorts Documentation 4.9 M 4928590
Sort range Documentation 14.5 M 14528460 The number of sorts that were done with ranges.
Sort rows Documentation 2.6 G 2595030077 The number of sorted rows.
Sort scan Documentation 37 M 36967743 The number of sorts that were done by scanning the table.
Ssl accept renegotiates Documentation 0 0
Ssl accepts Documentation 0 0
Ssl callback cache hits Documentation 0 0
Ssl cipher Documentation
Ssl cipher list Documentation
Ssl client connects Documentation 0 0
Ssl connect renegotiates Documentation 0 0
Ssl ctx verify depth Documentation 0 0
Ssl ctx verify mode Documentation 0 0
Ssl default timeout Documentation 0 0
Ssl finished accepts Documentation 0 0
Ssl finished connects Documentation 0 0
Ssl server not after Documentation
Ssl server not before Documentation
Ssl session cache hits Documentation 0 0
Ssl session cache misses Documentation 0 0
Ssl session cache mode Documentation NONE NONE
Ssl session cache overflows Documentation 0 0
Ssl session cache size Documentation 0 0
Ssl session cache timeouts Documentation 0 0
Ssl sessions reused Documentation 0 0
Ssl used session cache entries Documentation 0 0
Ssl verify depth Documentation 0 0
Ssl verify mode Documentation 0 0
Ssl version Documentation
Stack usage Documentation 0 0
Subquery cache hit Documentation 324 k 323998
Subquery cache miss Documentation 4 M 3952246
Syncs Documentation 274.9 k 274902
Table locks immediate Documentation 100.7 M 100723603 The number of times that a table lock was acquired immediately.
Table locks waited Documentation 22.2 k 22164 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 active instances Documentation 1 1
Table open cache hits Documentation 736.4 M 736378004
Table open cache misses Documentation 93.4 M 93398100
Table open cache overflows Documentation 63.5 M 63533963
Tc log max pages used Documentation 0 0
Tc log page size Documentation 0 0
Tc log page waits Documentation 0 0
Threadpool idle threads Documentation 0 0
Threadpool threads Documentation 0 0
Threads cached Documentation 214 214 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 59 59 The number of currently open connections.
Threads created Documentation 849 849 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 3 3 The number of threads that are not sleeping.
Transactions gtid foreign engine Documentation 0 0
Transactions multi engine Documentation 0 0
Update scan Documentation 15 k 15009
Uptime Documentation 2 days, 3 hours, 39 minutes and 28 seconds 185968
Uptime since flush status Documentation 2 days, 3 hours, 39 minutes and 28 seconds 185968
wsrep Documentation 0 0
wsrep applier thread count Documentation 0 0
wsrep cluster capabilities Documentation
wsrep cluster conf id Documentation 18.4 E 18446744073709551615
wsrep cluster size Documentation 0 0
wsrep cluster state uuid Documentation
wsrep cluster status Documentation Disconnected Disconnected
wsrep connected Documentation OFF OFF
wsrep local bf aborts Documentation 0 0
wsrep local index Documentation 18.4 E 18446744073709551615
wsrep provider capabilities Documentation
wsrep provider name Documentation
wsrep provider vendor Documentation
wsrep provider version Documentation
wsrep ready Documentation OFF OFF
wsrep rollbacker thread count Documentation 0 0
wsrep thread count Documentation 0 0
Key buffer fraction % 25.49 % 25.48828125 Percentage of used key cache (calculated value)
Key write ratio % 93.48 % 93.483327904137 Percentage of physical writes compared to write requests (calculated value)
Key read ratio % 0.16 % 0.15891329889004 Key cache miss calculated as rate of physical reads compared to read requests (calculated value)
Threads cache hitrate % 99.98 % 99.981320822465 Thread cache hit rate (calculated value)