Hi lejeczek,

On Thu, Dec 1, 2016 at 6:41 PM, lejeczek <peljasz@yahoo.co.uk> 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