Server: mysql wampserver »Database: information_schema »Table: INNODB_METRICS
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
Showing rows 0 - 24 (214 total, Query took 0.0010 sec)
SELECT * FROM `INNODB_METRICS`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]


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 COMMENT
metadata_table_handles_opened metadata 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Number of table handles opened
metadata_table_handles_closed metadata 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Number of table handles closed
metadata_table_reference_count metadata 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Table reference counter
metadata_mem_pool_size metadata 8388608 8388608 8388608 NULL8388608 8388608 8388608 NULL2024-10-30 06:50:18 NULL109263 NULLenabled value Size of a memory pool InnoDB uses to store data di...
lock_deadlocks lock 0 NULLNULL0 0 NULLNULLNULL2024-10-30 06:50:18 NULL109263 NULLenabled counter Number of deadlocks
lock_timeouts lock 0 NULLNULL0 0 NULLNULLNULL2024-10-30 06:50:18 NULL109263 NULLenabled counter Number of lock timeouts
lock_rec_lock_waits lock 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Number of times enqueued into record lock wait que...
lock_table_lock_waits lock 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Number of times enqueued into table lock wait queu...
lock_rec_lock_requests lock 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Number of record locks requested
lock_rec_lock_created lock 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Number of record locks created
lock_rec_lock_removed lock 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Number of record locks removed from the lock queue
lock_rec_locks lock 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Current number of record locks on tables
lock_table_lock_created lock 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Number of table locks created
lock_table_lock_removed lock 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Number of table locks removed from the lock queue
lock_table_locks lock 0 NULLNULLNULL0 NULLNULLNULLNULLNULLNULLNULLdisabled counter Current number of table locks on tables
lock_row_lock_current_waits lock 0 0 NULL0 0 0 NULLNULL2024-10-30 06:50:18 NULL109263 NULLenabled status_counter Number of row locks currently being waited for (in...
lock_row_lock_time lock 0 0 NULL0 0 0 NULLNULL2024-10-30 06:50:18 NULL109263 NULLenabled status_counter Time spent in acquiring row locks, in milliseconds...
lock_row_lock_time_max lock 0 0 0 NULL0 0 0 NULL2024-10-30 06:50:18 NULL109263 NULLenabled value The maximum time to acquire a row lock, in millise...
lock_row_lock_waits lock 0 0 NULL0 0 0 NULLNULL2024-10-30 06:50:18 NULL109263 NULLenabled status_counter Number of times a row lock had to be waited for (i...
lock_row_lock_time_avg lock 0 0 0 NULL0 0 0 NULL2024-10-30 06:50:18 NULL109263 NULLenabled value The average time to acquire a row lock, in millise...
buffer_pool_size server 134217728 134217728 134217728 NULL134217728 134217728 134217728 NULL2024-10-30 06:50:18 NULL109263 NULLenabled value Server buffer pool size (all buffer pools) in byte...
buffer_pool_reads buffer 356 356 NULL0.0032581935330349707 356 356 NULLNULL2024-10-30 06:50:18 NULL109263 NULLenabled status_counter Number of reads directly from disk (innodb_buffer_...
buffer_pool_read_requests buffer 1483644 1483644 NULL13.578649680129596 1483644 1483644 NULLNULL2024-10-30 06:50:18 NULL109263 NULLenabled status_counter Number of logical read requests (innodb_buffer_poo...
buffer_pool_write_requests buffer 28 28 NULL0.0002562624127106157 28 28 NULLNULL2024-10-30 06:50:18 NULL109263 NULLenabled status_counter Number of write requests (innodb_buffer_pool_write...
buffer_pool_wait_free buffer 0 0 NULL0 0 0 NULLNULL2024-10-30 06:50:18 NULL109263 NULLenabled status_counter Number of times waited for free buffer (innodb_buf...

Query results operations Print view Print view Print view (with full texts) Print view (with full texts) Export Export Display chart Display chart Create view Create view