[mythtv-users] HowTo tune MySQL for schedule time and in general?
Thomas Börkel
thomas at boerkel.de
Thu May 9 17:48:43 UTC 2013
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
More information about the mythtv-users
mailing list