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

[Thomas Mashos]

On Thu, Jul 12, 2012 at 5:34 AM, Igor Cicimov <icicimov at gmail.com> wrote:
> 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
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>

You have to be on 5.5, as the changes are for fixing the default
settings when using the innodb database engine. In 5.1, you are using
myisam not innodb, so if you mythfilldatabase is slow it's for a
different reason.

Thanks,

Thomas Mashos