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 :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `INNODB_METRICS` ORDER BY `AVG_COUNT` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
NAME SUBSYSTEM COUNT MAX_COUNT MIN_COUNT AVG_COUNT Descending Ascending 1 COUNT_RESET MAX_COUNT_RESET MIN_COUNT_RESET AVG_COUNT_RESET TIME_ENABLED TIME_DISABLED TIME_ELAPSED TIME_RESET STATUS TYPE COMMENT
buffer_data_written buffer 1691427328 1691427328 NULL 18900.318777097393 1691427328 1691427328 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Amount of data written in bytes (innodb_data_writt...
buffer_data_reads buffer 207129088 207129088 NULL 2314.4983685692578 207129088 207129088 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Amount of data read in bytes (innodb_data_reads)
os_log_bytes_written os 35317760 35317760 NULL 394.6471192955795 35317760 35317760 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Bytes of log written (innodb_os_log_written)
log_padded recovery 11360768 11360768 NULL 126.94730255218343 11360768 11360768 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Bytes of log padded for log write ahead
buffer_pool_read_requests buffer 691130 691130 NULL 7.722813212354177 691130 691130 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of logical read requests (innodb_buffer_poo...
adaptive_hash_searches_btree adaptive_hash_index 175968 175968 NULL 1.9662986635676931 175968 175968 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of searches using B-tree on an index search
buffer_pool_write_requests buffer 101153 101153 NULL 1.1303021499128414 101153 101153 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of write requests (innodb_buffer_pool_write...
os_data_writes os 81546 81546 NULL 0.9112099405533456 81546 81546 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of writes initiated (innodb_data_writes)
innodb_rwlock_s_spin_rounds server 77736 77736 NULL 0.8686363026862737 77736 77736 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of rwlock spin loop rounds due to shared la...
adaptive_hash_searches adaptive_hash_index 67814 67814 NULL 0.7577660573012113 67814 67814 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of successful searches using Adaptive Hash ...
log_write_requests recovery 54833 54833 NULL 0.6127139856076521 54833 54833 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of log write requests (innodb_log_write_req...
buffer_pages_written buffer 50576 50576 NULL 0.5651454878648371 50576 50576 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of pages written (innodb_pages_written)
innodb_dblwr_pages_written server 50445 50445 NULL 0.5636816698699325 50445 50445 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of pages that have been written for doublew...
os_data_fsyncs os 45520 45520 NULL 0.5086488177714209 45520 45520 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of fsync() calls (innodb_data_fsyncs)
innodb_activity_count server 31025 31025 NULL 0.34667903276270506 31025 31025 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Current server activity count
os_log_fsyncs os 23175 23175 NULL 0.2589616949001028 23175 23175 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of fsync log writes (innodb_os_log_fsyncs)
log_writes recovery 21163 21163 NULL 0.23647923836767532 21163 21163 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of log writes (innodb_log_writes)
innodb_rwlock_x_spin_rounds server 18385 18385 NULL 0.20543735752916462 18385 18385 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of rwlock spin loop rounds due to exclusive...
os_data_reads os 12671 12671 NULL 0.14158807491172395 12671 12671 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of reads initiated (innodb_data_reads)
buffer_pool_reads buffer 12638 12638 NULL 0.141219326867206 12638 12638 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of reads directly from disk (innodb_buffer_...
buffer_pages_read buffer 12637 12637 NULL 0.1412081526840388 12637 12637 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of pages read (innodb_pages_read)
dml_updates dml 10989 10989 NULL 0.12279309882447594 10989 10989 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of rows updated
dml_system_reads dml 8979 8979 NULL 0.10033299065838287 8979 8979 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of system rows read
innodb_dblwr_writes server 7798 7798 NULL 0.0871362803379073 7798 7798 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of doublewrite operations that have been pe...
innodb_rwlock_s_spin_waits server 3050 3050 NULL 0.03408125865999195 3050 3050 NULL NULL 2026-03-09 18:15:14 NULL 89492 NULL enabled status_counter Number of rwlock spin waits due to shared latch re...
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query