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: 2,481,364,156 Documentation

  • ø per hour: 12,820,403
  • ø per minute: 213,673
  • ø per second: 3,561
Statements # ø per hour %
select 2,288 M 11.8 M 92.20
set option 31,231 k 161.4 k 1.26
stmt execute 25,693 k 132.7 k 1.04
update 25,596 k 132.2 k 1.03
stmt prepare 25,578 k 132.2 k 1.03
stmt close 25,577 k 132.1 k 1.03
replace 23,227 k 120 k 0.94
change db 9,576 k 49.5 k 0.39
show fields 8,655 k 44.7 k 0.35
insert 6,701 k 34.6 k 0.27
delete 2,584 k 13.3 k 0.10
show status 2,336 k 12.1 k 0.09
show tables 1,923 k 9,938 0.08
show variables 807 k 4,170.3 0.03
insert select 712 k 3,678.1 0.03
show engine status 697 k 3,599.7 0.03
show generic 697 k 3,599.7 0.03
show keys 267 k 1,377.6 0.01
show create table 209 k 1,080.4 0.01
show processlist 188 k 972.2 0.01
update multi 155 k 801.6 0.01
rollback to savepoint 152 k 783.7 0.01
show databases 144 k 742.3 0.01
call procedure 83,675 432.3 <0.01
delete multi 80,086 413.8 <0.01
create table 72,657 375.4 <0.01
repair 65,759 339.8 <0.01
drop table 61,725 318.9 <0.01
create temporary table 58,690 303.2 <0.01
alter table 58,008 299.7 <0.01
begin 51,052 263.8 <0.01
show warnings 43,702 225.8 <0.01
show profile 39,402 203.6 <0.01
commit 26,276 135.8 <0.01
rollback 20,779 107.4 <0.01
show grants 13,245 68.4 <0.01
enable governor lve 11,601 59.9 <0.01
unlock tables 8,100 41.9 <0.01
show table status 6,011 31.1 <0.01
truncate 5,467 28.2 <0.01
empty query 4,207 21.7 <0.01
savepoint 4,114 21.3 <0.01
release savepoint 4,090 21.1 <0.01
lock tables 3,967 20.5 <0.01
grant 3,762 19.4 <0.01
alter user 2,925 15.1 <0.01
stmt send long data 2,633 13.6 <0.01
show storage engines 2,583 13.3 <0.01
show profiles 2,525 13 <0.01
show function status 2,131 11 <0.01
show procedure status 2,130 11 <0.01
show events 2,095 10.8 <0.01
show package status 2,049 10.6 <0.01
show package body status 2,049 10.6 <0.01
show create db 2,041 10.5 <0.01
check 1,829 9.4 <0.01
show slave status 472 2.4 <0.01
show binlog status 465 2.4 <0.01
show create trigger 459 2.4 <0.01
create user 324 1.7 <0.01
flush 301 1.6 <0.01
show binlogs 277 1.4 <0.01
create view 143 0.7 <0.01
drop user 137 0.7 <0.01
show triggers 120 0.6 <0.01
do 90 0.5 <0.01
create db 89 0.5 <0.01
create index 80 0.4 <0.01
show charsets 56 0.3 <0.01
revoke 55 0.3 <0.01
drop db 53 0.3 <0.01
show create proc 31 0.2 <0.01
drop temporary table 27 0.1 <0.01
enable governor reconn lve 27 0.1 <0.01
alter db 24 0.1 <0.01
show create func 23 0.1 <0.01
create trigger 14 0.1 <0.01
drop trigger 4 <0.1 <0.01
create procedure 2 <0.1 <0.01
drop index 2 <0.1 <0.01
drop procedure 2 <0.1 <0.01
rename table 2 <0.1 <0.01