MySQL 9.2 Release Notes
To be shown in the mysql_option.option_usage
and mysql_option tables, a component
or plugin must be written and compiled with support for the Option
Tracker. Components and plugins providing such support in MySQL
9.2 include those shown in the following table:
Table 7.8 Components and Plugins with Option Tracker Support
| Name | Container | Enabled | Incremented |
|---|---|---|---|
| AWS keyring plugin | keyring_aws plugin | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
| Binary Log | mysql_server | When binary logging is enabled (that is, when
--log-bin is set) | Every 10 minutes when enabled |
| Connection DoS control | connection_control plugin | When
connection_control_failed_connections_threshold
!= 0 | When a failed connection attempt is delayed |
| Encrypted File keyring | component_keyring_encrypted_file | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
| Enterprise AUDIT | audit_log plugin | audit_log_disable = OFF | When any of this plugin's functions are called, or a new audit output file is opened for writing |
| Enterprise Data Masking | component_masking | always | When any of this component's functions are called |
| Enterprise Encryption | component_enterprise_encryption | always | When any of this component's functions are called |
| Enterprise Firewall | firewall plugin | When mysql_firewall_mode = ON | When any of this plugin's administrative functions (see MySQL Enterprise Firewall Administrative Functions) are called, or a statement is added, flagged, or rejected |
| Enterprise Thread Pool | thread_pool plugin | always | When the plugin is initialized, or a new connection added |
| File keyring | component_keyring_file | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
| Group Replication | group_replication plugin | When Group Replication is running | Every 10 minutes while the plugin is enabled; whenever the plugin is
enabled or disabled; when the plugin sets
read_only off on
promotion to group primary |
| Hashicorp keyring | keyring_hashicoprp plugin | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
| Hypergraph Optimizer | mysql_server | When server is compiled with hypergraph optimizer support (MySQL HeatWave only) | When a connection is opened with the hypergraph optimizer as the default for the connection |
| HyperLogLog | component_hll | always | Whenever the HLL() aggregate function
(MySQL HeatWave only) is called |
| JavaScript Library | component:mle | always | Whenever a JavaScript library is created, dropped, or used |
| JavaScript Stored Program | component:mle | always | Whenever a JavaScript stored program is invoked |
| Kerberos authentication | authentication_kerberos plugin | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
| LDAP Simple authentication | authentication_ldap_simple plugin | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
| MySQL Server | mysql_server | always | Every 10 minutes |
| MySQL Telemetry | component_telemetry | always | Every 1000th time that traces, logs, or metrics are exported |
| OCI Authentication | authentication_oci plugin | always | When any of this plugin's functions are called |
| Oracle Key Vault keyring | keyring_okv plugin | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
| PAM authentication | authentication_pam plugin | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
| Password validation | component_validate_password | always | Whenever passwords are evaluated for strength, validated, or changed using this component |
| Replication Replica | mysql_server | When server acts as replica (at least one channel) | Every 10 minutes whenever replication is enabled; each time a secondary is reset or the primary is changed |
| SASL LDAP Authentication | authentication_ldap_sasl plugin | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
| Scheduler | component_scheduler | always | Whenever a scheduled task is created, run, or deleted |
| Traditional MySQL Optimizer | mysql_server | always | Whenever a connection is opened with the traditional optimizer as the default for the connection |
| Vector | component_vector | always | Whenever the DISTANCE() function (or its
alias
VECTOR_DISTANCE())
is called (MySQL HeatWave only) |
| WebauthN authentication | authentication_webauth plugin | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
| Windows authentication | authentication_windows plugin | always | When any of the general-purpose keyring functions (see Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”) are called using this component |
The component name displayed in the table's
Name column is the value shown by
the OPTION_NAME column of the
mysql_option.option_usage table (see
Section 7.5.8.1, “Option Tracker Tables”) and the
OPTION_NAME column of the Performance Schema
mysql_option table. The name of the Option
Tracker status variable (usage counter) associated with this
component is formed by prefixing this value with
option_tracker_usage:.
The name shown in the table'
Container column is the value
displayed in the
performance_schema.mysql_option
table's OPTION_CONTAINER column.
The Enabled column shows the conditions under which the component is enabled.
The Incremented column shows what events or actions cause this component's usage counter to be increased.
Note
Enterprise Data Masking was previously known as Enterprise Data Masking and Deidentification.