[mythtv-users] Slow MySQL query after delete

Rossco rossco at whyza.net
Thu Nov 29 09:44:10 UTC 2007

I should probably add that i did actually determine that it was the
recordedseek table that was slow for me via the myslq slow logging
feature, before converting to innodb.

log_slow_queries        = /var/log/mysql/mysql-slow.log

during peak usage, slow sql query time on recordedseek was over 30 secs
before the conversion, and after, was typically around 0.5-1.5 secs

I found I could further adjust the slow log timeout setting via
phpmyadmin and further tune other 'slow' tables by converting to
innodb, but providing questionable additional benefit.

so while I am certainly no sql expert, I'm confident recordedseek was my
biggest bottleneck by far before converting to innodb.

On Thu, 2007-11-29 at 15:03 +1000, ross camm wrote: 

> 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? 
> > 
> > 
> > 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071129/ca2da230/attachment.htm 

More information about the mythtv-users mailing list