Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25085

Simplify instrumentation for LRU eviction

Details

    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

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-11384 AliSQL: [Feature] Issue#19 BUFFER POOL LIST SCAN OPTIMIZATION

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-25088 Document simplified instrumentation for LRU eviction

          • Major - Major loss of function.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.