[mythtv-users] running optimize_mythdb.pl on an old version of the database?
myth at dermanouelian.com
Tue Jan 23 03:03:26 UTC 2007
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?
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.
More information about the mythtv-users