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
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
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 tab
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
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
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
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
