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
- Mentioned in
- mentioned in
-
Page Failed to load
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[JSWSERVER-21544] Starting with MySQL 8.0.30 Parameter innodb_log_file_size is deprecated
Just moved a Confluence 7.19.4 instance from CentOS 6/MySQL 5.7 to Ubuntu 22.04/MySQL 8.0.31, and got the same message. I did set
innodb_redo_log_capacity=4GB
Thank you for bringing this up!
The document is will be fixed for version 8.20 and later.
If you have an issue with connecting Confluence to MySQL, please create a ticket for this document: https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html
Feel free to leave your comments here if there's anything else we can help with.