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 `SUBSYSTEM` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
NAME SUBSYSTEM Descending Ascending 1 COUNT 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
trx_rw_commits transaction 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of read-write transactions  committed
trx_rollbacks transaction 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of transactions rolled back
trx_undo_slots_used transaction 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of undo slots used
trx_commits_insert_update transaction 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of transactions committed with inserts and ...
trx_rseg_history_len transaction 26 38 0 NULL 26 38 0 NULL 2026-02-03 03:05:43 NULL 4601313 NULL enabled value Length of the TRX_RSEG_HISTORY list
trx_nl_ro_commits transaction 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of non-locking auto-commit read-only transa...
trx_active_transactions transaction 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of active transactions
trx_rseg_current_size transaction 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled value Current rollback segment size in pages
trx_ro_commits transaction 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of read-only transactions committed
trx_rollbacks_savepoint transaction 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of transactions rolled back to savepoint
trx_undo_slots_cached transaction 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of undo slots cached
innodb_page_size server 16384 16384 16384 NULL 16384 16384 16384 NULL 2026-02-03 03:05:43 NULL 4601313 NULL enabled value InnoDB page size in bytes (innodb_page_size)
innodb_rwlock_s_spin_rounds server 14978243 14978243 NULL 3.2552106322695282 14978243 14978243 NULL NULL 2026-02-03 03:05:43 NULL 4601313 NULL enabled status_counter Number of rwlock spin loop rounds due to shared la...
innodb_rwlock_x_os_waits server 22616 22616 NULL 0.004915118793266183 22616 22616 NULL NULL 2026-02-03 03:05:43 NULL 4601313 NULL enabled status_counter Number of OS waits due to exclusive latch request
innodb_master_idle_loops server 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of times master thread performs its tasks w...
innodb_mem_validate_usec server 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Time (in microseconds) spent to do memory validati...
innodb_dict_lru_count_idle server 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of tables evicted from DICT LRU list in the...
buffer_pool_size server 16777216 16777216 16777216 NULL 16777216 16777216 16777216 NULL 2026-02-03 03:05:43 NULL 4601313 NULL enabled value Server buffer pool size (all buffer pools) in byte...
innodb_dblwr_pages_written server 5153766 5153766 NULL 1.1200642077598286 5153766 5153766 NULL NULL 2026-02-03 03:05:43 NULL 4601313 NULL enabled status_counter Number of pages that have been written for doublew...
innodb_rwlock_sx_spin_waits server 18812 18812 NULL 0.004088398246326647 18812 18812 NULL NULL 2026-02-03 03:05:43 NULL 4601313 NULL enabled status_counter Number of rwlock spin waits due to sx latch reques...
innodb_rwlock_s_os_waits server 428583 428583 NULL 0.09314363095925011 428583 428583 NULL NULL 2026-02-03 03:05:43 NULL 4601313 NULL enabled status_counter Number of OS waits due to shared latch request
innodb_master_active_loops server 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of times master thread performs its tasks w...
innodb_log_flush_usec server 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Time (in microseconds) spent to flush log records
innodb_dict_lru_count_active server 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of tables evicted from DICT LRU list in the...
innodb_rwlock_x_spin_waits server 899340 899340 NULL 0.19545290659426995 899340 899340 NULL NULL 2026-02-03 03:05:43 NULL 4601313 NULL enabled status_counter Number of rwlock spin waits due to exclusive latch...
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