<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.14.3">
</HEAD>
<BODY>
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 <FONT COLOR="#000000">innodb</FONT>.<BR>
<BR>
/etc/mysql/my.cnf<BR>
log_slow_queries = /var/log/mysql/mysql-slow.log<BR>
<BR>
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<BR>
<BR>
I found I could further adjust the slow log timeout setting via phpmyadmin and further tune other 'slow' tables by converting to <FONT COLOR="#000000">innodb</FONT>, but providing questionable additional benefit.<BR>
<BR>
so while I am certainly no sql expert, I'm confident recordedseek was my biggest bottleneck by far before converting to <FONT COLOR="#000000">innodb</FONT>.<BR>
<BR>
On Thu, 2007-11-29 at 15:03 +1000, ross camm wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">I used this</FONT>
<FONT COLOR="#000000">/usr/bin/mysql_convert_table_format --user=root --password=XXX</FONT>
<FONT COLOR="#000000">--type=innodb mythconverg recordedseek</FONT>
<FONT COLOR="#000000">I also converted other tables that had a 'large' number of rows....but</FONT>
<FONT COLOR="#000000">nothing came close to the size of recordedseek.</FONT>
<FONT COLOR="#000000">It worked miracles for me...hope it fixes your performance issues.</FONT>
<FONT COLOR="#000000">On Wed, 2007-11-28 at 21:08 -0500, Larry K wrote:</FONT>
<FONT COLOR="#000000">> BUSQ refers to the Big Ugly Slow Query that is driving everyone crazy.</FONT>
<FONT COLOR="#000000">> It joins several tables, but not recordedseek. That's why I wondered</FONT>
<FONT COLOR="#000000">> if converting this table would help me. </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> I assume you just did an alter table recordedseek engine innodb? </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">_______________________________________________</FONT>
<FONT COLOR="#000000">mythtv-users mailing list</FONT>
<FONT COLOR="#000000"><A HREF="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</A></FONT>
<FONT COLOR="#000000"><A HREF="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</A></FONT>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>