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,795,151 Documentation

  • ø per hour: 34,919
  • ø per minute: 582
  • ø per second: 10
Statements # ø per hour %
select 7,519 k 26.8 k 76.76
show tables 504 k 1,797 5.15
show fields 500 k 1,782.5 5.10
change db 373 k 1,330.7 3.81
set option 361 k 1,285.7 3.68
show keys 151 k 539.6 1.55
replace 89,173 317.9 0.91
show variables 83,206 296.6 0.85
show create table 62,750 223.7 0.64
insert 40,839 145.6 0.42
show warnings 35,779 127.5 0.37
stmt execute 16,875 60.2 0.17
stmt prepare 16,645 59.3 0.17
stmt close 16,603 59.2 0.17
show storage engines 14,084 50.2 0.14
update 2,568 9.2 0.03
delete 2,290 8.2 0.02
show table status 2,160 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 slave status 327 1.2 <0.01
show master status 318 1.1 <0.01
show grants 210 0.7 <0.01
show binlogs 66 0.2 <0.01
show create proc 44 0.2 <0.01
show status 42 0.1 <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