Bug #35889 Out of resources errcode:24
Submitted: 8 Apr 2008 5:23 Modified: 30 Sep 2008 18:53
Reporter: hady ginanjar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.13 OS:Windows (NT)
Assigned to: CPU Architecture:Any

[8 Apr 2008 5:23] hady ginanjar 
Description:
Hi MySQL Team, 

i have a problem with mySQL db, sometimes i got err Out of resources when opening file '#sql_da_0.myi' (errcode:24). this error after 15 minute solved. but after 2 or 3 hours i get this error again.

any solution for me ??

Tks
Hady
 

How to repeat:
Hi MySQL Team, 

i have a problem with mySQL db, sometimes i got err Out of resources when opening file '#sql_da_0.myi' (errcode:24). this error after 15 minute solved. but after 2 or 3 hours i get this error again.

any solution for me ??

Tks
Hady
[8 Apr 2008 11:17] Valeriy Kravchuk 
C:\Program Files\MySQL\MySQL Server 5.0\bin>perror 24
OS error code  24:  Too many open files

Looks like you hit a documented limitation of current version, not more that 2048 open files at the same time. Read http://dev.mysql.com/doc/refman/5.0/en/limits-windows.html:

"- The number of open file descriptors on Windows is limited to a maximum of 2048, which may limit the ability to open a large number of tables simultaneously. This limit is due to the compatibility functions used to open files on Windows that use the POSIX compatibility layer.

This limitation will also cause problems if you try to set max_open_files to a value greater than the 2048 file limit."
[30 Sep 2008 18:53] Konstantin Osipov 
We have implemented native file I/O on windows in 6.0.