Re: table cache value error in my.cnf file

2012-06-04 Thread Andrew Moore
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 wrote: > > > Am 04.06.2012 14:45, schrieb Joey L: > > Can you explain this further ? > > Sorry a

Re: table cache value error in my.cnf file

2012-06-04 Thread Reindl Harald
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

2012-06-04 Thread Joey L
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

2012-06-04 Thread Reindl Harald
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