maria-discuss team mailing list archive

[Claudio Nanni <claudio.nanni@xxxxxxxxxxx>]

Hi lejeczek,

On Thu, Dec 1, 2016 at 6:41 PM, lejeczek <peljasz@xxxxxxxxxxx> wrote:

> hi everyone
>
> I'm having a peculiar situation, a problem here with my config, which
> config is pretty galera-vanilla.
> Namely, if I set these:
>
> plugin-load-add = file_key_management.so
> file-key-management
> file-key-management-filename = /var/lib/mysql/.keys.txt
> innodb_file_per_table = 1
> innodb-encrypt-log
> innodb-encryption-threads = 4     <= # this ! one here
>
> I get constant load on four cores, it would fluctuate just under %400 CPU
> (24*7). I'd assume that innodb-encryption-threads value causes it, and
> whatever the value might be it will be reflected in CPU usage.
> I wonder if you too see it.
> I my case I think it does something more to one system, it crashes the
> bloody thing to the extent where cold reboot is needed.
>
> MariaDB-client-10.1.19-1.el7.centos.x86_64
> MariaDB-shared-10.1.19-1.el7.centos.x86_64
> MariaDB-common-10.1.19-1.el7.centos.x86_64
> MariaDB-server-10.1.19-1.el7.centos.x86_64
>
>
You might be affected by:

https://jira.mariadb.org/browse/MDEV-10368

It should have been fixed or at least greatly improved in 10.1.20.

According to some basic testing of mine the cpu load is gone on 10.1.20 and
multiple encryption threads.


Best regards

Claudio