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 `COUNT` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
NAME SUBSYSTEM COUNT Descending Ascending 1 MAX_COUNT MIN_COUNT AVG_COUNT 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 3956024832 3956024832 NULL 13826.646646814579 3956024832 3956024832 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Amount of data written in bytes (innodb_data_writt...
buffer_data_reads buffer 423283200 423283200 NULL 1479.411147926016 423283200 423283200 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Amount of data read in bytes (innodb_data_reads)
os_log_bytes_written os 89158144 89158144 NULL 311.6153727858631 89158144 89158144 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Bytes of log written (innodb_os_log_written)
log_padded recovery 31017984 31017984 NULL 108.41051881055236 31017984 31017984 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Bytes of log padded for log write ahead
buffer_pool_size server 16777216 16777216 16777216 NULL 16777216 16777216 16777216 NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled value Server buffer pool size (all buffer pools) in byte...
buffer_pool_bytes_data buffer 4177920 4505600 3915776 NULL 4177920 4505600 3915776 NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled value Buffer bytes containing data (innodb_buffer_pool_b...
buffer_pool_bytes_dirty buffer 3112960 3670016 0 NULL 3112960 3670016 0 NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled value Buffer bytes currently dirty (innodb_buffer_pool_b...
buffer_pool_read_requests buffer 1725909 1725909 NULL 6.032200226481567 1725909 1725909 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of logical read requests (innodb_buffer_poo...
adaptive_hash_searches_btree adaptive_hash_index 463892 463892 NULL 1.62134239259601 463892 463892 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of searches using B-tree on an index search
buffer_pool_write_requests buffer 244420 244420 NULL 0.8542688979295111 244420 244420 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of write requests (innodb_buffer_pool_write...
os_data_writes os 182195 182195 NULL 0.6367871772288163 182195 182195 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of writes initiated (innodb_data_writes)
adaptive_hash_searches adaptive_hash_index 152834 152834 NULL 0.5341679598484531 152834 152834 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of successful searches using Adaptive Hash ...
log_write_requests recovery 152455 152455 NULL 0.5328433222888619 152455 152455 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of log write requests (innodb_log_write_req...
buffer_pages_written buffer 118042 118042 NULL 0.4125669308951614 118042 118042 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of pages written (innodb_pages_written)
innodb_dblwr_pages_written server 117911 117911 NULL 0.4121090746410547 117911 117911 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of pages that have been written for doublew...
os_data_fsyncs os 91254 91254 NULL 0.31894056955919975 91254 91254 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of fsync() calls (innodb_data_fsyncs)
innodb_activity_count server 85637 85637 NULL 0.29930867200715794 85637 85637 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Current server activity count
innodb_rwlock_s_spin_rounds server 60030 60030 NULL 0.20981000712997525 60030 60030 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of rwlock spin loop rounds due to shared la...
os_log_fsyncs os 47461 47461 NULL 0.16588027233709404 47461 47461 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of fsync log writes (innodb_os_log_fsyncs)
log_writes recovery 45522 45522 NULL 0.15910330075913265 45522 45522 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of log writes (innodb_log_writes)
dml_updates dml 31809 31809 NULL 0.11117518768611333 31809 31809 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of rows updated
os_data_reads os 25867 25867 NULL 0.0904073872135777 25867 25867 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of reads initiated (innodb_data_reads)
buffer_pool_reads buffer 25834 25834 NULL 0.09029204937857373 25834 25834 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of reads directly from disk (innodb_buffer_...
buffer_pages_read buffer 25833 25833 NULL 0.09028855429266451 25833 25833 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of pages read (innodb_pages_read)
dml_system_reads dml 25294 25294 NULL 0.08840470298759943 25294 25294 NULL NULL 2026-01-20 16:51:06 NULL 286116 NULL enabled status_counter Number of system rows read
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