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: 538,347,577 Documentation

  • ø per hour: 2,051,089
  • ø per minute: 34,185
  • ø per second: 570
Statements # ø per hour %
select 258 M 982.2 k 47.89
insert 125 M 477.2 k 23.27
delete 55,827 k 212.7 k 10.37
set option 55,107 k 210 k 10.24
update 30,295 k 115.4 k 5.63
commit 13,583 k 51.7 k 2.52
show fields 135 k 515.9 0.03
change db 114 k 435.9 0.02
show tables 101 k 383 0.02
show create table 52,519 200.1 0.01
show keys 25,466 97 <0.01
replace 15,190 57.9 <0.01
show variables 13,731 52.3 <0.01
show warnings 4,618 17.6 <0.01
show storage engines 2,754 10.5 <0.01
stmt execute 1,679 6.4 <0.01
show grants 1,540 5.9 <0.01
alter table 1,248 4.8 <0.01
show table status 1,215 4.6 <0.01
stmt close 1,034 3.9 <0.01
stmt prepare 1,034 3.9 <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 204 0.8 <0.01
show slave status 75 0.3 <0.01
show master status 72 0.3 <0.01
show status 54 0.2 <0.01
rollback 47 0.2 <0.01
begin 44 0.2 <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 processlist 4 <0.1 <0.01
show charsets 3 <0.1 <0.01
show collations 3 <0.1 <0.01
show engine status 3 <0.1 <0.01
create db 2 <0.1 <0.01
kill 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