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: 9,556,376 Documentation

  • ø per hour: 20,874
  • ø per minute: 348
  • ø per second: 6
Statements # ø per hour %
select 6,480 k 14.2 k 67.81
show fields 485 k 1,060.1 5.08
show tables 449 k 979.8 4.69
insert 426 k 931.2 4.46
change db 294 k 642.9 3.08
stmt prepare 240 k 523.8 2.51
stmt execute 240 k 523.8 2.51
stmt close 240 k 523.6 2.51
set option 224 k 488.8 2.34
show keys 131 k 285.5 1.37
update 117 k 255 1.22
show grants 63,941 139.7 0.67
replace 58,706 128.2 0.61
show create table 37,434 81.8 0.39
show variables 37,103 81 0.39
show storage engines 12,343 27 0.13
show warnings 11,404 24.9 0.12
show table status 2,740 6 0.03
show binlogs 2,077 4.5 0.02
show slave status 1,311 2.9 0.01
show master status 1,297 2.8 0.01
delete 1,052 2.3 0.01
begin 673 1.5 0.01
commit 672 1.5 0.01
show status 90 0.2 <0.01
create table 55 0.1 <0.01
flush 17 <0.1 <0.01
grant 14 <0.1 <0.01
load 12 <0.1 <0.01
drop table 12 <0.1 <0.01
show processlist 11 <0.1 <0.01
show engine status 8 <0.1 <0.01
create user 7 <0.1 <0.01
create index 7 <0.1 <0.01
create db 4 <0.1 <0.01
insert select 4 <0.1 <0.01
alter table 4 <0.1 <0.01
alter user 2 <0.1 <0.01
rollback 1 <0.1 <0.01