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: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Fix Version/s: 10.1
        • Component/s: None
        • Labels:
          None

          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.

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    jb-boin Jean Weisbuch
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated: