maria-developers team mailing list archive

Thread
Date

The variable "table_definition_cache" is autosized by default on MySQL 5.6.8+ but not on MariaDB 10

To: maria-developers@xxxxxxxxxxxxxxxxxxx
From: Jean Weisbuch <jean@xxxxxxxxxx>
Date: Thu, 20 Nov 2014 21:52:10 +0100
Eximsenderaddress: jean@xxxxxxxxxx
Scriptpath: jean@xxxxxxxxxx
User-agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.2.0

The value of the variable "table_definition_cache" is by defaultautosized (based on the table_open_cache value) on MySQL >=5.6.8 whileit is still static (400) on the latest MariaDB 10.0.14 and 10.1.?, isthat by choice or this feature hasn't been backported and should be?

From the MySQL dochttp://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.