|Product:||[Fedora] Fedora||Reporter:||Nathanael Noblet <nathanael>|
|Component:||mysql||Assignee:||Tom Lane <tgl>|
|Status:||CLOSED NOTABUG||QA Contact:||Fedora Extras Quality Assurance <extras-qa>|
|Fixed In Version:||Doc Type:||Bug Fix|
|Doc Text:||Story Points:||---|
|Last Closed:||2010-06-28 15:27:49 UTC||Type:||---|
|oVirt Team:||---||RHEL 7.3 requirements from Atomic Host:|
Description Nathanael Noblet 2010-05-26 20:31:48 UTC
Description of problem: Sometimes I want to turn on mysql's query logging capability. To do this I need to edit the initscript, since for some reason adding the option to my.cnf takes no effect. It would be nice if /etc/init.d/mysqld could read from /etc/sysconfig/mysqld for that option. That way turning it on/off would be easier than editing the initscript Version-Release number of selected component (if applicable): How reproducible: Always Steps to Reproduce: 1. N/A 2. 3. Actual results: Expected results: Additional info:
Comment 1 Tom Lane 2010-05-26 20:58:00 UTC
Works for me. Please show exactly what you did to /etc/my.cnf that didn't work.
Comment 2 Nathanael Noblet 2010-05-28 16:48:05 UTC
I've tried adding added query-log=/var/log/mysql-query.log under the [mysqld] as well as [mysqld_safe] sections. Under mysqld mysql fails to start as it doesn't understand teh query-log option 100528 10:43:15 [ERROR] /usr/libexec/mysqld: unknown variable 'query-log=/var/log/mysql-query.log' 100528 10:43:15 [ERROR] Aborting The other just seems to be ignored. However if I edit the initscript for mysqld and add --query-log=/var/log/mysql-query.log and restart it works.
Comment 3 Tom Lane 2010-05-28 17:49:48 UTC
AFAIK the correct spelling of that option is --slow-query-log, or slow_query_log as a variable. I can't find anything in either the manual or the source code suggesting that query-log by itself should be accepted. Please see http://dev.mysql.com/doc/refman/5.1/en/server-options.html
Comment 4 Tom Lane 2010-06-28 15:27:49 UTC
Closing, since AFAICS this is just pilot error and not a bug.