maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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@xxxxxxxxxxx