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: 4,636,160 Documentation

  • ø per hour: 1,334
  • ø per minute: 22
Statements # ø per hour %
select 1,547 k 444.9 33.36
commit 1,221 k 351.2 26.33
insert 1,200 k 345.3 25.89
set option 183 k 52.7 3.95
show tables 144 k 41.3 3.10
show keys 94,408 27.2 2.04
show fields 76,094 21.9 1.64
change db 46,920 13.5 1.01
show variables 36,206 10.4 0.78
delete 19,673 5.7 0.42
show grants 18,407 5.3 0.40
show create table 18,342 5.3 0.40
show warnings 12,637 3.6 0.27
show binlogs 10,046 2.9 0.22
show storage engines 3,607 1 0.08
show binlog status 1,616 0.5 0.03
show slave status 1,616 0.5 0.03
update 936 0.3 0.02
show table status 462 0.1 0.01
show status 442 0.1 0.01
show processlist 57 <0.1 <0.01
alter table 40 <0.1 <0.01
show engine status 38 <0.1 <0.01
drop table 24 <0.1 <0.01
lock tables 24 <0.1 <0.01
unlock tables 24 <0.1 <0.01
create table 22 <0.1 <0.01
show databases 15 <0.1 <0.01
kill 7 <0.1 <0.01
flush 2 <0.1 <0.01
show create db 2 <0.1 <0.01
show function status 2 <0.1 <0.01
show procedure status 2 <0.1 <0.01
create db 1 <0.1 <0.01
create user 1 <0.1 <0.01
drop db 1 <0.1 <0.01
drop user 1 <0.1 <0.01
grant 1 <0.1 <0.01