29.12.22.6 The mysql_option Table

The mysql_option table provides information about options available in the MySQL Server, or in components and plugins that are currently or previously have been installed:

+-------------------------------+----------------+---------------------+
| OPTION_NAME                   | OPTION_ENABLED | OPTION_CONTAINER    |
+-------------------------------+----------------+---------------------+
| Enterprise AUDIT              | TRUE           | audit_log plugin    |
| JavaScript Stored Program     | TRUE           | component:mle       |
| MySQL Server                  | TRUE           | mysql_server        |
| scheduler                     | TRUE           | component_scheduler |
| test_option_tracker component | TRUE           | test_option_tracker |
| Vector                        | TRUE           | component_vector    |
+-------------------------------+----------------+---------------------+

(An “option” in this context refers to a feature of the server, component, or plugin, and not to a command-line option such as those used with mysqld or other MySQL programs.)

This table is installed by the Option Tracker component, available with MySQL Enterprise Edition; for more information about the component, see Section 7.5.9, “Option Tracker Component”.

To be shown in this table, a component or plugin must be written and compiled with support for the Option Tracker component. Not all MySQL components and plugins currently available provide such support. See Section 7.5.9.2, “Option Tracker Supported Components”, for a list of those which support the Option Tracker.

The mysql_option table has the following columns:

• OPTION_NAME

  The name of the option or feature, or MySQL Server, as appropriate.

• OPTION_ENABLED

  Whether the option or feature is currently enabled. This value is always one of TRUE or FALSE.

• OPTION_CONTAINER

  The name of the option or feature. For the MySQL server, this is mysql_server.

This table is read-only, and cannot be truncated, although it is updated by the functions described in Section 7.5.9.4, “Option Tracker Functions”.

Usage data for options and features listed in mysql_option can be found in the mysql_option.option_usage table, which is described in Section 7.5.9.1, “Option Tracker Tables”.