[mythtv-users] Slow DB with large Previous Recordings

[Nick]

On 27/08/06, Ben Curtis <mythtv at nosolutions.com> wrote:
>
> 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?

Check out the suggestions in the MySQL section of Jarod's HOWTO:

http://wilsonet.com/mythtv/fcmyth.php#mysql

Nick

-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users