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: 1,320,605 Documentation

  • ø per hour: 3,630
  • ø per minute: 60
  • ø per second: 1
Statements # ø per hour %
select 371 k 1,020.9 28.12
stmt execute 207 k 568.9 15.67
stmt prepare 136 k 372.9 10.27
stmt close 135 k 372.1 10.25
show fields 130 k 358.4 9.87
insert 83,125 228.5 6.29
set option 62,058 170.6 4.70
show keys 55,293 152 4.19
show tables 49,687 136.6 3.76
create table 24,870 68.4 1.88
show variables 20,030 55.1 1.52
change db 17,369 47.7 1.32
show create table 12,184 33.5 0.92
show warnings 7,708 21.2 0.58
show storage engines 3,035 8.3 0.23
update 2,680 7.4 0.20
alter table 604 1.7 0.05
show grants 498 1.4 0.04
show table status 392 1.1 0.03
show binlogs 255 0.7 0.02
insert select 199 0.5 0.02
show slave status 181 0.5 0.01
show master status 175 0.5 0.01
begin 86 0.2 0.01
create db 70 0.2 0.01
commit 65 0.2 <0.01
delete 60 0.2 <0.01
show create func 39 0.1 <0.01
show status 33 0.1 <0.01
update multi 23 0.1 <0.01
rollback 19 0.1 <0.01
delete multi 6 <0.1 <0.01
show processlist 5 <0.1 <0.01
empty query 4 <0.1 <0.01
show engine status 3 <0.1 <0.01
drop trigger 2 <0.1 <0.01
flush 2 <0.1 <0.01
call procedure 1 <0.1 <0.01
show create trigger 1 <0.1 <0.01
signal 1 <0.1 <0.01