[mythtv-users] Slow DB with large Previous Recordings

[Ben Curtis]

So I've been running Myth for many a year now, and recorded about a
billion shows.  I like the idea that re-runs never get recorded, but I've
noticed that the more I've recorded, the slower the database responds to
things like pulling up a guide, etc.  Every time I put together a system
for friends, I'm amazed at how fast it is compared to mine, especially
when it's on systems half the speed (I'm running an Intel 3ghz P4).

Are they any "optimizations" I can make to mysql to help speed it along?


Thanks,
Ben