How to prevent overriding of configs in my.cnf by variables?
Posted by: Ilya Khanataev
Date: June 07, 2016 04:36AM

Hello!

Since the upgrade from v5.5 to v5.6 some days ago I cannot monitor the logs anymore. The settings in the my.cnf (general_log_file = /var/log/mysql/mysql.log and general_log = 1) are ignored or better to say seem to get overriden by the variables:

mysql> SHOW VARIABLES LIKE '%general%';
+------------------+-----------------------------+
| Variable_name | Value |
+------------------+-----------------------------+
| general_log | OFF |
| general_log_file | /var/lib/mysql/ubuntuvm.log |
+------------------+-----------------------------+

Sure, I can set the variables to other values:

SET GLOBAL general_log = 'ON';
SET GLOBAL general_log_file = '/var/log/mysql/test.log';

but it works only for the current session.

What are these variables for, if the configs can/should be defined in the my.cnf? How to prevent overriding of configs the my.cnf configs, in order to keep all settings at one place (in the my.cnf)?

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.