[mythtv-users] mythtv.cnf - logging every query
Saul
jaglover at gmail.com
Thu Feb 18 00:05:15 UTC 2016
On Wed, 17 Feb 2016 19:45:13 +1030
Mark <perkins1724 at hotmail.com> wrote:
> MythTV 0.27/fixes on Centos 7
>
> I've just realised that my mariadb log (Centos 7 uses mariadb not
> mysql) has filled a 10G /var/log partition. On a quick glance it
> appears to be logging every query. I am using the mythtv.cnf example
> from https://www.mythtv.org/wiki/Tune_MySQL
>
> Am I correct that the line:
>
> general_log = 1
>
> Is the reason that every query is getting logged? Or am I looking in
> the wrong spot.
>
> Fortunately /var/log is a dedicated partition for exactly this kind of
> eventuality so does not appear to have done any damage to anything,
> in fact it took me a little while to notice, but would obviously like
> to get it fixed.
Methinks applications as logrotate were invented to keep logs under
control.
--
Cheers, Saul
More information about the mythtv-users
mailing list