[mythtv-users] HowTo tune MySQL for schedule time and in general?

[Michael T. Dean]

On 05/10/2013 12:04 PM, Thomas Börkel wrote:
> HI!
>
> On 10.05.2013 15:52, Michael T. Dean wrote:
>
>> Looks like your /tmp is on
>>
>> /dev/hda3 / ext3
>> rw,noatime,nodiratime,errors=continue,commit=5,barrier=1,data=writeback 0 0
>>
>> which has barriers enabled.  Note that I'm not telling you to disable
>> them (especially on all of / ), but that's probably what the problem was
>> and why changing to in-memory temp tables worked around it.
> Thanks for analyzing. So, I'd rather raise the MySQL memory usage before
> I disable barriers. ;-)

Yeah.  Disabling barriers is only something I'd recommend as a 
possibility if you had a "dedicated" tmp file system.

Mike