[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