[mythtv-users] Very slow mythfilldatabase after fresh mythbuntu 12.04 install?

[Igor Cicimov]

On Sat, Jul 7, 2012 at 11:50 PM, Jean-Yves Avenard <jyavenard at gmail.com>wrote:

> Hi
>
>
> On Thursday, 5 July 2012, Gary Buhrmaster wrote:
>
>>
>>
>> I note that recently someone contributed to the mythtv wiki
>> a number of suggestions for the mysql configuration that
>> should result in much better performance for many:
>>   http://www.mythtv.org/wiki/Tune_MySQL
>>
>>
> 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.
>
> Mythweb was even slower than before.
>
> I applied the settings recommended on that wiki entry: wahoos.. Night and
> day difference. Very snappy now
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
> Hi,

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:

[ERROR] /usr/sbin/mysqld: unknown variable 'innodb_file_format=barracuda'

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?

Thanks,
Igor
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20120712/66f3133e/attachment.html>