On Sat, Jul 7, 2012 at 11:50 PM, Jean-Yves Avenard <span dir="ltr"><<a href="mailto:jyavenard@gmail.com" target="_blank">jyavenard@gmail.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi<div class="im"><br><br>On Thursday, 5 July 2012, Gary Buhrmaster wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
<br>
I note that recently someone contributed to the mythtv wiki<br>
a number of suggestions for the mysql configuration that<br>
should result in much better performance for many:<br>
<a href="http://www.mythtv.org/wiki/Tune_MySQL" target="_blank">http://www.mythtv.org/wiki/Tune_MySQL</a><br>
<br>
</blockquote><div><br></div></div><div>I recently upgrade my backend and added an intel 520 SSD. I have to say that I was disappointed by the speed gain I experienced.</div><div><br></div><div>Mythweb was even slower than before.</div>
<div><br></div><div>I applied the settings recommended on that wiki entry: wahoos.. Night and day difference. Very snappy now <span></span></div>
<br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div>Hi,<br><br>What MySQL version are you guys on? Mine is 5.1.63 and when I tried to apply the recommended changes I got the following error:<br><br>[ERROR] /usr/sbin/mysqld: unknown variable 'innodb_file_format=barracuda'<br>
<br>Do I have to be on 5.5 maybe for this to work or is this setting valid for the innodb module/plugin and not the internal one?<br><br>Thanks,<br>Igor<br><br>