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: 7,809,776 Documentation

  • ø per hour: 38,984
  • ø per minute: 650
  • ø per second: 11
Statements # ø per hour %
select 2,618 k 13.1 k 33.52
stmt execute 1,092 k 5,451.6 13.98
stmt prepare 1,084 k 5,410.6 13.88
stmt close 1,068 k 5,329.8 13.67
show fields 588 k 2,936.8 7.53
set option 541 k 2,698.4 6.92
insert 267 k 1,332.2 3.42
show tables 159 k 795.8 2.04
show keys 116 k 578.6 1.48
change db 84,146 420 1.08
create table 74,461 371.7 0.95
update 43,019 214.7 0.55
show variables 21,071 105.2 0.27
replace 18,642 93.1 0.24
show create table 15,712 78.4 0.20
show warnings 8,802 43.9 0.11
show storage engines 2,860 14.3 0.04
begin 2,431 12.1 0.03
commit 2,418 12.1 0.03
update multi 835 4.2 0.01
rollback to savepoint 736 3.7 0.01
delete 470 2.3 0.01
show grants 344 1.7 <0.01
show table status 327 1.6 <0.01
show slave status 176 0.9 <0.01
show master status 169 0.8 <0.01
show binlogs 154 0.8 <0.01
alter table 133 0.7 <0.01
show status 42 0.2 <0.01
show create proc 20 0.1 <0.01
release savepoint 8 <0.1 <0.01
savepoint 8 <0.1 <0.01
show function status 8 <0.1 <0.01
show package status 8 <0.1 <0.01
show package body status 8 <0.1 <0.01
show procedure status 8 <0.1 <0.01
unlock tables 8 <0.1 <0.01
show processlist 6 <0.1 <0.01
rollback 5 <0.1 <0.01
show engine status 4 <0.1 <0.01
flush 1 <0.1 <0.01