SQL-Browser

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

   show less  show more             SQL-Datei hochladen   Suche   MySQL Dokumentation
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
  editieren löschen1. 
metadata_table_handles_opened
metadata
0
NULL
NULL
NULL
0
NULL
NULL
NULL
NULL
NULL
NULL
NULL
disabled
counter
Number of table handles opened
  editieren löschen2. 
metadata_table_handles_closed
metadata
0
NULL
NULL
NULL
0
NULL
NULL
NULL
NULL
NULL
NULL
NULL
disabled
counter
Number of table handles closed
  editieren löschen3. 
metadata_table_reference_count
metadata
0
NULL
NULL
NULL
0
NULL
NULL
NULL
NULL
NULL
NULL
NULL
disabled
counter
Table reference counter
  editieren löschen4. 
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
  editieren löschen5. 
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
  editieren löschen6. 
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
  editieren löschen7. 
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
  editieren löschen8. 
lock_rec_lock_requests
lock
0
NULL
NULL
NULL
0
NULL
NULL
NULL
NULL
NULL
NULL
NULL
disabled
counter
Number of record locks requested
  editieren löschen9. 
lock_rec_lock_created
lock
0
NULL
NULL
NULL
0
NULL
NULL
NULL
NULL
NULL
NULL
NULL
disabled
counter
Number of record locks created
  editieren löschen10. 
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
  editieren löschen11. 
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
  editieren löschen12. 
lock_table_lock_created
lock
0
NULL
NULL
NULL
0
NULL
NULL
NULL
NULL
NULL
NULL
NULL
disabled
counter
Number of table locks created
  editieren löschen13. 
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
  editieren löschen14. 
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
  editieren löschen15. 
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)
  editieren löschen16. 
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)
  editieren löschen17. 
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)
  editieren löschen18. 
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)
  editieren löschen19. 
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)
  editieren löschen20. 
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
  editieren löschen21. 
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)
  editieren löschen22. 
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)
  editieren löschen23. 
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)
  editieren löschen24. 
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)
  editieren löschen25. 
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)
  editieren löschen26. 
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)
  editieren löschen27. 
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)
  editieren löschen28. 
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)
  editieren löschen29. 
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)
  editieren löschen30. 
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)

Datensätze 1 - 30 von insgesamt 250    <<    <    >    >>