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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Questions since startup: 3,794,669 Documentation

  • ø per hour: 5,847
  • ø per minute: 97
  • ø per second: 2
Statements # ø per hour %
select 2,725 k 4,199.7 71.82
show tables 182 k 281.1 4.81
show fields 169 k 260 4.45
change db 139 k 214.4 3.67
stmt execute 94,167 145.1 2.48
set option 93,889 144.7 2.47
stmt prepare 93,596 144.2 2.47
stmt close 93,519 144.1 2.46
show keys 73,471 113.2 1.94
show variables 26,769 41.2 0.71
replace 26,659 41.1 0.70
show create table 20,169 31.1 0.53
show grants 16,432 25.3 0.43
create db 12,141 18.7 0.32
show warnings 10,482 16.2 0.28
create table 7,553 11.6 0.20
show storage engines 3,677 5.7 0.10
alter table 1,252 1.9 0.03
insert 1,135 1.7 0.03
update 994 1.5 0.03
show table status 854 1.3 0.02
show binlogs 617 1 0.02
show slave status 384 0.6 0.01
show master status 372 0.6 0.01
begin 233 0.4 0.01
commit 220 0.3 0.01
drop table 82 0.1 <0.01
show status 82 0.1 <0.01
lock tables 37 0.1 <0.01
unlock tables 37 0.1 <0.01
delete 23 <0.1 <0.01
rollback 11 <0.1 <0.01
show processlist 11 <0.1 <0.01
show engine status 8 <0.1 <0.01
flush 6 <0.1 <0.01
drop db 3 <0.1 <0.01
show function status 3 <0.1 <0.01
show procedure status 3 <0.1 <0.01
empty query 2 <0.1 <0.01