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
Restore default values
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Filters
Variable Value Description
Aborted clients Documentation 0 0 The number of connections that were aborted because the client died without closing the connection properly.
Aborted connects Documentation 0 0 The number of failed attempts to connect to the MySQL server.
Acl cache items count 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
Bytes received Documentation 281.1 k 281080
Bytes sent Documentation 1.4 M 1439804
Caching sha2 password rsa public key Documentation -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx1vvT1kkedc7d0ezgTYY 3NhVHYM+zYotl6z32Viw9b/F9rPOc0v5Z6RrjQlAiEeCVi0fako5M0lTpUSEN9hu gqeZFx3gujyxUEYLp+9XoFUdOfQJaB+1L8DwXw0yabdvrHWRiAPHsFLTDeZ+V+0n Lq2BtzLq87yjd0dS8I68crLBBejJhgu0ClcBPHcrONBbLYZYViO97urugdKyj7yJ vaTgWuldVld30Jlv95gIp/M+NY0ZYwjC4uLVkLD5T5gO6grtO3tWPb/quOJ0qKyT j0264kS0jtMwxxIgFRFlggBhSSBbXurdespV6Cqop2r8SrAyjX5oUOJ88YGrqfzg 4QIDAQAB -----END PUBLIC KEY----- -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx1vvT1kkedc7d0ezgTYY 3NhVHYM+zYotl6z32Viw9b/F9rPOc0v5Z6RrjQlAiEeCVi0fako5M0lTpUSEN9hu gqeZFx3gujyxUEYLp+9XoFUdOfQJaB+1L8DwXw0yabdvrHWRiAPHsFLTDeZ+V+0n Lq2BtzLq87yjd0dS8I68crLBBejJhgu0ClcBPHcrONBbLYZYViO97urugdKyj7yJ vaTgWuldVld30Jlv95gIp/M+NY0ZYwjC4uLVkLD5T5gO6grtO3tWPb/quOJ0qKyT j0264kS0jtMwxxIgFRFlggBhSSBbXurdespV6Cqop2r8SrAyjX5oUOJ88YGrqfzg 4QIDAQAB -----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 0 0
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 172 172
Com change master Documentation 0 0
Com change repl filter 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 1 1
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 34 34
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 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 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 0 0
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 1 1
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 0 0
Com insert select Documentation 0 0
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 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 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 1.2 k 1245
Com set option Documentation 308 308
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 0 0
Com show binlogs Documentation 11 11
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 42 42
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 0 0
Com show events Documentation 0 0
Com show errors Documentation 0 0
Com show fields Documentation 97 97
Com show function code Documentation 0 0
Com show function status Documentation 0 0
Com show grants Documentation 69 69
Com show keys Documentation 75 75
Com show master status Documentation 5 5
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 0 0
Com show processlist Documentation 0 0
Com show profile Documentation 0 0
Com show profiles Documentation 0 0
Com show relaylog events Documentation 0 0
Com show slave hosts Documentation 0 0
Com show slave status Documentation 5 5
Com show status Documentation 1 1
Com show storage engines Documentation 6 6
Com show table status Documentation 2 2
Com show tables Documentation 130 130
Com show triggers Documentation 0 0
Com show variables Documentation 84 84
Com show warnings Documentation 34 34
Com show create user Documentation 0 0
Com shutdown Documentation 0 0
Com slave start 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 0 0
Com stmt close Documentation 0 0
Com stmt fetch Documentation 0 0
Com stmt prepare Documentation 0 0
Com stmt reset Documentation 0 0
Com stmt send long data Documentation 0 0
Com truncate Documentation 0 0
Com uninstall component Documentation 0 0
Com uninstall plugin Documentation 0 0
Com unlock instance Documentation 0 0
Com unlock tables Documentation 0 0
Com update Documentation 0 0
Com update multi Documentation 0 0
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 209 209 The number of connection attempts (successful or not) to the MySQL server.
Created tmp disk tables Documentation 2 2 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 10 10 How many temporary files mysqld has created.
Created tmp tables Documentation 1.6 k 1608 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,TLSv1.1,TLSv1.2 TLSv1,TLSv1.1,TLSv1.2
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.
Flush commands Documentation 3 3 The number of executed FLUSH statements.
Handler commit Documentation 3.1 k 3088 The number of internal COMMIT statements.
Handler delete Documentation 0 0 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 23.9 k 23883
Handler mrr init Documentation 0 0
Handler prepare Documentation 0 0
Handler read first Documentation 1.4 k 1380 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 66.9 k 66878 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 0 0
Handler read next Documentation 63.4 k 63422 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 0 0 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 4.5 k 4495 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 194.8 k 194752 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 0 0 The number of internal ROLLBACK statements.
Handler savepoint Documentation 0 0
Handler savepoint rollback Documentation 0 0
Handler update Documentation 42 k 41989 The number of requests to update a row in a table.
Handler write Documentation 152.6 k 152615 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 250702 9:30:47 Buffer pool(s) load completed at 250702 9:30:47
Innodb buffer pool resize status Documentation
Innodb buffer pool pages data Documentation 1.4 k 1410 The number of pages containing data (dirty or clean).
Innodb buffer pool bytes data Documentation 23.1 M 23101440
Innodb buffer pool pages dirty Documentation 3 3 The number of pages currently dirty.
Innodb buffer pool bytes dirty Documentation 49.2 k 49152
Innodb buffer pool pages flushed Documentation 256 256 The number of buffer pool pages that have been requested to be flushed.
Innodb buffer pool pages free Documentation 6.8 k 6767 The number of free pages.
Innodb buffer pool pages misc Documentation 15 15 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 0 0
Innodb buffer pool read ahead evicted Documentation 0 0
Innodb buffer pool read requests Documentation 108.9 k 108943 The number of logical read requests InnoDB has done.
Innodb buffer pool reads Documentation 1.3 k 1267 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 5.7 k 5701 The number writes done to the InnoDB buffer pool.
Innodb data fsyncs Documentation 140 140 The number of fsync() operations so far.
Innodb data pending fsyncs Documentation 1 1 The curre