table cache value error in my.cnf file
i am getting this wierd error in the mysql log: 120604 8:31:32 [Warning] option 'table_cache': unsigned value 536870912 adjusted to 524288 I have 28G of ram in my server, can anyone tell me what this value should be set to ? what is the syntax - i have tried different syntax -- get the same error. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: table cache value error in my.cnf file
Am 04.06.2012 14:39, schrieb Joey L: i am getting this wierd error in the mysql log: 120604 8:31:32 [Warning] option 'table_cache': unsigned value 536870912 adjusted to 524288 I have 28G of ram in my server, can anyone tell me what this value should be set to ? what is the syntax - i have tried different syntax -- get the same error table count * expected connections signature.asc Description: OpenPGP digital signature
Re: table cache value error in my.cnf file
Can you explain this further ? Sorry a little slow ? table count * expected connections -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: table cache value error in my.cnf file
Am 04.06.2012 14:45, schrieb Joey L: Can you explain this further ? Sorry a little slow ? table count * expected connections http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_table_cache signature.asc Description: OpenPGP digital signature
Re: table cache value error in my.cnf file
Joey, you've over allocated the cache. MySQL is telling you that it has corrected the allocation. Check out the docs for the meaning behind the numbers. On Mon, Jun 4, 2012 at 2:01 PM, Reindl Harald h.rei...@thelounge.netwrote: Am 04.06.2012 14:45, schrieb Joey L: Can you explain this further ? Sorry a little slow ? table count * expected connections http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_table_cache