Die Suche nach "" in der Tabelle "INNODB_METRICS" lieferte folgende Treffer:
Blättern: vor=ALT+V, zurück=ALT+C
Blättern: vor=ALT+V, zurück=ALT+C
| # | 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 | 0 | disabled | counter | Number of table handles opened | ||||||||||
|
|
2. | metadata_table_handles_closed | metadata | 0 | 0 | disabled | counter | Number of table handles closed | ||||||||||
|
|
3. | metadata_table_reference_count | metadata | 0 | 0 | disabled | counter | Table reference counter | ||||||||||
|
|
4. | lock_deadlocks | lock | 0 | 0 | 0 | 2024-06-27 15:12:08 | 290014 | enabled | counter | Number of deadlocks | |||||||
|
|
5. | lock_timeouts | lock | 0 | 0 | 0 | 2024-06-27 15:12:08 | 290014 | enabled | counter | Number of lock timeouts | |||||||
|
|
6. | lock_rec_lock_waits | lock | 0 | 0 | disabled | counter | Number of times enqueued into record lock wait queue | ||||||||||
|
|
7. | lock_table_lock_waits | lock | 0 | 0 | disabled | counter | Number of times enqueued into table lock wait queue | ||||||||||
|
|
8. | lock_rec_lock_requests | lock | 0 | 0 | disabled | counter | Number of record locks requested | ||||||||||
|
|
9. | lock_rec_lock_created | lock | 0 | 0 | disabled | counter | Number of record locks created | ||||||||||
|
|
10. | lock_rec_lock_removed | lock | 0 | 0 | disabled | counter | Number of record locks removed from the lock queue | ||||||||||
|
|
11. | lock_rec_locks | lock | 0 | 0 | disabled | counter | Current number of record locks on tables | ||||||||||
|
|
12. | lock_table_lock_created | lock | 0 | 0 | disabled | counter | Number of table locks created | ||||||||||
|
|
13. | lock_table_lock_removed | lock | 0 | 0 | disabled | counter | Number of table locks removed from the lock queue | ||||||||||
|
|
14. | lock_table_locks | lock | 0 | 0 | disabled | counter | Current number of table locks on tables | ||||||||||
|
|
15. | lock_row_lock_current_waits | lock | 0 | 0 | 0 | 0 | 0 | 2024-06-27 15:12:08 | 290014 | enabled | status_counter | Number of row locks currently being waited for (innodb_row_lock_current_waits) | |||||
|
|
16. | lock_row_lock_time | lock | 0 | 0 | 0 | 0 | 0 | 2024-06-27 15:12:08 | 290014 | 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 | 0 | 0 | 0 | 2024-06-27 15:12:08 | 290014 | 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 | 0 | 0 | 0 | 2024-06-27 15:12:08 | 290014 | 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 | 0 | 0 | 0 | 2024-06-27 15:12:08 | 290014 | 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 | 134217728 | 134217728 | 134217728 | 2024-06-27 15:12:08 | 290014 | enabled | value | Server buffer pool size (all buffer pools) in bytes |