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

[Michael T. Dean]

On 11/20/2009 09:00 AM, Ronald Pijnacker wrote:
>>> 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?
>>>       
>> 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,

FWIW, fixing a corrupt DB schema is the one good reason to do a partial 
restore.

Anyway, it may have just been a problem with your index files or something.

Mike