[mythtv-users] Very slow mythfrontend, mysql at 100%

Ronald Pijnacker pijnacker at dse.nl
Sat Nov 21 22:42:23 UTC 2009

> On Fri Nov 20, 2009 at 03:00:16PM +0100, Ronald Pijnacker wrote:
> > Since the wiki page discourages partial restores and I wasn't in the mood
> > to reconfigure my systems, I tried just doing a backup/restore.
> > I compared the first backup with a second (after restore) with identical results.
> > But still somehow this managed to make the problem go away!
> > 
> Are you running the optimize_mythdb.pl script on a regular basis?  If
> not, the backup/restore would have done many of the same
> cleanups/optimisations as this script.

No, I not doing this. However would you expect that the output of the database-backup
script would be identical before and after restoring it?
I'm not that knowledgable about databases, but I would think that with the same (exactly)
output there would be no difference...


More information about the mythtv-users mailing list