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: | |
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
[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.