On the Drizzle-discuss mailing list, Baron just pointed out that MySQL has a means to validate its config file (/etc/my.cnf), similar to "apachectl configtest".
mysqld --help --verbose
Somehow, I never knew that...
Oh, and yes, this means I am following Drizzle. In fact, I'm trying to devote at least a few hours each day to reading the source and finding things to fix. In a weird way, it feels good to be writing C++ again!
Subscribe to:
Post Comments (Atom)
Posts
6 comments:
I have found this very useful in the past to determine what path mysqld was searching through to find my.cnf:
mysqld --help --verbose|grep cnf
:)
Yep the OurDelta builds has that (since 5.0.77-d8) as an option in the startup script, so you can do /etc/init.d/mysqld configtest
Peter Lieverdink put the patch in some months back.
Hi,
Have just posted a related post on this yesterday. Apparently, and sadly, mysqld --verbose --help and SHOW GLOBAL STATUS do not agree on naming and values conventions.
See: Variables ambiguities in names and values
And "mysqladmin variables" will show you exactly which configuration your mysql is running with.
At least in Ubuntu (MySQL version 5.0.51a) this don't work. I entered the line "stupid_value=true" into the my.cnf and issued "mysqld --help --verbose". It doesn't tell anything about an non-existing option.
my sql projects and my sql online live interactive training at http://bit.ly/wXKHod
Post a Comment