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

Michael T. Dean mtdean at thirdcontact.com
Thu May 9 14:53:54 UTC 2013


On 05/09/2013 10:39 AM, David Engel wrote:
> On Thu, May 09, 2013 at 02:47:37PM +0200, Thomas Börkel wrote:
>> On 06.05.2013 16:26, David Engel wrote:
>>
>>> That sounds like a reasonable test.  Still, that amount of improvement
>>> sounds way too good to be true.  If it works, though, enjoy. :)
>> mythfilldatabase is way faster, too.
>>
>> Before, Marking episode first/last showings too over 3 minutes each. Now
>> it's 15 seconds!
> It only takes 3 seconds for me with nothing special done to MySQL.
> Admittedly, my backed is fairly powerful.  Perhaps you had a really
> badly tuned MySQL to begin with.  What distribution are you using?
>

/me guesses one with barriers enabled on the filesystem that's used for 
tmp space

Mike


More information about the mythtv-users mailing list