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: 7,259,133 Documentation

  • ø per hour: 13,814
  • ø per minute: 230
  • ø per second: 4
Statements # ø per hour %
select 6,336 k 12.1 k 87.28
show tables 165 k 313.3 2.27
show fields 150 k 285.5 2.07
set option 147 k 279.8 2.03
change db 122 k 232.1 1.68
update 120 k 228.6 1.65
insert 61,538 117.1 0.85
delete 57,880 110.1 0.80
show keys 39,738 75.6 0.55
replace 18,142 34.5 0.25
show variables 14,997 28.5 0.21
show create table 11,132 21.2 0.15
show warnings 5,895 11.2 0.08
update multi 4,165 7.9 0.06
show storage engines 2,610 5 0.04
stmt close 642 1.2 0.01
stmt execute 642 1.2 0.01
stmt prepare 642 1.2 0.01
insert select 376 0.7 0.01
show table status 364 0.7 0.01
create table 166 0.3 <0.01
show slave status 134 0.3 <0.01
show master status 130 0.2 <0.01
show grants 73 0.1 <0.01
show binlogs 55 0.1 <0.01
delete multi 52 0.1 <0.01
show status 21 <0.1 <0.01
truncate 9 <0.1 <0.01
alter table 7 <0.1 <0.01
grant 4 <0.1 <0.01
create db 2 <0.1 <0.01
create user 2 <0.1 <0.01
show engine status 2 <0.1 <0.01
show plugins 2 <0.1 <0.01
show processlist 2 <0.1 <0.01
drop table 1 <0.1 <0.01
flush 1 <0.1 <0.01