MySQL 8.1 Release Notes
MySQL 8.1.0 Source Code Documentation
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 8.1.
The following system variables, status variables, and server options have been added in MySQL 8.1.
Audit_log_direct_writes: Number of direct writes to the audit log file. Added in MySQL 8.1.0.Gr_all_consensus_proposals_count: Sum of all proposals that were initiated and terminated in this node. Added in MySQL 8.1.0.Gr_all_consensus_time_sum: The sum of elapsed time of all consensus rounds started and finished in this node. Togheter with count_all_consensus_proposals, we can identify if the individual consensus time has a trend of going up, thus signaling a possible problem. Added in MySQL 8.1.0.Gr_certification_garbage_collector_count: Number of times certification garbage collection did run. Added in MySQL 8.1.0.Gr_certification_garbage_collector_time_sum: Sum of the time in micro-seconds that certification garbage collection runs took. Added in MySQL 8.1.0.Gr_consensus_bytes_received_sum: The sum of all socket-level bytes that were received to from group nodes having as a destination this node. Added in MySQL 8.1.0.Gr_consensus_bytes_sent_sum: Sum of all socket-level bytes that were sent to all group nodes originating on this node. Socket-level bytes mean that we will report more data here than in the sent messages, because they are multiplexed and sent to each member. As an example, if we have a group with 3 members and we send a 100 bytes message, this value will account for 300 bytes, since we send 100 bytes to each node. Added in MySQL 8.1.0.Gr_control_messages_sent_bytes_sum: Sum of bytes of control messages sent by this member. The size is the on-the-wire size. Added in MySQL 8.1.0.Gr_control_messages_sent_count: Number of control messages sent by this member. Added in MySQL 8.1.0.Gr_control_messages_sent_roundtrip_time_sum: Sum of the roundtrip time in micro-seconds of control messages sent by this member. The time is measured between the send and the delivery of the message on the sender member. This time will measure the time between the send and the delivery of the message on the majority of the members of the group (that includes the sender). Added in MySQL 8.1.0.Gr_data_messages_sent_bytes_sum: Sum of bytes of data messages sent by this member. The size is the on-the-wire size. Added in MySQL 8.1.0.Gr_data_messages_sent_count: Number of data messages sent by this member. Counts the number of transaction data messages sent. Added in MySQL 8.1.0.Gr_data_messages_sent_roundtrip_time_sum: Sum of the roundtrip time in micro-seconds of data messages sent by this member. The time is measured between the send and the delivery of the message on the sender member. This time will measure the time between the send and the delivery of the message on the majority of the members of the group (that includes the sender). Added in MySQL 8.1.0.Gr_empty_consensus_proposals_count: Sum of all empty proposal rounds that were initiated and terminated in this node. Added in MySQL 8.1.0.Gr_extended_consensus_count: The number of full 3-Phase PAXOS that this node initiated. If this number grows, it means that at least of the node is having issues answering to Proposals, either by slowliness or network issues. Use togheter with count_member_failure_suspicions to try and do some diagnose. Added in MySQL 8.1.0.Gr_last_consensus_end_timestamp: The time in which our last consensus proposal was approved. Reported in a timestamp format. This is an indicator if the group is halted or making slow progress. Added in MySQL 8.1.0.Gr_total_messages_sent_count: The number of high-level messages that this node sent to the group. These messages are the ones the we receive via the API to be proposed to the group. XCom has a batching mechanism, that will gather these messages and propose them all togheter. This will acocunt the number of message before being batched. Added in MySQL 8.1.0.Gr_transactions_consistency_after_sync_count: Number of transactions on secondaries that waited to start, while waiting for transactions from the primary with group_replication_consistency= AFTER and BEFORE_AND_AFTER to be committed. Added in MySQL 8.1.0.Gr_transactions_consistency_after_sync_time_sum: Sum of the time in micro-seconds that transactions on secondaries waited to start, while waiting for transactions from the primary with group_replication_consistency= AFTER and BEFORE_AND_AFTER to be committed. Added in MySQL 8.1.0.Gr_transactions_consistency_after_termination_count: Number of transactions executed with group_replication_consistency= AFTER and BEFORE_AND_AFTER. Added in MySQL 8.1.0.Gr_transactions_consistency_after_termination_time_sum: Sum of the time in micro-seconds spent between the delivery of the transaction executed with group_replication_consistency=AFTER and BEFORE_AND_AFTER, and the acknowledge of the other group members that the transaction is prepared. It does not include the transaction send roundtrip time. Added in MySQL 8.1.0.Gr_transactions_consistency_before_begin_count: Number of transactions executed with group_replication_consistency= BEFORE and BEFORE_AND_AFTER. Added in MySQL 8.1.0.Gr_transactions_consistency_before_begin_time_sum: Sum of the time in micro-seconds that the member waited until its group_replication_applier channel was consumed before execute the transaction with group_replication_consistency= BEFORE and BEFORE_AND_AFTER. Added in MySQL 8.1.0.Tls_sni_server_name: Server name supplied by the client. Added in MySQL 8.1.0.authentication_ldap_sasl_connect_timeout: SASL-Based LDAP server connection timeout. Added in MySQL 8.1.0.authentication_ldap_sasl_response_timeout: Simple LDAP server response timeout. Added in MySQL 8.1.0.authentication_ldap_simple_connect_timeout: Simple LDAP server connection timeout. Added in MySQL 8.1.0.authentication_ldap_simple_response_timeout: Simple LDAP server response timeout. Added in MySQL 8.1.0.telemetry.otel_bsp_max_export_batch_size: Maximum batch size. Added in MySQL 8.1.0.telemetry.otel_bsp_max_queue_size: Maximum queue size. Added in MySQL 8.1.0.telemetry.otel_bsp_schedule_delay: Delay interval between two consecutive exports in milliseconds. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_certificates: Unused at this time.. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_client_certificates: Unused at this time.. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_client_key: Unused at this time.. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_compression: Compression used by exporter. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_endpoint: Target URL to which the exporter sends traces. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_headers: Key-value pairs to be used as headers associated with HTTP requests. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_protocol: OTLP transport protocol. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_timeout: Time OLTP exporter waits for each batch export. Added in MySQL 8.1.0.telemetry.otel_log_level: Controls which opentelemetry logs are printed in the server logs (Linux only). Added in MySQL 8.1.0.telemetry.otel_resource_attributes: See corresponding OpenTelemetry variable OTEL_RESOURCE_ATTRIBUTES.. Added in MySQL 8.1.0.telemetry.query_text_enabled: Controls whether the SQL query text is included in the trace (Linux only). Added in MySQL 8.1.0.telemetry.trace_enabled: Controls whether telemetry traces are collected or not (Linux only). Added in MySQL 8.1.0.tls_certificates_enforced_validation: Whether to validate server and CA certificates. Added in MySQL 8.1.0.
No system variables, status variables, or server options have been deprecated in MySQL 8.1.