[MDEV-7261] Backport the default autosized value of "table_definition_cache" from MySQL 5.6.8+ Created: 2014-12-04  Updated: 2020-11-17

Status: Stalled
Project: MariaDB Server
Component/s: None
Fix Version/s: 10.2

Type: Task Priority: Minor
Reporter: Jean Weisbuch Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 1
Labels: None

Issue Links:
PartOf
is part of MDEV-7635 update defaults and simplify mysqld c... Closed
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.



 Comments   
Comment by Sergey Vojtovich [ 2015-11-20 ]

serg, please review fix for this bug.

Comment by Sergey Vojtovich [ 2015-12-28 ]

Questions sent to maria-developers@

Generated at Thu Feb 08 07:18:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.