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:
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any

[25 Mar 2008 13:28] Geert Vanderkelen
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:

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.