[mythtv-users] Slow DB with large Previous Recordings

[Michael T. Dean]

On 08/27/06 18:23, Jan Johansson wrote:

>>Are they any "optimizations" I can make to mysql to help speed it along?
>>    
>>
>Start with the optimize tools in mySQL, there is a script in 'contrib' which
>helps you do that.
>

Specifically, optimize_mythdb.pl (and I recommend setting it up to run 
in a daily cron job as described in the comments at the top of the script).

Mike