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

[Thomas Börkel]

HI!

On 09.05.2013 16:39, David Engel wrote:

>> 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

My main backend is an Ivy Bridge 2.9 GHz Core i5. But the disk is a
pretty old 320 GB IDE. This system was slow before tuning.

My test/desktop system is a Sandy Bridge 3.3 GHz Core i5 with SATA disk
and always was pretty fast regarding scheduling and mythfilldatabase.
But it has less channels.

Now that I raised the temp table space on my main backend, it is as fast
as my test system.

Probably this is the problem, if you have not enough temp table space
configured:

http://code.mythtv.org/trac/ticket/11282

> badly tuned MySQL to begin with.  What distribution are you using?

All my systems use Gentoo, not far away from each other regarding packages.

Regards,
Thomas