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,931,802 Documentation

  • ø per hour: 23,974
  • ø per minute: 400
  • ø per second: 7
Statements # ø per hour %
select 3,203 k 19.5 k 81.47
show fields 173 k 1,056.8 4.41
show tables 162 k 990 4.13
change db 123 k 747.4 3.12
set option 91,317 556.8 2.32
show variables 46,454 283.2 1.18
show keys 40,647 247.8 1.03
show grants 29,769 181.5 0.76
show create table 25,563 155.9 0.65
show warnings 22,200 135.4 0.56
replace 9,515 58 0.24
show storage engines 1,492 9.1 0.04
stmt prepare 703 4.3 0.02
stmt execute 702 4.3 0.02
stmt close 667 4.1 0.02
show binlogs 412 2.5 0.01
show slave status 301 1.8 0.01
show master status 299 1.8 0.01
show table status 195 1.2 <0.01
show status 31 0.2 <0.01
update 12 0.1 <0.01
delete 7 <0.1 <0.01
insert 4 <0.1 <0.01
show processlist 4 <0.1 <0.01
show engine status 3 <0.1 <0.01
flush 2 <0.1 <0.01