[mythtv-users] Program information storage

[Shawn Rutledge]

Nevermind... I just found something on a gentoo wiki page:

"Also, note that MySQL keeps logs of all database transactions in
/var/lib/mysql/. Over the course of a few years, these can really add
up. It's useful to have these deleted after a small interval by adding
the following to /etc/mysql/my.cnf under the section heading
"[mysqld]":

expire_logs_days                        = 7

This will delete logs older than seven days. "

Did that, restarted mysql, and they went away.

On 2/21/07, Shawn Rutledge <shawn.t.rutledge at gmail.com> wrote:
> On 2/21/07, Shawn Rutledge <shawn.t.rutledge at gmail.com> wrote:
> > Ah, well /var/lib/mysql on my system contains a bunch of large files
> > like muon-bin.0000xx with xx going from 1 to 54 currently.  I assumed
> > it was actual table data in there, but maybe not...
>
> Actually just using less to look at a file I see stuff like this (in
> muon-bin.000041 for example):
>
> @UPDATE program SET title          = 'Wicked Wicked Games',
> subtitle      = '',     description    = 'Blythe Hunter goes to great
> lengths to exact revenge on an
> ex-lover.',     category       = '',       category_type = '',
> starttime      = '2006-12-09T19:00:00', endtime       =
> '2006-12-09T20:00:00',     closecaptioned = 0,        subtitled     =
> 0,     stereo         = 0,    hdtv          = 0,     partnu
> mber     = 0,    parttotal     = 0,     airdate        = '0000',
> originalairdate=NULL,     listingsource  = 1 WHERE chanid    = 2451
> AND       starttime = '2006-12-09T19:00:00'
>
> with some control characters between each SQL statement.
>