[mythtv-users] Slow MySQL query after delete

ross camm rossco at whyza.net
Thu Nov 29 05:03:36 UTC 2007


I used this

/usr/bin/mysql_convert_table_format --user=root --password=XXX
--type=innodb mythconverg recordedseek


I also converted other tables that had a 'large' number of rows....but
nothing came close to the size of recordedseek.

It worked miracles for me...hope it fixes your performance issues.


On Wed, 2007-11-28 at 21:08 -0500, Larry K wrote:
> BUSQ refers to the Big Ugly Slow Query that is driving everyone crazy.
> It joins several tables, but not recordedseek.  That's why I wondered
> if converting this table would help me.  
> 
> I assume you just did an alter table recordedseek engine innodb? 
> 
> 

> 



More information about the mythtv-users mailing list