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,875,326 Documentation

  • ø per hour: 35,145
  • ø per minute: 586
  • ø per second: 10
Statements # ø per hour %
select 7,584 k 27 k 76.79
show tables 509 k 1,809.9 5.15
show fields 503 k 1,790.9 5.10
change db 377 k 1,340.9 3.82
set option 363 k 1,292.6 3.68
show keys 152 k 540.5 1.54
replace 89,253 317.6 0.90
show variables 83,915 298.6 0.85
show create table 62,906 223.9 0.64
insert 40,839 145.3 0.41
show warnings 35,779 127.3 0.36
stmt execute 16,892 60.1 0.17
stmt prepare 16,662 59.3 0.17
stmt close 16,620 59.1 0.17
show storage engines 14,111 50.2 0.14
update 2,568 9.1 0.03
delete 2,290 8.1 0.02
show table status 2,169 7.7 0.02
create table 746 2.7 0.01
begin 675 2.4 0.01
drop table 675 2.4 0.01
commit 674 2.4 0.01
show grants 398 1.4 <0.01
show slave status 331 1.2 <0.01
show master status 322 1.1 <0.01
show binlogs 158 0.6 <0.01
show create proc 46 0.2 <0.01
show status 44 0.2 <0.01
alter table 25 0.1 <0.01
kill 16 0.1 <0.01
insert select 9 <0.1 <0.01
show databases 5 <0.1 <0.01
show processlist 5 <0.1 <0.01
flush 4 <0.1 <0.01
create trigger 3 <0.1 <0.01
drop trigger 3 <0.1 <0.01
create db 2 <0.1 <0.01
create temporary table 2 <0.1 <0.01
create user 2 <0.1 <0.01
grant 2 <0.1 <0.01
show engine status 2 <0.1 <0.01
show charsets 1 <0.1 <0.01
show collations 1 <0.1 <0.01