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

[Gary Buhrmaster]

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.