Hi Karl, The option is in the same group as all other settings that do take effect ([mysqld]) and is the same across all 3 slave servers.
Default options are read from the following files in the given order: > /etc/my.cnf ~/.my.cnf > The following groups are read: mysqld server mysqld-10.4 mariadb > mariadb-10.4 mariadbd mariadbd-10.4 client-server galera ~/.my.cnf only contains user/password auth info and nothing else. The printout lists these: > general-log TRUE > general-log-file > /var/log/mysql/mysqld-queries.log The log-file is exactly what I set in my.cnf, but general-log is set to TRUE, even though I have it set to "off". I'm still at a loss. 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 Sat, Aug 22, 2020 at 1:45 PM Karl Levik <[email protected]> wrote: > 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, <[email protected]> > 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 <[email protected]> >> 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 : [email protected] >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
