[Tools]  Datenbank: `information_schema`  Tabelle: `INNODB_METRICS`

         ---               

SELECT * FROM `INNODB_METRICS`

Die Ausführung von SQL-Befehlen kann Daten manipulieren! Der Autor übernimmt keine Haftung bei Datenverlusten.

Daten-Ansicht

Datensatz einfügen    Tabellenstruktur bearbeiten

Tabelle `information_schema`.`INNODB_METRICS`
Datensätze 1 - 30 von insgesamt 250    <<    <    >    >>

Ansicht: kompakt   Die Abfrage enthält 17 Spalten
	#	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
	1.	metadata_table_handles_opened	metadata	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of table handles opened
	2.	metadata_table_handles_closed	metadata	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of table handles closed
	3.	metadata_table_reference_count	metadata	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Table reference counter
	4.	lock_deadlocks	lock	0	NULL	NULL	0	0	NULL	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	counter	Number of deadlocks
	5.	lock_timeouts	lock	0	NULL	NULL	0	0	NULL	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	counter	Number of lock timeouts
	6.	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 queue
	7.	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 queue
	8.	lock_rec_lock_requests	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of record locks requested
	9.	lock_rec_lock_created	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of record locks created
	10.	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
	11.	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
	12.	lock_table_lock_created	lock	0	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	disabled	counter	Number of table locks created
	13.	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
	14.	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
	15.	lock_row_lock_current_waits	lock	0	0	NULL	0	0	0	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	status_counter	Number of row locks currently being waited for (innodb_row_lock_current_waits)
	16.	lock_row_lock_time	lock	0	0	NULL	0	0	0	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	status_counter	Time spent in acquiring row locks, in milliseconds (innodb_row_lock_time)
	17.	lock_row_lock_time_max	lock	0	0	0	NULL	0	0	0	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	value	The maximum time to acquire a row lock, in milliseconds (innodb_row_lock_time_max)
	18.	lock_row_lock_waits	lock	0	0	NULL	0	0	0	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	status_counter	Number of times a row lock had to be waited for (innodb_row_lock_waits)
	19.	lock_row_lock_time_avg	lock	0	0	0	NULL	0	0	0	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	value	The average time to acquire a row lock, in milliseconds (innodb_row_lock_time_avg)
	20.	buffer_pool_size	server	134217728	134217728	134217728	NULL	134217728	134217728	134217728	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	value	Server buffer pool size (all buffer pools) in bytes
	21.	buffer_pool_reads	buffer	9868139	9868139	NULL	30.55983983252403	9868139	9868139	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	status_counter	Number of reads directly from disk (innodb_buffer_pool_reads)
	22.	buffer_pool_read_requests	buffer	3334654582	3334654582	NULL	10326.821493162224	3334654582	3334654582	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	status_counter	Number of logical read requests (innodb_buffer_pool_read_requests)
	23.	buffer_pool_write_requests	buffer	5022945	5022945	NULL	15.555151248637399	5022945	5022945	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	status_counter	Number of write requests (innodb_buffer_pool_write_requests)
	24.	buffer_pool_wait_free	buffer	99	99	NULL	0.0003065850758101278	99	99	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	status_counter	Number of times waited for free buffer (innodb_buffer_pool_wait_free)
	25.	buffer_pool_read_ahead	buffer	414408	414408	NULL	1.2833465464275096	414408	414408	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	status_counter	Number of pages read as read ahead (innodb_buffer_pool_read_ahead)
	26.	buffer_pool_read_ahead_evicted	buffer	26379	26379	NULL	0.08169098701813497	26379	26379	NULL	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	status_counter	Read-ahead pages evicted without being accessed (innodb_buffer_pool_read_ahead_evicted)
	27.	buffer_pool_pages_total	buffer	8191	8191	8191	NULL	8191	8191	8191	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	value	Total buffer pool size in pages (innodb_buffer_pool_pages_total)
	28.	buffer_pool_pages_misc	buffer	21	137	1	NULL	21	137	1	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	value	Buffer pages for misc use such as row locks or the adaptive hash index (innodb_buffer_pool_pages_misc)
	29.	buffer_pool_pages_data	buffer	7146	8190	7030	NULL	7146	8190	7030	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	value	Buffer pages containing data (innodb_buffer_pool_pages_data)
	30.	buffer_pool_bytes_data	buffer	117080064	134184960	115179520	NULL	117080064	134184960	115179520	NULL	2025-10-31 06:43:32	NULL	322912	NULL	enabled	value	Buffer bytes containing data (innodb_buffer_pool_bytes_data)