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

Mark Perkins perkins1724 at hotmail.com
Sat Feb 20 09:58:10 UTC 2016





>> On 18 Feb 2016, at 1:21 pm, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>> 
>> On 2/17/2016 4:15 AM, Mark 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.
>> 
> 
> https://www.mythtv.org/wiki/MythTV-HOWTO_-_0.27#MySQL
> 
> Mike
> _______________________________________________

Thanks Mike. The link referred to "log-bin" or "log_bin" which I can't find in any of my cnf files so I'm guessing this is one of the difference between MySQL and mariadb.

If I read the docs correctly it is disabled by default so deleting the general_log line should fix.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160220/7f4fe3b5/attachment.html>
-------------- next part --------------
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org


More information about the mythtv-users mailing list