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

David Engel david at istwok.net
Thu May 9 14:39:29 UTC 2013


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?

David
-- 
David Engel
david at istwok.net


More information about the mythtv-users mailing list