<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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>
</body>
</html>