Bug #66893 Minimum value for table-open-cache
Submitted: 20 Sep 2012 14:34 Modified: 20 Sep 2012 17:11
Reporter: Emilie B Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.5+ OS:Windows
Assigned to: CPU Architecture:Any

[20 Sep 2012 14:34] Emilie B
Description:
For table-open-cache in the documentation (http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_table_open_cach...) we can see that the range is "400 .. 524288"

But if in my.ini I add a lower value (ie 64), then I restart my MySQL Server and do a "show variables like 'table_open_cache';"
I can see my new value (64). I was expecting to see the value 400.

So what is the Wrong ? The documentation or the "show variables" ?
What is the minimal value in MySQL 5.6 ? 64 like in MySQL 5.1 or 400 like the documentation said ?

How to repeat:
Add table-open-cache=64 in your my.ini
Restart your server
Type "show variables like 'table_open_cache'"

Suggested fix:
Change the documenation or the result of a "show variables"
[20 Sep 2012 17:11] MySQL Verification Team
Thank you for the bug report.

d:\dbs>d:\dbs\5.5\bin\mysql -uroot --port=3541 --prompt="mysql 5.5 >"
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.29 Source distribution

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.5 >-- first testing another variable with similar default and range values
mysql 5.5 >show variables like "table_definition_cache";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| table_definition_cache | 400   |
+------------------------+-------+
1 row in set (0.00 sec)

mysql 5.5 >set global table_definition_cache=64;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql 5.5 >show warnings;
+---------+------+--------------------------------------------------------+
| Level   | Code | Message                                                |
+---------+------+--------------------------------------------------------+
| Warning | 1292 | Truncated incorrect table_definition_cache value: '64' |
+---------+------+--------------------------------------------------------+
1 row in set (0.00 sec)

mysql 5.5 >show variables like "table_definition_cache";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| table_definition_cache | 400   |
+------------------------+-------+
1 row in set (0.00 sec)

mysql 5.5 >show variables like "table_open_cache";
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| table_open_cache | 64    |
+------------------+-------+
1 row in set (0.00 sec)

mysql 5.5 >exit
Bye

d:\dbs>type my.ini | findstr table-open-cache
table-open-cache=64

d:\dbs>
[31 Jan 2013 11:12] Erlend Dahl
The problem seems to be there on 5.5 too.