[mythtv-users] mysql 100% cpu since upgrading to fedora 22 and mythtv-0.27.4 from git

[Jerry]

On Sat, Jun 6, 2015 at 5:01 AM, Udo van den Heuvel <udovdh at xs4all.nl> wrote:

> On 2015-06-03 16:12, Udo van den Heuvel wrote:
> >> Did you follow the mariadb upgrade steps in the
> >> mariadb release notes?
> >
> > Yes, I did. Twice.
> > But the CPU issue remained.
>
> Well, after reading https://github.com/omega8cc/boa/issues/423 I set
> innodb_buffer_pool_size=5M. No change.
> Then I tried innodb_buffer_pool_size=25M.
> Much better!
> I do not yet know the ideal size but the high load is gone.
>
> Tips for setting the correct value are welcome.
>
>
I would have said something much earlier if I knew this was your problem.
Before I made the changes on the wiki, mythfilldatabase was taking a very
long time.  After making those changes, there was a huge difference.

https://www.mythtv.org/wiki/Tune_MySQL

I created /etc/my.cnf.d/mythtv.cnf with the changes listed above and this
seems to have fixed things.  After that, I ran the mysqltuner.pl script and
made the suggested changes.

Good luck.  I hope that helps.  Kudos to whoever made that wiki page!

Jerry
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150606/933304c5/attachment.html>