<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div><span></span></div><div><div><br><br><br></div><div><br>On 18 Feb 2016, at 1:21 pm, Michael T. Dean <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:<br><br></div><blockquote type="cite"><div>
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type">
On 2/17/2016 4:15 AM, Mark wrote:<br>
<blockquote cite="mid:BLU437-SMTP140985020488EA3AA95675B7AE0@phx.gbl" type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="MS Exchange Server version
14.02.5004.000">
<title>mythtv.cnf - logging every query</title>
<!-- Converted from text/rtf format -->
<p dir="LTR"><span lang="en-au"></span><span lang="en-gb"><font face="Calibri">MythTV 0.27/fixes on Centos 7</font></span></p>
<p dir="LTR"><span lang="en-gb"><font face="Calibri">I’ve just
realised that my mariadb log</font></span><span lang="en-au"></span><span lang="en-gb"><font face="Calibri"> (Centos 7 uses mariadb not
mysql)</font></span><span lang="en-au"></span><span lang="en-gb"><font face="Calibri"> has filled</font></span><span lang="en-au"></span><span lang="en-gb"><font face="Calibri"> a
10G</font></span><span lang="en-au"></span><span lang="en-gb"><font face="Calibri"> /var/</font></span><span lang="en-au"></span><span lang="en-gb"><font face="Calibri">log
partition.</font></span><span lang="en-au"></span><span lang="en-gb"> <font face="Calibri">On a quick glance it
appears to be</font></span><span lang="en-au"></span><span lang="en-gb"> <font face="Calibri">logging every query. I am
using the mythtv.cnf example from</font></span><span lang="en-au"> </span><a moz-do-not-send="true" href="https://www.mythtv.org/wiki/Tune_MySQL"><span lang="en-au"></span><u><span lang="en-gb"><font color="#0000FF" face="Calibri">https://www.mythtv.org/wiki/Tune_MySQL</font></span></u><span lang="en-au"></span></a><span lang="en-au"></span><span lang="en-gb"></span></p>
<p dir="LTR"><span lang="en-gb"><font face="Calibri">Am I correct
that the line:</font></span></p>
<p dir="LTR"><span lang="en-au"></span><span lang="en-gb"><font face="Calibri">general_log = 1</font></span><span lang="en-au"></span><span lang="en-gb"></span></p>
<p dir="LTR"><span lang="en-gb"><font face="Calibri">Is</font></span><span lang="en-au"></span><span lang="en-gb"> <font face="Calibri">the
reason that every query is getting logged? Or am I looking
in the wrong spot.</font></span></p>
<p dir="LTR"><span lang="en-gb"><font face="Calibri">Fortunately
/var/log is a dedicated partition for exactly this kind of
eventuality so does not appear to have done any damage</font></span><span lang="en-au"></span><span lang="en-gb"><font face="Calibri">
to anything, in fact it took me a little while to notice</font></span><span lang="en-au"></span><span lang="en-gb"><font face="Calibri">,
but would obviously like to get it fixed</font></span><span lang="en-au"></span><span lang="en-gb"><font face="Calibri">.</font></span></p>
</blockquote>
<br>
<a class="moz-txt-link-freetext" href="https://www.mythtv.org/wiki/MythTV-HOWTO_-_0.27#MySQL">https://www.mythtv.org/wiki/MythTV-HOWTO_-_0.27#MySQL</a><br>
<br>
Mike<br>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br></div></blockquote><br><div>Thanks Mike. The link referred to <span style="background-color: rgba(255, 255, 255, 0);">"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.</span></div><div><span style="background-color: rgba(255, 255, 255, 0);"><br><div><span style="background-color: rgba(255, 255, 255, 0);">If I read the docs correctly it is disabled by default so deleting the general_log line should fix.</span></div></span></div></div></body></html>