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 [email protected] _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
