maria-discuss team mailing list archive

[Karl Levik <karl.levik@xxxxxxxxx>]

Hi Artem,

In which option group have you placed the setting? ([server], [mysqld],
[mariadb] etc.)

Are you sure your setting isn't being overridden by another option file?
You can check the output of running "mysqld --help --verbose" and verify
that you don't have any extra files at the locations listed.

Cheers,
Karl

On Sat, 22 Aug 2020, 6:09 pm Artem Russakovskii, <archon810@xxxxxxxxx>
wrote:

> I opened up a bug report here https://jira.mariadb.org/browse/MDEV-23540.
>
> Sincerely,
> Artem
>
> --
> Founder, Android Police <http://www.androidpolice.com>, APK Mirror
> <http://www.apkmirror.com/>, Illogical Robot LLC
> beerpla.net | @ArtemR <http://twitter.com/ArtemR>
>
>
> On Fri, Aug 21, 2020 at 4:29 PM Artem Russakovskii <archon810@xxxxxxxxx>
> wrote:
>
>> Hi folks,
>>
>> I'm at a loss here. I've had a mysql and now mariadb
>> (MariaDB 10.4.13-MariaDB-log) slave with query logging enabled for years,
>> but I'm now trying to turn it off using the my.cnf option and it does not
>> seem to stick on server restarts.
>>
>> What's weird is the other slaves with the exact same my.cnf don't log,
>> but this one slave refuses to stop doing it.
>>
>> To clarify, SET global general_log = 0 does stop logging but the setting
>> comes back on after a restart.
>>
>> I'm turning it off in my.cnf like this:
>> general_log = off
>> #Enter a name for the query log file. Otherwise a default name will be
>> used.
>> general_log_file=/var/log/mysql/mysqld-queries.log
>>
>> Commenting out general_log_file simply changes it to go to a different
>> location. I also tried general_log=0 without any luck.
>>
>> ps shows it as running with:
>> mysql    27580     1 99 16:26 ?        00:01:40 /usr/sbin/mysqld
>> --defaults-file=/etc/my.cnf --user=mysql
>> So --general-log isn't getting set on command line.
>>
>> What am I missing? Why does it insist on getting turned on and refuses to
>> listen to the setting? Is it a bug?
>>
>> Thanks.
>>
>> Sincerely,
>> Artem
>>
>> --
>> Founder, Android Police <http://www.androidpolice.com>, APK Mirror
>> <http://www.apkmirror.com/>, Illogical Robot LLC
>> beerpla.net | @ArtemR <http://twitter.com/ArtemR>
>>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>