[mythtv] [mythtv-commits] Ticket #9503: Very sluggish UI during reschedules especially

[Michael Rice]

On Sat, Jan 22, 2011 at 6:46 PM, Michael Rice <mikerice1969 at gmail.com> wrote:
> On Sat, Jan 22, 2011 at 5:35 PM, Raymond Wagner <raymond at wagnerrp.com> wrote:
>> On 1/22/2011 20:21, MythTV wrote:
>>>
>>> #9503: Very sluggish UI during reschedules especially
>>>
>>>  I am experiencing very sluggish UI on my frontend (backend on another
>>>  machine).  It happens frequently but I usually notice a problem when a
>>>  reschedule is happening.
>>
>> The scheduler is extremely database intensive, and other operations that
>> depend on the database (pretty much everything) can stall while the
>> scheduler is running.  Could this be a simple case of insufficient CPU/disk
>> performance?
>>
>> What CPU do you have running your database?  What kind of disk is it on?
>>  Were you running other intensive IO operations on that disk at the same
>> time?  Are you going into swap at all?
>
> CPU is: Intel(R) Core(TM)2 CPU          6300  @ 1.86GHz
> Both cores running at about 1% until a reschedule then one core
> goes to about 65%
>
> 1 GB Ram
> top reports about 990Mb used and about 100Mb swap used.
> No noticeable change during a few reschedules I just tried.

Checking my old logs (before updating to Fedora 14/MythTV 0.24) I found
that the schedule was taking 20-25 seconds.  After the update it is taking
40-45 seconds.

So I swapped out the 667MHz 1G with the 800MHz 2G DIMMs from the
bedroom frontend and that cut the query down to 20 seconds again.

I also moved the database off the system drive but that didn't seem to
affect the query time much.

Not sure if the memory usage of MythTV increased or something else
in Fedora14 but the problem seems to be gone with the added memory.
You can close this ticket.  Thanks for putting me on the right track.