Looks like I've found the problem.
The table_cache was actually too high.
By reducing it to 200, I've stopped the problem.
Seems Win2K doesn't actually have that many file handle to give out after
Thanks for your help.
----- Original Message -----
From: "Leigh Sharpe" <lsharpe@stripped>
To: "Armando" <dijital@stripped>; "'MySQL Win32 List'"
Sent: Wednesday, August 11, 2004 9:37 AM
Subject: Re: Out of resources error
> Still struggling here, I'm afraid.
> * Set open_files_limit to 10000. Mysqld refused to start altogether.
> *Removed setting and increased table_cache to 1200 and re-started mysqld.
> difference. I have about 520 or so tables which are being accessed
> continuously, simultaneously. According to 'show variables', the
> is 1200, but I run into problems whenever the I reach 512 open tables.
> Any ideas?
> ----- Original Message -----
> From: "Armando" <dijital@stripped>
> To: "'MySQL Win32 List'" <win32@stripped>
> Sent: Saturday, August 07, 2004 8:02 AM
> Subject: RE: Out of resources error
> > Win2k Server I believe has a maximum of 16384. I can't recall off the
> > top of my head if 2K Pro is the same. I would probably start by doubling
> > your table-cache to see what that does for you. That will give you a
> > good increase to 2148 file descriptors, and yet still leave a fair
> > amount for Windows. As for how much is too much? Depends on what else
> > your server is running. If it's strictly for the database, then you can
> > increase the value a lot as there will be little else running that will
> > require them. Cheers.
> > Armando
> > -----Original Message-----
> > From: Leigh Sharpe [mailto:lsharpe@stripped]
> > Sent: August 5, 2004 11:40 PM
> > To: Armando; 'MySQL Win32 List'
> > Subject: Re: Out of resources error
> > Any idea what the maximum number of file descriptors is for Win2K? My
> > table_cache is currently 512 and max_connections is 100. according to
> > your formula, that gives a value of 1124 for file descriptors. If I
> > increase this too far, am I going to strike trouble with Windows not
> > having enough file descriptors to give to MySQL? And how much is too
> > much?
> > ----- Original Message -----
> > From: "Armando" <dijital@stripped>
> > To: "'MySQL Win32 List'" <win32@stripped>
> > Sent: Friday, August 06, 2004 1:47 PM
> > Subject: RE: Out of resources error
> > > Hi Leigh,
> > >
> > > As you have probably already figured out, the error means there are
> > > "Too many open files" which I agree is somewhat terse and not very
> > > descriptive - it basically means that too many file descriptors are
> > > being used by the mysql daemon than are actually avaialble to it. HDD
> > > and RAM space are not the issue. The first thing I would try is
> > > increasing your open_files_limit system variable to allow the mysql
> > > daemon to use more file descriptors. I believe by default the value is
> > > 0 which means MySQL will allocate a value equivalent to
> > > max_connections+5 or max_connections+table_cache*2, whichever is
> > > larger. Try setting a larger static value to see if the error
> > > persists. Cheers.
> > >
> > > Armando
> > >
> > > -----Original Message-----
> > > From: Leigh Sharpe [mailto:lsharpe@stripped]
> > > Sent: August 4, 2004 6:01 PM
> > > To: Armando; 'MySQL Win32 List'
> > > Subject: Re: Out of resources error
> > >
> > >
> > > Temporary tables vary from about 10 rows to a max of 500000. Typically
> > > around the 100-500 mark. Running version 4.0.15 on Win2K. The machine
> > > has 1GB of RAM, of which about half is free. There's about 1.5GB of
> > > space on the temp drive to play with, and over 50GB of space on the
> > > drive the database is stored on. I have noticed that regularly issuing
> > > a 'flush tables' command stops the problem, but I'm not sure if this
> > > is a satisfactory solution.
> > >
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: