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,370,240 Documentation

  • ø per hour: 2,804
  • ø per minute: 47
Statements # ø per hour %
select 1,817 k 2,150 76.66
show tables 125 k 147.4 5.25
show fields 115 k 135.6 4.83
change db 86,298 102.1 3.64
set option 66,667 78.9 2.81
show keys 33,169 39.2 1.40
stmt execute 22,830 27 0.96
stmt prepare 21,717 25.7 0.92
replace 18,658 22.1 0.79
stmt close 17,612 20.8 0.74
show create table 13,814 16.3 0.58
show variables 13,245 15.7 0.56
show storage engines 5,989 7.1 0.25
show warnings 4,793 5.7 0.20
insert 2,755 3.3 0.12
alter table 2,070 2.4 0.09
show table status 1,308 1.5 0.06
update 576 0.7 0.02
delete 513 0.6 0.02
show create db 461 0.5 0.02
show slave status 271 0.3 0.01
show master status 266 0.3 0.01
begin 153 0.2 0.01
commit 153 0.2 0.01
create table 136 0.2 0.01
show grants 94 0.1 <0.01
insert select 91 0.1 <0.01
show function status 56 0.1 <0.01
show procedure status 56 0.1 <0.01
show triggers 45 0.1 <0.01
show binlogs 35 <0.1 <0.01
do 33 <0.1 <0.01
show status 28 <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 create proc 8 <0.1 <0.01
show open tables 5 <0.1 <0.01
show collations 4 <0.1 <0.01
show charsets 2 <0.1 <0.01
show processlist 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
show engine status 1 <0.1 <0.01