148.216.95.41 / mysql wampserver / information_schema / 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.0014 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	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of table handles opened
metadata_table_handles_closed	metadata	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of table handles closed
metadata_table_reference_count	metadata	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Table reference counter
metadata_mem_pool_size	metadata	8388608	8388608	8388608	NULL	8388608	8388608	8388608	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	value	Size of a memory pool InnoDB uses to store data di...
lock_deadlocks	lock	0	NULL	NULL	0	0	NULL	NULL	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	counter	Number of deadlocks
lock_timeouts	lock	0	NULL	NULL	0	0	NULL	NULL	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	counter	Number of lock timeouts
lock_rec_lock_waits	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of times enqueued into record lock wait que...
lock_table_lock_waits	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of times enqueued into table lock wait queu...
lock_rec_lock_requests	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of record locks requested
lock_rec_lock_created	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of record locks created
lock_rec_lock_removed	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of record locks removed from the lock queue
lock_rec_locks	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Current number of record locks on tables
lock_table_lock_created	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of table locks created
lock_table_lock_removed	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of table locks removed from the lock queue
lock_table_locks	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Current number of table locks on tables
lock_row_lock_current_waits	lock	0	0	NULL	0	0	0	NULL	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	status_counter	Number of row locks currently being waited for (in...
lock_row_lock_time	lock	0	0	NULL	0	0	0	NULL	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	status_counter	Time spent in acquiring row locks, in milliseconds...
lock_row_lock_time_max	lock	0	0	0	NULL	0	0	0	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	value	The maximum time to acquire a row lock, in millise...
lock_row_lock_waits	lock	0	0	NULL	0	0	0	NULL	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	status_counter	Number of times a row lock had to be waited for (i...
lock_row_lock_time_avg	lock	0	0	0	NULL	0	0	0	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	value	The average time to acquire a row lock, in millise...
buffer_pool_size	server	134217728	134217728	134217728	NULL	134217728	134217728	134217728	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	value	Server buffer pool size (all buffer pools) in byte...
buffer_pool_reads	buffer	355	355	NULL	0.00021286087413266688	355	355	NULL	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	status_counter	Number of reads directly from disk (innodb_buffer_...
buffer_pool_read_requests	buffer	541644	541644	NULL	0.32477412763018093	541644	541644	NULL	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	status_counter	Number of logical read requests (innodb_buffer_poo...
buffer_pool_write_requests	buffer	204	204	NULL	0.00012232005161426493	204	204	NULL	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	status_counter	Number of write requests (innodb_buffer_pool_write...
buffer_pool_wait_free	buffer	0	0	NULL	0	0	0	NULL	NULL	2024-06-12 00:33:17	NULL	1667756	NULL	enabled	status_counter	Number of times waited for free buffer (innodb_buf...

Query results operations

Print view

Print view (with full texts)

Export

Display chart

Create view