Hi I have a Huge amounts of data imported into mysql. My database has about 1,500,000 rows.each row has a text field with approx 70 words in it!.Size of my .MYD is 1013MB mysql has been starting to make fulltext index on text field since 55 hours ago!!! and now it dose not accomplish this job yet!! Although my HD is not very fast(128Mb & 300MHZ) but this really takes a long time to finish. I've increased size of key_buffer_size and table_cache befor but it still a long time! Dose any body can recommend me any faster solution?
TNX in Advance --M. Hajimoradi --------------------------------------------------------------------- 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
