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: 6,246,004 Documentation

  • ø per hour: 12,404
  • ø per minute: 207
  • ø per second: 3
Statements # ø per hour %
select 5,387 k 10.7 k 86.24
set option 299 k 593.6 4.79
change db 103 k 204.1 1.65
create table 84,368 167.5 1.35
show fields 81,871 162.6 1.31
update 66,334 131.7 1.06
show tables 66,067 131.2 1.06
insert 47,588 94.5 0.76
delete 38,492 76.4 0.62
show keys 25,911 51.5 0.41
update multi 13,482 26.8 0.22
show create table 9,986 19.8 0.16
show variables 9,903 19.7 0.16
replace 5,072 10.1 0.08
show storage engines 2,403 4.8 0.04
show warnings 2,152 4.3 0.03
insert select 1,662 3.3 0.03
show table status 612 1.2 0.01
show grants 471 0.9 0.01
show master status 145 0.3 <0.01
show replica status 145 0.3 <0.01
show slave status 145 0.3 <0.01
delete multi 136 0.3 <0.01
show binlogs 100 0.2 <0.01
stmt execute 79 0.2 <0.01
stmt close 79 0.2 <0.01
stmt prepare 79 0.2 <0.01
stmt send long data 55 0.1 <0.01
do 33 0.1 <0.01
truncate 33 0.1 <0.01
show status 12 <0.1 <0.01
alter table 6 <0.1 <0.01
show triggers 6 <0.1 <0.01
show binlog events 4 <0.1 <0.01
show replicas 4 <0.1 <0.01
show slave hosts 4 <0.1 <0.01
create db 3 <0.1 <0.01
flush 3 <0.1 <0.01
lock tables 3 <0.1 <0.01
show function status 3 <0.1 <0.01
show procedure status 3 <0.1 <0.01
unlock tables 3 <0.1 <0.01
drop db 2 <0.1 <0.01
show processlist 2 <0.1 <0.01
drop table 1 <0.1 <0.01
show engine status 1 <0.1 <0.01