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 823 823 The number of connections that were aborted because the client died without closing the connection properly.
Aborted connects Documentation 7 M 7036698 The number of failed attempts to connect to the MySQL server.
Access denied errors Documentation 7 M 7036710
Aria pagecache blocks not flushed Documentation 0 0
Aria pagecache blocks unused Documentation 15.7 k 15736
Aria pagecache blocks used Documentation 15.7 k 15736
Aria pagecache read requests Documentation 762.1 M 762068541
Aria pagecache reads Documentation 27.4 M 27378305
Aria pagecache write requests Documentation 145.6 M 145578454
Aria pagecache writes Documentation 1.1 M 1087322
Aria transaction log syncs Documentation 89 89
Binlog commits Documentation 3.3 M 3288023
Binlog group commits Documentation 3.3 M 3288023
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 mysql-bin.000002 mysql-bin.000002
Binlog snapshot position Documentation 427.8 M 427831707
Binlog bytes written Documentation 1.5 G 1501458210
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 3.3 M 3288023 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 30.4 G 30374411874
Bytes sent Documentation 270.7 G 270702432257
Com admin commands Documentation 9 k 8987
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 table Documentation 2 2
Com alter tablespace Documentation 0 0
Com analyze Documentation 0 0
Com assign to keycache Documentation 0 0
Com begin Documentation 66 66
Com binlog Documentation 0 0
Com call procedure Documentation 5.2 k 5179
Com change db Documentation 14.1 M 14056237
Com change master Documentation 0 0
Com check Documentation 0 0
Com checksum Documentation 0 0
Com commit Documentation 64 64
Com create db Documentation 0 0
Com create event Documentation 0 0
Com create function Documentation 5 5
Com create index Documentation 6 6
Com create procedure Documentation 57 57
Com create role Documentation 0 0
Com create server Documentation 0 0
Com create table Documentation 872 872
Com create trigger Documentation 0 0
Com create udf Documentation 0 0
Com create user Documentation 0 0
Com create view Documentation 0 0
Com delete Documentation 0 0
Com delete multi Documentation 0 0
Com do Documentation 0 0
Com drop db Documentation 0 0
Com drop event Documentation 0 0
Com drop function Documentation 5 5
Com drop index Documentation 0 0
Com drop procedure Documentation 60 60
Com drop role Documentation 0 0
Com drop server Documentation 0 0
Com drop table Documentation 916 916
Com drop trigger Documentation 0 0
Com drop user Documentation 0 0
Com drop view Documentation 0 0
Com empty query Documentation 0 0
Com flush Documentation 4 4
Com get diagnostics Documentation 0 0
Com grant Documentation 0 0
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 70 70
Com insert select Documentation 3.3 M 3287275
Com install plugin Documentation 0 0
Com kill Documentation 11 11
Com load Documentation 0 0
Com lock tables Documentation 0 0
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 0 0
Com rename table Documentation 0 0
Com rename user Documentation 0 0
Com repair Documentation 0 0
Com replace Documentation 0 0
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 3 3
Com rollback to savepoint Documentation 0 0
Com savepoint Documentation 0 0
Com select Documentation 127.3 M 127269787
Com set option Documentation 21.1 M 21089974
Com show authors Documentation 0 0
Com show binlog events Documentation 20 20
Com show binlogs Documentation 1.9 k 1863
Com show charsets Documentation 4 4
Com show client statistics Documentation 0 0
Com show collations Documentation 765 765
Com show contributors Documentation 0 0
Com show create db Documentation 1 1
Com show create event Documentation 0 0
Com show create func Documentation 61.8 k 61786
Com show create proc Documentation 688.5 k 688457
Com show create table Documentation 7.3 M 7278234
Com show create trigger Documentation 0 0
Com show databases Documentation 81 81
Com show engine logs Documentation 0 0
Com show engine mutex Documentation 0 0
Com show engine status Documentation 2 2
Com show errors Documentation 0 0
Com show events Documentation 0 0
Com show explain Documentation 0 0
Com show fields Documentation 21.3 M 21288066
Com show function status Documentation 0 0
Com show grants Documentation 7 M 7012924
Com show index statistics Documentation 0 0
Com show keys Documentation 7.3 M 7289718
Com show master status Documentation 1.5 k 1472
Com show open tables Documentation 0 0
Com show plugins Documentation 0 0
Com show privileges Documentation 0 0
Com show procedure status Documentation 0 0
Com show processlist Documentation 9 9
Com show profile Documentation 0 0
Com show profiles Documentation 45 45
Com show relaylog events Documentation 0 0
Com show slave hosts Documentation 15 15
Com show slave status Documentation 1.6 k 1591
Com show status Documentation 191 191
Com show storage engines Documentation 8.8 k 8773
Com show table statistics Documentation 0 0
Com show table status Documentation 1.2 k 1158
Com show tables Documentation 21.1 M 21127900
Com show triggers Documentation 843 843
Com show user statistics Documentation 0 0
Com show variables Documentation 14 M 13953598
Com show warnings Documentation 7 M 6969790
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 621 621
Com stmt execute Documentation 622 622
Com stmt fetch Documentation 0 0
Com stmt prepare Documentation 622 622
Com stmt reprepare Documentation 1 1
Com stmt reset Documentation 0 0
Com stmt send long data Documentation 0 0
Com stop all slaves Documentation 0 0
Com stop slave Documentation 0 0
Com truncate Documentation 0 0
Com uninstall plugin Documentation 0 0
Com unlock tables Documentation 0 0
Com update Documentation 344 344
Com update multi Documentation 3 3
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 0 0
Connection errors peer address Documentation 0 0
Connection errors select Documentation 0 0
Connection errors tcpwrap Documentation 0 0
Connections Documentation 24.6 M 24601554 The number of connection attempts (successful or not) to the MySQL server.
Cpu time Documentation 0 0.000000
Created tmp disk tables Documentation 47.4 M 47365087 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 723 723 How many temporary files mysqld has created.
Created tmp tables Documentation 251.5 M 251534270 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 0 0
Empty queries Documentation 40.1 M 40059017
Executed events Documentation 3.5 M 3505237
Executed triggers Documentation 0 0
Feature delay key write Documentation 585 585
Feature dynamic columns Documentation 0 0
Feature fulltext Documentation 0 0
Feature gis Documentation 0 0
Feature locale Documentation 7 M 7029323
Feature subquery Documentation 17.6 M 17614034
Feature timezone Documentation 0 0
Feature trigger Documentation 40.9 k 40854
Feature xml Documentation 0 0
Flush commands Documentation 1 1 The number of executed FLUSH statements.
Handler commit Documentation 19.6 M 19624963 The number of internal COMMIT statements.
Handler delete Documentation 51 51 The number of times a row was deleted from a table.
Handler discover Documentation 0 0 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 5.9 M 5880050
Handler icp match Documentation 5.9 M 5880028
Handler mrr init Documentation 0 0
Handler mrr key refills Documentation 0 0
Handler mrr rowid refills Documentation 0 0
Handler prepare Documentation 1.1 k 1058
Handler read first Documentation 9.9 M 9874100 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 494 M 494036902 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 896 896
Handler read next Documentation 2.5 G 2506821031 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 M 1038694 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 385.9 M 385908942 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 13.9 M 13893360
Handler read rnd next Documentation 1.5 G 1511530744 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 38 38 The number of internal ROLLBACK statements.
Handler savepoint Documentation 0 0
Handler savepoint rollback Documentation 0 0
Handler tmp update Documentation 6.8 M 6846890
Handler tmp write Documentation 2.7 G 2725479014
Handler update Documentation 3.5 M 3507028 The number of requests to update a row in a table.
Handler write Documentation 382.1 M 382119751 The number of requests to insert a row in a table.
Innodb available undo logs Documentation 128 128
Innodb background log sync Documentation 2.5 M 2485648
Innodb buffer pool bytes data Documentation 961.5 M 961544192
Innodb buffer pool bytes dirty Documentation 0 0
Innodb buffer pool dump status Documentation not started not started
Innodb buffer pool load status Documentation not started not started
Innodb buffer pool pages data Documentation 320.8 k 320832 The number of pages containing data (dirty or clean).
Innodb buffer pool pages dirty Documentation 0 0 The number of pages currently dirty.
Innodb buffer pool pages flushed Documentation 1.1 M 1085977 The number of buffer pool pages that have been requested to be flushed.
Innodb buffer pool pages free Documentation 4.1 k 4096 The number of free pages.
Innodb buffer pool pages lru flushed Documentation 0 0
Innodb buffer pool pages made not young Documentation 5.2 M 5205048
Innodb buffer pool pages made young Documentation 62.9 k 62911
Innodb buffer pool pages misc Documentation 2.7 k 2748 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 118.4 k 118350
Innodb buffer pool pages total Documentation 327.7 k 327676 Total size of buffer pool, in pages.
Innodb buffer pool read ahead Documentation 51.8 k 51784
Innodb buffer pool read ahead evicted Documentation 0 0
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 requests Documentation 4 G 4016881973 The number of logical read requests InnoDB has done.
Innodb buffer pool reads Documentation 61.1 k 61121 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 98 98 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 782 M 782000470 The number writes done to the InnoDB buffer pool.
Innodb checkpoint age Documentation 0 0
Innodb checkpoint max age Documentation 869 M 869019772
Innodb data fsyncs Documentation 204.3 k 204255 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 1.8 G 1849938432 The amount of data read so far, in bytes.
Innodb data reads Documentation 119.9 k 119856 The total number of data reads.
Innodb data writes Documentation 4.5 M 4534562 The total number of data writes.
Innodb data written Documentation 4.3 G 4282699776 The amount of data written so far, in bytes.
Innodb dblwr pages written Documentation 1.1 M 1085977 The number of pages that have been written for doublewrite operations.
Innodb dblwr writes Documentation 50 k 50019 The number of doublewrite operations that have been performed.
Innodb deadlocks Documentation 0 0
Innodb have atomic builtins Documentation ON ON
Innodb history list length Documentation 872 872
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 3 3
Innodb ibuf merged deletes Documentation 0 0
Innodb ibuf merged inserts Documentation 0 0
Innodb ibuf merges Documentation 3 3
Innodb ibuf segment size Documentation 2 2
Innodb ibuf size Documentation 1 1
Innodb log waits Documentation 0 0 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 61.7 M 61700067 The number of log write requests.
Innodb log writes Documentation 3.3 M 3337553 The number of physical writes to the log file.
Innodb lsn current Documentation 121.2 G 121237313068
Innodb lsn flushed Documentation 121.2 G 121237313068
Innodb lsn last checkpoint Documentation 121.2 G 121237313068
Innodb master thread active loops Documentation 60.5 k 60520
Innodb master thread idle loops Documentation 2.4 M 2425148
Innodb max trx id Documentation 90.7 M 90654949
Innodb mem adaptive hash Documentation 130 M 130026448
Innodb mem dictionary Documentation 32.8 M 32843938
Innodb mem total Documentation 1.3 G 1262485504
Innodb mutex os waits Documentation 3 M 3022676
Innodb mutex spin rounds Documentation 140.8 M 140828483
Innodb mutex spin waits Documentation 3.1 M 3136748
Innodb oldest view low limit trx id Documentation 0 0
Innodb os log fsyncs Documentation 87.6 k 87571 The number of fsync() writes done to the log file.
Innodb os log pending fsyncs Documentation 0 0 The number of pending log file fsyncs.
Innodb os log pending writes Documentation 0 0 Pending log file writes.
Innodb os log written Documentation 33.1 G 33101416448 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 1.1 M 1095829 The number of pages created.
Innodb pages read Documentation 112.9 k 112904 The number of pages read.
Innodb pages written Documentation 1.1 M 1085977 The number of pages written.
Innodb purge trx id Documentation 86.5 M 86487140
Innodb purge undo no Documentation 0 0
Innodb read views memory Documentation 86.5 M 86519544
Innodb row lock current waits Documentation 0 0 The number of row locks currently being waited for.
Innodb row lock time Documentation 0 0 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 0 0 The maximum time to acquire a row lock, in milliseconds.
Innodb row lock waits Documentation 0 0 The number of times a row lock had to be waited for.
Innodb rows deleted Documentation 0 0 The number of rows deleted from InnoDB tables.
Innodb rows inserted Documentation 373.9 M 373856689 The number of rows inserted in InnoDB tables.
Innodb rows read Documentation 3.2 G 3155343594 The number of rows read from InnoDB tables.
Innodb rows updated Documentation 1.8 k 1791 The number of rows updated in InnoDB tables.
Innodb system rows deleted Documentation 0 0
Innodb system rows inserted Documentation 0 0
Innodb system rows read Documentation 316 316
Innodb system rows updated Documentation 0 0
Innodb s lock os waits Documentation 49.4 k 49413
Innodb s lock spin rounds Documentation 1.5 M 1491131
Innodb s lock spin waits Documentation 44.2 k 44247
Innodb truncated status writes Documentation 0 0
Innodb x lock os waits Documentation 1 k 1030
Innodb x lock spin rounds Documentation 68.2 k 68243
Innodb x lock spin waits Documentation 10.4 k 10393
Innodb secondary index triggered cluster reads Documentation 77.2 M 77163612
Innodb secondary index triggered cluster reads avoided Documentation 0 0
Innodb buffered aio submitted Documentation 0 0
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 105.7 k 105655 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 5.8 k 5758 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 0 0
Key read requests Documentation 182.7 M 182703385 The number of requests to read a key block from the cache.
Key reads Documentation 499.7 k 499680 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 230 230 The number of requests to write a key block to the cache.
Key writes Documentation 230 230 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.
Max used connections Documentation 138 138 The maximum number of connections that have been in use simultaneously since the server started.
Memory used Documentation 453.4 M 453365072
Not flushed delayed rows Documentation 0 0 The number of rows waiting to be written in INSERT DELAYED queues.
Open files Documentation 173 173 The number of files that are open.
Open streams Documentation 0 0 The number of streams that are open (used mainly for logging).
Open table definitions Documentation 2 k 1987
Open tables Documentation 2 k 2000 The number of tables that are open.
Opened files Documentation 200.4 M 200402372
Opened plugin libraries Documentation 182 182
Opened table definitions Documentation 6.2 M 6191386
Opened tables Documentation 5.3 M 5265042 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 81.8 k 81773
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 locker lost Documentation 0 0
Performance schema mutex classes lost Documentation 0 0
Performance schema mutex instances 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 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 312.1 M 312065654
Questions Documentation 262.2 M 262162536
Rows read Documentation 7.8 G 7840881889
Rows sent Documentation 2.9 G 2931749978
Rows tmp read Documentation 9.6 G 9589223690
Rpl status Documentation AUTH_MASTER AUTH_MASTER The status of failsafe replication (not yet implemented).
Select full join Documentation 7 M 7025405 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 0 0 The number of joins that used a range search on a reference table.
Select range Documentation 44 44 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 108 108 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 240.5 M 240480714 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.
Slaves connected Documentation 0 0
Slaves running Documentation 0 0
Slow launch threads Documentation 0 0 The number of threads that have taken more than slow_launch_time seconds to create.
Slow queries Documentation 75 75 The number of queries that have taken more than long_query_time seconds. Documentation
Sort merge passes Documentation 567 567 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 2.7 k 2715
Sort range Documentation 121 121 The number of sorts that were done with ranges.
Sort rows Documentation 390.3 M 390335421 The number of sorted rows.
Sort scan Documentation 14.1 M 14058399 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
Subquery cache hit Documentation 19.2 k 19200
Subquery cache miss Documentation 456 456
Syncs Documentation 1.1 k 1141
Table locks immediate Documentation 33.9 M 33914001 The number of times that a table lock was acquired immediately.
Table locks waited Documentation 852.2 k 852230 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.
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 7 7
Threads cached Documentation 0 0 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 5 5 The number of currently open connections.
Threads created Documentation 7.4 k 7416 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 1 1 The number of threads that are not sleeping.
Update scan Documentation 140 140
Uptime Documentation 28 days, 23 hours, 29 minutes and 2 seconds 2503742
Uptime since flush status Documentation 28 days, 23 hours, 29 minutes and 2 seconds 2503742
Key buffer fraction % 19.39 % 19.391632080078 Percentage of used key cache (calculated value)
Key write ratio % 100.00 % 100 Percentage of physical writes compared to write requests (calculated value)
Key read ratio % 0.27 % 0.27349246977553 Key cache miss calculated as rate of physical reads compared to read requests (calculated value)
Threads cache hitrate % 99.97 % 99.969855562783 Thread cache hit rate (calculated value)