Making fulltext is very slow!!
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 or have tha same experiance? 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
Making fulltext is very slow
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 or have tha same experiance? 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
Making fulltext index is very slow!!
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
