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

[Robin Hill]

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.

Cheers,
    Robin
-- 
     ___        
    ( ' }     |       Robin Hill        <myth at robinhill.me.uk>  |
   / / )      | Little Jim says ....                            |
  // !!       |      "He fallen in de water !!"                 |
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20091120/f9bc18cf/attachment.pgp>