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,858,622 Documentation

  • ø per hour: 6,909
  • ø per minute: 115
  • ø per second: 2
Statements # ø per hour %
select 4,544 k 5,359 77.57
show tables 320 k 376.9 5.45
show fields 291 k 342.6 4.96
change db 223 k 263.5 3.81
set option 167 k 196.7 2.85
show keys 85,805 101.2 1.46
replace 53,051 62.6 0.91
show variables 38,214 45.1 0.65
show create table 34,242 40.4 0.58
stmt execute 23,125 27.3 0.39
stmt prepare 22,012 26 0.38
stmt close 17,907 21.1 0.31
show warnings 13,128 15.5 0.22
show storage engines 11,714 13.8 0.20
show table status 2,855 3.4 0.05
insert 2,755 3.2 0.05
show grants 2,200 2.6 0.04
alter table 2,070 2.4 0.04
delete 1,709 2 0.03
update 576 0.7 0.01
show create db 461 0.5 0.01
show slave status 383 0.5 0.01
show master status 376 0.4 0.01
show binlogs 182 0.2 <0.01
begin 153 0.2 <0.01
commit 153 0.2 <0.01
create table 136 0.2 <0.01
insert select 91 0.1 <0.01
show create proc 68 0.1 <0.01
show function status 56 0.1 <0.01
show procedure status 56 0.1 <0.01
show status 53 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 engine status 5 <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 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