Comments - High CPU usage when TDE is enabled
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
innodb_encryption_rotation_iops is the number of IOPs of the storage allocated to the encryption threads. If you don't have 2000 IOPs available then this can cause excess CPU use.
Also if you don't have sufficient innodb_buffer_pool_size for your active working set of data then a lot of CPU will be used decrypting the recently read data from disk.
Look at the SHOW GLOBAL STATUS LIKE 'innodb_buffer_pool%' status variables and others related to encryption and also calculate the number of IOPs available on your storage.
Hi Daniel,
I really couldn't determine the what is a normal amount of IOPS, from my findings the InnoDB buffer pool seems to be in a normal state, the disk usage isn't that high but there is a lot of writing while the application has almost no users on it. All these writings are being made by the application in a 'idle' state.
I've attached an updated on the changes that I've made, and also attached all the screenshots that you might find useful.
Really appreciate your help :)