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

Query cache invalidation and lock tables with write lock

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • N/A
    • Query Cache
    • None

    Description

      Hi guys, i think we have a problem with lock tables write lock and query cache
      when we execute a LOCK TABLE xxx WRITE, shouldn't the query cache for that table be avoid? cause i can execute select with that table and get results even i have lock table with write lock

      in other words, what i'm thinking about:
      1) lock table with write should invalidate query cache table
      2) locked tables should be checked before returning query cache data to client (for example, if we got the query from cache, check if we have a locked table with LOCK TABLE command, if yes, don't fetch from query cache)

      this happen with any engine (including innodb but not common)

      Attachments

        Activity

          People

            Unassigned Unassigned
            rspadim roberto spadim
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.