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: 505,800,825 Documentation

  • ø per hour: 6,782,192
  • ø per minute: 113,037
  • ø per second: 1,884
Statements # ø per hour %
select 464 M 6,215.4 k 91.64
insert 14,379 k 192.8 k 2.84
update 7,201 k 96.6 k 1.42
set option 6,583 k 88.3 k 1.30
show fields 4,465 k 59.9 k 0.88
change db 3,133 k 42 k 0.62
show tables 1,473 k 19.7 k 0.29
delete 1,335 k 17.9 k 0.26
stmt prepare 792 k 10.6 k 0.16
stmt execute 792 k 10.6 k 0.16
stmt close 777 k 10.4 k 0.15
begin 275 k 3,681.3 0.05
rollback 234 k 3,142.2 0.05
show keys 175 k 2,346.5 0.03
update multi 165 k 2,212.1 0.03
insert select 114 k 1,527.8 0.02
show variables 61,285 821.8 0.01
delete multi 59,752 801.2 0.01
commit 43,267 580.2 0.01
show create table 30,020 402.5 0.01
replace 29,051 389.5 0.01
create table 27,532 369.2 0.01
show warnings 21,114 283.1 <0.01
show grants 20,813 279.1 <0.01
show slave status 19,183 257.2 <0.01
show binlogs 11,866 159.1 <0.01
show slave hosts 11,190 150 <0.01
show status 9,873 132.4 <0.01
show engine status 9,024 121 <0.01
stmt send long data 8,634 115.8 <0.01
show table status 4,698 63 <0.01
alter table 4,065 54.5 <0.01
checksum 1,375 18.4 <0.01
load 1,060 14.2 <0.01
do 784 10.5 <0.01
drop table 714 9.6 <0.01
truncate 710 9.5 <0.01
create temporary table 498 6.7 <0.01
drop temporary table 486 6.5 <0.01
optimize 415 5.6 <0.01
rollback to savepoint 231 3.1 <0.01
unlock tables 191 2.6 <0.01
lock tables 188 2.5 <0.01
purge 169 2.3 <0.01
show binlog status 150 2 <0.01
show collations 56 0.8 <0.01
show function status 46 0.6 <0.01
show procedure status 46 0.6 <0.01
show triggers 46 0.6 <0.01
alter user 40 0.5 <0.01
grant 39 0.5 <0.01
revoke all 38 0.5 <0.01
show databases 38 0.5 <0.01
check 12 0.2 <0.01
kill 7 0.1 <0.01
release savepoint 3 <0.1 <0.01
repair 3 <0.1 <0.01
savepoint 3 <0.1 <0.01
show events 3 <0.1 <0.01
drop user 2 <0.1 <0.01
rename table 2 <0.1 <0.01
revoke 2 <0.1 <0.01
create index 1 <0.1 <0.01
drop db 1 <0.1 <0.01
flush 1 <0.1 <0.01
show create func 1 <0.1 <0.01
show processlist 1 <0.1 <0.01