<br><br><div class="gmail_quote">On Mon, May 31, 2010 at 7:21 PM, Dave Day <span dir="ltr"><<a href="mailto:david.scott.day@gmail.com">david.scott.day@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div text="#000000" bgcolor="#ffffff">
<font size="+1"><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>
</font><br></div></blockquote></div><br>11 GB is huge indeed. My mythconverg databasefiles take up 78 MB of diskspace. That Mythconverg database is in use for about 6 years now... Not doing any real housekeeping there. Are the timestamps on the files in /var/lib/mysql all fairly current? Could it be that some files have been put there that don't belong there? Is there a database backup script that dumps it's contents there and that you now have loads of daily copies?<br>