Skip to:
I have mysql with 3 undo logs, but truncation is not working.
I enabled innodb_undo_log_truncate, decreased innodb_purge_rseg_truncate_frequency to 32
show global variables like '%undo%'
innodb_max_undo_log_size 1073741824innodb_undo_directory /data/mysql/innodb_undo_log_truncate ONinnodb_undo_logs 128innodb_undo_tablespaces 3
show global variables like '%truncate%'
innodb_purge_rseg_truncate_frequency 32innodb_undo_log_truncate ON
Executing show engine innodb status doesn't show any long running rollback transaction.
But my undo logs keep growing.
root@server:/data/mysql# du -h -c undo00*598G undo001747G undo002346G undo003
Ubuntu 16.04.1 LTS
Hi
Thank you for the update.
Hi Lalit,
i found the culprit.
trx_rseg_history_len was very higher, so i reduced the load of server with innodb_max_purge_lag greater than 0 and waited the history purged.
Thank you for the report.
can send error log entries as well for review. If it's adding any message for undo trucation.
I have mysql with 3 undo logs, but truncation is not working.
I enabled innodb_undo_log_truncate, decreased innodb_purge_rseg_truncate_frequency to 32
show global variables like '%undo%'
innodb_max_undo_log_size 1073741824
innodb_undo_directory /data/mysql/
innodb_undo_log_truncate ON
innodb_undo_logs 128
innodb_undo_tablespaces 3
show global variables like '%truncate%'
innodb_purge_rseg_truncate_frequency 32
innodb_undo_log_truncate ON
Executing show engine innodb status doesn't show any long running rollback transaction.
But my undo logs keep growing.
root@server:/data/mysql# du -h -c undo00*
598G undo001
747G undo002
346G undo003