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: 537,191,030 Documentation

  • ø per hour: 2,048,592
  • ø per minute: 34,143
  • ø per second: 569
Statements # ø per hour %
select 257 M 980.3 k 47.85
insert 125 M 477.1 k 23.29
delete 55,776 k 212.7 k 10.38
set option 55,042 k 209.9 k 10.25
update 30,264 k 115.4 k 5.63
commit 13,571 k 51.8 k 2.53
show fields 107 k 409.6 0.02
change db 91,878 350.4 0.02
show tables 68,426 260.9 0.01
show create table 49,568 189 0.01
show keys 16,221 61.9 <0.01
replace 10,496 40 <0.01
show variables 10,464 39.9 <0.01
show warnings 3,929 15 <0.01
show storage engines 2,034 7.8 <0.01
stmt execute 1,679 6.4 <0.01
alter table 1,248 4.8 <0.01
show grants 1,248 4.8 <0.01
stmt close 1,034 3.9 <0.01
stmt prepare 1,034 3.9 <0.01
show table status 975 3.7 <0.01
lock tables 887 3.4 <0.01
unlock tables 887 3.4 <0.01
create table 624 2.4 <0.01
drop table 624 2.4 <0.01
show binlogs 143 0.5 <0.01
show slave status 59 0.2 <0.01
show master status 56 0.2 <0.01
rollback 47 0.2 <0.01
begin 44 0.2 <0.01
show status 39 0.1 <0.01
show databases 25 0.1 <0.01
create user 7 <0.1 <0.01
grant 5 <0.1 <0.01
empty query 4 <0.1 <0.01
show charsets 3 <0.1 <0.01
show collations 3 <0.1 <0.01
create db 2 <0.1 <0.01
show processlist 2 <0.1 <0.01
kill 1 <0.1 <0.01
show engine status 1 <0.1 <0.01
show function status 1 <0.1 <0.01
show plugins 1 <0.1 <0.01
show procedure status 1 <0.1 <0.01