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.
--
\\|//
(@ @)
-------oOO---(_)---OOo------------
| |
| Mike Baranski |
| Security Managment Consulting |
| http://www.secmgmt.com |
| |
| |
----------------------------------
|__|__|
|| ||
ooO Ooo
--
---------------------------------------------------------------------
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
