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: 3,797,558 Documentation

  • ø per hour: 8,264
  • ø per minute: 138
  • ø per second: 2
Statements # ø per hour %
insert 2,025 k 4,406.5 53.32
select 1,000 k 2,176.9 26.34
commit 295 k 641.5 7.76
delete 158 k 344.4 4.17
set option 120 k 260.8 3.16
insert select 51,082 111.2 1.35
show tables 43,653 95 1.15
show fields 36,177 78.7 0.95
change db 29,986 65.3 0.79
show keys 13,032 28.4 0.34
replace 5,317 11.6 0.14
show variables 4,789 10.4 0.13
show create table 3,903 8.5 0.10
truncate 3,364 7.3 0.09
update 2,636 5.7 0.07
show grants 1,288 2.8 0.03
show storage engines 950 2.1 0.03
show warnings 926 2 0.02
show binlogs 297 0.6 0.01
stmt prepare 287 0.6 0.01
stmt execute 287 0.6 0.01
show table status 278 0.6 0.01
drop temporary table 219 0.5 0.01
create temporary table 219 0.5 0.01
stmt reprepare 214 0.5 0.01
stmt close 73 0.2 <0.01
show slave status 69 0.2 <0.01
show master status 65 0.1 <0.01
show status 61 0.1 <0.01
alter table 38 0.1 <0.01
show create proc 12 <0.1 <0.01
show procedure status 8 <0.1 <0.01
show triggers 8 <0.1 <0.01
show function status 8 <0.1 <0.01
show open tables 5 <0.1 <0.01
show databases 5 <0.1 <0.01
show collations 4 <0.1 <0.01
show processlist 3 <0.1 <0.01
show engine status 3 <0.1 <0.01
flush 2 <0.1 <0.01
create table 1 <0.1 <0.01