11 messages in com.mysql.lists.win32RE: Out of resources error - RESOLVED
FromSent OnAttachments
Leigh Sharpe03 Aug 2004 17:19 
Armando04 Aug 2004 14:24 
Leigh Sharpe04 Aug 2004 16:00 
Friedhelm Betz04 Aug 2004 16:47 
Armando05 Aug 2004 20:47 
Leigh Sharpe05 Aug 2004 21:40 
Armando06 Aug 2004 15:02 
Leigh Sharpe10 Aug 2004 16:37 
Leigh Sharpe11 Aug 2004 16:18 
Armando11 Aug 2004 21:31 
Leigh Sharpe11 Aug 2004 22:09 
Subject:RE: Out of resources error - RESOLVED
From:Armando (diji@shaw.ca)
Date:08/11/2004 09:31:54 PM
List:com.mysql.lists.win32

Hi Leigh,

I'm glad you were able to get it resolved before I got a chance to reply. I've actually never encountered someone who had to reduce the table cache before, so that's pretty weird. If you don't mind me asking, is this 2K Pro or 2K Server and what other type of applications is it running simultaneously with MySQL? I'd love to tuck that information away for future reference! Cheers.

Armando

-----Original Message----- From: Leigh Sharpe [mailto:lsha@pacificwireless.com.au] Sent: August 11, 2004 6:19 PM To: Armando; 'MySQL Win32 List' Subject: Re: Out of resources error - RESOLVED

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 all. Thanks for your help.

----- Original Message ----- From: "Leigh Sharpe" <lsha@pacificwireless.com.au> To: "Armando" <diji@shaw.ca>; "'MySQL Win32 List'" <win@lists.mysql.com> 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. 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.

Any ideas?

----- Original Message ----- From: "Armando" <diji@shaw.ca> To: "'MySQL Win32 List'" <win@lists.mysql.com> 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:lsha@pacificwireless.com.au] 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" <diji@shaw.ca> To: "'MySQL Win32 List'" <win@lists.mysql.com> 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:lsha@pacificwireless.com.au] 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: http://lists.mysql.com/win32?unsub=lsha@pacificwireless.com.au

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=diji@shaw.ca