[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mythtv-users
Subject:    Re: [mythtv-users] High mysql cpu usage
From:       David Scammell <davescammell () gmail ! com>
Date:       2012-12-30 21:19:21
Message-ID: CAH3P9mNm5t=dZDwB3OL2rxvAHS_9t9TJLcd=SV6h+oGMfeCAsA () mail ! gmail ! com
[Download RAW message or body]

Thanks for the replies, i'm wondering about the duplicate freesat
channels of CH4 etc also. I've got lots of ram to cache table lookups
and am writing over iscsi which I would guess would not honour barrier
requests but then again they might. ;( ugh.

On 30/12/2012, Michael T. Dean <mtdean@thirdcontact.com> wrote:
> On 12/30/2012 12:25 PM, Jarle Thorsen wrote:
>> 2012/12/30 David Scammell
>>
>>> At the end of the day I'm unsure if there's a problem with indexes but
>>> my situation was fixed by setting the visible=0 setting on a number of
>>> 'useless' channels that i'm unlikely to record from, bringing the
>>> number of visible channels to about 90. My longest slow query is now
>>> 13 seconds, once or twice a day.
>>>
>> I have currently about 700 channels, and I am in the process of deleting
>> channels that I can not tune in to. I'm thinking that my number of
>> (possibly) bad channels may contribute to my problem.
>>
>> I have seen some reports of similar problems for ext4 users, but I'm not
>> running ext4 on my box.
>
> It's not just ext4.  It's most any file system with barriers
> enabled--because that slows write speeds to platter write speeds (it
> completely disables disk cache (in software /and/ hardware) for writes).
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://www.mythtv.org/mailman/listinfo/mythtv-users
[prev in list] [next in list] [prev in thread] [next in thread]