Bug #35552 Allowing --defaults-extra-file in option file
Submitted: 25 Mar 2008 13:28 Modified: 25 Mar 2008 14:36
Reporter: Geert Vanderkelen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D5 (Feature request)

[25 Mar 2008 13:28] Geert Vanderkelen
Description:
A bit nitpicking maybe, but currently mysqld_safe starts mysqld with all the options defined under [mysqld] as command line arguments. This is mostly making the `ps` output unreadable. Doing `ps auw` might show options trimmed, and `ps auwww` might show a 10 line output on the terminal (useless in the end).

 

How to repeat:

shell> ps ax
..
29564 ?        S      0:00 /bin/sh ./bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf
29611 ?        S      0:03 /usr/local/mysql-5.1.18-beta-linux-x86_64-glibc23/bin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr/local/mysql-5.1.18-beta-li
..

Starting mysqld without mysqld_safe makes it look much nicer:
shell> ps ax
..
  534 pts/1    Sl     0:00 ./mysqld --defaults-file=/etc/mysql/my.cnf
..

Suggested fix:

Could change the mysqld_safe or how it starts up the mysqld, so writing your own.

But maybe it's also cool to have --defaults-extra-file option available in the option file?
So, doing for example the following:

[mysqld]
defaults_extra_file = /etc/mysql/real_my.cnf

and mysqld_safe will have to pass only that 1 option to the mysqld process.
!include is not doing the trick btw.