Oracle Cloud Infrastructure v2.33.0, May 1 25

Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi

oci.Mysql.getMysqlConfigurations

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testMysqlConfigurations = oci.Mysql.getMysqlConfigurations({
    compartmentId: compartmentId,
    configurationId: mysqlConfigurationId,
    displayName: mysqlConfigurationDisplayName,
    shapeName: mysqlShapeName,
    state: mysqlConfigurationState,
    types: mysqlConfigurationType,
});

import pulumi
import pulumi_oci as oci

test_mysql_configurations = oci.Mysql.get_mysql_configurations(compartment_id=compartment_id,
    configuration_id=mysql_configuration_id,
    display_name=mysql_configuration_display_name,
    shape_name=mysql_shape_name,
    state=mysql_configuration_state,
    types=mysql_configuration_type)

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/mysql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := mysql.GetMysqlConfigurations(ctx, &mysql.GetMysqlConfigurationsArgs{
			CompartmentId:   compartmentId,
			ConfigurationId: pulumi.StringRef(mysqlConfigurationId),
			DisplayName:     pulumi.StringRef(mysqlConfigurationDisplayName),
			ShapeName:       pulumi.StringRef(mysqlShapeName),
			State:           pulumi.StringRef(mysqlConfigurationState),
			Types:           mysqlConfigurationType,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testMysqlConfigurations = Oci.Mysql.GetMysqlConfigurations.Invoke(new()
    {
        CompartmentId = compartmentId,
        ConfigurationId = mysqlConfigurationId,
        DisplayName = mysqlConfigurationDisplayName,
        ShapeName = mysqlShapeName,
        State = mysqlConfigurationState,
        Types = mysqlConfigurationType,
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Mysql.MysqlFunctions;
import com.pulumi.oci.Mysql.inputs.GetMysqlConfigurationsArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testMysqlConfigurations = MysqlFunctions.getMysqlConfigurations(GetMysqlConfigurationsArgs.builder()
            .compartmentId(compartmentId)
            .configurationId(mysqlConfigurationId)
            .displayName(mysqlConfigurationDisplayName)
            .shapeName(mysqlShapeName)
            .state(mysqlConfigurationState)
            .types(mysqlConfigurationType)
            .build());

    }
}

variables:
  testMysqlConfigurations:
    fn::invoke:
      function: oci:Mysql:getMysqlConfigurations
      arguments:
        compartmentId: ${compartmentId}
        configurationId: ${mysqlConfigurationId}
        displayName: ${mysqlConfigurationDisplayName}
        shapeName: ${mysqlShapeName}
        state: ${mysqlConfigurationState}
        types: ${mysqlConfigurationType}

Using getMysqlConfigurations

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getMysqlConfigurations(args: GetMysqlConfigurationsArgs, opts?: InvokeOptions): Promise<GetMysqlConfigurationsResult>
function getMysqlConfigurationsOutput(args: GetMysqlConfigurationsOutputArgs, opts?: InvokeOptions): Output<GetMysqlConfigurationsResult>

def get_mysql_configurations(compartment_id: Optional[str] = None,
                             configuration_id: Optional[str] = None,
                             display_name: Optional[str] = None,
                             filters: Optional[Sequence[GetMysqlConfigurationsFilter]] = None,
                             shape_name: Optional[str] = None,
                             state: Optional[str] = None,
                             types: Optional[Sequence[str]] = None,
                             opts: Optional[InvokeOptions] = None) -> GetMysqlConfigurationsResult
def get_mysql_configurations_output(compartment_id: Optional[pulumi.Input[str]] = None,
                             configuration_id: Optional[pulumi.Input[str]] = None,
                             display_name: Optional[pulumi.Input[str]] = None,
                             filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetMysqlConfigurationsFilterArgs]]]] = None,
                             shape_name: Optional[pulumi.Input[str]] = None,
                             state: Optional[pulumi.Input[str]] = None,
                             types: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                             opts: Optional[InvokeOptions] = None) -> Output[GetMysqlConfigurationsResult]

func GetMysqlConfigurations(ctx *Context, args *GetMysqlConfigurationsArgs, opts ...InvokeOption) (*GetMysqlConfigurationsResult, error)
func GetMysqlConfigurationsOutput(ctx *Context, args *GetMysqlConfigurationsOutputArgs, opts ...InvokeOption) GetMysqlConfigurationsResultOutput

> Note: This function is named GetMysqlConfigurations in the Go SDK.

