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
