Details
-
Suggestion
-
Resolution: Unresolved
-
None
-
None
-
1
-
Description
MySQL 5.7 uses optimizer switch called "derived_merge" which was introduced and enabled by default in MySQL 5.7 - https://mysqlserverteam.com/derived-tables-in-mysql-5-7.
Confluence is affected by a known bug CONFSERVER-54984 which occurs when using MySQL 5.7 and when derived_merge feature is enabled.
Feature request:
Add following warning to "Database Setup For MySQL" documentation (https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html )
Using Confluence with MySQL 5.7 might lead to known performance problems due to known Confluence bug = see CONFSERVER-54984 for more details and possible workarounds.