[mythtv-users] mysql / mythbackend running at 100%+ CPU on 0.24.3-fixes

[Karl Newman]

On Sun, Oct 13, 2013 at 11:26 AM, Paul <dazzle at edazzle.net> wrote:

>  it is possible that your oldrecorded table (used to maintain history) has
>>> accumulated a lot of entries.
>>>
>>
> I have cleared it out a bit and now have 267 entries in the oldrecorded
> table and still experiencing the same slow downs.
>
>
>  I believe that moving from the unsupported 0.24 to the current 0.27
>>>
>>
> I am, at the moment, not wishing to upgrade as I have (had?) a very stable
> set-up
>
>
>  but the Atom is a slow CPU, and I doubt you are going to be entirely
>>> happy with the scheduling times.
>>>
>>
> I've been running this set-up for about 2 years and have never had slow
> down problems like this before. I compile from source and use Atom specific
> optimizations, plus the latest NVidia drivers have improved the performance
> of the ION massively.
>
> thanks for the reply and info though.
>
> Paul
>

You might try tweaking your mysql tuning. In particular, increasing the
temp table size made a big difference for me (but I have 8 GB memory to
play with...) Take a look at the mysql tuning page:
http://www.mythtv.org/wiki/Tune_MySQL

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131013/b809c30f/attachment.html>