控制台
当前所选内容没有包含唯一字段。单元格编辑、复选框、编辑、复制和删除无法正常使用。
正在显示第 0 - ... 此视图的行数最少有这么多。请参阅档案。 行 (查询花费 0.0009 秒。) [TYPE: VALUE... - VALUE...]
SELECT * FROM `INNODB_METRICS` ORDER BY `TYPE` DESC
| 过滤行: |
| NAME | SUBSYSTEM | 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 1
|
COMMENT | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| log_pending_log_flushes | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Pending log flushes | |
| innodb_page_size | server | 16384 | 16384 | 16384 | NULL | 16384 | 16384 | 16384 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | InnoDB page size in bytes (innodb_page_size) | |
| 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 | |
| file_num_open_files | file_system | 45 | 45 | 45 | NULL | 45 | 45 | 45 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | Number of files currently open (innodb_num_open_fi... | |
| buffer_pool_pages_dirty | buffer | 0 | 51 | 0 | NULL | 0 | 51 | 0 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | Buffer pages currently dirty (innodb_buffer_pool_p... | |
| lock_row_lock_current_waits | lock | 0 | 0 | 0 | NULL | 0 | 0 | 0 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | Number of row locks currently being waited for (in... | |
| lock_row_lock_time_avg | lock | 2 | 2 | 0 | NULL | 2 | 2 | 0 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | The average time to acquire a row lock, in millise... | |
| buffer_pool_pages_total | buffer | 1003 | 1003 | 1003 | NULL | 1003 | 1003 | 1003 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | Total buffer pool size in pages (innodb_buffer_poo... | |
| purge_resume_count | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Number of times purge was resumed | |
| log_lsn_current | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Current LSN value | |
| log_max_modified_age_sync | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Maximum LSN difference; when exceeded, start synch... | |
| buffer_pool_bytes_data | buffer | 4194304 | 16334848 | 3883008 | NULL | 4194304 | 16334848 | 3883008 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | Buffer bytes containing data (innodb_buffer_pool_b... | |
| log_num_log_io | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Number of log I/Os | |
| purge_stop_count | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Number of times purge was stopped | |
| log_lsn_last_checkpoint | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | LSN at last checkpoint | |
| log_max_modified_age_async | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Maximum LSN difference; when exceeded, start async... | |
| buffer_pool_pages_free | buffer | 732 | 760 | 0 | NULL | 732 | 760 | 0 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | Buffer pages currently free (innodb_buffer_pool_pa... | |
| lock_row_lock_time_max | lock | 25 | 25 | 0 | NULL | 25 | 25 | 0 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | The maximum time to acquire a row lock, in millise... | |
| buffer_pool_pages_data | buffer | 256 | 997 | 237 | NULL | 256 | 997 | 237 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | Buffer pages containing data (innodb_buffer_pool_p... | |
| log_pending_checkpoint_writes | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Pending checkpoints | |
| trx_rseg_history_len | transaction | 2 | 107 | 0 | NULL | 2 | 107 | 0 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | Length of the TRX_RSEG_HISTORY list | |
| purge_dml_delay_usec | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Microseconds DML to be delayed due to purge laggin... | |
| log_lsn_last_flush | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | LSN of Last flush | |
| log_lsn_buf_pool_oldest | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | The oldest modified block LSN in the buffer pool | |
| buffer_pool_bytes_dirty | buffer | 0 | 835584 | 0 | NULL | 0 | 835584 | 0 | NULL | 2026-07-10 15:34:56 | NULL | 114839 | NULL | enabled | value | Buffer bytes currently dirty (innodb_buffer_pool_b... |
| 过滤行: |