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: 88,951,347 Documentation

  • ø per hour: 71,949
  • ø per minute: 1,199
  • ø per second: 20
Statements # ø per hour %
select 70,928 k 57.4 k 79.74
show fields 4,527 k 3,661.7 5.09
show tables 3,749 k 3,032.6 4.21
change db 2,981 k 2,411.3 3.35
set option 2,237 k 1,809.5 2.51
show variables 1,459 k 1,180.2 1.64
show keys 870 k 703.9 0.98
show create table 735 k 594.6 0.83
show warnings 727 k 588.4 0.82
show grants 660 k 534.1 0.74
replace 66,839 54.1 0.08
show storage engines 3,517 2.8 <0.01
update 1,500 1.2 <0.01
stmt prepare 932 0.8 <0.01
show binlogs 707 0.6 <0.01
stmt close 687 0.6 <0.01
stmt execute 687 0.6 <0.01
show slave status 388 0.3 <0.01
show table status 385 0.3 <0.01
show master status 376 0.3 <0.01
insert 332 0.3 <0.01
delete 193 0.2 <0.01
show status 56 <0.1 <0.01
delete multi 12 <0.1 <0.01
flush 12 <0.1 <0.01
show engine status 8 <0.1 <0.01
alter table 6 <0.1 <0.01
create db 6 <0.1 <0.01
create table 6 <0.1 <0.01
drop db 6 <0.1 <0.01
reset 6 <0.1 <0.01
show processlist 6 <0.1 <0.01
show databases 4 <0.1 <0.01
truncate 4 <0.1 <0.01
grant 3 <0.1 <0.01
insert select 2 <0.1 <0.01