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 wrote: > > > 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 > > >
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
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: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: i am running mysqlrepair on 80G myisam table.
Am 04.06.2012 14:35, schrieb Joey L: > i am running mysqlrepair on 80G myisam table. > It is taking forever to repair - i am getting a lot of "Waiting for > table" messeges when i execute "show full processlist" > > 613 | p_040912 | localhost | p_040912| Query | 24 | Waiting > for table | SELECT `oldurl`, `newurl > > Can anyone help for this ? is there anything i can tweak in the my.cnf > file that avoids this issue - it is taking forever !!! no - a repair always locks a table how would you avoid this technically? the whole table is re-created and mysql can not deal with queries at this time additionally MyISAM does ALWAYS full table locks signature.asc Description: OpenPGP digital signature
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
i am running mysqlrepair on 80G myisam table.
i am running mysqlrepair on 80G myisam table. It is taking forever to repair - i am getting a lot of "Waiting for table" messeges when i execute "show full processlist" 613 | p_040912 | localhost | p_040912| Query | 24 | Waiting for table | SELECT `oldurl`, `newurl Can anyone help for this ? is there anything i can tweak in the my.cnf file that avoids this issue - it is taking forever !!! thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql