Hi again, Sinisa... Chris Withers wrote: > > Okay, table_cache increased from 64 to 256... > > > * check free disk space on all drives
Well, it got up to indexing 10,000 documents this time but then hung again. Now, I don't know if this is because increasing the table_cache made a difference or because it was just lucky and got further this time. Looking at 'mysqladmin processlist', it has hung on 'Opening table' again, if that helps... I'm gonna try table_cache at 1024 to see if that is the cause. If it is, what could I be doign that needs this number to be so high? Of course, it also brings my following questions back into play: > > * starting / stopping MySQL as a service only > > Well, I run MySQL in a DOS box not as a service. Would running it as as service > help? If so, why? Hope you can help... cheers, Chris --------------------------------------------------------------------- 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