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,344,104 Documentation

  • ø per hour: 20,516
  • ø per minute: 342
  • ø per second: 6
Statements # ø per hour %
select 6,315 k 13.9 k 67.59
show fields 475 k 1,042.6 5.08
show tables 436 k 957.4 4.67
insert 426 k 935.9 4.56
change db 285 k 626.4 3.05
stmt prepare 240 k 526.1 2.56
stmt execute 240 k 526.1 2.56
stmt close 240 k 525.9 2.56
set option 218 k 478 2.33
show keys 127 k 278.3 1.36
update 117 k 256.3 1.25
show grants 63,644 139.7 0.68
replace 57,276 125.8 0.61
show create table 36,350 79.8 0.39
show variables 35,990 79 0.39
show storage engines 12,016 26.4 0.13
show warnings 11,208 24.6 0.12
show table status 2,623 5.8 0.03
show binlogs 2,015 4.4 0.02
show slave status 1,278 2.8 0.01
show master status 1,266 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 75 0.2 <0.01
create table 55 0.1 <0.01
flush 16 <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 9 <0.1 <0.01
create user 7 <0.1 <0.01
show engine status 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