[mythtv-users] running optimize_mythdb.pl on an old version of the database?

[Brad DerManouelian]

On Jan 22, 2007, at 6:52 PM, Darren Richards wrote:

> I'm running version 0.17.  It has been rock solid for a couple  
> years now, which is why I've been afraid to touch it.  But recently  
> it has been taking a long time (20-30 sec) to bring up a recorded  
> program.  I'd like to run optimize_mythdb.pl, but version 0.17  
> didn't come with this utility.  Can I run optimize_mythdb.pl that  
> is packaged with a later version of mythtv?
>
> Thanks,
> darren

You can log into your MySQL client and run:

OPTIMIZE TABLE <tablename>

on all of the tables in your mythconverg database. I haven't looked  
at the script, but I imagine it's simply looking up the tables in  
that database and running the MySQL optimize command.