Bug 596507 - query-log option
query-log option
Status: CLOSED NOTABUG
Product: Fedora
Classification: Fedora
Component: mysql (Show other bugs)
13
All Linux
low Severity low
: ---
: ---
Assigned To: Tom Lane
Fedora Extras Quality Assurance
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2010-05-26 16:31 EDT by Nathanael Noblet
Modified: 2013-07-02 23:28 EDT (History)
2 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2010-06-28 11:27:49 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Nathanael Noblet 2010-05-26 16:31:48 EDT
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 16:58:00 EDT
Works for me.  Please show exactly what you did to /etc/my.cnf that didn't work.
Comment 2 Nathanael Noblet 2010-05-28 12:48:05 EDT
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 13:49:48 EDT
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 11:27:49 EDT
Closing, since AFAICS this is just pilot error and not a bug.

Note You need to log in before you can comment on or make changes to this bug.