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: 899,906,636 Documentation

  • ø per hour: 10,500,218
  • ø per minute: 175,004
  • ø per second: 2,917
Statements # ø per hour %
stmt execute 312 M 3,635.5 k 34.62
insert 246 M 2,875.8 k 27.39
create table 80,855 k 943.4 k 8.98
stmt prepare 68,715 k 801.8 k 7.64
stmt close 68,569 k 800.1 k 7.62
select 58,860 k 686.8 k 6.54
alter table 42,146 k 491.8 k 4.68
update 10,575 k 123.4 k 1.18
set option 4,669 k 54.5 k 0.52
show fields 3,940 k 46 k 0.44
begin 879 k 10.3 k 0.10
commit 773 k 9,015.6 0.09
show tables 756 k 8,817.6 0.08
delete 405 k 4,728.3 0.05
show keys 363 k 4,230.9 0.04
rollback 113 k 1,315.8 0.01
change db 89,594 1,045.4 0.01
show processlist 60,280 703.4 0.01
show create table 30,170 352 <0.01
show variables 12,260 143.1 <0.01
show databases 8,950 104.4 <0.01
update multi 8,490 99.1 <0.01
show grants 7,610 88.8 <0.01
insert select 6,504 75.9 <0.01
enable governor lve 5,138 60 <0.01
show warnings 3,147 36.7 <0.01
show table status 2,817 32.9 <0.01
replace 1,555 18.1 <0.01
flush 1,399 16.3 <0.01
create temporary table 1,102 12.9 <0.01
drop temporary table 1,078 12.6 <0.01
show storage engines 1,033 12.1 <0.01
drop table 695 8.1 <0.01
show triggers 574 6.7 <0.01
grant 537 6.3 <0.01
show function status 405 4.7 <0.01
show procedure status 405 4.7 <0.01
show binlogs 400 4.7 <0.01
show events 362 4.2 <0.01
show binlog status 331 3.9 <0.01
show slave status 331 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 160 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 122 1.4 <0.01
show charsets 96 1.1 <0.01
delete multi 81 0.9 <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 engine status 11 0.1 <0.01
show package status 10 0.1 <0.01
show package body status 10 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