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: 10,003,280 Documentation

  • ø per hour: 35,583
  • ø per minute: 593
  • ø per second: 10
Statements # ø per hour %
select 7,681 k 27.3 k 76.78
show tables 515 k 1,833.4 5.15
show fields 511 k 1,817.3 5.11
change db 383 k 1,361.4 3.83
set option 367 k 1,304.6 3.67
show keys 155 k 551.4 1.55
replace 90,261 321.1 0.90
show variables 84,432 300.3 0.84
show create table 63,790 226.9 0.64
insert 40,839 145.3 0.41
show warnings 35,822 127.4 0.36
stmt execute 16,994 60.4 0.17
stmt prepare 16,764 59.6 0.17
stmt close 16,722 59.5 0.17
show storage engines 14,455 51.4 0.14
update 2,568 9.1 0.03
delete 2,290 8.1 0.02
show table status 2,187 7.8 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 529 1.9 0.01
show slave status 346 1.2 <0.01
show master status 336 1.2 <0.01
show binlogs 187 0.7 <0.01
show status 54 0.2 <0.01
show create proc 48 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 processlist 7 <0.1 <0.01
flush 5 <0.1 <0.01
show databases 5 <0.1 <0.01
create trigger 3 <0.1 <0.01
drop trigger 3 <0.1 <0.01
show engine status 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 charsets 1 <0.1 <0.01
show collations 1 <0.1 <0.01