Undo log file is growing as high as 400 GB but innodb_max_undo_log_size is 1 GB
Out of the 2 undo log files ,the size of one of the file is growing as high as 400 GB. The parameters for undo log truncation as already set as below.
mysql> show variables like '%undo%';
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| innodb_max_undo_log_size | 1073741824 |
| innodb_undo_directory | ./ |
| innodb_undo_log_encrypt | OFF |
| innodb_undo_log_truncate | ON |
| innodb_undo_tablespaces | 2 |
+--------------------------+------------+
Mysql version : 8.0.17
Why is this happening.?
How can we purge out the size taken file ?
0