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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Questions since startup: 892,248,111 Documentation

  • ø per hour: 10,601,982
  • ø per minute: 176,700
  • ø per second: 2,945
Statements # ø per hour %
stmt execute 309 M 3,673.7 k 34.65
insert 245 M 2,907.7 k 27.43
create table 80,300 k 954.1 k 9.00
stmt prepare 68,039 k 808.5 k 7.63
stmt close 67,894 k 806.7 k 7.61
select 57,998 k 689.2 k 6.50
alter table 41,861 k 497.4 k 4.69
update 10,449 k 124.2 k 1.17
set option 4,592 k 54.6 k 0.51
show fields 3,870 k 46 k 0.43
begin 865 k 10.3 k 0.10
commit 758 k 9,010.6 0.08
show tables 697 k 8,278.4 0.08
delete 400 k 4,749.3 0.04
show keys 329 k 3,906.4 0.04
rollback 113 k 1,339.9 0.01
change db 66,824 794 0.01
show processlist 59,162 703 0.01
show create table 18,892 224.5 <0.01
show variables 10,911 129.6 <0.01
show databases 8,950 106.3 <0.01
update multi 8,376 99.5 <0.01
show grants 7,371 87.6 <0.01
insert select 6,487 77.1 <0.01
enable governor lve 5,045 59.9 <0.01
show table status 2,677 31.8 <0.01
show warnings 2,628 31.2 <0.01
replace 1,554 18.5 <0.01
flush 1,377 16.4 <0.01
create temporary table 1,090 13 <0.01
drop temporary table 1,066 12.7 <0.01
show storage engines 921 10.9 <0.01
drop table 695 8.3 <0.01
show triggers 574 6.8 <0.01
grant 537 6.4 <0.01
show function status 405 4.8 <0.01
show procedure status 405 4.8 <0.01
show events 362 4.3 <0.01
show binlog status 311 3.7 <0.01
show slave status 311 3.7 <0.01
show binlogs 308 3.7 <0.01
call procedure 293 3.5 <0.01
rollback to savepoint 236 2.8 <0.01
create index 219 2.6 <0.01
create db 158 1.9 <0.01
create user 137 1.6 <0.01
stmt reprepare 125 1.5 <0.01
drop user 123 1.5 <0.01
show charsets 96 1.1 <0.01
show status 96 1.1 <0.01
delete multi 81 1 <0.01
unlock tables 72 0.9 <0.01
lock tables 58 0.7 <0.01
alter user 32 0.4 <0.01
truncate 30 0.4 <0.01
savepoint 29 0.3 <0.01
drop db 19 0.2 <0.01
release savepoint 14 0.2 <0.01
drop index 11 0.1 <0.01
show package status 10 0.1 <0.01
show package body status 10 0.1 <0.01
show open tables 9 0.1 <0.01
enable governor reconn lve 8 0.1 <0.01
empty query 7 0.1 <0.01
show engine status 7 0.1 <0.01
create view 2 <0.1 <0.01
revoke 2 <0.1 <0.01
check 1 <0.1 <0.01