When you use SHOW VARIABLES LIKE “have_%” to see whether a particular feature is enabled, you will note the value of NO for some, and DISABLED for others. These values are not intrinsically clear for the casual onlooker, and often cause confusion. Typically, this happens with SSL and InnoDB. So, here is a quick clarification!
- NO means that the feature was not enabled (or was actively disabled) in the build. This means the code and any required libraries are not present in the binary.
- DISABLED means that the feature is built in and capable of working in the binary, but is disabled due to relevant my.cnf settings.
- YES means the feature is available, and configured in my.cnf.
SSL tends to show up as DISABLED, until you configure the appropriate settings to use it …
[Read more]