Bug #264 mysqld_safe not setting open-files-limit
Submitted: 9 Apr 2003 16:52 Modified: 15 Apr 2003 7:15
Reporter: Lance Lovette Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.12 OS:Linux (Red Hat Linux 7.2)
Assigned to: Lenz Grimmer CPU Architecture:Any

[9 Apr 2003 16:52] Lance Lovette
mysqld_safe does not set open-files-limit as specified in my.cnf.

How to repeat:
Add to /etc/my.cnf:


Start mysql and look at value of open_files_limit.

Suggested fix:
In mysqld_safe, change the line:

args="open-files-limit=$open_files $args"


args="--open-files-limit=$open_files $args"
[15 Apr 2003 7:15] Lenz Grimmer
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 

Thanks for observing this - it will be fixed for the upcoming MySQL 4.0.13 
ChangeSet@1.1438, 2003-04-15 16:11:37+02:00, lenz@mysql.com 
   - added missing dashes to parameter "open-files-limit" in mysqld_safe 
     (bug #264)
[29 Nov 2010 17:52] DBA Lead
an explanation can be seen at  
[30 Nov 2010 0:40] Kika Olivia
I know this AWESOME! site where you can find everything. There are tutorials nd videos from MySQL to Java and CSS. 


You have got to check this site out!