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: 12,682,963 Documentation

  • ø per hour: 1,007,473
  • ø per minute: 16,791
  • ø per second: 280
Statements # ø per hour %
select 12,260 k 973.8 k 96.66
show tables 83,431 6,627.4 0.66
show fields 81,117 6,443.5 0.64
change db 59,558 4,731 0.47
set option 50,090 3,978.9 0.39
stmt execute 27,000 2,144.7 0.21
stmt prepare 26,995 2,144.4 0.21
stmt close 26,990 2,144 0.21
show keys 20,244 1,608.1 0.16
replace 11,160 886.5 0.09
show variables 9,731 773 0.08
show create table 8,376 665.3 0.07
create table 8,325 661.3 0.07
show warnings 3,261 259 0.03
show storage engines 3,259 258.9 0.03
update 698 55.4 0.01
insert 630 50 <0.01
delete 549 43.6 <0.01
show table status 411 32.6 <0.01
show slave status 310 24.6 <0.01
show master status 303 24.1 <0.01
show grants 256 20.3 <0.01
show status 144 11.4 <0.01
begin 124 9.8 <0.01
commit 124 9.8 <0.01
show binlogs 118 9.4 <0.01
show collations 92 7.3 <0.01
lock tables 19 1.5 <0.01
unlock tables 19 1.5 <0.01
alter table 18 1.4 <0.01
revoke 10 0.8 <0.01
grant 9 0.7 <0.01
show charsets 8 0.6 <0.01
show function status 8 0.6 <0.01
show procedure status 8 0.6 <0.01
show create db 7 0.6 <0.01
show events 6 0.5 <0.01
show package status 6 0.5 <0.01
show package body status 6 0.5 <0.01
show processlist 4 0.3 <0.01
flush 3 0.2 <0.01
show databases 3 0.2 <0.01
create user 2 0.2 <0.01
show engine status 2 0.2 <0.01
alter user 1 0.1 <0.01
delete multi 1 0.1 <0.01
drop user 1 0.1 <0.01
empty query 1 0.1 <0.01
show plugins 1 0.1 <0.01