Re: MySQL thread hanging on Win2K

[Chris Withers <chrisw@xxxxxxxxxx>]

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 <mysql-thread92834@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php