MySQL 9.2 Release Notes
This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL 9.2.
The following system variables, status variables, and server options have been added in MySQL 9.2.
Com_create_library: Count of CREATE LIBRARY statements. Added in MySQL 9.2.0.Com_drop_library: Count of DROP LIBRARY statements. Added in MySQL 9.2.0.Com_show_create_library: Count of SHOW CREATE LIBRARY statements. Added in MySQL 9.2.0.Count_hit_tmp_table_size: Number of in-memory to disk internal temp table conversions due to temp table size limit. Added in MySQL 9.1.0.Gr_flow_control_throttle_active_count: Number of sessions in which transactions are currently being throttled. Added in MySQL 9.1.0.Gr_flow_control_throttle_count: Number of transactions which have been throttled. Added in MySQL 9.1.0.Gr_flow_control_throttle_last_throttle_timestamp: Timestamp indicating when transaction was most recently throttled. Added in MySQL 9.1.0.Gr_flow_control_throttle_time_sum: Total amount of time transactions have been throttled. Added in MySQL 9.1.0.Performance_schema_logger_lost: Displays the number of logger instruments which failed to be created. Added in MySQL 9.1.0.Telemetry_logs_supported: Indicates whether the Telemetry Logs feature is compiled in. Added in MySQL 9.1.0.TempTable_count_hit_max_ram: Number of internal temp table conversions due to temptable_max_ram limit. Added in MySQL 9.1.0.authentication_openid_connect_configuration: Issuer list with corresponding public signing keys to validate the Identity token. Added in MySQL 9.1.0.connection_memory_status_limit: Maximum amount of memory that can be consumed by any one user connection before before incrementing Count_hit_query_past_connection_memory_status_limit. Added in MySQL 9.1.0.global_connection_memory_status_limit: Maximum amount of memory that can be consumed by all user connections before before incrementing Count_hit_query_past_global_connection_memory_status_limit. Added in MySQL 9.1.0.mle.memory_max: Maxmimum amount of memory available to MLE component. Added in MySQL 9.0.0.mle_heap_status: MLE component heap status. Added in MySQL 9.0.0.mle_languages_supported: Languages supported by MLE component. Added in MySQL 9.0.0.mle_memory_used: Percentage of available memory used by MLE component. Added in MySQL 9.0.0.mle_oom_errors: Total number of out-of-memory errors thrown by MLE stored programs, across all sessions. Added in MySQL 9.0.0.mle_sessions: Number of times MLE sessions were cleared using mle_session_reset(). Added in MySQL 9.0.0.mle_sessions: Current number of active MLE sessions. Added in MySQL 9.0.0.mle_sessions: Maximum number of MLE sessions simultaneously active at any point in time since component was enabled.. Added in MySQL 9.0.0.mle_status: MLE component status. Added in MySQL 9.0.0.mle_stored_functions: Number of MLE stored functions currently cached across all sessions.. Added in MySQL 9.0.0.mle_stored_procedures: Number of MLE stored procedures currently cached across all sessions.. Added in MySQL 9.0.0.mle_stored_program_bytes_max: Size of largest MLE stored program, in bytes. Added in MySQL 9.0.0.mle_stored_program_sql_max: Maximum number of SQL statements executed by any MLE stored program. Added in MySQL 9.0.0.mle_stored_programs: Number of MLE stored programs currently cached across all sessions.. Added in MySQL 9.0.0.mle_threads: Number of threads currently used by MLE. Added in MySQL 9.0.0.mle_threads_max: Maximum number of threads used by MLE at any given time since it became active. Added in MySQL 9.0.0.option_tracker.gr_complete_table_received: Number of complete tables received. Added in MySQL 9.1.0.option_tracker.gr_complete_table_sent: Number of complete tables sent. Added in MySQL 9.1.0.option_tracker.gr_error_received: Number of errors received. Added in MySQL 9.1.0.option_tracker.gr_error_sent: Number of errors sent. Added in MySQL 9.1.0.option_tracker.gr_reset_request_received: Number of reset requests received. Added in MySQL 9.1.0.option_tracker.gr_reset_request_sent: Number of reset requests sent. Added in MySQL 9.1.0.option_tracker.gr_single_row_received: Number of single rows received. Added in MySQL 9.1.0.option_tracker.gr_single_row_sent: Number of single rows sent. Added in MySQL 9.1.0.performance-schema-logger: Configure Performance Schema logger instruments. Added in MySQL 9.1.0.performance_schema_max_logger_classes: Defines the maximum number of logger client instruments which can be created. Added in MySQL 9.1.0.telemetry.log_enabled: Defines whether Telemetry logs are collected. Added in MySQL 9.1.0.telemetry.otel_blrp_max_export_batch_size: Maximum batch size. Added in MySQL 9.1.0.telemetry.otel_blrp_max_queue_size: Maximum queue size. Added in MySQL 9.1.0.telemetry.otel_blrp_schedule_delay: Delay interval between two consecutive exports in milliseconds. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_certificates: Defines the certificate/chain trust to use when verifying a server’s TLS credentials. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_cipher: Current list of approved TLS 1.2 ciphers to use for logs. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_cipher_suite: TLS cipher to use for logs (TLS 1.3). Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_client_certificates: Defines the certificate/chain trust for clients private key to use in mTLS communication in PEM format. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_client_key: Defines the client's private key to use in mTLS communication in PEM format. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_compression: Compression used by exporter. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_endpoint: Defines the endpoint URL for log data only, with an optionally-specified port number. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_headers: Key-value pairs to be used as headers associated with HTTP requests. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_max_tls: Maximum TLS version to use for logs. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_min_tls: Minimum TLS version to use for logs. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_protocol: Defines the OTLP transport protocol to use for log data. Added in MySQL 9.1.0.telemetry.otel_exporter_otlp_logs_timeout: Time OLTP exporter waits for each batch export. Added in MySQL 9.1.0.
The following system variables, status variables, and options have been deprecated in MySQL 9.2.
version_tokens_session: Client token list for Version Tokens. Deprecated in MySQL 9.2.0.version_tokens_session_number: For internal use. Deprecated in MySQL 9.2.0.
The following system variables, status variables, and options have been removed in MySQL 9.2.