[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 ( 
), then doing a full restore of the backup ( 

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


More information about the mythtv-users mailing list