After upgrading from mysql 5.6 to 5.7 appeared and despite innodb_max_undo_log_size = 50M in the config after a few hours takes up all the free space on the server. How can this be fixed?

  • one
    In ibtmp1 are temporary tables, not a transaction log. Apparently its maximum size can not be limited. We need to look from where in the system so many temporary tables and data in them - Mike
  • at 5.6 this was not, but it was much slower. - Magi
  • one
    By default, the variable innodb_temp_data_file_path = ibtmp1: 12M: autoextend is as follows. Removed: autoextend ibtmp1 has stopped increasing. - Magi

1 answer 1

Reply from comments

The ibtmp1 file contains temporary tables, not a transaction log. It is necessary to look from where in the system so many temporary tables and data in them.

By default, the innodb_temp_data_file_path directive takes the following value

 innodb_temp_data_file_path = ibtmp1:12M:autoextend

Removed :autoextend and ibtmp1 file ceased to grow.

  • On Ubuntu, this setting can be added to the configuration mysql /etc/mysql/mysql.conf.d/mysqld.cnf - vjweb