Starting with MySQL 8.0.30 Parameter innodb_log_file_size is deprecated

XMLWordPrintable

      Problem

      The following Warning messages are displayed in the MySQL logs due to the deprecated innodb_log_file_size parameter configured in the my.cnf/my.ini file according to connecting-jira-to-mysql-8-0

      2022-11-15T12:47:31.336458Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=4294967296. Please use innodb_redo_log_capacity instead

      Suggested Solution

      As innodb_log_file_size parameter is deprecated with  MySQL 8.0.30  (MySQL documentation ) it is recommended to use the  innodb_redo_log_capacity and update the documentation with the new reference for 8.0.30 connecting-jira-to-mysql-8-0 with the new configuration.

      innodb_redo_log_capacity should be configured to  4 GB ( by default innodb_log_files_in_group is 2   and innodb_log_file_size is set to be 2GB )

      innodb_redo_log_capacity= (innodb_log_files_in_group*innodb_log_file_size)

      Why This Is Important

       

      Workaround

       

       

            Assignee:
            Daria Shatsylo (Inactive)
            Reporter:
            Deepak R
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: