http://marc.theaimsgroup.com/?l=mysql&m=99257445520048&w=2 may help
> OK, another one here...
>
> On the very large table (at least 5 million rows) I need to index
> several columns. The mysqladmin -i60 processlist
>
> lists the state of the query as
>
> Repair with keycache
>
> for a very long time. I imagne it's sorting the indexes somehow.
> My question is what variable will speed this process up? I can
> allocate some more memory for this type of thing, I just need to
> know where...
>
> Thanks
> Mike B.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
