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 11 11 The number of connections that were aborted because the client died without closing the connection properly.
Aborted connects Documentation 54 54 The number of failed attempts to connect to the MySQL server.
Acl cache items count Documentation 0 0
Binlog cache disk use Documentation 260 260 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 159.5 k 159474 The number of transactions that used the temporary binary log cache.
Binlog stmt cache disk use Documentation 0 0
Binlog stmt cache use Documentation 84.2 k 84231
Bytes received Documentation 952.9 M 952883768
Bytes sent Documentation 58.3 G 58302465464
Caching sha2 password rsa public key Documentation -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA4zRmw+4N9YxhykOrJkxi 7ZO4TnPKfs6GESRfHMLDs/ZY00mpRAYX1sxXK0myX8/zSRulPPn8KF9ysnhZIJX8 cHhUXrZAmlGqx50OPNQhT/cXD/wn5182dw01hiuAlwUro6rN1/f/qHskgbYNmmXJ iCND8+NqUFjOfrxjkWxafTL6P7pPlzkfBp9FRUcdQhC9qltLEofOYmpXrNroiQvI PtJoDgTzaQK0/AmJKQDsvFlvVbVLVw3cY4gfGD2C4zkcvtxzTVYVEik8votvXE8P 4m99CQ7SIGkWH2Sp/m1zF79oXZb3GiWD3UzH4f5sRL9ef8J3OCNrPHX+8wzqS4vy QQIDAQAB -----END PUBLIC KEY----- -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA4zRmw+4N9YxhykOrJkxi 7ZO4TnPKfs6GESRfHMLDs/ZY00mpRAYX1sxXK0myX8/zSRulPPn8KF9ysnhZIJX8 cHhUXrZAmlGqx50OPNQhT/cXD/wn5182dw01hiuAlwUro6rN1/f/qHskgbYNmmXJ iCND8+NqUFjOfrxjkWxafTL6P7pPlzkfBp9FRUcdQhC9qltLEofOYmpXrNroiQvI PtJoDgTzaQK0/AmJKQDsvFlvVbVLVw3cY4gfGD2C4zkcvtxzTVYVEik8votvXE8P 4m99CQ7SIGkWH2Sp/m1zF79oXZb3GiWD3UzH4f5sRL9ef8J3OCNrPHX+8wzqS4vy QQIDAQAB -----END PUBLIC KEY-----
Com admin commands Documentation 0 0
Com assign to keycache Documentation 0 0
Com alter db Documentation 0 0
Com alter event Documentation 0 0
Com alter function Documentation 0 0
Com alter instance Documentation 0 0
Com alter procedure Documentation 0 0
Com alter resource group Documentation 0 0
Com alter server Documentation 0 0
Com alter table Documentation 6 6
Com alter tablespace Documentation 0 0
Com alter user Documentation 0 0
Com alter user default role Documentation 0 0
Com analyze Documentation 0 0
Com begin Documentation 0 0
Com binlog Documentation 0 0
Com call procedure Documentation 0 0
Com change db Documentation 102.8 k 102830
Com change master Documentation 0 0
Com change repl filter Documentation 0 0
Com change replication source Documentation 0 0
Com check Documentation 0 0
Com checksum Documentation 0 0
Com clone Documentation 0 0
Com commit Documentation 0 0
Com create db Documentation 3 3
Com create event Documentation 0 0
Com create function Documentation 0 0
Com create index Documentation 0 0
Com create procedure Documentation 0 0
Com create role Documentation 0 0
Com create server Documentation 0 0
Com create table Documentation 84.4 k 84368
Com create resource group Documentation 0 0
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 create spatial reference system Documentation 0 0
Com delete Documentation 38.5 k 38492
Com delete multi Documentation 136 136
Com do Documentation 33 33
Com drop db Documentation 2 2
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 resource group Documentation 0 0
Com drop role Documentation 0 0
Com drop server Documentation 0 0
Com drop spatial reference system Documentation 0 0
Com drop table Documentation 1 1
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 explain other Documentation 0 0
Com flush Documentation 3 3
Com get diagnostics Documentation 0 0
Com grant Documentation 0 0
Com grant roles 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 import Documentation 0 0
Com insert Documentation 47.6 k 47588
Com insert select Documentation 1.7 k 1662
Com install component Documentation 0 0
Com install plugin Documentation 0 0
Com kill Documentation 0 0
Com load Documentation 0 0
Com lock instance Documentation 0 0
Com lock tables Documentation 3 3
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 5.1 k 5072
Com replace select Documentation 0 0
Com reset Documentation 0 0
Com resignal Documentation 0 0
Com restart Documentation 0 0
Com revoke Documentation 0 0
Com revoke all Documentation 0 0
Com revoke roles Documentation 0 0
Com rollback Documentation 0 0
Com rollback to savepoint Documentation 0 0
Com savepoint Documentation 0 0
Com select Documentation 5.4 M 5387421
Com set option Documentation 299 k 299013
Com set password Documentation 0 0
Com set resource group Documentation 0 0
Com set role Documentation 0 0
Com signal Documentation 0 0
Com show binlog events Documentation 4 4
Com show binlogs Documentation 101 101
Com show charsets Documentation 0 0
Com show collations Documentation 0 0
Com show create db Documentation 0 0
Com show create event Documentation 0 0
Com show create func Documentation 0 0
Com show create proc Documentation 0 0
Com show create table Documentation 10 k 9997
Com show create trigger Documentation 0 0
Com show databases Documentation 0 0
Com show engine logs Documentation 0 0
Com show engine mutex Documentation 0 0
Com show engine status Documentation 1 1
Com show events Documentation 0 0
Com show errors Documentation 0 0
Com show fields Documentation 82 k 82001
Com show function code Documentation 0 0
Com show function status Documentation 3 3
Com show grants Documentation 473 473
Com show keys Documentation 26 k 26016
Com show master status Documentation 146 146
Com show open tables Documentation 0 0
Com show plugins Documentation 0 0
Com show privileges Documentation 0 0
Com show procedure code Documentation 0 0
Com show procedure status Documentation 3 3
Com show processlist Documentation 2 2
Com show profile Documentation 0 0
Com show profiles Documentation 0 0
Com show relaylog events Documentation 0 0
Com show replicas Documentation 4 4
Com show slave hosts Documentation 4 4
Com show replica status Documentation 146 146
Com show slave status Documentation 146 146
Com show status Documentation 13 13
Com show storage engines Documentation 2.4 k 2409
Com show table status Documentation 612 612
Com show tables Documentation 66.2 k 66237
Com show triggers Documentation 6 6
Com show variables Documentation 9.9 k 9941
Com show warnings Documentation 2.2 k 2161
Com show create user Documentation 0 0
Com shutdown Documentation 0 0
Com replica start Documentation 0 0
Com slave start Documentation 0 0
Com replica stop Documentation 0 0
Com slave stop Documentation 0 0
Com group replication start Documentation 0 0
Com group replication stop Documentation 0 0
Com stmt execute Documentation 79 79
Com stmt close Documentation 79 79
Com stmt fetch Documentation 0 0
Com stmt prepare Documentation 79 79
Com stmt reset Documentation 0 0
Com stmt send long data Documentation 55 55
Com truncate Documentation 33 33
Com uninstall component Documentation 0 0
Com uninstall plugin Documentation 0 0
Com unlock instance Documentation 0 0
Com unlock tables Documentation 3 3
Com update Documentation 66.3 k 66334
Com update multi Documentation 13.5 k 13482
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
Com stmt reprepare Documentation 0 0
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 114.6 k 114640 The number of connection attempts (successful or not) to the MySQL server.
Created tmp disk tables Documentation 51 51 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 721 721 How many temporary files mysqld has created.
Created tmp tables Documentation 396.6 k 396570 The number of in-memory temporary tables created automatically by the server while executing statements.
Current tls ca Documentation ca.pem ca.pem
Current tls capath Documentation
Current tls cert Documentation server-cert.pem server-cert.pem
Current tls cipher Documentation
Current tls ciphersuites Documentation
Current tls crl Documentation
Current tls crlpath Documentation
Current tls key Documentation server-key.pem server-key.pem
Current tls version Documentation TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3
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.
Deprecated use i s processlist count Documentation 5 5
Deprecated use i s processlist last timestamp Documentation 1.8 P 1786006961199272
Error log buffered bytes Documentation 64.8 k 64824
Error log buffered events Documentation 460 460
Error log expired events Documentation 0 0
Error log latest write Documentation 1.8 P 1786007535885870
Flush commands Documentation 3 3 The number of executed FLUSH statements.
Global connection memory Documentation 0 0
Handler commit Documentation 6.2 M 6157243 The number of internal COMMIT statements.
Handler delete Documentation 44.8 k 44789 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 16.3 M 16349125
Handler mrr init Documentation 0 0
Handler prepare Documentation 316.7 k 316744
Handler read first Documentation 709.1 k 709083 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 40 M 39971866 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 18.3 k 18327
Handler read next Documentation 19.7 M 19682219 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 4.7 k 4734 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 665.6 k 665610 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 80.7 M 80722200 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 11 11 The number of internal ROLLBACK statements.
Handler savepoint Documentation 0 0
Handler savepoint rollback Documentation 0 0
Handler update Documentation 12 M 12016141 The number of requests to update a row in a table.
Handler write Documentation 12.3 M 12325468 The number of requests to insert a row in a table.
Innodb buffer pool dump status Documentation Dumping of buffer pool not started Dumping of buffer pool not started
Innodb buffer pool load status Documentation Buffer pool(s) load completed at 260716 12:44:13 Buffer pool(s) load completed at 260716 12:44:13
Innodb buffer pool resize status Documentation
Innodb buffer pool resize status code Documentation 0 0
Innodb buffer pool resize status progress Documentation 0 0
Innodb buffer pool pages data Documentation 6.9 k 6900 The number of pages containing data (dirty or clean).
Innodb buffer pool bytes data Documentation 113 M 113049600
Innodb buffer pool pages dirty Documentation 0 0 The number of pages currently dirty.
Innodb buffer pool bytes dirty Documentation 0 0
Innodb buffer pool pages flushed Documentation 809 k 809017 The number of buffer pool pages that have been requested to be flushed.
Innodb buffer pool pages free Documentation 1.1 k 1088 The number of free pages.
Innodb buffer pool pages misc Documentation 204 204 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 8.2 k 8192 Total size of buffer pool, in pages.
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 832 832
Innodb buffer pool read ahead evicted Documentation 0 0
Innodb buffer pool read requests Documentation 184.1 M 184095766 The number of logical read requests InnoDB has done.
Innodb buffer pool reads Documentation 28.5 k 28498 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 2.8 M 2844810 The number writes done to the InnoDB buffer pool.
Innodb data fsyncs Documentation 1.2 M 1178053 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 480.6 M 480610816 The amount of data read so far, in bytes.
Innodb data reads Documentation 35.9 k 35894 The total number of data reads.
Innodb data writes Documentation 1.8 M 1812466 The total number of data writes.
Innodb data written Documentation 1.4 G 1404855296 The amount of data written so far, in bytes.
Innodb dblwr pages written Documentation 808.6 k 808573 The number of pages that have been written for doublewrite operations.
Innodb dblwr writes Documentation 243.7 k 243665 The number of doublewrite operations that have been performed.
Innodb redo log read only Documentation OFF OFF
Innodb redo log uuid Documentation 761 M 761016667
Innodb redo log checkpoint lsn Documentation 5.5 G 5460535493
Innodb redo log current lsn Documentation 5.5 G 5460535493
Innodb redo log flushed to disk lsn Documentation 5.5 G 5460535493
Innodb redo log logical size Documentation 512 512
Innodb redo log physical size Documentation 6.6 M 6553600
Innodb redo log capacity resized Documentation 104.9 M 104857600
Innodb redo log resize status Documentation OK OK
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 2.2 M 2160708 The number of log write requests.
Innodb log writes Documentation 708.9 k 708872 The number of physical writes to the log file.
Innodb os log fsyncs Documentation 745.6 k 745649 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 746.5 M 746519552 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 3.6 k 3634 The number of pages created.
Innodb pages read Documentation 29.3 k 29329 The number of pages read.
Innodb pages written Documentation 809 k 809023 The number of pages written.
Innodb redo log enabled Documentation ON ON
Innodb row lock current waits Documentation 0 0 The number of row locks currently being waited for.
Innodb row lock time Documentation 101 101 The total time spent in acquiring row locks, in milliseconds.
Innodb row lock time avg Documentation 1 1 The average time to acquire a row lock, in milliseconds.
Innodb row lock time max Documentation 30 30 The maximum time to acquire a row lock, in milliseconds.
Innodb row lock waits Documentation 79 79 The number of times a row lock had to be waited for.
Innodb rows deleted Documentation 39.8 k 39795 The number of rows deleted from InnoDB tables.
Innodb rows inserted Documentation 170.5 k 170470 The number of rows inserted in InnoDB tables.
Innodb rows read Documentation 70.4 M 70382442 The number of rows read from InnoDB tables.
Innodb rows updated Documentation 67.9 k 67880 The number of rows updated in InnoDB tables.
Innodb system rows deleted Documentation 5 k 5000
Innodb system rows inserted Documentation 15.3 k 15299
Innodb system rows read Documentation 21.5 M 21540771
Innodb system rows updated Documentation 6 k 6028
Innodb sampled pages read Documentation 0 0
Innodb sampled pages skipped Documentation 0 0
Innodb num open files Documentation 300 300
Innodb truncated status writes Documentation 0 0
Innodb undo tablespaces total Documentation 2 2
Innodb undo tablespaces implicit Documentation 2 2
Innodb undo tablespaces explicit Documentation 0 0
Innodb undo tablespaces active Documentation 2 2
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 13.4 k 13396 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 3 3 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 21 21 The number of requests to read a key block from the cache.
Key reads Documentation 21 21 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 0 0 The number of requests to write a key block to the cache.
Key writes Documentation 0 0 The number of physical writes of a key block to disk.
Locked connects Documentation 0 0
Max execution time exceeded Documentation 0 0
Max execution time set Documentation 0 0
Max execution time set failed Documentation 0 0
Max used connections Documentation 30 30 The maximum number of connections that have been in use simultaneously since the server started.
Max used connections time Documentation 2026-08-04 18:46:03 2026-08-04 18:46:03
Mysqlx aborted clients Documentation 0 0
Mysqlx address Documentation :: ::
Mysqlx bytes received Documentation 0 0
Mysqlx bytes received compressed payload Documentation 0 0
Mysqlx bytes received uncompressed frame Documentation 0 0
Mysqlx bytes sent Documentation 0 0
Mysqlx bytes sent compressed payload Documentation 0 0
Mysqlx bytes sent uncompressed frame Documentation 0 0
Mysqlx compression algorithm Documentation
Mysqlx compression level Documentation
Mysqlx connection accept errors Documentation 0 0
Mysqlx connection errors Documentation 0 0
Mysqlx connections accepted Documentation 0 0
Mysqlx connections closed Documentation 0 0
Mysqlx connections rejected Documentation 0 0
Mysqlx crud create view Documentation 0 0
Mysqlx crud delete Documentation 0 0
Mysqlx crud drop view Documentation 0 0
Mysqlx crud find Documentation 0 0
Mysqlx crud insert Documentation 0 0
Mysqlx crud modify view Documentation 0 0
Mysqlx crud update Documentation 0 0
Mysqlx cursor close Documentation 0 0
Mysqlx cursor fetch Documentation 0 0
Mysqlx cursor open Documentation 0 0
Mysqlx errors sent Documentation 0 0
Mysqlx errors unknown message type Documentation 0 0
Mysqlx expect close Documentation 0 0
Mysqlx expect open Documentation 0 0
Mysqlx init error Documentation 0 0
Mysqlx messages sent Documentation 0 0
Mysqlx notice global sent Documentation 0 0
Mysqlx notice other sent Documentation 0 0
Mysqlx notice warning sent Documentation 0 0
Mysqlx notified by group replication Documentation 0 0
Mysqlx port Documentation 33.1 k 33060
Mysqlx prep deallocate Documentation 0 0
Mysqlx prep execute Documentation 0 0
Mysqlx prep prepare Documentation 0 0
Mysqlx rows sent Documentation 0 0
Mysqlx sessions Documentation 0 0
Mysqlx sessions accepted Documentation 0 0
Mysqlx sessions closed Documentation 0 0
Mysqlx sessions fatal error Documentation 0 0
Mysqlx sessions killed Documentation 0 0
Mysqlx sessions rejected Documentation 0 0
Mysqlx socket Documentation UNDEFINED UNDEFINED
Mysqlx ssl accepts Documentation 0 0
Mysqlx ssl active Documentation
Mysqlx ssl cipher Documentation
Mysqlx ssl cipher list Documentation
Mysqlx ssl ctx verify depth Documentation 18.4 E 18446744073709551615
Mysqlx ssl ctx verify mode Documentation 5 5
Mysqlx ssl finished accepts Documentation 0 0
Mysqlx ssl server not after Documentation Jan 26 07:21:55 2036 GMT Jan 26 07:21:55 2036 GMT
Mysqlx ssl server not before Documentation Jan 28 07:21:55 2026 GMT Jan 28 07:21:55 2026 GMT
Mysqlx ssl verify depth Documentation
Mysqlx ssl verify mode Documentation
Mysqlx ssl version Documentation
Mysqlx stmt create collection Documentation 0 0
Mysqlx stmt create collection index Documentation 0 0
Mysqlx stmt disable notices Documentation 0 0
Mysqlx stmt drop collection Documentation 0 0
Mysqlx stmt drop collection index Documentation 0 0
Mysqlx stmt enable notices Documentation 0 0
Mysqlx stmt ensure collection Documentation 0 0
Mysqlx stmt execute mysqlx Documentation 0 0
Mysqlx stmt execute sql Documentation 0 0
Mysqlx stmt execute xplugin Documentation 0 0
Mysqlx stmt get collection options Documentation 0 0
Mysqlx stmt kill client Documentation 0 0
Mysqlx stmt list clients Documentation 0 0
Mysqlx stmt list notices Documentation 0 0
Mysqlx stmt list objects Documentation 0 0
Mysqlx stmt modify collection options Documentation 0 0
Mysqlx stmt ping Documentation 0 0
Mysqlx worker threads Documentation 2 2
Mysqlx worker threads active Documentation 0 0
Not flushed delayed rows Documentation 0 0 The number of rows waiting to be written in INSERT DELAYED queues.
Ongoing anonymous transaction count Documentation 0 0
Open files Documentation 2 2 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 432 432
Open tables Documentation 64 64 The number of tables that are open.
Opened files Documentation 2 2
Opened table definitions Documentation 23 k 23003
Opened tables Documentation 2.7 M 2709664 The number of tables that have been opened. If opened tables is big, your table_open_cache value is probably too small.
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 136.3 k 136282
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 longest seen Documentation 120 120
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
Queries Documentation 6.4 M 6431651
Questions Documentation 6.4 M 6361434
Replica open temp tables Documentation 0 0
Resource group supported Documentation ON ON
Rsa public key Documentation -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA4zRmw+4N9YxhykOrJkxi 7ZO4TnPKfs6GESRfHMLDs/ZY00mpRAYX1sxXK0myX8/zSRulPPn8KF9ysnhZIJX8 cHhUXrZAmlGqx50OPNQhT/cXD/wn5182dw01hiuAlwUro6rN1/f/qHskgbYNmmXJ iCND8+NqUFjOfrxjkWxafTL6P7pPlzkfBp9FRUcdQhC9qltLEofOYmpXrNroiQvI PtJoDgTzaQK0/AmJKQDsvFlvVbVLVw3cY4gfGD2C4zkcvtxzTVYVEik8votvXE8P 4m99CQ7SIGkWH2Sp/m1zF79oXZb3GiWD3UzH4f5sRL9ef8J3OCNrPHX+8wzqS4vy QQIDAQAB -----END PUBLIC KEY----- -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA4zRmw+4N9YxhykOrJkxi 7ZO4TnPKfs6GESRfHMLDs/ZY00mpRAYX1sxXK0myX8/zSRulPPn8KF9ysnhZIJX8 cHhUXrZAmlGqx50OPNQhT/cXD/wn5182dw01hiuAlwUro6rN1/f/qHskgbYNmmXJ iCND8+NqUFjOfrxjkWxafTL6P7pPlzkfBp9FRUcdQhC9qltLEofOYmpXrNroiQvI PtJoDgTzaQK0/AmJKQDsvFlvVbVLVw3cY4gfGD2C4zkcvtxzTVYVEik8votvXE8P 4m99CQ7SIGkWH2Sp/m1zF79oXZb3GiWD3UzH4f5sRL9ef8J3OCNrPHX+8wzqS4vy QQIDAQAB -----END PUBLIC KEY-----
Secondary engine execution count Documentation 0 0
Select full join Documentation 84.1 k 84091 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 62 62 The number of joins that used a range search on a reference table.
Select range Documentation 1.1 M 1054687 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 0 0 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 829.9 k 829939 The number of joins that did a full scan of the first table.
Slave open temp tables Documentation 0 0 The number of temporary tables currently open by the replica SQL thread.
Slow launch threads Documentation 0 0 The number of threads that have taken more than slow_launch_time seconds to create.
Slow queries Documentation 0 0 The number of queries that have taken more than long_query_time seconds. Documentation
Sort merge passes Documentation 13 13 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 0 0 The number of sorts that were done with ranges.
Sort rows Documentation 6.7 M 6652251 The number of sorted rows.
Sort scan Documentation 357.2 k 357222 The number of sorts that were done by scanning the table.
Ssl accept renegotiates Documentation 0 0
Ssl accepts Documentation 3 3
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 4.3 G 4294967295
Ssl ctx verify mode Documentation 5 5
Ssl default timeout Documentation 0 0
Ssl finished accepts Documentation 3 3
Ssl finished connects Documentation 0 0
Ssl server not after Documentation Jan 26 07:21:55 2036 GMT Jan 26 07:21:55 2036 GMT
Ssl server not before Documentation Jan 28 07:21:55 2026 GMT Jan 28 07:21:55 2026 GMT
Ssl session cache hits Documentation 0 0
Ssl session cache misses Documentation 0 0
Ssl session cache mode Documentation SERVER SERVER
Ssl session cache overflows Documentation 0 0
Ssl session cache size Documentation 128 128
Ssl session cache timeout Documentation 300 300
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
Table locks immediate Documentation 10.9 k 10945 The number of times that a table lock was acquired immediately.
Table locks waited Documentation 0 0 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 5.6 M 5564720
Table open cache misses Documentation 2.7 M 2709664
Table open cache overflows Documentation 2.7 M 2709573
Tc log max pages used Documentation 0 0
Tc log page size Documentation 0 0
Tc log page waits Documentation 0 0
Telemetry traces supported Documentation ON ON
Threads cached Documentation 7 7 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 2 2 The number of currently open connections.
Threads created Documentation 264 264 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 2 2 The number of threads that are not sleeping.
Tls library version Documentation OpenSSL 3.0.18 30 Sep 2025 OpenSSL 3.0.18 30 Sep 2025
Uptime Documentation 20 days, 23 hours, 33 minutes and 42 seconds 1812822
Uptime since flush status Documentation 20 days, 23 hours, 33 minutes and 42 seconds 1812822
Key buffer fraction % 18.24 % 18.2373046875 Percentage of used key cache (calculated value)
Key read ratio % 100.00 % 100 Key cache miss calculated as rate of physical reads compared to read requests (calculated value)
Threads cache hitrate % 99.77 % 99.76971388695 Thread cache hit rate (calculated value)