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 :

Questions since startup: 522,969,799 Documentation

  • ø per hour: 706,886
  • ø per minute: 11,781
  • ø per second: 196
Statements # ø per hour %
select 498 M 672.7 k 95.16
set option 6,961 k 9,408.8 1.33
update 6,292 k 8,504.1 1.20
show fields 3,646 k 4,928.7 0.70
insert 2,747 k 3,713 0.53
show tables 2,693 k 3,640.3 0.51
change db 2,072 k 2,800.4 0.40
delete 417 k 563.5 0.08
show keys 325 k 439.9 0.06
show function status 70,784 95.7 0.01
show variables 19,127 25.9 <0.01
show grants 9,375 12.7 <0.01
show create table 8,174 11 <0.01
insert select 8,051 10.9 <0.01
begin 5,199 7 <0.01
commit 5,196 7 <0.01
delete multi 4,607 6.2 <0.01
show storage engines 2,528 3.4 <0.01
show warnings 1,542 2.1 <0.01
rollback to savepoint 1,498 2 <0.01
alter table 468 0.6 <0.01
show table status 463 0.6 <0.01
show binlogs 295 0.4 <0.01
truncate 280 0.4 <0.01
create table 255 0.3 <0.01
drop table 231 0.3 <0.01
unlock tables 162 0.2 <0.01
lock tables 159 0.2 <0.01
show collations 123 0.2 <0.01
show binlog status 97 0.1 <0.01
show slave status 97 0.1 <0.01
show databases 81 0.1 <0.01
show status 38 0.1 <0.01
drop user 26 <0.1 <0.01
revoke 22 <0.1 <0.01
grant 22 <0.1 <0.01
create user 13 <0.1 <0.01
create db 11 <0.1 <0.01
drop db 11 <0.1 <0.01
show charsets 10 <0.1 <0.01
create index 9 <0.1 <0.01
show processlist 5 <0.1 <0.01
show create func 5 <0.1 <0.01
update multi 5 <0.1 <0.01
flush 4 <0.1 <0.01
show engine status 4 <0.1 <0.01
show procedure status 3 <0.1 <0.01
show package body status 3 <0.1 <0.01
show package status 3 <0.1 <0.01
savepoint 3 <0.1 <0.01
release savepoint 3 <0.1 <0.01
show events 3 <0.1 <0.01
kill 2 <0.1 <0.01
load 2 <0.1 <0.01
drop index 1 <0.1 <0.01