Hi! On Jan 21, Steve Rapaport wrote: > Okay, does anyone know how long this will take? > 22 million records, fulltext index on a single field, first 40 chars. > record length 768 chars, variable. > > It's been running for 2 days, processlist quotes time at around 100000. > Index file still growing occasionally, up to 3Gb. > > Should I let it continue or give up? Will this take another 2 days? > another week? Anyone else with experience to get a rule of thumb? > > I'm using mysql 3.23.37 on a dual processor intel Redhat, 700Mhz, 1G ram.
on your hardware it should index about 15Kb/sec. I'd recommend you to install MySQL-4.0.1, index your tables, and copy them back to 3.23.37 (if you prefer to use 3.23 branch). MySQL 4.0.x should create fulltext index with up to 1Mb/sec (benchmarks are hardware dependent, of course). 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
