[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.
/etc/mysql/my.cnf
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