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: 34,150,032 Documentation

  • ø per hour: 20,124
  • ø per minute: 335
  • ø per second: 6
Statements # ø per hour %
select 19,968 k 11.8 k 58.47
stmt prepare 2,175 k 1,281.8 6.37
stmt execute 2,175 k 1,281.8 6.37
stmt close 2,175 k 1,281.7 6.37
show fields 2,168 k 1,277.3 6.35
show tables 1,330 k 783.5 3.89
update 1,069 k 629.7 3.13
change db 873 k 514.5 2.56
set option 660 k 388.7 1.93
insert 473 k 278.5 1.38
show keys 397 k 234.2 1.16
show grants 189 k 111.3 0.55
replace 173 k 102.1 0.51
show variables 117 k 68.7 0.34
show create table 111 k 65.6 0.33
show warnings 36,957 21.8 0.11
show storage engines 33,261 19.6 0.10
show table status 7,863 4.6 0.02
show binlogs 6,592 3.9 0.02
show slave status 3,591 2.1 0.01
show master status 3,547 2.1 0.01
begin 2,492 1.5 0.01
commit 2,487 1.5 0.01
delete 1,052 0.6 <0.01
show status 317 0.2 <0.01
create table 55 <0.1 <0.01
show engine status 37 <0.1 <0.01
show processlist 36 <0.1 <0.01
flush 29 <0.1 <0.01
grant 14 <0.1 <0.01
load 12 <0.1 <0.01
drop table 12 <0.1 <0.01
create index 7 <0.1 <0.01
create user 7 <0.1 <0.01
rollback 5 <0.1 <0.01
insert select 4 <0.1 <0.01
create db 4 <0.1 <0.01
alter table 4 <0.1 <0.01
alter user 2 <0.1 <0.01
show databases 1 <0.1 <0.01