Hi, lejeczek! On Dec 01, lejeczek 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.
It might, innodb-encryption-threads=4 means there are four threads that are encrypting your data in the background. On the other hand, you don't have innodb-encrypt-tables, so may be they don't. Do you use enable_encryption.preset config? Does the load disappear if you remove innodb-encryption-threads? Does the load disappear if you add innodb-encrypt-tables? Does the load disappear if you set innodb-encryption-rotation-iops to some low number (like 1)?
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.
A user-mode CPU load shouldn't really crash the system. Are you sure your hardware (e.g. RAM) is ok? Regards, Sergei Chief Architect MariaDB and security@mariadb.org