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,401,385 Documentation

  • ø per hour: 22,715
  • ø per minute: 379
  • ø per second: 6
Statements # ø per hour %
select 8,032 k 17.5 k 77.22
show fields 525 k 1,147.6 5.05
show tables 437 k 954.9 4.20
change db 334 k 730.1 3.21
set option 332 k 724.6 3.19
show keys 312 k 681.1 3.00
show variables 146 k 318.4 1.40
show create table 73,889 161.4 0.71
show grants 72,946 159.3 0.70
show warnings 72,017 157.3 0.69
replace 25,433 55.5 0.24
insert 16,449 35.9 0.16
update 5,592 12.2 0.05
stmt execute 3,452 7.5 0.03
stmt prepare 3,359 7.3 0.03
stmt close 3,341 7.3 0.03
show binlogs 1,057 2.3 0.01
delete 837 1.8 0.01
unlock tables 672 1.5 0.01
lock tables 648 1.4 0.01
show storage engines 490 1.1 <0.01
show slave status 389 0.8 <0.01
show master status 386 0.8 <0.01
show function status 234 0.5 <0.01
show procedure status 234 0.5 <0.01
show create db 224 0.5 <0.01
show events 224 0.5 <0.01
show package status 224 0.5 <0.01
show package body status 224 0.5 <0.01
show table status 216 0.5 <0.01
alter table 149 0.3 <0.01
create table 126 0.3 <0.01
insert select 53 0.1 <0.01
begin 28 0.1 <0.01
create db 27 0.1 <0.01
commit 26 0.1 <0.01
drop table 10 <0.1 <0.01
show status 9 <0.1 <0.01
flush 8 <0.1 <0.01
truncate 8 <0.1 <0.01
show processlist 1 <0.1 <0.01