[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