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,074,683 Documentation

  • ø per hour: 71,709
  • ø per minute: 1,195
  • ø per second: 20
Statements # ø per hour %
select 2,017 k 47 k 65.61
stmt execute 158 k 3,688.8 5.14
stmt prepare 158 k 3,688 5.14
stmt close 158 k 3,686.7 5.14
show tables 149 k 3,463.7 4.83
show fields 125 k 2,907.5 4.05
change db 94,616 2,206.7 3.08
set option 94,049 2,193.5 3.06
show keys 37,925 884.5 1.23
replace 16,790 391.6 0.55
show variables 15,186 354.2 0.49
show create table 14,072 328.2 0.46
create table 8,826 205.8 0.29
insert 5,633 131.4 0.18
update 5,633 131.4 0.18
show storage engines 4,463 104.1 0.15
show warnings 3,327 77.6 0.11
insert select 2,198 51.3 0.07
call procedure 2,154 50.2 0.07
show table status 2,006 46.8 0.07
begin 1,002 23.4 0.03
commit 596 13.9 0.02
rollback 404 9.4 0.01
delete 308 7.2 0.01
show slave status 226 5.3 0.01
show master status 221 5.2 0.01
show grants 157 3.7 0.01
show status 46 1.1 <0.01
show binlogs 42 1 <0.01
show create proc 31 0.7 <0.01
update multi 10 0.2 <0.01
show databases 4 0.1 <0.01
show processlist 4 0.1 <0.01
alter table 3 0.1 <0.01
show engine status 3 0.1 <0.01
show function status 2 <0.1 <0.01
show open tables 2 <0.1 <0.01
show procedure status 2 <0.1 <0.01
show triggers 2 <0.1 <0.01
show collations 1 <0.1 <0.01