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: 15,226,015 Documentation

  • ø per hour: 741,136
  • ø per minute: 12,352
  • ø per second: 206
Statements # ø per hour %
select 14,670 k 714.1 k 96.35
set option 180 k 8,751.1 1.18
update 109 k 5,304.3 0.72
show fields 83,751 4,076.6 0.55
change db 49,883 2,428.1 0.33
insert 44,630 2,172.4 0.29
show tables 44,489 2,165.5 0.29
delete 19,393 944 0.13
show processlist 15,034 731.8 0.10
update multi 1,256 61.1 0.01
insert select 1,185 57.7 0.01
show variables 1,039 50.6 0.01
show status 1,014 49.4 0.01
create table 720 35 <0.01
stmt execute 653 31.8 <0.01
stmt close 653 31.8 <0.01
stmt prepare 653 31.8 <0.01
stmt send long data 653 31.8 <0.01
show keys 448 21.8 <0.01
show table status 336 16.4 <0.01
show create table 327 15.9 <0.01
replace 154 7.5 <0.01
delete multi 149 7.3 <0.01
show grants 118 5.7 <0.01
check 114 5.5 <0.01
show binlogs 79 3.8 <0.01
show storage engines 37 1.8 <0.01
show master status 32 1.6 <0.01
show replica status 32 1.6 <0.01
show slave status 32 1.6 <0.01
show triggers 30 1.5 <0.01
truncate 29 1.4 <0.01
lock tables 28 1.4 <0.01
unlock tables 28 1.4 <0.01
drop table 10 0.5 <0.01
rollback 4 0.2 <0.01
show databases 4 0.2 <0.01
show engine status 3 0.1 <0.01
flush 2 0.1 <0.01
show function status 2 0.1 <0.01
show procedure status 2 0.1 <0.01
alter table 1 <0.1 <0.01
commit 1 <0.1 <0.01
create db 1 <0.1 <0.01
drop db 1 <0.1 <0.01
optimize 1 <0.1 <0.01