<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 14.02.5004.000">
<TITLE>mythtv.cnf - logging every query</TITLE>
</HEAD>
<BODY>
<!-- 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 HREF="https://www.mythtv.org/wiki/Tune_MySQL"><SPAN LANG="en-au"><U></U></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><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
</BODY>
</HTML>