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

Query Cache Partitioning

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Make QC partition, i.e. many QC to avoid bottleneck of mutexes in it.

      Query should be divided by QCs without parsing (QC answer should be given without parsing the query)

      1) Divide query by its text hash + flags value.
      + even distribution
      + fully automatic and 0 management
      – duplicating queries
      – no ability to manage QCs by task

      2) Divide queries by current DB and other flags (client text attributes for example (new feature of MySQL 5.6 and MariaDB 10.*)
      + more precise management by task
      + less duplication in the caches
      – more complex setup

      QC can be changed to plugin intrface and we can plug old (for small installations) and petitioned (for advanced).

      General problem:

      • Current engine interface suppose that there is only one QC and we can't avoid storing the same tables/queries in different QC's

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              sanja Oleksandr Byelkin
              Votes:
              4 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration