Description:
Currently the number of fd’s on windows is limited to 2048.
This is bad for performance, for many reasons, mostly windows servers
are stuck with a tiny table_cache or low number of concurrent connections,
compared with linux running on the same hardware.
Error Log:
Could not increase number of max_open_files to more than 2048 (request: 3082)
Othre Error:
ERROR 1135: Can’t create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug
How to repeat:
Run the server
mysqld-nt.exe –table_cache=1000 –max_connections=500 –open_files-limit=3000 –console
061122 17:04:27 [Warning] Could not increase number of max_open_files to more than 2048
(request: 2510)
061122 17:04:28 InnoDB: Started; log sequence number 0 43655
061122 17:04:28 [Note] mysqld-nt: ready for connections.
Version: ‘5.0.30-enterprise-gpl-nt’ socket: ” port: 3306 MySQL Enterprise Server
(GPL)
More:http://bugs.mysql.com/bug.php?id=24509
Solution:
1.Update Your Mysql Server to Mysql5.5,It has been fix is released in 5.5.
2.Replacement of the operating system,Linux have not the problem.
…
Спс …