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

QUERY CACHE - Reaping Thread

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None

    Description

      Created a thread that monitors and cleans up the Query Cache. When an update/insert is made to a table, all queries from that table could be simply marked as invalid and later, the reaper thread could come in to actually return the invalid blocks to the memory system. Same thing with inserting into a full query cache, instead of immediately removing the oldest row, track the N number of oldest rows, just mark the rows as invalid, and have the query not be cached at that point At some point in the future, the oldest ones will be removed by the reaper along with any additional invalid queries and caching will work as normal from there.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              belugabehr BELUGABEHR
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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