[mythtv-users] 0.25 SQL CPU Load issues after optimisation

Another Sillyname anothersname at googlemail.com
Tue Jul 17 23:05:41 UTC 2012


On 18 July 2012 00:01, Gary Buhrmaster <gary.buhrmaster at gmail.com> wrote:
> On Tue, Jul 17, 2012 at 10:48 PM, Another Sillyname
> <anothersname at googlemail.com> wrote:
> ....
>> I am running ext4 and noticed from a previous comment on this problems
>> that ext4 barriers could be an issue but couldn't find anything
>> explanatory in the mailing list archives to explain this.
>
> In my experience, ext4 barriers usually manifest themselves are disk I/O
> wait, and not high CPU usage (mysql is actually waiting a lot).
>
> If you are using innodb tables (which is possible if you rebuilt your system
> with a newer mysql server) you should review the recommendations at:
>    http://www.mythtv.org/wiki/Tune_MySQL
> Regardless of whether they help this particular issue, they will
> help overall performance in the long run.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users

Thanks Gary but I'd already done that, I've been looking at this for 3
days now and as a number of people seem to have experienced this
problem without a clearly defined problem/solution I though it would
be useful to try to get some expert focus on it which means not me.


More information about the mythtv-users mailing list