Bug 596507

Summary:	query-log option
Product:	[Fedora] Fedora	Reporter:	Nathanael Noblet <nathanael>
Component:	mysql	Assignee:	Tom Lane <tgl>
Status:	CLOSED NOTABUG	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	low	Docs Contact:
Priority:	low
Version:	13	CC:	hhorak, tgl
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-06-28 15:27:49 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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.