[MDEV-25085] Simplify instrumentation for LRU eviction Created: 2021-03-08  Updated: 2021-03-09  Resolved: 2021-03-09

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: 10.6.0

Type: Task Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: monitoring, performance

Issue Links:
Blocks
blocks MDEV-11384 AliSQL: [Feature] Issue#19 BUFFER POO... Closed
Relates
relates to MDEV-25088 Document simplified instrumentation f... Closed

 Description   

Let us add the status variable innodb_buffer_pool_pages_LRU_freed to monitor the number of pages that were freed by a buffer pool LRU eviction scan, without flushing.

Also, let us simplify the information_schema.innodb_metrics interface (which we hope to eventually remove in MDEV-15706) by removing the following:

  • buffer_LRU_batches_flush
  • buffer_LRU_batch_flush_pages
  • buffer_LRU_batches_evict
  • buffer_LRU_batch_evict_pages

and by making the following reflect the status variables:

  • buffer_LRU_batch_flush_total_pages: innodb_buffer_pool_pages_LRU_flushed
  • buffer_LRU_batch_evict_total_pages: innodb_buffer_pool_pages_LRU_freed

Generated at Thu Feb 08 09:35:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.