Re: What led to the design of having multiple option file locations?

Tianyin Xu <[email protected]> writes:
> One special thing for MySQL configuration is that there're multiple
> locations for the option files (there're 5 locations both on Windows
> and Unix-like platforms),
> http://dev.mysql.com/doc/refman/5.5/en/option-files.html

/etc/my.cnf largely for historical reasons.

/etc/mysql/my.cnf as the main one as then you can do things such as
"include /etc/mysql/*cnf" and have individual components configured in
their own files (great for package managers!).

The SYSCONFDIR/my.cnf and $MYSQL_HOME/my.cnf really just exist to make
it easier to have 101 mysql servers running on a single machine sharing
some common configuration and some custom configuration.

defaults-extra-file so you can on-demand point at some other config file
(useful when running benchmarks or experiments or something)

and ~/.my.cnf can do things like "i'm a user and i want to set options
for my mysql client"


-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals