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: 440,141,700 Documentation

  • ø per hour: 5,561,851
  • ø per minute: 92,698
  • ø per second: 1,545
Statements # ø per hour %
select 384 M 4,854.4 k 87.28
stmt execute 9,412 k 118.9 k 2.14
stmt prepare 9,396 k 118.7 k 2.13
stmt close 9,395 k 118.7 k 2.13
set option 7,608 k 96.1 k 1.73
insert 4,207 k 53.2 k 0.96
update 4,098 k 51.8 k 0.93
change db 2,249 k 28.4 k 0.51
delete 2,191 k 27.7 k 0.50
show fields 1,907 k 24.1 k 0.43
show tables 1,444 k 18.2 k 0.33
show keys 1,073 k 13.6 k 0.24
show variables 720 k 9,096.4 0.16
show create table 300 k 3,789.4 0.07
show status 291 k 3,673.7 0.07
show engine status 285 k 3,599.5 0.06
show generic 285 k 3,599.5 0.06
show grants 220 k 2,778.8 0.05
show warnings 212 k 2,678 0.05
replace 117 k 1,472.7 0.03
insert select 102 k 1,286.8 0.02
update multi 91,989 1,162.4 0.02
alter table 80,766 1,020.6 0.02
show processlist 76,935 972.2 0.02
rollback to savepoint 60,870 769.2 0.01
repair 45,221 571.4 0.01
create table 30,728 388.3 0.01
begin 14,529 183.6 <0.01
commit 12,871 162.6 <0.01
show databases 12,206 154.2 <0.01
delete multi 8,649 109.3 <0.01
empty query 5,237 66.2 <0.01
enable governor lve 4,743 59.9 <0.01
alter user 4,009 50.7 <0.01
show table status 3,344 42.3 <0.01
unlock tables 3,069 38.8 <0.01
grant 2,543 32.1 <0.01
savepoint 1,633 20.6 <0.01
release savepoint 1,612 20.4 <0.01
lock tables 1,407 17.8 <0.01
check 1,168 14.8 <0.01
stmt send long data 848 10.7 <0.01
show function status 845 10.7 <0.01
show procedure status 845 10.7 <0.01
show events 824 10.4 <0.01
show create db 806 10.2 <0.01
show package status 806 10.2 <0.01
show package body status 806 10.2 <0.01
truncate 437 5.5 <0.01
drop table 429 5.4 <0.01
show binlogs 360 4.5 <0.01
flush 334 4.2 <0.01
show create trigger 292 3.7 <0.01
show slave status 215 2.7 <0.01
show binlog status 212 2.7 <0.01
create user 118 1.5 <0.01
do 115 1.5 <0.01
show storage engines 106 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.5 <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