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: 422,897,695 Documentation

  • ø per hour: 5,523,001
  • ø per minute: 92,050
  • ø per second: 1,534
Statements # ø per hour %
select 369 M 4,815.6 k 87.19
stmt execute 9,123 k 119.1 k 2.16
stmt prepare 9,107 k 118.9 k 2.15
stmt close 9,106 k 118.9 k 2.15
set option 7,346 k 95.9 k 1.74
insert 4,076 k 53.2 k 0.96
update 3,968 k 51.8 k 0.94
change db 2,165 k 28.3 k 0.51
delete 2,121 k 27.7 k 0.50
show fields 1,832 k 23.9 k 0.43
show tables 1,371 k 17.9 k 0.32
show keys 1,036 k 13.5 k 0.24
show variables 696 k 9,085.7 0.16
show create table 291 k 3,802.7 0.07
show status 281 k 3,673.5 0.07
show engine status 276 k 3,599.5 0.07
show generic 276 k 3,599.5 0.07
show grants 212 k 2,775.1 0.05
show warnings 205 k 2,672.4 0.05
replace 116 k 1,518.9 0.03
insert select 98,814 1,290.5 0.02
update multi 88,461 1,155.3 0.02
alter table 79,450 1,037.6 0.02
show processlist 74,439 972.2 0.02
rollback to savepoint 60,870 795 0.01
repair 45,221 590.6 0.01
create table 29,950 391.1 0.01
begin 14,279 186.5 <0.01
commit 12,623 164.9 <0.01
show databases 12,075 157.7 <0.01
delete multi 8,402 109.7 <0.01
empty query 5,237 68.4 <0.01
enable governor lve 4,589 59.9 <0.01
alter user 4,009 52.4 <0.01
show table status 3,295 43 <0.01
unlock tables 3,069 40.1 <0.01
grant 2,543 33.2 <0.01
savepoint 1,633 21.3 <0.01
release savepoint 1,612 21.1 <0.01
lock tables 1,407 18.4 <0.01
check 1,168 15.3 <0.01
stmt send long data 844 11 <0.01
show function status 843 11 <0.01
show procedure status 843 11 <0.01
show events 824 10.8 <0.01
show create db 806 10.5 <0.01
show package status 806 10.5 <0.01
show package body status 806 10.5 <0.01
drop table 429 5.6 <0.01
truncate 424 5.5 <0.01
flush 334 4.4 <0.01
show create trigger 292 3.8 <0.01
show binlogs 244 3.2 <0.01
show slave status 197 2.6 <0.01
show binlog status 194 2.5 <0.01
create user 118 1.5 <0.01
do 115 1.5 <0.01
drop user 96 1.3 <0.01
show storage engines 72 0.9 <0.01
rollback 53 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.5 <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