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: 1,000,816,188 Documentation

  • ø per hour: 16,041,363
  • ø per minute: 267,356
  • ø per second: 4,456
Statements # ø per hour %
select 926 M 14.8 M 92.53
set option 16,256 k 260.6 k 1.62
stmt prepare 11,043 k 177 k 1.10
stmt execute 11,040 k 177 k 1.10
stmt close 11,035 k 176.9 k 1.10
update 8,585 k 137.6 k 0.86
change db 5,015 k 80.4 k 0.50
show fields 3,612 k 57.9 k 0.36
insert 3,353 k 53.7 k 0.34
show tables 1,115 k 17.9 k 0.11
delete 1,023 k 16.4 k 0.10
replace 510 k 8,171.3 0.05
show status 506 k 8,112.3 0.05
show variables 243 k 3,892.6 0.02
show engine status 225 k 3,599.4 0.02
show generic 225 k 3,599 0.02
insert select 215 k 3,438.8 0.02
show create table 133 k 2,139.3 0.01
rollback to savepoint 84,822 1,359.6 0.01
update multi 80,133 1,284.4 0.01
show databases 72,201 1,157.3 0.01
repair 70,281 1,126.5 0.01
show processlist 60,668 972.4 0.01
show keys 48,619 779.3 <0.01
alter table 29,974 480.4 <0.01
create table 21,741 348.5 <0.01
begin 13,735 220.1 <0.01
delete multi 12,012 192.5 <0.01
show grants 11,990 192.2 <0.01
show profile 11,780 188.8 <0.01
commit 11,140 178.6 <0.01
savepoint 10,057 161.2 <0.01
unlock tables 6,692 107.3 <0.01
show warnings 4,363 69.9 <0.01
lock tables 4,060 65.1 <0.01
truncate 4,051 64.9 <0.01
enable governor lve 3,736 59.9 <0.01
show table status 3,591 57.6 <0.01
drop table 2,755 44.2 <0.01
release savepoint 2,580 41.4 <0.01
empty query 2,187 35.1 <0.01
grant 1,429 22.9 <0.01
alter user 1,357 21.8 <0.01
show function status 1,349 21.6 <0.01
show procedure status 1,349 21.6 <0.01
show events 1,320 21.2 <0.01
show package status 1,293 20.7 <0.01
show package body status 1,293 20.7 <0.01
show create db 1,287 20.6 <0.01
show storage engines 1,195 19.2 <0.01
show binlogs 1,018 16.3 <0.01
stmt send long data 987 15.8 <0.01
show profiles 738 11.8 <0.01
show create trigger 525 8.4 <0.01
check 386 6.2 <0.01
show slave status 328 5.3 <0.01
show binlog status 325 5.2 <0.01
create user 318 5.1 <0.01
drop user 316 5.1 <0.01
flush 274 4.4 <0.01
create view 141 2.3 <0.01
drop db 115 1.8 <0.01
create db 103 1.7 <0.01
show charsets 103 1.7 <0.01
drop view 76 1.2 <0.01
show triggers 48 0.8 <0.01
do 45 0.7 <0.01
show create proc 40 0.6 <0.01
show create func 20 0.3 <0.01
enable governor reconn lve 17 0.3 <0.01
rollback 14 0.2 <0.01
create temporary table 6 0.1 <0.01
rename table 4 0.1 <0.01
call procedure 2 <0.1 <0.01
kill 1 <0.1 <0.01