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

Introduce status variables for table cache monitoring and tuning

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Fix Version/s: 10.3.3
    • Component/s: Locking
    • Labels:
      None
    • Sprint:
      10.3.3-1

      Description

      1. Since MariaDB's definition and use of table_open_cache_instances is different from MySQL's, it naturally calls for a status variable which would indicate how many instances are in use at the moment. MySQL does not have it, but it's not needed there, because there table_open_cache_instances shows exactly that.

      2. MySQL 5.6/5.7 has status variables Table_open_cache_hits, Table_open_cache_misses, Table_open_cache_overflows. Even though MariaDB's table cache tuning is more automated than MySQL's, the variables can still be useful in MariaDB too.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                svoj Sergey Vojtovich
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: