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. No
difference. I have about 520 or so tables which are being accessed
continuously, simultaneously. According to 'show variables', the table_cache
is 1200, but I run into problems whenever the I reach 512 open tables.
----- 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.
> -----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
> ----- 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.