content_image/667603.jpg content_image/667604.jpg content_image/667605.jpg
• innodb_undo_log_encrypt 

<img src='content_image/667603.jpg'>

Controls encryption of undo log data for tables encrypted using the InnoDB  data-at-rest encryption feature. Only applies to undo logs that reside in separate undo tablespaces. See Section 15.6.3.4, “Undo Tablespaces” . Encryption is not supported for undo log data that resides in the system tablespace. For more information, see Undo Log Encryption. 

• innodb_undo_log_truncate 

<img src='content_image/667604.jpg'>

When enabled, undo tablespaces that exceed the threshold value defined by innodb_max_undo_log_size  are marked for truncation. Only undo tablespaces can be truncated. Truncating undo logs that reside in the system tablespace is not supported. For truncation to occur, there must be at least two undo tablespaces. 

The innodb_purge_rseg_truncate_frequency  variable can be used to expedite truncation of undo tablespaces. 

For more information, see Truncating Undo Tablespaces. 

• innodb_undo_tablespaces 

<img src='content_image/667605.jpg'>

