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.1.
The following system variables, status variables, and server options have been added in MySQL 9.1.
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.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.
No system variables, status variables, or server options have been deprecated in MySQL 9.1.