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: 895,861,601 Documentation

  • ø per hour: 10,547,890
  • ø per minute: 175,798
  • ø per second: 2,930
Statements # ø per hour %
stmt execute 310 M 3,653.7 k 34.64
insert 246 M 2,891 k 27.41
create table 80,565 k 948.6 k 8.99
stmt prepare 68,362 k 804.9 k 7.63
stmt close 68,217 k 803.2 k 7.61
select 58,381 k 687.4 k 6.52
alter table 41,997 k 494.5 k 4.69
update 10,513 k 123.8 k 1.17
set option 4,625 k 54.5 k 0.52
show fields 3,899 k 45.9 k 0.44
begin 872 k 10.3 k 0.10
commit 765 k 9,011.7 0.09
show tables 718 k 8,451.2 0.08
delete 403 k 4,741.2 0.04
show keys 341 k 4,018.9 0.04
rollback 113 k 1,327.7 0.01
change db 74,802 880.7 0.01
show processlist 59,725 703.2 0.01
show create table 22,821 268.7 <0.01
show variables 11,740 138.2 <0.01
show databases 8,950 105.4 <0.01
update multi 8,432 99.3 <0.01
show grants 7,548 88.9 <0.01
insert select 6,488 76.4 <0.01
enable governor lve 5,091 59.9 <0.01
show warnings 2,917 34.3 <0.01
show table status 2,763 32.5 <0.01
replace 1,554 18.3 <0.01
flush 1,385 16.3 <0.01
create temporary table 1,102 13 <0.01
drop temporary table 1,078 12.7 <0.01
show storage engines 1,004 11.8 <0.01
drop table 695 8.2 <0.01
show triggers 574 6.8 <0.01
grant 537 6.3 <0.01
show function status 405 4.8 <0.01
show procedure status 405 4.8 <0.01
show binlogs 366 4.3 <0.01
show events 362 4.3 <0.01
show binlog status 328 3.9 <0.01
show slave status 328 3.9 <0.01
call procedure 293 3.4 <0.01
rollback to savepoint 236 2.8 <0.01
create index 219 2.6 <0.01
create db 159 1.9 <0.01
create user 137 1.6 <0.01
stmt reprepare 125 1.5 <0.01
drop user 123 1.4 <0.01
show status 117 1.4 <0.01
show charsets 96 1.1 <0.01
delete multi 81 1 <0.01
unlock tables 72 0.8 <0.01
lock tables 58 0.7 <0.01
alter user 33 0.4 <0.01
truncate 30 0.4 <0.01
savepoint 29 0.3 <0.01
drop db 19 0.2 <0.01
release savepoint 14 0.2 <0.01
drop index 11 0.1 <0.01
show package status 10 0.1 <0.01
show package body status 10 0.1 <0.01
show engine status 9 0.1 <0.01
show open tables 9 0.1 <0.01
enable governor reconn lve 8 0.1 <0.01
empty query 7 0.1 <0.01
create view 2 <0.1 <0.01
revoke 2 <0.1 <0.01
check 1 <0.1 <0.01