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,501,917 Documentation

  • ø per hour: 7,653
  • ø per minute: 128
  • ø per second: 2
Statements # ø per hour %
insert 2,025 k 4,425.5 57.83
select 770 k 1,683.6 22.00
commit 295 k 644.3 8.42
delete 158 k 345.8 4.52
set option 111 k 243.4 3.18
insert select 51,082 111.6 1.46
show tables 24,314 53.1 0.69
show fields 22,122 48.3 0.63
change db 17,908 39.1 0.51
show keys 8,867 19.4 0.25
truncate 3,364 7.4 0.10
show variables 2,855 6.2 0.08
replace 2,795 6.1 0.08
update 2,636 5.8 0.08
show create table 2,575 5.6 0.07
show grants 720 1.6 0.02
show storage engines 611 1.3 0.02
show warnings 443 1 0.01
stmt prepare 239 0.5 0.01
stmt execute 239 0.5 0.01
show binlogs 237 0.5 0.01
drop temporary table 219 0.5 0.01
create temporary table 219 0.5 0.01
stmt reprepare 178 0.4 0.01
show table status 135 0.3 <0.01
show slave status 62 0.1 <0.01
stmt close 61 0.1 <0.01
show master status 58 0.1 <0.01
show status 55 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
flush 2 <0.1 <0.01
show processlist 1 <0.1 <0.01
show engine status 1 <0.1 <0.01
create table 1 <0.1 <0.01