public static class GetMysqlConfigurations 
{
    public static Task<GetMysqlConfigurationsResult> InvokeAsync(GetMysqlConfigurationsArgs args, InvokeOptions? opts = null)
    public static Output<GetMysqlConfigurationsResult> Invoke(GetMysqlConfigurationsInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetMysqlConfigurationsResult> getMysqlConfigurations(GetMysqlConfigurationsArgs args, InvokeOptions options)
public static Output<GetMysqlConfigurationsResult> getMysqlConfigurations(GetMysqlConfigurationsArgs args, InvokeOptions options)

fn::invoke:
  function: oci:Mysql/getMysqlConfigurations:getMysqlConfigurations
  arguments:
    # arguments dictionary

The following arguments are supported:

CompartmentId string: The compartment OCID.
ConfigurationId string: The requested Configuration instance.
DisplayName string: A filter to return only the resource matching the given display name exactly.
Filters List<GetMysqlConfigurationsFilter>
ShapeName string: The requested Shape name.
State string: Configuration Lifecycle State
Types List<string>: The requested Configuration types.

CompartmentId string: The compartment OCID.
ConfigurationId string: The requested Configuration instance.
DisplayName string: A filter to return only the resource matching the given display name exactly.
Filters []GetMysqlConfigurationsFilter
ShapeName string: The requested Shape name.
State string: Configuration Lifecycle State
Types []string: The requested Configuration types.

compartmentId String: The compartment OCID.
configurationId String: The requested Configuration instance.
displayName String: A filter to return only the resource matching the given display name exactly.
filters List<GetConfigurationsFilter>
shapeName String: The requested Shape name.
state String: Configuration Lifecycle State
types List<String>: The requested Configuration types.

compartmentId string: The compartment OCID.
configurationId string: The requested Configuration instance.
displayName string: A filter to return only the resource matching the given display name exactly.
filters GetMysqlConfigurationsFilter[]
shapeName string: The requested Shape name.
state string: Configuration Lifecycle State
types string[]: The requested Configuration types.

compartment_id str: The compartment OCID.
configuration_id str: The requested Configuration instance.
display_name str: A filter to return only the resource matching the given display name exactly.
filters Sequence[GetMysqlConfigurationsFilter]
shape_name str: The requested Shape name.
state str: Configuration Lifecycle State
types Sequence[str]: The requested Configuration types.

compartmentId String: The compartment OCID.
configurationId String: The requested Configuration instance.
displayName String: A filter to return only the resource matching the given display name exactly.
filters List<Property Map>
shapeName String: The requested Shape name.
state String: Configuration Lifecycle State
types List<String>: The requested Configuration types.

getMysqlConfigurations Result

The following output properties are available:

CompartmentId string: OCID of the Compartment the Configuration exists in.
Configurations List<GetMysqlConfigurationsConfiguration>: The list of configurations.
Id string: The provider-assigned unique ID for this managed resource.
ConfigurationId string
DisplayName string: The display name of the Configuration.
Filters List<GetMysqlConfigurationsFilter>
ShapeName string: The name of the associated Shape.
State string: The current state of the Configuration.
Types List<string>: The Configuration type, DEFAULT or CUSTOM.

CompartmentId string: OCID of the Compartment the Configuration exists in.
Configurations []GetMysqlConfigurationsConfiguration: The list of configurations.
Id string: The provider-assigned unique ID for this managed resource.
ConfigurationId string
DisplayName string: The display name of the Configuration.
Filters []GetMysqlConfigurationsFilter
ShapeName string: The name of the associated Shape.
State string: The current state of the Configuration.
Types []string: The Configuration type, DEFAULT or CUSTOM.

compartmentId String: OCID of the Compartment the Configuration exists in.
configurations List<GetConfigurationsConfiguration>: The list of configurations.
id String: The provider-assigned unique ID for this managed resource.
configurationId String
displayName String: The display name of the Configuration.
filters List<GetConfigurationsFilter>
shapeName String: The name of the associated Shape.
state String: The current state of the Configuration.
types List<String>: The Configuration type, DEFAULT or CUSTOM.

compartmentId string: OCID of the Compartment the Configuration exists in.
configurations GetMysqlConfigurationsConfiguration[]: The list of configurations.
id string: The provider-assigned unique ID for this managed resource.
configurationId string
displayName string: The display name of the Configuration.
filters GetMysqlConfigurationsFilter[]
shapeName string: The name of the associated Shape.
state string: The current state of the Configuration.
types string[]: The Configuration type, DEFAULT or CUSTOM.

compartment_id str: OCID of the Compartment the Configuration exists in.
configurations Sequence[GetMysqlConfigurationsConfiguration]: The list of configurations.
id str: The provider-assigned unique ID for this managed resource.
configuration_id str
display_name str: The display name of the Configuration.
filters Sequence[GetMysqlConfigurationsFilter]
shape_name str: The name of the associated Shape.
state str: The current state of the Configuration.
types Sequence[str]: The Configuration type, DEFAULT or CUSTOM.

compartmentId String: OCID of the Compartment the Configuration exists in.
configurations List<Property Map>: The list of configurations.
id String: The provider-assigned unique ID for this managed resource.
configurationId String
displayName String: The display name of the Configuration.
filters List<Property Map>
shapeName String: The name of the associated Shape.
state String: The current state of the Configuration.
types List<String>: The Configuration type, DEFAULT or CUSTOM.

Supporting Types

GetMysqlConfigurationsConfiguration

CompartmentId string: The compartment OCID.
DefinedTags Dictionary<string, string>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
Description string: User-provided data about the Configuration.
DisplayName string: A filter to return only the resource matching the given display name exactly.
FreeformTags Dictionary<string, string>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
Id string: The OCID of the Configuration.
InitVariables List<GetMysqlConfigurationsConfigurationInitVariable>: User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
ParentConfigurationId string: The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.
ShapeName string: The requested Shape name.
State string: Configuration Lifecycle State
SystemTags Dictionary<string, string>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
TimeCreated string: The date and time the Configuration was created, as described by RFC 3339.
TimeUpdated string: The date and time the Configuration was last updated, as described by RFC 3339.
Type string: The requested Configuration types.
Variables List<GetMysqlConfigurationsConfigurationVariable>: User-defined service variables.

CompartmentId string: The compartment OCID.
DefinedTags map[string]string: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
Description string: User-provided data about the Configuration.
DisplayName string: A filter to return only the resource matching the given display name exactly.
FreeformTags map[string]string: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
Id string: The OCID of the Configuration.
InitVariables []GetMysqlConfigurationsConfigurationInitVariable: User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
ParentConfigurationId string: The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.
ShapeName string: The requested Shape name.
State string: Configuration Lifecycle State
SystemTags map[string]string: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
TimeCreated string: The date and time the Configuration was created, as described by RFC 3339.
TimeUpdated string: The date and time the Configuration was last updated, as described by RFC 3339.
Type string: The requested Configuration types.
Variables []GetMysqlConfigurationsConfigurationVariable: User-defined service variables.

compartmentId String: The compartment OCID.
definedTags Map<String,String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description String: User-provided data about the Configuration.
displayName String: A filter to return only the resource matching the given display name exactly.
freeformTags Map<String,String>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id String: The OCID of the Configuration.
initVariables List<GetConfigurationsConfigurationInitVariable>: User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
parentConfigurationId String: The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.
shapeName String: The requested Shape name.
state String: Configuration Lifecycle State
systemTags Map<String,String>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated String: The date and time the Configuration was created, as described by RFC 3339.
timeUpdated String: The date and time the Configuration was last updated, as described by RFC 3339.
type String: The requested Configuration types.
variables List<GetConfigurationsConfigurationVariable>: User-defined service variables.

compartmentId string: The compartment OCID.
definedTags {[key: string]: string}: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description string: User-provided data about the Configuration.
displayName string: A filter to return only the resource matching the given display name exactly.
freeformTags {[key: string]: string}: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id string: The OCID of the Configuration.
initVariables GetMysqlConfigurationsConfigurationInitVariable[]: User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
parentConfigurationId string: The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.
shapeName string: The requested Shape name.
state string: Configuration Lifecycle State
systemTags {[key: string]: string}: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated string: The date and time the Configuration was created, as described by RFC 3339.
timeUpdated string: The date and time the Configuration was last updated, as described by RFC 3339.
type string: The requested Configuration types.
variables GetMysqlConfigurationsConfigurationVariable[]: User-defined service variables.

compartment_id str: The compartment OCID.
defined_tags Mapping[str, str]: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description str: User-provided data about the Configuration.
display_name str: A filter to return only the resource matching the given display name exactly.
freeform_tags Mapping[str, str]: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id str: The OCID of the Configuration.
init_variables Sequence[GetMysqlConfigurationsConfigurationInitVariable]: User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
parent_configuration_id str: The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.
shape_name str: The requested Shape name.
state str: Configuration Lifecycle State
system_tags Mapping[str, str]: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
time_created str: The date and time the Configuration was created, as described by RFC 3339.
time_updated str: The date and time the Configuration was last updated, as described by RFC 3339.
type str: The requested Configuration types.
variables Sequence[GetMysqlConfigurationsConfigurationVariable]: User-defined service variables.

compartmentId String: The compartment OCID.
definedTags Map<String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description String: User-provided data about the Configuration.
displayName String: A filter to return only the resource matching the given display name exactly.
freeformTags Map<String>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id String: The OCID of the Configuration.
initVariables List<Property Map>: User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
parentConfigurationId String: The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.
shapeName String: The requested Shape name.
state String: Configuration Lifecycle State
systemTags Map<String>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated String: The date and time the Configuration was created, as described by RFC 3339.
timeUpdated String: The date and time the Configuration was last updated, as described by RFC 3339.
type String: The requested Configuration types.
variables List<Property Map>: User-defined service variables.

GetMysqlConfigurationsConfigurationInitVariable

LowerCaseTableNames string: Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

LowerCaseTableNames string: Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

lowerCaseTableNames String: Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

lowerCaseTableNames string: Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

lower_case_table_names str: Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

lowerCaseTableNames String: Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

GetMysqlConfigurationsConfigurationVariable

AutoIncrementIncrement int

auto_increment_increment and auto_increment_offset are intended for use with circular (source-to-source) replication, and can be used to control the operation of AUTO_INCREMENT columns. Both variables have global and session values, and each can assume an integer value between 1 and 65,535 inclusive.

AutoIncrementOffset int

This variable has a default value of 1. If it is left with its default value, and Group Replication is started on the server in multi-primary mode, it is changed to the server ID.

Autocommit bool

("autocommit")

BigTables bool

If enabled, the server stores all temporary tables on disk rather than in memory.

BinlogExpireLogsSeconds int

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

BinlogGroupCommitSyncDelay int

Controls how many microseconds the binary log commit waits before synchronizing the binary log file to disk. There is no delay by default. Setting this variable to a microsecond delay enables more transactions to be synchronized together to disk at once, reducing the overall time to commit a group of transactions because the larger groups required fewer time units per group.

BinlogGroupCommitSyncNoDelayCount int

The maximum number of transactions to wait for before aborting the current delay as specified by binlog_group_commit_sync_delay. If binlog_group_commit_sync_delay is set to 0, then this option has no effect.

BinlogRowMetadata string

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

BinlogRowValueOptions string

When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.

BinlogTransactionCompression bool

Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.

BlockEncryptionMode string

This variable controls the block encryption mode for block-based algorithms such as AES. It affects encryption for AES_ENCRYPT() and AES_DECRYPT(). block_encryption_mode takes a value in aes-keylen-mode format, where keylen is the key length in bits and mode is the encryption mode. The value is not case-sensitive. Permitted keylen values are 128, 192, and 256. Permitted mode values are ECB, CBC, CFB1, CFB8, CFB128, and OFB.

CharacterSetServer string

The server's default character set. If you set this variable, you should also set collation_server to specify the collation for the character set.

CollationServer string

The server's default collation.

CompletionType string

("completion_type")

ConnectTimeout int

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

ConnectionMemoryChunkSize int

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

ConnectionMemoryLimit string

Set the maximum amount of memory that can be used by a single user connection.

CteMaxRecursionDepth string

("cte_max_recursion_depth")

DefaultAuthenticationPlugin string

The default authentication plugin. This must be a plugin that uses internal credentials storage, so these values are permitted: mysql_native_password, sha256_password, caching_sha2_password.

ExplainFormat string

This variable determines the default output format used by EXPLAIN in the absence of a FORMAT option when displaying a query execution plan.

ExplicitDefaultsForTimestamp bool

This system variable determines whether the server enables certain nonstandard behaviors for default values and NULL-value handling in TIMESTAMP columns. By default, explicit_defaults_for_timestamp is enabled, which disables the nonstandard behaviors. Disabling explicit_defaults_for_timestamp results in a warning.

ForeignKeyChecks bool

("foreign_key_checks")

GeneratedRandomPasswordLength int

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

GlobalConnectionMemoryLimit string

Set the total amount of memory that can be used by all user connections.

GlobalConnectionMemoryTracking bool

Determines whether the MySQL server calculates Global_connection_memory.

GroupConcatMaxLen string

Specifies the maximum permitted result length in bytes for the GROUP_CONCAT() function.

GroupReplicationConsistency string

EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.

InformationSchemaStatsExpiry int

("information_schema_stats_expiry")

InnodbAdaptiveHashIndex bool

Whether the InnoDB adaptive hash index is enabled or disabled. It may be desirable, depending on your workload, to dynamically enable or disable adaptive hash indexing to improve query performance. Because the adaptive hash index may not be useful for all workloads, conduct benchmarks with it both enabled and disabled, using realistic workloads.

InnodbAutoincLockMode int

The lock mode to use for generating auto-increment values. Permissible values are 0, 1, or 2, for traditional, consecutive, or interleaved, respectively.

InnodbBufferPoolDumpPct int

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

InnodbBufferPoolInstances int

("innodb_buffer_pool_instances")

InnodbBufferPoolSize string

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

InnodbChangeBuffering string

Whether InnoDB performs change buffering, an optimization that delays write operations to secondary indexes so that the I/O operations can be performed sequentially. Permitted values are described in the following table. Values may also be specified numerically.

InnodbDdlBufferSize string

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

InnodbDdlThreads int

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

InnodbFtEnableStopword bool

("innodb_ft_enable_stopword")

InnodbFtMaxTokenSize int

("innodb_ft_max_token_size")

InnodbFtMinTokenSize int

("innodb_ft_min_token_size")

InnodbFtNumWordOptimize int

("innodb_ft_num_word_optimize")

InnodbFtResultCacheLimit string

("innodb_ft_result_cache_limit")

InnodbFtServerStopwordTable string

("innodb_ft_server_stopword_table")

InnodbLockWaitTimeout int

("innodb_lock_wait_timeout")

InnodbLogWriterThreads bool

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

InnodbMaxPurgeLag string

The desired maximum purge lag in terms of transactions.

InnodbMaxPurgeLagDelay int

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

InnodbNumaInterleave bool

Enables the NUMA interleave memory policy for allocation of the InnoDB buffer pool. When innodb_numa_interleave is enabled, the NUMA memory policy is set to MPOL_INTERLEAVE for the mysqld process. After the InnoDB buffer pool is allocated, the NUMA memory policy is set back to MPOL_DEFAULT. For the innodb_numa_interleave option to be available, MySQL must be compiled on a NUMA-enabled Linux system.

InnodbOnlineAlterLogMaxSize string

Specifies an upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. There is one such log file for each index being created or table being altered. This log file stores data inserted, updated, or deleted in the table during the DDL operation.

InnodbRedoLogCapacity string

Defines the amount of disk space occupied by redo log files. innodb_redo_log_capacity supercedes the innodb_log_files_in_group and innodb_log_file_size variables, which are both ignored if innodb_redo_log_capacity is defined. If innodb_redo_log_capacity is not defined, and if neither innodb_log_file_size or innodb_log_files_in_group are defined, then the default innodb_redo_log_capacity value is used.

InnodbRollbackOnTimeout bool

InnoDB rolls back only the last statement on a transaction timeout by default. If --innodb-rollback-on-timeout is specified, a transaction timeout causes InnoDB to abort and roll back the entire transaction.

InnodbSortBufferSize int

This variable defines:

The sort buffer size for online DDL operations that create or rebuild secondary indexes. However, as of MySQL 8.0.27, this responsibility is subsumed by the innodb_ddl_buffer_size variable.
The amount by which the temporary log file is extended when recording concurrent DML during an online DDL operation, and the size of the temporary log file read buffer and write buffer.

InnodbStatsPersistentSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

InnodbStatsTransientSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

InnodbStrictMode bool

When you enable innodbStrictMode, the InnoDB storage engine returns errors instead of warnings for invalid or incompatible table options.

InnodbUndoLogTruncate bool

When enabled, undo tablespaces that exceed the threshold value defined by innodb_max_undo_log_size are marked for truncation. Only undo tablespaces can be truncated. Truncating undo logs that reside in the system tablespace is not supported. For truncation to occur, there must be at least two undo tablespaces.

InteractiveTimeout int

The number of seconds the server waits for activity on an interactive connection before closing it.

JoinBufferSize string

The minimum size of the buffer that is used for plain index scans, range index scans, and joins that do not use indexes and thus perform full table scans. In MySQL 8.0.18 and later, this variable also controls the amount of memory used for hash joins. Normally, the best way to get fast joins is to add indexes. Increase the value of join_buffer_size to get a faster full join when adding indexes is not possible. One join buffer is allocated for each full join between two tables. For a complex join between several tables for which indexes are not used, multiple join buffers might be necessary.

LocalInfile bool

This variable controls server-side LOCAL capability for LOAD DATA statements. Depending on the local_infile setting, the server refuses or permits local data loading by clients that have LOCAL enabled on the client side.

LongQueryTime int

If a query takes longer than this many seconds, the server increments the Slow_queries status variable. If the slow query log is enabled, the query is logged to the slow query log file. This value is measured in real time, not CPU time, so a query that is under the threshold on a lightly loaded system might be above the threshold on a heavily loaded one.

MandatoryRoles string

("mandatory_roles")

MaxAllowedPacket int

The maximum size of one packet or any generated/intermediate string.

MaxBinlogCacheSize string

Sets the size of the transaction cache.

MaxConnectErrors string

("max_connect_errors")

MaxConnections int

("max_connections")

MaxExecutionTime string

("max_execution_time")

MaxHeapTableSize string

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

MaxPreparedStmtCount int

("max_prepared_stmt_count")

MaxSeeksForKey string

Limit the assumed maximum number of seeks when looking up rows based on a key. The MySQL optimizer assumes that no more than this number of key seeks are required when searching for matching rows in a table by scanning an index, regardless of the actual cardinality of the index (see Section 15.7.7.22, “SHOW INDEX Statement”). By setting this to a low value (say, 100), you can force MySQL to prefer indexes instead of table scans.

MaxUserConnections string

The maximum number of simultaneous connections permitted to any given MySQL user account. A value of 0 (the default) means “no limit.” This variable has a global value that can be set at server startup or runtime. It also has a read-only session value that indicates the effective simultaneous-connection limit that applies to the account associated with the current session.

MysqlFirewallMode bool

("mysql_firewall_mode")

MysqlZstdDefaultCompressionLevel int

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxConnectTimeout int

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

MysqlxDeflateDefaultCompressionLevel int

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

MysqlxDeflateMaxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

MysqlxDocumentIdUniquePrefix int

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxEnableHelloNotice bool

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

MysqlxIdleWorkerThreadTimeout int

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxInteractiveTimeout int

The number of seconds to wait for interactive clients to timeout.

MysqlxLz4defaultCompressionLevel int

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

MysqlxLz4maxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

MysqlxMaxAllowedPacket int

The maximum size of network packets that can be received by X Plugin.

MysqlxMinWorkerThreads int

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxReadTimeout int

The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.

MysqlxWaitTimeout int

The number of seconds that X Plugin waits for activity on a connection.

MysqlxWriteTimeout int

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

MysqlxZstdDefaultCompressionLevel int

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

MysqlxZstdMaxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

NetReadTimeout int

The number of seconds to wait for more data from a connection before aborting the read.

NetWriteTimeout int

The number of seconds to wait for a block to be written to a connection before aborting the write.

OptimizerSwitch string

The optimizer_switch system variable enables control over optimizer behavior. The value of this variable is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. This variable has global and session values and can be changed at runtime. The global default can be set at server startup.

ParserMaxMemSize string

("parser_max_mem_size")

QueryAllocBlockSize string

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

QueryPreallocSize string

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

RangeOptimizerMaxMemSize string

The limit on memory consumption for the range optimizer. A value of 0 means “no limit.” If an execution plan considered by the optimizer uses the range access method but the optimizer estimates that the amount of memory needed for this method would exceed the limit, it abandons the plan and considers other plans.

Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

RegexpTimeLimit int

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

RelayLogSpaceLimit string

The maximum amount of space to use for all relay logs.

ReplicaNetTimeout int

Specifies the number of seconds to wait for more data or a heartbeat signal from the source before the replica considers the connection broken, aborts the read, and tries to reconnect. Setting this variable has no immediate effect. The state of the variable applies on all subsequent START REPLICA commands.

ReplicaParallelWorkers int

Beginning with MySQL 8.0.26, slave_parallel_workers is deprecated, and you should use replica_parallel_workers instead. (Prior to MySQL 8.0.26, you must use slave_parallel_workers to set the number of applier threads.)

ReplicaTypeConversions string

From MySQL 8.0.26, use replica_type_conversions in place of slave_type_conversions, which is deprecated from that release. In releases before MySQL 8.0.26, use slave_type_conversions.

RequireSecureTransport bool

Whether client connections to the server are required to use some form of secure transport. When this variable is enabled, the server permits only TCP/IP connections encrypted using TLS/SSL, or connections that use a socket file or shared memory. The server rejects nonsecure connection attempts, which fail with an ER_SECURE_TRANSPORT_REQUIRED error.

SkipNameResolve bool

Whether to resolve host names when checking client connections. If this variable is OFF, mysqld resolves host names when checking client connections. If it is ON, mysqld uses only IP numbers; in this case, all Host column values in the grant tables must be IP addresses. See Section 7.1.12.3, “DNS Lookups and the Host Cache”.

SortBufferSize string

Each session that must perform a sort allocates a buffer of this size.

SqlGenerateInvisiblePrimaryKey bool

Whether GIPK mode is in effect, in which case a MySQL replication source server adds a generated invisible primary key to any InnoDB table that is created without one.

SqlMode string

("sql_mode")

SqlRequirePrimaryKey bool

("sql_require_primary_key")

SqlWarnings bool

("sql_warnings")

TableDefinitionCache int

The number of table definitions that can be stored in the table definition cache. If you use a large number of tables, you can create a large table definition cache to speed up opening of tables. The table definition cache takes less space and does not use file descriptors, unlike the normal table cache.

TableOpenCache int

The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires.

TemptableMaxRam string

Defines the maximum amount of memory that can be occupied by the TempTable storage engine before it starts storing data on disk. The default value is 1073741824 bytes (1GiB). For more information, see Section 10.4.4, “Internal Temporary Table Use in MySQL”.

ThreadPoolDedicatedListeners bool

Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.

ThreadPoolMaxTransactionsLimit int

Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.

ThreadPoolQueryThreadsPerGroup int

The maximum number of query threads permitted in a thread group. The maximum value is 4096, but if thread_pool_max_transactions_limit is set, thread_pool_query_threads_per_group must not exceed that value. The default value of 1 means there is one active query thread in each thread group, which works well for many loads. When you are using the high concurrency thread pool algorithm (thread_pool_algorithm = 1), consider increasing the value if you experience slower response times due to long-running transactions.

ThreadPoolSize int

The number of thread groups in the thread pool. This is the most important parameter controlling thread pool performance. It affects how many statements can execute simultaneously. If a value outside the range of permissible values is specified, the thread pool plugin does not load and the server writes a message to the error log.

ThreadPoolTransactionDelay int

The delay period before executing a new transaction, in milliseconds. The maximum value is 300000 (5 minutes). A transaction delay can be used in cases where parallel transactions affect the performance of other operations due to resource contention. For example, if parallel transactions affect index creation or an online buffer pool resizing operation, you can configure a transaction delay to reduce resource contention while those operations are running.

TimeZone string

Initializes the time zone for each client that connects.

TmpTableSize string

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

TransactionIsolation string

("transaction_isolation")

WaitTimeout int

The number of seconds the server waits for activity on a noninteractive connection before closing it.

AutoIncrementIncrement int

AutoIncrementOffset int

This variable has a default value of 1. If it is left with its default value, and Group Replication is started on the server in multi-primary mode, it is changed to the server ID.

Autocommit bool

("autocommit")

BigTables bool

If enabled, the server stores all temporary tables on disk rather than in memory.

BinlogExpireLogsSeconds int

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

BinlogGroupCommitSyncDelay int

BinlogGroupCommitSyncNoDelayCount int

BinlogRowMetadata string

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

BinlogRowValueOptions string

BinlogTransactionCompression bool

BlockEncryptionMode string

CharacterSetServer string

The server's default character set. If you set this variable, you should also set collation_server to specify the collation for the character set.

CollationServer string

The server's default collation.

CompletionType string

("completion_type")

ConnectTimeout int

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

ConnectionMemoryChunkSize int

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

ConnectionMemoryLimit string

Set the maximum amount of memory that can be used by a single user connection.

CteMaxRecursionDepth string

("cte_max_recursion_depth")

DefaultAuthenticationPlugin string

The default authentication plugin. This must be a plugin that uses internal credentials storage, so these values are permitted: mysql_native_password, sha256_password, caching_sha2_password.

ExplainFormat string

This variable determines the default output format used by EXPLAIN in the absence of a FORMAT option when displaying a query execution plan.

ExplicitDefaultsForTimestamp bool

ForeignKeyChecks bool

("foreign_key_checks")

GeneratedRandomPasswordLength int

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

GlobalConnectionMemoryLimit string

Set the total amount of memory that can be used by all user connections.

GlobalConnectionMemoryTracking bool

Determines whether the MySQL server calculates Global_connection_memory.

GroupConcatMaxLen string

Specifies the maximum permitted result length in bytes for the GROUP_CONCAT() function.

GroupReplicationConsistency string

EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.

InformationSchemaStatsExpiry int

("information_schema_stats_expiry")

InnodbAdaptiveHashIndex bool

InnodbAutoincLockMode int

The lock mode to use for generating auto-increment values. Permissible values are 0, 1, or 2, for traditional, consecutive, or interleaved, respectively.

InnodbBufferPoolDumpPct int

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

InnodbBufferPoolInstances int

("innodb_buffer_pool_instances")

InnodbBufferPoolSize string

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

InnodbChangeBuffering string

InnodbDdlBufferSize string

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

InnodbDdlThreads int

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

InnodbFtEnableStopword bool

("innodb_ft_enable_stopword")

InnodbFtMaxTokenSize int

("innodb_ft_max_token_size")

InnodbFtMinTokenSize int

("innodb_ft_min_token_size")

InnodbFtNumWordOptimize int

("innodb_ft_num_word_optimize")

InnodbFtResultCacheLimit string

("innodb_ft_result_cache_limit")

InnodbFtServerStopwordTable string

("innodb_ft_server_stopword_table")

InnodbLockWaitTimeout int

("innodb_lock_wait_timeout")

InnodbLogWriterThreads bool

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

InnodbMaxPurgeLag string

The desired maximum purge lag in terms of transactions.

InnodbMaxPurgeLagDelay int

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

InnodbNumaInterleave bool

InnodbOnlineAlterLogMaxSize string

InnodbRedoLogCapacity string

InnodbRollbackOnTimeout bool

InnodbSortBufferSize int

This variable defines:

The sort buffer size for online DDL operations that create or rebuild secondary indexes. However, as of MySQL 8.0.27, this responsibility is subsumed by the innodb_ddl_buffer_size variable.
The amount by which the temporary log file is extended when recording concurrent DML during an online DDL operation, and the size of the temporary log file read buffer and write buffer.

InnodbStatsPersistentSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

InnodbStatsTransientSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

InnodbStrictMode bool

When you enable innodbStrictMode, the InnoDB storage engine returns errors instead of warnings for invalid or incompatible table options.

InnodbUndoLogTruncate bool

InteractiveTimeout int

The number of seconds the server waits for activity on an interactive connection before closing it.

JoinBufferSize string

LocalInfile bool

LongQueryTime int

MandatoryRoles string

("mandatory_roles")

MaxAllowedPacket int

The maximum size of one packet or any generated/intermediate string.

MaxBinlogCacheSize string

Sets the size of the transaction cache.

MaxConnectErrors string

("max_connect_errors")

MaxConnections int

("max_connections")

MaxExecutionTime string

("max_execution_time")

MaxHeapTableSize string

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

MaxPreparedStmtCount int

("max_prepared_stmt_count")

MaxSeeksForKey string

MaxUserConnections string

MysqlFirewallMode bool

("mysql_firewall_mode")

MysqlZstdDefaultCompressionLevel int

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxConnectTimeout int

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

MysqlxDeflateDefaultCompressionLevel int

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

MysqlxDeflateMaxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

MysqlxDocumentIdUniquePrefix int

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxEnableHelloNotice bool

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

MysqlxIdleWorkerThreadTimeout int

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxInteractiveTimeout int

The number of seconds to wait for interactive clients to timeout.

MysqlxLz4defaultCompressionLevel int

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

MysqlxLz4maxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

MysqlxMaxAllowedPacket int

The maximum size of network packets that can be received by X Plugin.

MysqlxMinWorkerThreads int

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxReadTimeout int

MysqlxWaitTimeout int

The number of seconds that X Plugin waits for activity on a connection.

MysqlxWriteTimeout int

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

MysqlxZstdDefaultCompressionLevel int

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

MysqlxZstdMaxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

NetReadTimeout int

The number of seconds to wait for more data from a connection before aborting the read.

NetWriteTimeout int

The number of seconds to wait for a block to be written to a connection before aborting the write.

OptimizerSwitch string

ParserMaxMemSize string

("parser_max_mem_size")

QueryAllocBlockSize string

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

QueryPreallocSize string

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

RangeOptimizerMaxMemSize string

Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

RegexpTimeLimit int

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

RelayLogSpaceLimit string

The maximum amount of space to use for all relay logs.

ReplicaNetTimeout int

ReplicaParallelWorkers int

ReplicaTypeConversions string

From MySQL 8.0.26, use replica_type_conversions in place of slave_type_conversions, which is deprecated from that release. In releases before MySQL 8.0.26, use slave_type_conversions.

RequireSecureTransport bool

SkipNameResolve bool

SortBufferSize string

Each session that must perform a sort allocates a buffer of this size.

SqlGenerateInvisiblePrimaryKey bool

Whether GIPK mode is in effect, in which case a MySQL replication source server adds a generated invisible primary key to any InnoDB table that is created without one.

SqlMode string

("sql_mode")

SqlRequirePrimaryKey bool

("sql_require_primary_key")

SqlWarnings bool

("sql_warnings")

TableDefinitionCache int

TableOpenCache int

The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires.

TemptableMaxRam string

ThreadPoolDedicatedListeners bool

ThreadPoolMaxTransactionsLimit int

ThreadPoolQueryThreadsPerGroup int

ThreadPoolSize int

ThreadPoolTransactionDelay int

TimeZone string

Initializes the time zone for each client that connects.

TmpTableSize string

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

TransactionIsolation string

("transaction_isolation")

WaitTimeout int

The number of seconds the server waits for activity on a noninteractive connection before closing it.

autoIncrementIncrement Integer

autoIncrementOffset Integer

This variable has a default value of 1. If it is left with its default value, and Group Replication is started on the server in multi-primary mode, it is changed to the server ID.

autocommit Boolean

("autocommit")

bigTables Boolean

If enabled, the server stores all temporary tables on disk rather than in memory.

binlogExpireLogsSeconds Integer

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

binlogGroupCommitSyncDelay Integer

binlogGroupCommitSyncNoDelayCount Integer

binlogRowMetadata String

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

binlogRowValueOptions String

binlogTransactionCompression Boolean

blockEncryptionMode String

characterSetServer String

The server's default character set. If you set this variable, you should also set collation_server to specify the collation for the character set.

collationServer String

The server's default collation.

completionType String

("completion_type")

connectTimeout Integer

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

connectionMemoryChunkSize Integer

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

connectionMemoryLimit String

Set the maximum amount of memory that can be used by a single user connection.

cteMaxRecursionDepth String

("cte_max_recursion_depth")

defaultAuthenticationPlugin String

The default authentication plugin. This must be a plugin that uses internal credentials storage, so these values are permitted: mysql_native_password, sha256_password, caching_sha2_password.

explainFormat String

This variable determines the default output format used by EXPLAIN in the absence of a FORMAT option when displaying a query execution plan.

explicitDefaultsForTimestamp Boolean

foreignKeyChecks Boolean

("foreign_key_checks")

generatedRandomPasswordLength Integer

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

globalConnectionMemoryLimit String

Set the total amount of memory that can be used by all user connections.

globalConnectionMemoryTracking Boolean

Determines whether the MySQL server calculates Global_connection_memory.

groupConcatMaxLen String

Specifies the maximum permitted result length in bytes for the GROUP_CONCAT() function.

groupReplicationConsistency String

EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.

informationSchemaStatsExpiry Integer

("information_schema_stats_expiry")

innodbAdaptiveHashIndex Boolean

innodbAutoincLockMode Integer

The lock mode to use for generating auto-increment values. Permissible values are 0, 1, or 2, for traditional, consecutive, or interleaved, respectively.

innodbBufferPoolDumpPct Integer

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

innodbBufferPoolInstances Integer

("innodb_buffer_pool_instances")

innodbBufferPoolSize String

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

innodbChangeBuffering String

innodbDdlBufferSize String

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

innodbDdlThreads Integer

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

innodbFtEnableStopword Boolean

("innodb_ft_enable_stopword")

innodbFtMaxTokenSize Integer

("innodb_ft_max_token_size")

innodbFtMinTokenSize Integer

("innodb_ft_min_token_size")

innodbFtNumWordOptimize Integer

("innodb_ft_num_word_optimize")

innodbFtResultCacheLimit String

("innodb_ft_result_cache_limit")

innodbFtServerStopwordTable String

("innodb_ft_server_stopword_table")

innodbLockWaitTimeout Integer

("innodb_lock_wait_timeout")

innodbLogWriterThreads Boolean

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

innodbMaxPurgeLag String

The desired maximum purge lag in terms of transactions.

innodbMaxPurgeLagDelay Integer

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

innodbNumaInterleave Boolean

innodbOnlineAlterLogMaxSize String

innodbRedoLogCapacity String

innodbRollbackOnTimeout Boolean

innodbSortBufferSize Integer

This variable defines:

The sort buffer size for online DDL operations that create or rebuild secondary indexes. However, as of MySQL 8.0.27, this responsibility is subsumed by the innodb_ddl_buffer_size variable.
The amount by which the temporary log file is extended when recording concurrent DML during an online DDL operation, and the size of the temporary log file read buffer and write buffer.

innodbStatsPersistentSamplePages String

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodbStatsTransientSamplePages String

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodbStrictMode Boolean

When you enable innodbStrictMode, the InnoDB storage engine returns errors instead of warnings for invalid or incompatible table options.

innodbUndoLogTruncate Boolean

interactiveTimeout Integer

The number of seconds the server waits for activity on an interactive connection before closing it.

joinBufferSize String

localInfile Boolean

longQueryTime Integer

mandatoryRoles String

("mandatory_roles")

maxAllowedPacket Integer

The maximum size of one packet or any generated/intermediate string.

maxBinlogCacheSize String

Sets the size of the transaction cache.

maxConnectErrors String

("max_connect_errors")

maxConnections Integer

("max_connections")

maxExecutionTime String

("max_execution_time")

maxHeapTableSize String

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

maxPreparedStmtCount Integer

("max_prepared_stmt_count")

maxSeeksForKey String

maxUserConnections String

mysqlFirewallMode Boolean

("mysql_firewall_mode")

mysqlZstdDefaultCompressionLevel Integer

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxConnectTimeout Integer

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

mysqlxDeflateDefaultCompressionLevel Integer

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

mysqlxDeflateMaxClientCompressionLevel Integer

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

mysqlxDocumentIdUniquePrefix Integer

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxEnableHelloNotice Boolean

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

mysqlxIdleWorkerThreadTimeout Integer

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxInteractiveTimeout Integer

The number of seconds to wait for interactive clients to timeout.

mysqlxLz4defaultCompressionLevel Integer

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

mysqlxLz4maxClientCompressionLevel Integer

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

mysqlxMaxAllowedPacket Integer

The maximum size of network packets that can be received by X Plugin.

mysqlxMinWorkerThreads Integer

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxReadTimeout Integer

mysqlxWaitTimeout Integer

The number of seconds that X Plugin waits for activity on a connection.

mysqlxWriteTimeout Integer

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

mysqlxZstdDefaultCompressionLevel Integer

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

mysqlxZstdMaxClientCompressionLevel Integer

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

netReadTimeout Integer

The number of seconds to wait for more data from a connection before aborting the read.

netWriteTimeout Integer

The number of seconds to wait for a block to be written to a connection before aborting the write.

optimizerSwitch String

parserMaxMemSize String

("parser_max_mem_size")

queryAllocBlockSize String

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

queryPreallocSize String

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

rangeOptimizerMaxMemSize String

Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

regexpTimeLimit Integer

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

relayLogSpaceLimit String

The maximum amount of space to use for all relay logs.

replicaNetTimeout Integer

replicaParallelWorkers Integer

replicaTypeConversions String

From MySQL 8.0.26, use replica_type_conversions in place of slave_type_conversions, which is deprecated from that release. In releases before MySQL 8.0.26, use slave_type_conversions.

requireSecureTransport Boolean

skipNameResolve Boolean

sortBufferSize String

Each session that must perform a sort allocates a buffer of this size.

sqlGenerateInvisiblePrimaryKey Boolean

Whether GIPK mode is in effect, in which case a MySQL replication source server adds a generated invisible primary key to any InnoDB table that is created without one.

sqlMode String

("sql_mode")

sqlRequirePrimaryKey Boolean

("sql_require_primary_key")

sqlWarnings Boolean

("sql_warnings")

tableDefinitionCache Integer

tableOpenCache Integer

The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires.

temptableMaxRam String

threadPoolDedicatedListeners Boolean

threadPoolMaxTransactionsLimit Integer

threadPoolQueryThreadsPerGroup Integer

threadPoolSize Integer

threadPoolTransactionDelay Integer

timeZone String

Initializes the time zone for each client that connects.

tmpTableSize String

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

transactionIsolation String

("transaction_isolation")

waitTimeout Integer

The number of seconds the server waits for activity on a noninteractive connection before closing it.

autoIncrementIncrement number

autoIncrementOffset number

This variable has a default value of 1. If it is left with its default value, and Group Replication is started on the server in multi-primary mode, it is changed to the server ID.

autocommit boolean

("autocommit")

bigTables boolean

If enabled, the server stores all temporary tables on disk rather than in memory.

binlogExpireLogsSeconds number

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

binlogGroupCommitSyncDelay number

binlogGroupCommitSyncNoDelayCount number

binlogRowMetadata string

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

binlogRowValueOptions string

binlogTransactionCompression boolean

blockEncryptionMode string

characterSetServer string

The server's default character set. If you set this variable, you should also set collation_server to specify the collation for the character set.

collationServer string

The server's default collation.

completionType string

("completion_type")

connectTimeout number

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

connectionMemoryChunkSize number

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

connectionMemoryLimit string

Set the maximum amount of memory that can be used by a single user connection.

cteMaxRecursionDepth string

("cte_max_recursion_depth")

defaultAuthenticationPlugin string

The default authentication plugin. This must be a plugin that uses internal credentials storage, so these values are permitted: mysql_native_password, sha256_password, caching_sha2_password.

explainFormat string

This variable determines the default output format used by EXPLAIN in the absence of a FORMAT option when displaying a query execution plan.

explicitDefaultsForTimestamp boolean

foreignKeyChecks boolean

("foreign_key_checks")

generatedRandomPasswordLength number

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

globalConnectionMemoryLimit string

Set the total amount of memory that can be used by all user connections.

globalConnectionMemoryTracking boolean

Determines whether the MySQL server calculates Global_connection_memory.

groupConcatMaxLen string

Specifies the maximum permitted result length in bytes for the GROUP_CONCAT() function.

groupReplicationConsistency string

EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.

informationSchemaStatsExpiry number

("information_schema_stats_expiry")

innodbAdaptiveHashIndex boolean

innodbAutoincLockMode number

The lock mode to use for generating auto-increment values. Permissible values are 0, 1, or 2, for traditional, consecutive, or interleaved, respectively.

innodbBufferPoolDumpPct number

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

innodbBufferPoolInstances number

("innodb_buffer_pool_instances")

innodbBufferPoolSize string

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

innodbChangeBuffering string

innodbDdlBufferSize string

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

innodbDdlThreads number

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

innodbFtEnableStopword boolean

("innodb_ft_enable_stopword")

innodbFtMaxTokenSize number

("innodb_ft_max_token_size")

innodbFtMinTokenSize number

("innodb_ft_min_token_size")

innodbFtNumWordOptimize number

("innodb_ft_num_word_optimize")

innodbFtResultCacheLimit string

("innodb_ft_result_cache_limit")

innodbFtServerStopwordTable string

("innodb_ft_server_stopword_table")

innodbLockWaitTimeout number

("innodb_lock_wait_timeout")

innodbLogWriterThreads boolean

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

innodbMaxPurgeLag string

The desired maximum purge lag in terms of transactions.

innodbMaxPurgeLagDelay number

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

innodbNumaInterleave boolean

innodbOnlineAlterLogMaxSize string

innodbRedoLogCapacity string

innodbRollbackOnTimeout boolean

innodbSortBufferSize number

This variable defines:

The sort buffer size for online DDL operations that create or rebuild secondary indexes. However, as of MySQL 8.0.27, this responsibility is subsumed by the innodb_ddl_buffer_size variable.
The amount by which the temporary log file is extended when recording concurrent DML during an online DDL operation, and the size of the temporary log file read buffer and write buffer.

innodbStatsPersistentSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodbStatsTransientSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodbStrictMode boolean

When you enable innodbStrictMode, the InnoDB storage engine returns errors instead of warnings for invalid or incompatible table options.

innodbUndoLogTruncate boolean

interactiveTimeout number

The number of seconds the server waits for activity on an interactive connection before closing it.

joinBufferSize string

localInfile boolean

longQueryTime number

mandatoryRoles string

("mandatory_roles")

maxAllowedPacket number

The maximum size of one packet or any generated/intermediate string.

maxBinlogCacheSize string

Sets the size of the transaction cache.

maxConnectErrors string

("max_connect_errors")

maxConnections number

("max_connections")

maxExecutionTime string

("max_execution_time")

maxHeapTableSize string

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

maxPreparedStmtCount number

("max_prepared_stmt_count")

maxSeeksForKey string

maxUserConnections string

mysqlFirewallMode boolean

("mysql_firewall_mode")

mysqlZstdDefaultCompressionLevel number

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxConnectTimeout number

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

mysqlxDeflateDefaultCompressionLevel number

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

mysqlxDeflateMaxClientCompressionLevel number

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

mysqlxDocumentIdUniquePrefix number

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxEnableHelloNotice boolean

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

mysqlxIdleWorkerThreadTimeout number

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxInteractiveTimeout number

The number of seconds to wait for interactive clients to timeout.

mysqlxLz4defaultCompressionLevel number

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

mysqlxLz4maxClientCompressionLevel number

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

mysqlxMaxAllowedPacket number

The maximum size of network packets that can be received by X Plugin.

mysqlxMinWorkerThreads number

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxReadTimeout number

mysqlxWaitTimeout number

The number of seconds that X Plugin waits for activity on a connection.

mysqlxWriteTimeout number

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

mysqlxZstdDefaultCompressionLevel number

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

mysqlxZstdMaxClientCompressionLevel number

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

netReadTimeout number

The number of seconds to wait for more data from a connection before aborting the read.

netWriteTimeout number

The number of seconds to wait for a block to be written to a connection before aborting the write.

optimizerSwitch string

parserMaxMemSize string

("parser_max_mem_size")

queryAllocBlockSize string

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

queryPreallocSize string

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

rangeOptimizerMaxMemSize string

Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

regexpTimeLimit number

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

relayLogSpaceLimit string

The maximum amount of space to use for all relay logs.

replicaNetTimeout number

replicaParallelWorkers number

replicaTypeConversions string

From MySQL 8.0.26, use replica_type_conversions in place of slave_type_conversions, which is deprecated from that release. In releases before MySQL 8.0.26, use slave_type_conversions.

requireSecureTransport boolean

skipNameResolve boolean

sortBufferSize string

Each session that must perform a sort allocates a buffer of this size.

sqlGenerateInvisiblePrimaryKey boolean

Whether GIPK mode is in effect, in which case a MySQL replication source server adds a generated invisible primary key to any InnoDB table that is created without one.

sqlMode string

("sql_mode")

sqlRequirePrimaryKey boolean

("sql_require_primary_key")

sqlWarnings boolean

("sql_warnings")

tableDefinitionCache number

tableOpenCache number

The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires.

temptableMaxRam string

threadPoolDedicatedListeners boolean

threadPoolMaxTransactionsLimit number

threadPoolQueryThreadsPerGroup number

threadPoolSize number

threadPoolTransactionDelay number

timeZone string

Initializes the time zone for each client that connects.

tmpTableSize string

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

transactionIsolation string

("transaction_isolation")

waitTimeout number

The number of seconds the server waits for activity on a noninteractive connection before closing it.

auto_increment_increment int

auto_increment_offset int

This variable has a default value of 1. If it is left with its default value, and Group Replication is started on the server in multi-primary mode, it is changed to the server ID.

autocommit bool

("autocommit")

big_tables bool

If enabled, the server stores all temporary tables on disk rather than in memory.

binlog_expire_logs_seconds int

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

binlog_group_commit_sync_delay int

binlog_group_commit_sync_no_delay_count int

binlog_row_metadata str

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

binlog_row_value_options str

binlog_transaction_compression bool

block_encryption_mode str

character_set_server str

The server's default character set. If you set this variable, you should also set collation_server to specify the collation for the character set.

collation_server str

The server's default collation.

completion_type str

("completion_type")

connect_timeout int

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

connection_memory_chunk_size int

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

connection_memory_limit str

Set the maximum amount of memory that can be used by a single user connection.

cte_max_recursion_depth str

("cte_max_recursion_depth")

default_authentication_plugin str

The default authentication plugin. This must be a plugin that uses internal credentials storage, so these values are permitted: mysql_native_password, sha256_password, caching_sha2_password.

explain_format str

This variable determines the default output format used by EXPLAIN in the absence of a FORMAT option when displaying a query execution plan.

explicit_defaults_for_timestamp bool

foreign_key_checks bool

("foreign_key_checks")

generated_random_password_length int

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

global_connection_memory_limit str

Set the total amount of memory that can be used by all user connections.

global_connection_memory_tracking bool

Determines whether the MySQL server calculates Global_connection_memory.

group_concat_max_len str

Specifies the maximum permitted result length in bytes for the GROUP_CONCAT() function.

group_replication_consistency str

EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.

information_schema_stats_expiry int

("information_schema_stats_expiry")

innodb_adaptive_hash_index bool

innodb_autoinc_lock_mode int

The lock mode to use for generating auto-increment values. Permissible values are 0, 1, or 2, for traditional, consecutive, or interleaved, respectively.

innodb_buffer_pool_dump_pct int

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

innodb_buffer_pool_instances int

("innodb_buffer_pool_instances")

innodb_buffer_pool_size str

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

innodb_change_buffering str

innodb_ddl_buffer_size str

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

innodb_ddl_threads int

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

innodb_ft_enable_stopword bool

("innodb_ft_enable_stopword")

innodb_ft_max_token_size int

("innodb_ft_max_token_size")

innodb_ft_min_token_size int

("innodb_ft_min_token_size")

innodb_ft_num_word_optimize int

("innodb_ft_num_word_optimize")

innodb_ft_result_cache_limit str

("innodb_ft_result_cache_limit")

innodb_ft_server_stopword_table str

("innodb_ft_server_stopword_table")

innodb_lock_wait_timeout int

("innodb_lock_wait_timeout")

innodb_log_writer_threads bool

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

innodb_max_purge_lag str

The desired maximum purge lag in terms of transactions.

innodb_max_purge_lag_delay int

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

innodb_numa_interleave bool

innodb_online_alter_log_max_size str

innodb_redo_log_capacity str

innodb_rollback_on_timeout bool

innodb_sort_buffer_size int

This variable defines:

The sort buffer size for online DDL operations that create or rebuild secondary indexes. However, as of MySQL 8.0.27, this responsibility is subsumed by the innodb_ddl_buffer_size variable.
The amount by which the temporary log file is extended when recording concurrent DML during an online DDL operation, and the size of the temporary log file read buffer and write buffer.

innodb_stats_persistent_sample_pages str

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodb_stats_transient_sample_pages str

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodb_strict_mode bool

When you enable innodbStrictMode, the InnoDB storage engine returns errors instead of warnings for invalid or incompatible table options.

innodb_undo_log_truncate bool

interactive_timeout int

The number of seconds the server waits for activity on an interactive connection before closing it.

join_buffer_size str

local_infile bool

long_query_time int

mandatory_roles str

("mandatory_roles")

max_allowed_packet int

The maximum size of one packet or any generated/intermediate string.

max_binlog_cache_size str

Sets the size of the transaction cache.

max_connect_errors str

("max_connect_errors")

max_connections int

("max_connections")

max_execution_time str

("max_execution_time")

max_heap_table_size str

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

max_prepared_stmt_count int

("max_prepared_stmt_count")

max_seeks_for_key str

max_user_connections str

mysql_firewall_mode bool

("mysql_firewall_mode")

mysql_zstd_default_compression_level int

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlx_connect_timeout int

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

mysqlx_deflate_default_compression_level int

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

mysqlx_deflate_max_client_compression_level int

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

mysqlx_document_id_unique_prefix int

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlx_enable_hello_notice bool

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

mysqlx_idle_worker_thread_timeout int

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlx_interactive_timeout int

The number of seconds to wait for interactive clients to timeout.

mysqlx_lz4default_compression_level int

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

mysqlx_lz4max_client_compression_level int

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

mysqlx_max_allowed_packet int

The maximum size of network packets that can be received by X Plugin.

mysqlx_min_worker_threads int

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlx_read_timeout int

mysqlx_wait_timeout int

The number of seconds that X Plugin waits for activity on a connection.

mysqlx_write_timeout int

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

mysqlx_zstd_default_compression_level int

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

mysqlx_zstd_max_client_compression_level int

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

net_read_timeout int

The number of seconds to wait for more data from a connection before aborting the read.

net_write_timeout int

The number of seconds to wait for a block to be written to a connection before aborting the write.

optimizer_switch str

parser_max_mem_size str

("parser_max_mem_size")

query_alloc_block_size str

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

query_prealloc_size str

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

range_optimizer_max_mem_size str

Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

regexp_time_limit int

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

relay_log_space_limit str

The maximum amount of space to use for all relay logs.

replica_net_timeout int

replica_parallel_workers int

replica_type_conversions str

From MySQL 8.0.26, use replica_type_conversions in place of slave_type_conversions, which is deprecated from that release. In releases before MySQL 8.0.26, use slave_type_conversions.

require_secure_transport bool

skip_name_resolve bool

sort_buffer_size str

Each session that must perform a sort allocates a buffer of this size.

sql_generate_invisible_primary_key bool

Whether GIPK mode is in effect, in which case a MySQL replication source server adds a generated invisible primary key to any InnoDB table that is created without one.

sql_mode str

("sql_mode")

sql_require_primary_key bool

("sql_require_primary_key")

sql_warnings bool

("sql_warnings")

table_definition_cache int

table_open_cache int

The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires.

temptable_max_ram str

thread_pool_dedicated_listeners bool

thread_pool_max_transactions_limit int

thread_pool_query_threads_per_group int

thread_pool_size int

thread_pool_transaction_delay int

time_zone str

Initializes the time zone for each client that connects.

tmp_table_size str

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

transaction_isolation str

("transaction_isolation")

wait_timeout int

The number of seconds the server waits for activity on a noninteractive connection before closing it.

autoIncrementIncrement Number

autoIncrementOffset Number

This variable has a default value of 1. If it is left with its default value, and Group Replication is started on the server in multi-primary mode, it is changed to the server ID.

autocommit Boolean

("autocommit")

bigTables Boolean

If enabled, the server stores all temporary tables on disk rather than in memory.

binlogExpireLogsSeconds Number

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

binlogGroupCommitSyncDelay Number

binlogGroupCommitSyncNoDelayCount Number

binlogRowMetadata String

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

binlogRowValueOptions String

binlogTransactionCompression Boolean

blockEncryptionMode String

characterSetServer String

The server's default character set. If you set this variable, you should also set collation_server to specify the collation for the character set.

collationServer String

The server's default collation.

completionType String

("completion_type")

connectTimeout Number

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

connectionMemoryChunkSize Number

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

connectionMemoryLimit String

Set the maximum amount of memory that can be used by a single user connection.

cteMaxRecursionDepth String

("cte_max_recursion_depth")

defaultAuthenticationPlugin String

The default authentication plugin. This must be a plugin that uses internal credentials storage, so these values are permitted: mysql_native_password, sha256_password, caching_sha2_password.

explainFormat String

This variable determines the default output format used by EXPLAIN in the absence of a FORMAT option when displaying a query execution plan.

explicitDefaultsForTimestamp Boolean

foreignKeyChecks Boolean

("foreign_key_checks")

generatedRandomPasswordLength Number

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

globalConnectionMemoryLimit String

Set the total amount of memory that can be used by all user connections.

globalConnectionMemoryTracking Boolean

Determines whether the MySQL server calculates Global_connection_memory.

groupConcatMaxLen String

Specifies the maximum permitted result length in bytes for the GROUP_CONCAT() function.

groupReplicationConsistency String

EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.

informationSchemaStatsExpiry Number

("information_schema_stats_expiry")

innodbAdaptiveHashIndex Boolean

innodbAutoincLockMode Number

The lock mode to use for generating auto-increment values. Permissible values are 0, 1, or 2, for traditional, consecutive, or interleaved, respectively.

innodbBufferPoolDumpPct Number

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

innodbBufferPoolInstances Number

("innodb_buffer_pool_instances")

innodbBufferPoolSize String

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

innodbChangeBuffering String

innodbDdlBufferSize String

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

innodbDdlThreads Number

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

innodbFtEnableStopword Boolean

("innodb_ft_enable_stopword")

innodbFtMaxTokenSize Number

("innodb_ft_max_token_size")

innodbFtMinTokenSize Number

("innodb_ft_min_token_size")

innodbFtNumWordOptimize Number

("innodb_ft_num_word_optimize")

innodbFtResultCacheLimit String

("innodb_ft_result_cache_limit")

innodbFtServerStopwordTable String

("innodb_ft_server_stopword_table")

innodbLockWaitTimeout Number

("innodb_lock_wait_timeout")

innodbLogWriterThreads Boolean

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

innodbMaxPurgeLag String

The desired maximum purge lag in terms of transactions.

innodbMaxPurgeLagDelay Number

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

innodbNumaInterleave Boolean

innodbOnlineAlterLogMaxSize String

innodbRedoLogCapacity String

innodbRollbackOnTimeout Boolean

innodbSortBufferSize Number

This variable defines:

The sort buffer size for online DDL operations that create or rebuild secondary indexes. However, as of MySQL 8.0.27, this responsibility is subsumed by the innodb_ddl_buffer_size variable.
The amount by which the temporary log file is extended when recording concurrent DML during an online DDL operation, and the size of the temporary log file read buffer and write buffer.

innodbStatsPersistentSamplePages String

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodbStatsTransientSamplePages String

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodbStrictMode Boolean

When you enable innodbStrictMode, the InnoDB storage engine returns errors instead of warnings for invalid or incompatible table options.

innodbUndoLogTruncate Boolean

interactiveTimeout Number

The number of seconds the server waits for activity on an interactive connection before closing it.

joinBufferSize String

localInfile Boolean

longQueryTime Number

mandatoryRoles String

("mandatory_roles")

maxAllowedPacket Number

The maximum size of one packet or any generated/intermediate string.

maxBinlogCacheSize String

Sets the size of the transaction cache.

maxConnectErrors String

("max_connect_errors")

maxConnections Number

("max_connections")

maxExecutionTime String

("max_execution_time")

maxHeapTableSize String

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

maxPreparedStmtCount Number

("max_prepared_stmt_count")

maxSeeksForKey String

maxUserConnections String

mysqlFirewallMode Boolean

("mysql_firewall_mode")

mysqlZstdDefaultCompressionLevel Number

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxConnectTimeout Number

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

mysqlxDeflateDefaultCompressionLevel Number

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

mysqlxDeflateMaxClientCompressionLevel Number

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

mysqlxDocumentIdUniquePrefix Number

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxEnableHelloNotice Boolean

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

mysqlxIdleWorkerThreadTimeout Number

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxInteractiveTimeout Number

The number of seconds to wait for interactive clients to timeout.

mysqlxLz4defaultCompressionLevel Number

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

mysqlxLz4maxClientCompressionLevel Number

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

mysqlxMaxAllowedPacket Number

The maximum size of network packets that can be received by X Plugin.

mysqlxMinWorkerThreads Number

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxReadTimeout Number

mysqlxWaitTimeout Number

The number of seconds that X Plugin waits for activity on a connection.

mysqlxWriteTimeout Number

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

mysqlxZstdDefaultCompressionLevel Number

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

mysqlxZstdMaxClientCompressionLevel Number

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

netReadTimeout Number

The number of seconds to wait for more data from a connection before aborting the read.

netWriteTimeout Number

The number of seconds to wait for a block to be written to a connection before aborting the write.

optimizerSwitch String

parserMaxMemSize String

("parser_max_mem_size")

queryAllocBlockSize String

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

queryPreallocSize String

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

rangeOptimizerMaxMemSize String

Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

regexpTimeLimit Number

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

relayLogSpaceLimit String

The maximum amount of space to use for all relay logs.

replicaNetTimeout Number

replicaParallelWorkers Number

replicaTypeConversions String

From MySQL 8.0.26, use replica_type_conversions in place of slave_type_conversions, which is deprecated from that release. In releases before MySQL 8.0.26, use slave_type_conversions.

requireSecureTransport Boolean

skipNameResolve Boolean

sortBufferSize String

Each session that must perform a sort allocates a buffer of this size.

sqlGenerateInvisiblePrimaryKey Boolean

Whether GIPK mode is in effect, in which case a MySQL replication source server adds a generated invisible primary key to any InnoDB table that is created without one.

sqlMode String