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: 100,156,734 Documentation

  • ø per hour: 17,002,935
  • ø per minute: 283,382
  • ø per second: 4,723
Statements # ø per hour %
select 87,825 k 14.9 M 87.69
stmt prepare 2,761 k 468.8 k 2.76
stmt execute 2,760 k 468.5 k 2.76
stmt close 2,760 k 468.5 k 2.76
set option 1,538 k 261.2 k 1.54
update 782 k 132.7 k 0.78
change db 540 k 91.6 k 0.54
insert 397 k 67.4 k 0.40
show fields 344 k 58.4 k 0.34
delete 96,391 16.4 k 0.10
show tables 87,418 14.8 k 0.09
replace 83,720 14.2 k 0.08
show status 65,112 11.1 k 0.07
show variables 22,944 3,895 0.02
show engine status 21,208 3,600.3 0.02
show generic 21,205 3,599.8 0.02
insert select 19,187 3,257.2 0.02
update multi 7,736 1,313.3 0.01
show keys 7,137 1,211.6 0.01
show processlist 5,729 972.6 0.01
create table 1,728 293.4 <0.01
delete multi 1,429 242.6 <0.01
show profile 1,375 233.4 <0.01
show create table 1,250 212.2 <0.01
alter table 1,143 194 <0.01
begin 784 133.1 <0.01
commit 774 131.4 <0.01
show databases 610 103.6 <0.01
truncate 402 68.2 <0.01
enable governor lve 354 60.1 <0.01
show warnings 340 57.7 <0.01
show storage engines 298 50.6 <0.01
show grants 271 46 <0.01
rollback to savepoint 262 44.5 <0.01
unlock tables 115 19.5 <0.01
drop table 107 18.2 <0.01
lock tables 105 17.8 <0.01
show profiles 88 14.9 <0.01
show table status 59 10 <0.01
stmt send long data 59 10 <0.01
show binlog status 38 6.5 <0.01
show slave status 38 6.5 <0.01
show binlogs 36 6.1 <0.01
grant 34 5.8 <0.01
check 28 4.8 <0.01
create view 20 3.4 <0.01
empty query 15 2.5 <0.01
release savepoint 10 1.7 <0.01
savepoint 10 1.7 <0.01
create user 9 1.5 <0.01
show function status 7 1.2 <0.01
show procedure status 7 1.2 <0.01
do 6 1 <0.01
drop user 6 1 <0.01
create temporary table 5 0.8 <0.01
flush 5 0.8 <0.01
show create db 5 0.8 <0.01
show events 5 0.8 <0.01
show package status 5 0.8 <0.01
show package body status 5 0.8 <0.01
alter user 4 0.7 <0.01
create db 3 0.5 <0.01
drop db 2 0.3 <0.01
show charsets 2 0.3 <0.01
show triggers 2 0.3 <0.01
alter db 1 0.2 <0.01