Bug #90031 Deprecated option in Options File: innodb_additional_mem_pool_size
Submitted: 12 Mar 2018 18:25 Modified: 13 Mar 2018 19:02
Reporter: Shem Sargent Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:6.3.10 OS:Any
Assigned to: CPU Architecture:Any

[12 Mar 2018 18:25] Shem Sargent
Description:
If innodb_additional_mem_pool_size is added to the Options File for a recent MySQL version, MySQL fails to start with a related error.

How to repeat:
Install MySQL 5.7.21, connect with MySQL Workbench 6.3.10, navigate to Management, Instance, Options File, InnoDB tab, Memory section. Check innodb_additional_mem_pool_size and enter a value like '32M'. Apply change, restart MySQL. MySQL fails to start with an error in the log:
[ERROR] unknown variable 'innodb_additional_mem_pool_size=32M'

Suggested fix:
It would be helpful if this option was removed from the Options File interface when MySQL workbench detects a MySQL version that does not support this option. According to the MySQL documentation, this option was removed in 5.7.4.
[12 Mar 2018 22:21] MySQL Verification Team
Thank you for the bug report. Please attach (use Files tab for) a screenshot of innodb_additional_mem_pool_size in InnoDB->memory section, I couldn't find in Windows 10 Pro. Thanks in advance.
[13 Mar 2018 19:02] Shem Sargent
Thanks for the quick response. I can no longer find that option in the interface either. Not sure what changed, but I'll close this issue and not trouble you further unless I can recreate it at a later time.