[mythtv-users] mythtv.cnf - logging every query

[Mark Perkins]

> On 18 Feb 2016, at 10:35 am, Saul <jaglover at gmail.com> wrote:
> 
> 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
> _______________________________________________

Sure. But I don't want to be logging every query. Errors, sure. But for day to day use every query seems excessive for my use case.