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: 137,374,246 Documentation

  • ø per hour: 16,149,010
  • ø per minute: 269,150
  • ø per second: 4,486
Statements # ø per hour %
select 120 M 14.1 M 87.37
stmt prepare 4,100 k 482 k 2.98
stmt execute 4,100 k 482 k 2.98
stmt close 4,100 k 482 k 2.98
set option 1,897 k 223 k 1.38
update 958 k 112.6 k 0.70
change db 671 k 78.9 k 0.49
insert 528 k 62.1 k 0.38
show fields 434 k 51 k 0.32
delete 121 k 14.2 k 0.09
replace 119 k 14 k 0.09
show status 94,038 11.1 k 0.07
show tables 76,392 8,980.3 0.06
show variables 31,885 3,748.2 0.02
show engine status 30,600 3,597.2 0.02
show generic 30,599 3,597.1 0.02
insert select 26,716 3,140.6 0.02
update multi 10,044 1,180.7 0.01
show processlist 8,271 972.3 0.01
show keys 3,699 434.8 <0.01
create table 2,104 247.3 <0.01
show create table 1,959 230.3 <0.01
delete multi 1,359 159.8 <0.01
show profile 1,310 154 <0.01
begin 1,304 153.3 <0.01
commit 1,304 153.3 <0.01
alter table 1,076 126.5 <0.01
savepoint 914 107.4 <0.01
show databases 762 89.6 <0.01
truncate 565 66.4 <0.01
enable governor lve 510 60 <0.01
show grants 231 27.2 <0.01
show warnings 230 27 <0.01
show table status 199 23.4 <0.01
stmt send long data 117 13.8 <0.01
show storage engines 113 13.3 <0.01
show binlogs 81 9.5 <0.01
show profiles 80 9.4 <0.01
show create trigger 32 3.8 <0.01
show slave status 30 3.5 <0.01
show binlog status 29 3.4 <0.01
lock tables 9 1.1 <0.01
unlock tables 9 1.1 <0.01
show function status 8 0.9 <0.01
show procedure status 8 0.9 <0.01
show triggers 4 0.5 <0.01
drop table 3 0.4 <0.01
show events 2 0.2 <0.01
drop user 1 0.1 <0.01