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,992,867 Documentation

  • ø per hour: 5,892
  • ø per minute: 98
  • ø per second: 2
Statements # ø per hour %
select 3,870 k 4,567.5 77.52
show tables 273 k 321.7 5.46
show fields 248 k 292.3 4.96
change db 189 k 223.6 3.79
set option 143 k 168.4 2.86
show keys 73,245 86.4 1.47
replace 43,017 50.8 0.86
show variables 28,985 34.2 0.58
show create table 28,976 34.2 0.58
stmt execute 23,119 27.3 0.46
stmt prepare 22,006 26 0.44
stmt close 17,901 21.1 0.36
show storage engines 10,846 12.8 0.22
show warnings 9,677 11.4 0.19
insert 2,755 3.3 0.06
show table status 2,388 2.8 0.05
alter table 2,070 2.4 0.04
show grants 1,443 1.7 0.03
delete 708 0.8 0.01
update 576 0.7 0.01
show create db 461 0.5 0.01
show slave status 364 0.4 0.01
show master status 357 0.4 0.01
begin 153 0.2 <0.01
commit 153 0.2 <0.01
create table 136 0.2 <0.01
show binlogs 119 0.1 <0.01
insert select 91 0.1 <0.01
show create proc 64 0.1 <0.01
show function status 56 0.1 <0.01
show procedure status 56 0.1 <0.01
show status 46 0.1 <0.01
show triggers 45 0.1 <0.01
do 33 <0.1 <0.01
lock tables 22 <0.1 <0.01
unlock tables 22 <0.1 <0.01
update multi 22 <0.1 <0.01
show package status 11 <0.1 <0.01
show package body status 11 <0.1 <0.01
show databases 10 <0.1 <0.01
show open tables 5 <0.1 <0.01
show processlist 5 <0.1 <0.01
show collations 4 <0.1 <0.01
show engine status 3 <0.1 <0.01
show charsets 2 <0.1 <0.01
create db 1 <0.1 <0.01
drop db 1 <0.1 <0.01
rename table 1 <0.1 <0.01