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: 3,031,732 Documentation

  • ø per hour: 5,379
  • ø per minute: 90
  • ø per second: 1
Statements # ø per hour %
select 2,292 k 4,066.7 75.60
show fields 141 k 250.2 4.65
show tables 128 k 226.5 4.21
change db 99,764 177 3.29
set option 81,846 145.2 2.70
stmt close 56,103 99.5 1.85
stmt execute 56,103 99.5 1.85
stmt prepare 56,103 99.5 1.85
show keys 29,191 51.8 0.96
show variables 29,114 51.7 0.96
replace 19,847 35.2 0.65
show create table 19,019 33.7 0.63
show warnings 12,962 23 0.43
insert 4,600 8.2 0.15
show storage engines 2,817 5 0.09
update 923 1.6 0.03
show table status 662 1.2 0.02
show grants 580 1 0.02
insert select 323 0.6 0.01
delete 299 0.5 0.01
show binlogs 272 0.5 0.01
rollback to savepoint 180 0.3 0.01
show slave status 114 0.2 <0.01
show master status 107 0.2 <0.01
show status 30 0.1 <0.01
create table 15 <0.1 <0.01
alter table 14 <0.1 <0.01
show databases 11 <0.1 <0.01
show create proc 9 <0.1 <0.01
drop procedure 8 <0.1 <0.01
show procedure status 8 <0.1 <0.01
truncate 8 <0.1 <0.01
create procedure 7 <0.1 <0.01
drop table 7 <0.1 <0.01
show function status 6 <0.1 <0.01
create temporary table 5 <0.1 <0.01
drop temporary table 5 <0.1 <0.01
call procedure 4 <0.1 <0.01
show charsets 2 <0.1 <0.01
show collations 2 <0.1 <0.01
begin 1 <0.1 <0.01
create db 1 <0.1 <0.01
release savepoint 1 <0.1 <0.01
savepoint 1 <0.1 <0.01
show package status 1 <0.1 <0.01
show package body status 1 <0.1 <0.01
show processlist 1 <0.1 <0.01
unlock tables 1 <0.1 <0.01