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: 431,882,113 Documentation

  • ø per hour: 5,542,872
  • ø per minute: 92,381
  • ø per second: 1,540
Statements # ø per hour %
select 377 M 4,835.6 k 87.24
stmt execute 9,269 k 119 k 2.15
stmt prepare 9,253 k 118.8 k 2.14
stmt close 9,252 k 118.7 k 2.14
set option 7,481 k 96 k 1.73
insert 4,153 k 53.3 k 0.96
update 4,032 k 51.7 k 0.93
change db 2,208 k 28.3 k 0.51
delete 2,165 k 27.8 k 0.50
show fields 1,871 k 24 k 0.43
show tables 1,406 k 18.1 k 0.33
show keys 1,055 k 13.5 k 0.24
show variables 708 k 9,090.7 0.16
show create table 295 k 3,791.1 0.07
show status 286 k 3,673.6 0.07
show engine status 280 k 3,599.5 0.06
show generic 280 k 3,599.5 0.06
show grants 216 k 2,776.7 0.05
show warnings 208 k 2,674.7 0.05
replace 116 k 1,494.5 0.03
insert select 100 k 1,287.1 0.02
update multi 90,309 1,159 0.02
alter table 80,622 1,034.7 0.02
show processlist 75,751 972.2 0.02
rollback to savepoint 60,870 781.2 0.01
repair 45,221 580.4 0.01
create table 30,648 393.3 0.01
begin 14,400 184.8 <0.01
commit 12,742 163.5 <0.01
show databases 12,140 155.8 <0.01
delete multi 8,550 109.7 <0.01
empty query 5,237 67.2 <0.01
enable governor lve 4,670 59.9 <0.01
alter user 4,009 51.5 <0.01
show table status 3,302 42.4 <0.01
unlock tables 3,069 39.4 <0.01
grant 2,543 32.6 <0.01
savepoint 1,633 21 <0.01
release savepoint 1,612 20.7 <0.01
lock tables 1,407 18.1 <0.01
check 1,168 15 <0.01
stmt send long data 844 10.8 <0.01
show function status 843 10.8 <0.01
show procedure status 843 10.8 <0.01
show events 824 10.6 <0.01
show create db 806 10.3 <0.01
show package status 806 10.3 <0.01
show package body status 806 10.3 <0.01
truncate 430 5.5 <0.01
drop table 429 5.5 <0.01
flush 334 4.3 <0.01
show binlogs 309 4 <0.01
show create trigger 292 3.7 <0.01
show slave status 207 2.7 <0.01
show binlog status 204 2.6 <0.01
create user 118 1.5 <0.01
do 115 1.5 <0.01
show storage engines 98 1.3 <0.01
drop user 96 1.2 <0.01
rollback 55 0.7 <0.01
show create proc 48 0.6 <0.01
create view 46 0.6 <0.01
create db 43 0.6 <0.01
drop db 39 0.5 <0.01
show triggers 38 0.5 <0.01
show create func 35 0.4 <0.01
create sequence 20 0.3 <0.01
enable governor reconn lve 17 0.2 <0.01
show collations 16 0.2 <0.01
kill 12 0.2 <0.01
show charsets 9 0.1 <0.01
alter db 8 0.1 <0.01
create index 6 0.1 <0.01
optimize 6 0.1 <0.01
revoke 6 0.1 <0.01
create temporary table 5 0.1 <0.01
drop temporary table 3 <0.1 <0.01
create trigger 2 <0.1 <0.01
signal 1 <0.1 <0.01