[Tools]
Datenbank:
`fhem`
Tabelle: `INNODB_METRICS`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `fhem`.`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-15 11:13:04 | NULL | 52375 | NULL | enabled | counter | Number of deadlocks |
|
| 5. | lock_timeouts | lock | 0 | NULL | NULL | 0 | 0 | NULL | NULL | NULL | 2024-05-15 11:13:04 | NULL | 52375 | 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-15 11:13:04 | NULL | 52375 | 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-15 11:13:04 | NULL | 52375 | 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-15 11:13:04 | NULL | 52375 | 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-15 11:13:04 | NULL | 52375 | 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-15 11:13:04 | NULL | 52375 | 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-15 11:13:04 | NULL | 52375 | NULL | enabled | value | Server buffer pool size (all buffer pools) in bytes |
|
| 21. | buffer_pool_reads | buffer | 1024840 | 1024840 | NULL | 19.567350835322195 | 1024840 | 1024840 | NULL | NULL | 2024-05-15 11:13:04 | NULL | 52375 | NULL | enabled | status_counter | Number of reads directly from disk (innodb_buffer_pool_reads) |
|
| 22. | buffer_pool_read_requests | buffer | 325093811 | 325093811 | NULL | 6207.041737470167 | 325093811 | 325093811 | NULL | NULL | 2024-05-15 11:13:04 | NULL | 52375 | NULL | enabled | status_counter | Number of logical read requests (innodb_buffer_pool_read_requests) |
|
| 23. | buffer_pool_write_requests | buffer | 1031573 | 1031573 | NULL | 19.695904534606207 | 1031573 | 1031573 | NULL | NULL | 2024-05-15 11:13:04 | NULL | 52375 | 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-15 11:13:04 | NULL | 52375 | NULL | enabled | status_counter | Number of times waited for free buffer (innodb_buffer_pool_wait_free) |
|
| 25. | buffer_pool_read_ahead | buffer | 22853 | 22853 | NULL | 0.4363341288782816 | 22853 | 22853 | NULL | NULL | 2024-05-15 11:13:04 | NULL | 52375 | NULL | enabled | status_counter | Number of pages read as read ahead (innodb_buffer_pool_read_ahead) |
|
| 26. | buffer_pool_read_ahead_evicted | buffer | 993 | 993 | NULL | 0.01895942720763723 | 993 | 993 | NULL | NULL | 2024-05-15 11:13:04 | NULL | 52375 | 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-15 11:13:04 | NULL | 52375 | NULL | enabled | value | Total buffer pool size in pages (innodb_buffer_pool_pages_total) |
|
| 28. | buffer_pool_pages_misc | buffer | 159 | 159 | 134 | NULL | 159 | 159 | 134 | NULL | 2024-05-15 11:13:04 | NULL | 52375 | 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 | 7008 | 7058 | 7008 | NULL | 7008 | 7058 | 7008 | NULL | 2024-05-15 11:13:04 | NULL | 52375 | NULL | enabled | value | Buffer pages containing data (innodb_buffer_pool_pages_data) |
|
| 30. | buffer_pool_bytes_data | buffer | 114819072 | 115638272 | 114819072 | NULL | 114819072 | 115638272 | 114819072 | NULL | 2024-05-15 11:13:04 | NULL | 52375 | NULL | enabled | value | Buffer bytes containing data (innodb_buffer_pool_bytes_data) |
Datensätze 1 - 30 von insgesamt 250 << < > >>