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: 825,310,790 Documentation

  • ø per hour: 14,784,554
  • ø per minute: 246,409
  • ø per second: 4,107
Statements # ø per hour %
select 760 M 13.6 M 92.07
stmt prepare 11,615 k 208.1 k 1.41
stmt execute 11,611 k 208 k 1.41
stmt close 11,611 k 208 k 1.41
set option 11,112 k 199.1 k 1.35
update 6,245 k 111.9 k 0.76
change db 3,582 k 64.2 k 0.43
insert 3,467 k 62.1 k 0.42
show fields 2,370 k 42.4 k 0.29
delete 824 k 14.8 k 0.10
show tables 772 k 13.8 k 0.09
replace 770 k 13.8 k 0.09
show status 313 k 5,609.1 0.04
show variables 216 k 3,871 0.03
show engine status 201 k 3,599.4 0.02
show generic 201 k 3,599.2 0.02
insert select 185 k 3,313.7 0.02
update multi 65,179 1,167.6 0.01
show processlist 54,269 972.2 0.01
show keys 39,652 710.3 <0.01
show create table 26,010 465.9 <0.01
rollback to savepoint 25,570 458.1 <0.01
alter table 22,712 406.9 <0.01
create table 15,756 282.3 <0.01
show profile 14,681 263 <0.01
delete multi 9,197 164.8 <0.01
begin 8,315 149 <0.01
commit 7,502 134.4 <0.01
show databases 4,988 89.4 <0.01
show warnings 4,478 80.2 <0.01
show grants 3,641 65.2 <0.01
truncate 3,618 64.8 <0.01
savepoint 3,527 63.2 <0.01
enable governor lve 3,348 60 <0.01
show table status 1,426 25.5 <0.01
stmt send long data 1,137 20.4 <0.01
unlock tables 1,118 20 <0.01
show profiles 1,015 18.2 <0.01
show storage engines 1,006 18 <0.01
empty query 947 17 <0.01
release savepoint 810 14.5 <0.01
alter user 695 12.5 <0.01
show function status 431 7.7 <0.01
show procedure status 431 7.7 <0.01
show events 415 7.4 <0.01
show package status 408 7.3 <0.01
show package body status 408 7.3 <0.01
show create db 403 7.2 <0.01
show binlogs 365 6.5 <0.01
grant 325 5.8 <0.01
lock tables 306 5.5 <0.01
drop table 305 5.5 <0.01
show slave status 140 2.5 <0.01
show binlog status 138 2.5 <0.01
show create trigger 93 1.7 <0.01
check 56 1 <0.01
create view 50 0.9 <0.01
flush 33 0.6 <0.01
create user 21 0.4 <0.01
drop user 19 0.3 <0.01
do 18 0.3 <0.01
show triggers 16 0.3 <0.01
drop db 8 0.1 <0.01
create db 7 0.1 <0.01
create temporary table 6 0.1 <0.01
show charsets 5 0.1 <0.01
call procedure 2 <0.1 <0.01
rollback 2 <0.1 <0.01
enable governor reconn lve 1 <0.1 <0.01