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: 4,729,238 Documentation

  • ø per hour: 2,422
  • ø per minute: 40
Statements # ø per hour %
select 3,747 k 1,919.3 79.24
show tables 301 k 154.3 6.37
show fields 191 k 97.8 4.04
set option 174 k 89.2 3.68
change db 172 k 88.1 3.64
show keys 36,287 18.6 0.77
stmt execute 18,853 9.7 0.40
stmt prepare 18,592 9.5 0.39
stmt close 18,551 9.5 0.39
show variables 14,090 7.2 0.30
replace 13,715 7 0.29
show create table 13,160 6.7 0.28
show warnings 5,700 2.9 0.12
show storage engines 1,824 0.9 0.04
insert 775 0.4 0.02
show table status 270 0.1 0.01
lock tables 240 0.1 0.01
unlock tables 240 0.1 0.01
show slave status 214 0.1 <0.01
show master status 209 0.1 <0.01
update 146 0.1 <0.01
show grants 123 0.1 <0.01
delete 107 0.1 <0.01
show binlogs 83 <0.1 <0.01
create table 46 <0.1 <0.01
show status 34 <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
show collations 6 <0.1 <0.01
show databases 6 <0.1 <0.01
alter table 5 <0.1 <0.01
flush 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
show processlist 3 <0.1 <0.01
drop db 2 <0.1 <0.01
drop user 2 <0.1 <0.01
show engine status 2 <0.1 <0.01
alter user 1 <0.1 <0.01