Comments on Deva's MySQL / Linux blog: check your my.cnf with "mysqld --help --verbose"

my sql projects and my sql online live interactive...

2012-01-06T03:25:57.771-08:00

my sql projects and my sql online live interactive training at http://bit.ly/wXKHod

At least in Ubuntu (MySQL version 5.0.51a) this do...

2010-01-26T06:18:26.396-08:00

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.

And "mysqladmin variables" will show you...

2009-06-19T09:52:28.542-07:00

And "mysqladmin variables" will show you exactly which configuration your mysql is running with.

Hi, Have just posted a related post on this yeste...

2009-04-28T21:38:00.000-07:00

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

Yep the OurDelta builds has that (since 5.0.77-d8)...

2009-04-28T19:59:00.000-07:00

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.

I have found this very useful in the past to deter...

2009-04-28T17:56:00.000-07:00

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

:)