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: 5,005,628 Documentation

  • ø per hour: 2,561
  • ø per minute: 43
Statements # ø per hour %
select 3,961 k 2,026.6 79.13
show tables 318 k 162.7 6.35
show fields 205 k 104.9 4.10
change db 184 k 93.9 3.67
set option 182 k 93.1 3.64
show keys 42,009 21.5 0.84
stmt execute 19,049 9.7 0.38
stmt prepare 18,788 9.6 0.38
stmt close 18,747 9.6 0.37
replace 15,798 8.1 0.32
show variables 15,765 8.1 0.31
show create table 14,414 7.4 0.29
show warnings 6,119 3.1 0.12
show storage engines 2,156 1.1 0.04
insert 775 0.4 0.02
show grants 582 0.3 0.01
show table status 365 0.2 0.01
show slave status 253 0.1 0.01
show master status 246 0.1 <0.01
lock tables 240 0.1 <0.01
unlock tables 240 0.1 <0.01
show binlogs 179 0.1 <0.01
update 146 0.1 <0.01
delete 107 0.1 <0.01
show status 56 <0.1 <0.01
create table 46 <0.1 <0.01
show charsets 18 <0.1 <0.01
commit 12 <0.1 <0.01
show function status 7 <0.1 <0.01
show procedure status 7 <0.1 <0.01
flush 6 <0.1 <0.01
show collations 6 <0.1 <0.01
show databases 6 <0.1 <0.01
show processlist 6 <0.1 <0.01
alter table 5 <0.1 <0.01
show engine status 4 <0.1 <0.01
create db 3 <0.1 <0.01
create user 3 <0.1 <0.01
grant 3 <0.1 <0.01
show plugins 3 <0.1 <0.01
drop db 2 <0.1 <0.01
drop user 2 <0.1 <0.01
alter user 1 <0.1 <0.01