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:
None 
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
Description:
mysqld_safe does not set open-files-limit as specified in my.cnf.

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

[safe_mysqld]
open-files-limit=8192

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"

to:

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 
    http://www.mysql.com/doc/en/Installing_source_tree.html

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  
http://www.geeksww.com/tutorials/database_management_systems/mysql/configuration/mysql_ope...
[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. 

www.geeksww.com

You have got to check this site out!