<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
On 05/31/2010 01:48 PM, Paul Harrison wrote:
<blockquote cite="mid:4C03F65C.4030902@sky.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
On 31/05/10 18:21, Dave Day wrote:
<blockquote cite="mid:4C03F015.5040904@gmail.com" type="cite">
<meta http-equiv="content-type"
content="text/html; charset=ISO-8859-1">
<font size="+1">I am a relatively new user of Mythtv. I installed
Myth
in February of this year and have been using the same database ever
since. Yesterday I noticed that the partition it is on was getting
full. One of the problems was that I originally assigned Myth Video to
use that partition and then never moved its storage to a more spacious
place.<br>
<br>
But I was also surprised to see that /var/lib/mysql which is where the
mysql database lives has 11GB!!! That makes me suspect that there is
some required housekeeping that I am not doing. I have a fairly simple
Myth system of one backend with one HVR 1600. I started with MythTV 22
and have switched to 23.<br>
<br>
Should the DB really be that big? There are only two databases,
mythconverg and test.<br>
<br>
What can I do to keep it more lean?<br>
<br>
Thanks,<br>
Dave</font><br>
</blockquote>
<br>
11GB isn't normal. Sound like you may have transaction logging enabled
or something like that.<br>
<br>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.gossamer-threads.com/lists/mythtv/users/249133#249133">http://www.gossamer-threads.com/lists/mythtv/users/249133#249133</a><br>
<br>
Paul H.<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a>
</pre>
</blockquote>
<font size="+1">Paul -<br>
<br>
Thanks so much. That was it.<br>
<br>
purge binary logs to 'mysqld-bin-000038'; <br>
<br>
did the trick and I am well under a Gig now. I also commented out<br>
<br>
log-bin in /etc/mysql/my.cnf<br>
<br>
Thanks again,<br>
Dave<br>
</font>
</body>
</html>