Hi, I'm running MySQLd-NT on an Athlon 1.33GHz w/512MB RAM, under Win2000. I'm doing a fulltext index on a varchar(255) column in one of my tables. Admittedly, the table has ~77million rows, but the indexing has been going for almost a *week* now. What can I do to optimize MySQL for fulltext indexing (amongst other things)? The only adjustment I've made is setting the key_buffer to 64MB; on my other machine I've sinced made the following changes to my.ini: set-variable=key_buffer=128M set-variable=table_cache=512 set-variable=sort_buffer=8M set-variable=record_buffer=2M It still doesn't seem too spritely though. My CPU utilization is under 10% for the most part; how would I go about increasing this? The SQL server only has 4 tables, and only 1 or 2 concurrent processes at any given time. This is taking a stupid amount of time. What am I doing wrong? Cheers, -robin --------------------------------------------------------------------- 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
