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

Michael T. Dean mtdean at thirdcontact.com
Fri Nov 20 14:48:17 UTC 2009


On 11/19/2009 04:59 PM, GXL.nl wrote:
> Below are the two queries I used, it might be that I'm overseeing 
> something, to run them I copied the record table to sched_tmp_record. 
> I though maybe the two missing fields made the query to big for memory 
> but removing other fields don't have the same result. Am I missing 
> something here, can you see another difference? I ran both queries 
> multiple times, yesterday and today and always the same result?

Could you try doing a full SQL-based backup ( 
http://www.mythtv.org/wiki/Database_Backup_and_Restore ), then dropping 
your database and creating a new database ( 
http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore 
), then doing a full restore of the backup ( 
http://www.mythtv.org/wiki/Database_Backup_and_Restore#Full_restore_of_a_specific_backup_file 
)?

If that doesn't help, try 
http://www.gossamer-threads.com/lists/mythtv/users/409050#409050 .

Mike




More information about the mythtv-users mailing list