[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	2024-05-18 09:52:58	NULL	109938	NULL	enabled	counter	Number of deadlocks
	5.	lock_timeouts	lock	0	NULL	NULL	0	0	NULL	NULL	NULL	2024-05-18 09:52:58	NULL	109938	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	2024-05-18 09:52:58	NULL	109938	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	2024-05-18 09:52:58	NULL	109938	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	2024-05-18 09:52:58	NULL	109938	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	2024-05-18 09:52:58	NULL	109938	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	2024-05-18 09:52:58	NULL	109938	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	2024-05-18 09:52:58	NULL	109938	NULL	enabled	value	Server buffer pool size (all buffer pools) in bytes
	21.	buffer_pool_reads	buffer	3680360	3680360	NULL	33.47668685986647	3680360	3680360	NULL	NULL	2024-05-18 09:52:58	NULL	109938	NULL	enabled	status_counter	Number of reads directly from disk (innodb_buffer_pool_reads)
	22.	buffer_pool_read_requests	buffer	1134436245	1134436245	NULL	10318.872864705561	1134436245	1134436245	NULL	NULL	2024-05-18 09:52:58	NULL	109938	NULL	enabled	status_counter	Number of logical read requests (innodb_buffer_pool_read_requests)
	23.	buffer_pool_write_requests	buffer	3814664	3814664	NULL	34.69832087176408	3814664	3814664	NULL	NULL	2024-05-18 09:52:58	NULL	109938	NULL	enabled	status_counter	Number of write requests (innodb_buffer_pool_write_requests)
	24.	buffer_pool_wait_free	buffer	0	0	NULL	0	0	0	NULL	NULL	2024-05-18 09:52:58	NULL	109938	NULL	enabled	status_counter	Number of times waited for free buffer (innodb_buffer_pool_wait_free)
	25.	buffer_pool_read_ahead	buffer	130432	130432	NULL	1.186414160708763	130432	130432	NULL	NULL	2024-05-18 09:52:58	NULL	109938	NULL	enabled	status_counter	Number of pages read as read ahead (innodb_buffer_pool_read_ahead)
	26.	buffer_pool_read_ahead_evicted	buffer	12363	12363	NULL	0.11245429241936364	12363	12363	NULL	NULL	2024-05-18 09:52:58	NULL	109938	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	2024-05-18 09:52:58	NULL	109938	NULL	enabled	value	Total buffer pool size in pages (innodb_buffer_pool_pages_total)
	28.	buffer_pool_pages_misc	buffer	87	188	87	NULL	87	188	87	NULL	2024-05-18 09:52:58	NULL	109938	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	7081	7081	7004	NULL	7081	7081	7004	NULL	2024-05-18 09:52:58	NULL	109938	NULL	enabled	value	Buffer pages containing data (innodb_buffer_pool_pages_data)
	30.	buffer_pool_bytes_data	buffer	116015104	116015104	114753536	NULL	116015104	116015104	114753536	NULL	2024-05-18 09:52:58	NULL	109938	NULL	enabled	value	Buffer bytes containing data (innodb_buffer_pool_bytes_data)