Bug #77734 disabled_storage_engines should be dynamic

• Submitted: 15 Jul 2015 16:18
• Modified: 22 Jul 2015 6:50
• Reporter: Morgan Tocker
• Status: Verified
• Category: MySQL Server: Options
• Severity: S4 (Feature request)
• Version: 5.7.8
• OS: Any
• CPU Architecture: Any

[15 Jul 2015 16:18] Morgan Tocker

Description:
The new setting disabled_storage_engines can only be set as a configuration setting at startup.

As a DBA, I may discover that MyISAM has accidentally been introduced, and want to turn on 'disable mode' without requiring a server restart.  Currently I can not.

How to repeat:
mysql> set global disabled_storage_engines='myisam';
ERROR 1238 (HY000): Variable 'disabled_storage_engines' is a read only variable

Suggested fix:
Make it dynamic!

[22 Jul 2015 6:50] MySQL Verification Team

Hello Morgan,

Thank you for the feature request!

Thanks,
Umesh