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.
----- Original Message -----
From: "Armando" <dijital@stripped>
To: "'MySQL Win32 List'" <win32@stripped>
Sent: Thursday, August 05, 2004 7:25 AM
Subject: RE: Out of resources error
> Please provide a little more information. How big is the temp. tables
> that are being created? What kind of resources are you running? What
> O/S? What about your configuration file settings? Cheers.
>
> Armando
>
> -----Original Message-----
> From: Leigh Sharpe [mailto:lsharpe@stripped]
> Sent: August 3, 2004 7:19 PM
> To: MySQL Win32 List
> Subject: Out of resources error
>
>
> Hi all,
> I'm getting the following error when using a temporary table:
>
> Out of resources when opening file 'C:\WINNT\TEMP\#sql748_c33_0.MYD'
> (Errcode: 24)
>
> It's a slightly terse error description. Can anybody tell me what
> might be causing this?
>
>
> Regards,
> Leigh
>
> Leigh Sharpe
> Network Systems Engineer
> Pacific Wireless
> Ph 9584 8966
> Mob 0408 009 502
> email lsharpe@stripped
> web www.pacificwireless.com.au
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=1
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=1
