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

Backport the default autosized value of "table_definition_cache" from MySQL 5.6.8+

    Details

    • Type: Task
    • Status: Stalled (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: 10.2
    • Component/s: None
    • Labels:
      None
    • Sprint:
      10.2.0-6, 10.2.0-7, 10.2.0-8

      Description

      The value of the variable "table_definition_cache" is by default autosized (based on the table_open_cache value) on MySQL >=5.6.8 while it is still static (400) on the latest MariaDB 10.0.15 and in 10.1.*.

      From the MySQL doc (http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_table_definition_cache) :

          Permitted Values (>= 5.6.8)
          Type 	numeric
          Default 	-1 (autosized)
          Min Value 	400
          Max Value 	524288
       
          The default value is based on the following formula, capped to a limit of 2000:
          400 + (table_open_cache / 2)
       
          Before MySQL 5.6.8, the default is 400.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                svoj Sergey Vojtovich
                Reporter:
                jb-boin Jean Weisbuch
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: