Hi! On Feb 12, Peter Bryant wrote: > Hi. I'm adding a fulltext index to two fields in a large (2300MB) table. > > The index created the first 200MB or so of data pretty quickly (in a couple > of hours), but progress from there has been very slow. > > After 48 hours the temporary table is only 640MB / 2300MB original table > size.
MySQL 3.23, right ? > I've changed myisam_sort_buffer to 128M in the hopes that that may have > sped things up, but to no avail. It does not apply here. > Does anyone have a) an explanation for why the index creation seems to go > slower and slower the more rows there are or b) any ideas on how to sped up > the index creation. a) Because as btree becomes deeper more time is required to get to the leaf and to maintain it. b) Use MySQL 4.0, increase myisam_sort_buffer (I said "does not apply in 3.23", didn't I ? :). Be sure you have enough disk space for temporary files. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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
