[mythtv-users] Very slow mythfrontend, mysql at 100%
Ronald Pijnacker
pijnacker at dse.nl
Fri Nov 20 14:00:16 UTC 2009
Hi Mike,
>> My primary frontend is very slow since a while.
>> Deleting recordings etc. is taking seconds, which is very annoying.
>> I noticed that mysql is at 100% cpu on the backend.
>> Could it be that over the years mythconverg has become so big that
>> this is the cause of the issue?
>>
>> If so, which tables can I safely purge?
>
> No, MythTV cleans up the data in the mythconverg database--and besides,
> myth doesn't use that much data, so even if stuff wasn't being cleaned up,
> it wouldn't get that large.
>
> Something else is going on.
>
> I have a clean mythconverg database and get:
>
> # du -sh /srv/mysql/mythconverg/
> 448M /srv/mysql/mythconverg/
>
> (that's 448MiB). That's not very big from a MySQL standpoint but is
> probably rather large from a mythconverg standpoint. My performance is
> fine, though.
>
> I'd guess it's more likely schema corruption (i.e. missing/broken indices,
> etc.--and, yes, I saw that you said in IRC it's not crashed tables, but I
> mean broken schema) or something.
>
> If you'd like to get Myth to recreate your schema (and all indices, etc.)
> see http://www.mythtv.org/wiki/Database_Backup_and_Restore and:
> a) Back up your DB
> b) Drop your DB
> c) Create a new DB with mc.sql
> d) Create a new DB schema by running and exiting mythtv-setup
> e) Do a partial restore (
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup
> )
> f) Run mythtv-setup to reconfigure mythbackend
> g) Start mythbackend
> h) Run mythfrontend and reconfigure mythfrontend and all your plugins
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!
Thanks,
Ronald
More information about the mythtv-users
mailing list