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: 14,092,316 Documentation

  • ø per hour: 45,340
  • ø per minute: 756
  • ø per second: 13
Statements # ø per hour %
select 7,348 k 23.6 k 52.14
stmt execute 5,286 k 17 k 37.51
stmt prepare 480 k 1,543.7 3.40
stmt close 479 k 1,541.3 3.40
show tables 136 k 437.6 0.97
show fields 104 k 334.6 0.74
change db 87,580 281.8 0.62
set option 74,174 238.6 0.53
show keys 36,179 116.4 0.26
show variables 13,809 44.4 0.10
replace 10,969 35.3 0.08
show create table 8,452 27.2 0.06
update 7,168 23.1 0.05
show warnings 5,293 17 0.04
insert 4,195 13.5 0.03
begin 3,609 11.6 0.03
commit 2,924 9.4 0.02
show storage engines 1,514 4.9 0.01
show grants 876 2.8 0.01
show binlogs 738 2.4 0.01
rollback 660 2.1 <0.01
show table status 269 0.9 <0.01
show slave status 205 0.7 <0.01
show master status 199 0.6 <0.01
rollback to savepoint 164 0.5 <0.01
delete 153 0.5 <0.01
show status 32 0.1 <0.01
unlock tables 27 0.1 <0.01
release savepoint 25 0.1 <0.01
savepoint 25 0.1 <0.01
show events 25 0.1 <0.01
create table 13 <0.1 <0.01
alter table 11 <0.1 <0.01
show function status 8 <0.1 <0.01
show procedure status 8 <0.1 <0.01
grant 7 <0.1 <0.01
show package status 7 <0.1 <0.01
show package body status 7 <0.1 <0.01
flush 6 <0.1 <0.01
show processlist 4 <0.1 <0.01
create db 3 <0.1 <0.01
create user 3 <0.1 <0.01
rename table 3 <0.1 <0.01
update multi 3 <0.1 <0.01
lock tables 2 <0.1 <0.01
revoke 2 <0.1 <0.01
show engine status 2 <0.1 <0.01
drop db 1 <0.1 <0.01
drop table 1 <0.1 <0.01