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: 2,760,950 Documentation

  • ø per hour: 14,703
  • ø per minute: 245
  • ø per second: 4
Statements # ø per hour %
select 1,786 k 9,512.2 64.70
stmt prepare 164 k 876 5.96
stmt close 164 k 874.8 5.95
stmt execute 164 k 874.8 5.95
show fields 106 k 565.2 3.84
show tables 106 k 564.5 3.84
change db 76,043 404.9 2.75
set option 59,599 317.4 2.16
show keys 50,694 270 1.84
show variables 21,046 112.1 0.76
insert 18,558 98.8 0.67
replace 16,499 87.9 0.60
show create table 13,880 73.9 0.50
show warnings 9,106 48.5 0.33
show storage engines 2,076 11.1 0.08
show table status 441 2.3 0.02
update 221 1.2 0.01
begin 206 1.1 0.01
commit 203 1.1 0.01
show grants 186 1 0.01
show slave status 178 0.9 0.01
show master status 174 0.9 0.01
delete 144 0.8 0.01
show binlogs 131 0.7 <0.01
truncate 36 0.2 <0.01
alter table 31 0.2 <0.01
create table 31 0.2 <0.01
show status 19 0.1 <0.01
create index 3 <0.1 <0.01
rollback 3 <0.1 <0.01
flush 2 <0.1 <0.01
show engine status 2 <0.1 <0.01
show processlist 2 <0.1 <0.01
create db 1 <0.1 <0.01
create view 1 <0.1 <0.01
drop view 1 <0.1 <0.01
empty query 1 <0.1 <0.01