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

[Udo van den Heuvel]

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.


Udo