Hi Sinisa, Sinisa Milivojevic wrote: > > There are several possibilities. You could be reaching some OS limits > or haning user / group permission problems.
Don't think its permissions, since I had a similar process which ran fine, but I had to change the schema to use the last insert id for other reasons and that's when the problems started... > * 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? > * increase table_cache by a factor of 4 Okay, table_cache increased from 64 to 256... > * check free disk space on all drives Minimum free on a drive it 400Mb, the drive which the MySQL data dir his on has close to 4GB free... I'm trying again with the new table_cache setting, I'll let you know how I get on... 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
