oci.Mysql.getMysqlConfigurations
This data source provides the list of Mysql Configurations in Oracle Cloud Infrastructure MySQL Database service.
Lists the Configurations available when creating a DB System.
This may include DEFAULT configurations per Shape and CUSTOM configurations.
The default sort order is a multi-part sort by:
- shapeName, ascending
- DEFAULT-before-CUSTOM
- displayName ascending
Example Usage
using System.Collections.Generic;
using Pulumi;
using Oci = Pulumi.Oci;
return await Deployment.RunAsync(() =>
{
var testMysqlConfigurations = Oci.Mysql.GetMysqlConfigurations.Invoke(new()
{
CompartmentId = @var.Compartment_id,
ConfigurationId = @var.Mysql_configuration_id,
DisplayName = @var.Mysql_configuration_display_name,
ShapeName = @var.Mysql_shape_name,
State = @var.Mysql_configuration_state,
Types = @var.Mysql_configuration_type,
});
});
package main
import (
"github.com/pulumi/pulumi-oci/sdk/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: _var.Compartment_id,
ConfigurationId: pulumi.StringRef(_var.Mysql_configuration_id),
DisplayName: pulumi.StringRef(_var.Mysql_configuration_display_name),
ShapeName: pulumi.StringRef(_var.Mysql_shape_name),
State: pulumi.StringRef(_var.Mysql_configuration_state),
Types: _var.Mysql_configuration_type,
}, nil)
if err != nil {
return err
}
return nil
})
}
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(var_.compartment_id())
.configurationId(var_.mysql_configuration_id())
.displayName(var_.mysql_configuration_display_name())
.shapeName(var_.mysql_shape_name())
.state(var_.mysql_configuration_state())
.types(var_.mysql_configuration_type())
.build());
}
}
import pulumi
import pulumi_oci as oci
test_mysql_configurations = oci.Mysql.get_mysql_configurations(compartment_id=var["compartment_id"],
configuration_id=var["mysql_configuration_id"],
display_name=var["mysql_configuration_display_name"],
shape_name=var["mysql_shape_name"],
state=var["mysql_configuration_state"],
types=var["mysql_configuration_type"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testMysqlConfigurations = oci.Mysql.getMysqlConfigurations({
compartmentId: _var.compartment_id,
configurationId: _var.mysql_configuration_id,
displayName: _var.mysql_configuration_display_name,
shapeName: _var.mysql_shape_name,
state: _var.mysql_configuration_state,
types: _var.mysql_configuration_type,
});
variables:
testMysqlConfigurations:
fn::invoke:
Function: oci:Mysql:getMysqlConfigurations
Arguments:
compartmentId: ${var.compartment_id}
configurationId: ${var.mysql_configuration_id}
displayName: ${var.mysql_configuration_display_name}
shapeName: ${var.mysql_shape_name}
state: ${var.mysql_configuration_state}
types: ${var.mysql_configuration_type}
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[_mysql.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[_mysql.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)
// Output-based functions aren't available in Java yet
fn::invoke:
function: oci:Mysql/getMysqlConfigurations:getMysqlConfigurations
arguments:
# arguments dictionaryThe following arguments are supported:
- Compartment
Id string The compartment OCID.
- Configuration
Id string The requested Configuration instance.
- Display
Name string A filter to return only the resource matching the given display name exactly.
- Filters
List<Get
Mysql Configurations Filter> - Shape
Name string The requested Shape name.
- State string
Configuration Lifecycle State
- Types List<string>
The requested Configuration types.
- Compartment
Id string The compartment OCID.
- Configuration
Id string The requested Configuration instance.
- Display
Name string A filter to return only the resource matching the given display name exactly.
- Filters
[]Get
Mysql Configurations Filter - Shape
Name string The requested Shape name.
- State string
Configuration Lifecycle State
- Types []string
The requested Configuration types.
- compartment
Id String The compartment OCID.
- configuration
Id String The requested Configuration instance.
- display
Name String A filter to return only the resource matching the given display name exactly.
- filters
List<Get
Configurations Filter> - shape
Name String The requested Shape name.
- state String
Configuration Lifecycle State
- types List<String>
The requested Configuration types.
- compartment
Id string The compartment OCID.
- configuration
Id string The requested Configuration instance.
- display
Name string A filter to return only the resource matching the given display name exactly.
- filters
Get
Mysql Configurations Filter[] - shape
Name 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
Get
Mysql Configurations Filter] - shape_
name str The requested Shape name.
- state str
Configuration Lifecycle State
- types Sequence[str]
The requested Configuration types.
- compartment
Id String The compartment OCID.
- configuration
Id String The requested Configuration instance.
- display
Name String A filter to return only the resource matching the given display name exactly.
- filters List<Property Map>
- shape
Name 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:
- Compartment
Id string OCID of the Compartment the Configuration exists in.
- Configurations
List<Get
Mysql Configurations Configuration> The list of configurations.
- Id string
The provider-assigned unique ID for this managed resource.
- Configuration
Id string - Display
Name string The display name of the Configuration.
- Filters
List<Get
Mysql Configurations Filter> - Shape
Name string The name of the associated Shape.
- State string
The current state of the Configuration.
- Types List<string>
The Configuration type, DEFAULT or CUSTOM.
- Compartment
Id string OCID of the Compartment the Configuration exists in.
- Configurations
[]Get
Mysql Configurations Configuration The list of configurations.
- Id string
The provider-assigned unique ID for this managed resource.
- Configuration
Id string - Display
Name string The display name of the Configuration.
- Filters
[]Get
Mysql Configurations Filter - Shape
Name 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 String OCID of the Compartment the Configuration exists in.
- configurations
List<Get
Configurations Configuration> The list of configurations.
- id String
The provider-assigned unique ID for this managed resource.
- configuration
Id String - display
Name String The display name of the Configuration.
- filters
List<Get
Configurations Filter> - shape
Name String The name of the associated Shape.
- state String
The current state of the Configuration.
- types List<String>
The Configuration type, DEFAULT or CUSTOM.
- compartment
Id string OCID of the Compartment the Configuration exists in.
- configurations
Get
Mysql Configurations Configuration[] The list of configurations.
- id string
The provider-assigned unique ID for this managed resource.
- configuration
Id string - display
Name string The display name of the Configuration.
- filters
Get
Mysql Configurations Filter[] - shape
Name 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
Get
Mysql Configurations Configuration] 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
Get
Mysql Configurations Filter] - 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.
- compartment
Id 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.
- configuration
Id String - display
Name String The display name of the Configuration.
- filters List<Property Map>
- shape
Name 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
- Compartment
Id string The compartment OCID.
- Dictionary<string, object>
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.
- Display
Name string A filter to return only the resource matching the given display name exactly.
- Dictionary<string, object>
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.
- Init
Variables List<GetMysql Configurations Configuration Init Variable> User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- Parent
Configuration stringId 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 string The requested Shape name.
- State string
Configuration Lifecycle State
- Time
Created string The date and time the Configuration was created, as described by RFC 3339.
- Time
Updated string The date and time the Configuration was last updated, as described by RFC 3339.
- Type string
The requested Configuration types.
- Variables
List<Get
Mysql Configurations Configuration Variable> User-defined service variables.
- Compartment
Id string The compartment OCID.
- map[string]interface{}
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.
- Display
Name string A filter to return only the resource matching the given display name exactly.
- map[string]interface{}
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.
- Init
Variables []GetMysql Configurations Configuration Init Variable User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- Parent
Configuration stringId 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 string The requested Shape name.
- State string
Configuration Lifecycle State
- Time
Created string The date and time the Configuration was created, as described by RFC 3339.
- Time
Updated string The date and time the Configuration was last updated, as described by RFC 3339.
- Type string
The requested Configuration types.
- Variables
[]Get
Mysql Configurations Configuration Variable User-defined service variables.
- compartment
Id String The compartment OCID.
- Map<String,Object>
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.
- display
Name String A filter to return only the resource matching the given display name exactly.
- Map<String,Object>
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.
- init
Variables List<GetConfigurations Configuration Init Variable> User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent
Configuration StringId 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 String The requested Shape name.
- state String
Configuration Lifecycle State
- time
Created String The date and time the Configuration was created, as described by RFC 3339.
- time
Updated String The date and time the Configuration was last updated, as described by RFC 3339.
- type String
The requested Configuration types.
- variables
List<Get
Configurations Configuration Variable> User-defined service variables.
- compartment
Id string The compartment OCID.
- {[key: string]: any}
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.
- display
Name string A filter to return only the resource matching the given display name exactly.
- {[key: string]: any}
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.
- init
Variables GetMysql Configurations Configuration Init Variable[] User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent
Configuration stringId 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 string The requested Shape name.
- state string
Configuration Lifecycle State
- time
Created string The date and time the Configuration was created, as described by RFC 3339.
- time
Updated string The date and time the Configuration was last updated, as described by RFC 3339.
- type string
The requested Configuration types.
- variables
Get
Mysql Configurations Configuration Variable[] User-defined service variables.
- compartment_
id str The compartment OCID.
- Mapping[str, Any]
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.
- Mapping[str, Any]
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 GetMysql Configurations Configuration Init Variable] User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent_
configuration_ strid 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
- 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
Get
Mysql Configurations Configuration Variable] User-defined service variables.
- compartment
Id String The compartment OCID.
- Map<Any>
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.
- display
Name String A filter to return only the resource matching the given display name exactly.
- Map<Any>
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.
- init
Variables List<Property Map> User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent
Configuration StringId 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 String The requested Shape name.
- state String
Configuration Lifecycle State
- time
Created String The date and time the Configuration was created, as described by RFC 3339.
- time
Updated 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
- Lower
Case stringTable Names 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 stringTable Names 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 StringTable Names 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 stringTable Names 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_ strtable_ names 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 StringTable Names 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
- Autocommit bool
("autocommit")
- Big
Tables bool If enabled, the server stores all temporary tables on disk rather than in memory.
- Binlog
Expire intLogs Seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- Binlog
Row stringMetadata 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 stringValue Options 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.
- Binlog
Transaction boolCompression 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.
- Completion
Type string ("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 intChunk Size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
- Connection
Memory stringLimit Set the maximum amount of memory that can be used by a single user connection.
- Cte
Max stringRecursion Depth ("cte_max_recursion_depth")
- Default
Authentication stringPlugin ("default_authentication_plugin")
- Foreign
Key boolChecks ("foreign_key_checks")
- Generated
Random intPassword Length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.
- Global
Connection stringMemory Limit Set the total amount of memory that can be used by all user connections.
- Global
Connection boolMemory Tracking Determines whether the MySQL server calculates Global_connection_memory.
- Group
Replication stringConsistency - 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 intStats Expiry ("information_schema_stats_expiry")
- Innodb
Buffer intPool Dump Pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
- Innodb
Buffer intPool Instances ("innodb_buffer_pool_instances")
- Innodb
Buffer stringPool Size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
- Innodb
Ddl stringBuffer Size 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 intThreads 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 boolEnable Stopword ("innodb_ft_enable_stopword")
- Innodb
Ft intMax Token Size ("innodb_ft_max_token_size")
- Innodb
Ft intMin Token Size ("innodb_ft_min_token_size")
- Innodb
Ft intNum Word Optimize ("innodb_ft_num_word_optimize")
- Innodb
Ft stringResult Cache Limit ("innodb_ft_result_cache_limit")
- Innodb
Ft stringServer Stopword Table ("innodb_ft_server_stopword_table")
- Innodb
Lock intWait Timeout ("innodb_lock_wait_timeout")
- Innodb
Log boolWriter Threads 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 stringPurge Lag The desired maximum purge lag in terms of transactions.
- Innodb
Max intPurge Lag Delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
- Innodb
Stats stringPersistent Sample Pages 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 stringTransient Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
- Interactive
Timeout int The number of seconds the server waits for activity on an interactive connection before closing it.
- Local
Infile bool ("local_infile")
- Mandatory
Roles string ("mandatory_roles")
- Max
Allowed intPacket The maximum size of one packet or any generated/intermediate string.
- Max
Binlog stringCache Size Sets the size of the transaction cache.
- Max
Connect stringErrors ("max_connect_errors")
- Max
Connections int ("max_connections")
- Max
Execution stringTime ("max_execution_time")
- Max
Heap stringTable Size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
- Max
Prepared intStmt Count ("max_prepared_stmt_count")
- Mysql
Firewall boolMode ("mysql_firewall_mode")
- Mysql
Zstd intDefault Compression Level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
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 intTimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
- Mysqlx
Deflate intDefault Compression Level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- Mysqlx
Deflate intMax Client Compression Level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- Mysqlx
Document intId Unique Prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
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 boolHello Notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Idle intWorker Thread Timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
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 intTimeout The number of seconds to wait for interactive clients to timeout.
- Mysqlx
Lz4default intCompression Level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- Mysqlx
Lz4max intClient Compression Level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- Mysqlx
Max intAllowed Packet The maximum size of network packets that can be received by X Plugin.
- Mysqlx
Min intWorker Threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.
- Mysqlx
Read intTimeout 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.
- Mysqlx
Wait intTimeout The number of seconds that X Plugin waits for activity on a connection.
- Mysqlx
Write intTimeout 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 intDefault Compression Level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- Mysqlx
Zstd intMax Client Compression Level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- Net
Read intTimeout The number of seconds to wait for more data from a connection before aborting the read.
- Net
Write intTimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
- Parser
Max stringMem Size ("parser_max_mem_size")
- Query
Alloc stringBlock Size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.
- Query
Prealloc stringSize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.
- Regexp
Time intLimit 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)
- Sort
Buffer stringSize Each session that must perform a sort allocates a buffer of this size.
- Sql
Mode string ("sql_mode")
- Sql
Require boolPrimary Key ("sql_require_primary_key")
- Sql
Warnings bool ("sql_warnings")
- Thread
Pool boolDedicated Listeners 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.
- Thread
Pool intMax Transactions Limit 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.
- Time
Zone string Initializes the time zone for each client that connects.
- Tmp
Table stringSize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
- Transaction
Isolation string ("transaction_isolation")
- Wait
Timeout int The number of seconds the server waits for activity on a noninteractive connection before closing it.
- Autocommit bool
("autocommit")
- Big
Tables bool If enabled, the server stores all temporary tables on disk rather than in memory.
- Binlog
Expire intLogs Seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- Binlog
Row stringMetadata 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 stringValue Options 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.
- Binlog
Transaction boolCompression 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.
- Completion
Type string ("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 intChunk Size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
- Connection
Memory stringLimit Set the maximum amount of memory that can be used by a single user connection.
- Cte
Max stringRecursion Depth ("cte_max_recursion_depth")
- Default
Authentication stringPlugin ("default_authentication_plugin")
- Foreign
Key boolChecks ("foreign_key_checks")
- Generated
Random intPassword Length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.
- Global
Connection stringMemory Limit Set the total amount of memory that can be used by all user connections.
- Global
Connection boolMemory Tracking Determines whether the MySQL server calculates Global_connection_memory.
- Group
Replication stringConsistency - 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 intStats Expiry ("information_schema_stats_expiry")
- Innodb
Buffer intPool Dump Pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
- Innodb
Buffer intPool Instances ("innodb_buffer_pool_instances")
- Innodb
Buffer stringPool Size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
- Innodb
Ddl stringBuffer Size 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 intThreads 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 boolEnable Stopword ("innodb_ft_enable_stopword")
- Innodb
Ft intMax Token Size ("innodb_ft_max_token_size")
- Innodb
Ft intMin Token Size ("innodb_ft_min_token_size")
- Innodb
Ft intNum Word Optimize ("innodb_ft_num_word_optimize")
- Innodb
Ft stringResult Cache Limit ("innodb_ft_result_cache_limit")
- Innodb
Ft stringServer Stopword Table ("innodb_ft_server_stopword_table")
- Innodb
Lock intWait Timeout ("innodb_lock_wait_timeout")
- Innodb
Log boolWriter Threads 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 stringPurge Lag The desired maximum purge lag in terms of transactions.
- Innodb
Max intPurge Lag Delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
- Innodb
Stats stringPersistent Sample Pages 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 stringTransient Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
- Interactive
Timeout int The number of seconds the server waits for activity on an interactive connection before closing it.
- Local
Infile bool ("local_infile")
- Mandatory
Roles string ("mandatory_roles")
- Max
Allowed intPacket The maximum size of one packet or any generated/intermediate string.
- Max
Binlog stringCache Size Sets the size of the transaction cache.
- Max
Connect stringErrors ("max_connect_errors")
- Max
Connections int ("max_connections")
- Max
Execution stringTime ("max_execution_time")
- Max
Heap stringTable Size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
- Max
Prepared intStmt Count ("max_prepared_stmt_count")
- Mysql
Firewall boolMode ("mysql_firewall_mode")
- Mysql
Zstd intDefault Compression Level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
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 intTimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
- Mysqlx
Deflate intDefault Compression Level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- Mysqlx
Deflate intMax Client Compression Level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- Mysqlx
Document intId Unique Prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
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 boolHello Notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Idle intWorker Thread Timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
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 intTimeout The number of seconds to wait for interactive clients to timeout.
- Mysqlx
Lz4default intCompression Level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- Mysqlx
Lz4max intClient Compression Level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- Mysqlx
Max intAllowed Packet The maximum size of network packets that can be received by X Plugin.
- Mysqlx
Min intWorker Threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.
- Mysqlx
Read intTimeout 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.
- Mysqlx
Wait intTimeout The number of seconds that X Plugin waits for activity on a connection.
- Mysqlx
Write intTimeout 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 intDefault Compression Level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- Mysqlx
Zstd intMax Client Compression Level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- Net
Read intTimeout The number of seconds to wait for more data from a connection before aborting the read.
- Net
Write intTimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
- Parser
Max stringMem Size ("parser_max_mem_size")
- Query
Alloc stringBlock Size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.
- Query
Prealloc stringSize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.
- Regexp
Time intLimit 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)
- Sort
Buffer stringSize Each session that must perform a sort allocates a buffer of this size.
- Sql
Mode string ("sql_mode")
- Sql
Require boolPrimary Key ("sql_require_primary_key")
- Sql
Warnings bool ("sql_warnings")
- Thread
Pool boolDedicated Listeners 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.
- Thread
Pool intMax Transactions Limit 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.
- Time
Zone string Initializes the time zone for each client that connects.
- Tmp
Table stringSize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
- Transaction
Isolation string ("transaction_isolation")
- Wait
Timeout int The number of seconds the server waits for activity on a noninteractive connection before closing it.
- autocommit Boolean
("autocommit")
- big
Tables Boolean If enabled, the server stores all temporary tables on disk rather than in memory.
- binlog
Expire IntegerLogs Seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog
Row StringMetadata 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 StringValue Options 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.
- binlog
Transaction BooleanCompression 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.
- completion
Type String ("completion_type")
- connect
Timeout Integer The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
- connection
Memory IntegerChunk Size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
- connection
Memory StringLimit Set the maximum amount of memory that can be used by a single user connection.
- cte
Max StringRecursion Depth ("cte_max_recursion_depth")
- default
Authentication StringPlugin ("default_authentication_plugin")
- foreign
Key BooleanChecks ("foreign_key_checks")
- generated
Random IntegerPassword Length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.
- global
Connection StringMemory Limit Set the total amount of memory that can be used by all user connections.
- global
Connection BooleanMemory Tracking Determines whether the MySQL server calculates Global_connection_memory.
- group
Replication StringConsistency - 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 IntegerStats Expiry ("information_schema_stats_expiry")
- innodb
Buffer IntegerPool Dump Pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
- innodb
Buffer IntegerPool Instances ("innodb_buffer_pool_instances")
- innodb
Buffer StringPool Size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
- innodb
Ddl StringBuffer Size 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 IntegerThreads 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 BooleanEnable Stopword ("innodb_ft_enable_stopword")
- innodb
Ft IntegerMax Token Size ("innodb_ft_max_token_size")
- innodb
Ft IntegerMin Token Size ("innodb_ft_min_token_size")
- innodb
Ft IntegerNum Word Optimize ("innodb_ft_num_word_optimize")
- innodb
Ft StringResult Cache Limit ("innodb_ft_result_cache_limit")
- innodb
Ft StringServer Stopword Table ("innodb_ft_server_stopword_table")
- innodb
Lock IntegerWait Timeout ("innodb_lock_wait_timeout")
- innodb
Log BooleanWriter Threads 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 StringPurge Lag The desired maximum purge lag in terms of transactions.
- innodb
Max IntegerPurge Lag Delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
- innodb
Stats StringPersistent Sample Pages 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 StringTransient Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
- interactive
Timeout Integer The number of seconds the server waits for activity on an interactive connection before closing it.
- local
Infile Boolean ("local_infile")
- mandatory
Roles String ("mandatory_roles")
- max
Allowed IntegerPacket The maximum size of one packet or any generated/intermediate string.
- max
Binlog StringCache Size Sets the size of the transaction cache.
- max
Connect StringErrors ("max_connect_errors")
- max
Connections Integer ("max_connections")
- max
Execution StringTime ("max_execution_time")
- max
Heap StringTable Size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
- max
Prepared IntegerStmt Count ("max_prepared_stmt_count")
- mysql
Firewall BooleanMode ("mysql_firewall_mode")
- mysql
Zstd IntegerDefault Compression Level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
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 IntegerTimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
- mysqlx
Deflate IntegerDefault Compression Level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx
Deflate IntegerMax Client Compression Level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx
Document IntegerId Unique Prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
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 BooleanHello Notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Idle IntegerWorker Thread Timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
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 IntegerTimeout The number of seconds to wait for interactive clients to timeout.
- mysqlx
Lz4default IntegerCompression Level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx
Lz4max IntegerClient Compression Level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx
Max IntegerAllowed Packet The maximum size of network packets that can be received by X Plugin.
- mysqlx
Min IntegerWorker Threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.
- mysqlx
Read IntegerTimeout 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.
- mysqlx
Wait IntegerTimeout The number of seconds that X Plugin waits for activity on a connection.
- mysqlx
Write IntegerTimeout 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 IntegerDefault Compression Level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx
Zstd IntegerMax Client Compression Level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- net
Read IntegerTimeout The number of seconds to wait for more data from a connection before aborting the read.
- net
Write IntegerTimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
- parser
Max StringMem Size ("parser_max_mem_size")
- query
Alloc StringBlock Size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.
- query
Prealloc StringSize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.
- regexp
Time IntegerLimit 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)
- sort
Buffer StringSize Each session that must perform a sort allocates a buffer of this size.
- sql
Mode String ("sql_mode")
- sql
Require BooleanPrimary Key ("sql_require_primary_key")
- sql
Warnings Boolean ("sql_warnings")
- thread
Pool BooleanDedicated Listeners 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.
- thread
Pool IntegerMax Transactions Limit 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.
- time
Zone String Initializes the time zone for each client that connects.
- tmp
Table StringSize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
- transaction
Isolation String ("transaction_isolation")
- wait
Timeout Integer The number of seconds the server waits for activity on a noninteractive connection before closing it.
- autocommit boolean
("autocommit")
- big
Tables boolean If enabled, the server stores all temporary tables on disk rather than in memory.
- binlog
Expire numberLogs Seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog
Row stringMetadata 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 stringValue Options 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.
- binlog
Transaction booleanCompression 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.
- completion
Type string ("completion_type")
- connect
Timeout number The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
- connection
Memory numberChunk Size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
- connection
Memory stringLimit Set the maximum amount of memory that can be used by a single user connection.
- cte
Max stringRecursion Depth ("cte_max_recursion_depth")
- default
Authentication stringPlugin ("default_authentication_plugin")
- foreign
Key booleanChecks ("foreign_key_checks")
- generated
Random numberPassword Length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.
- global
Connection stringMemory Limit Set the total amount of memory that can be used by all user connections.
- global
Connection booleanMemory Tracking Determines whether the MySQL server calculates Global_connection_memory.
- group
Replication stringConsistency - 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 numberStats Expiry ("information_schema_stats_expiry")
- innodb
Buffer numberPool Dump Pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
- innodb
Buffer numberPool Instances ("innodb_buffer_pool_instances")
- innodb
Buffer stringPool Size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
- innodb
Ddl stringBuffer Size 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 numberThreads 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 booleanEnable Stopword ("innodb_ft_enable_stopword")
- innodb
Ft numberMax Token Size ("innodb_ft_max_token_size")
- innodb
Ft numberMin Token Size ("innodb_ft_min_token_size")
- innodb
Ft numberNum Word Optimize ("innodb_ft_num_word_optimize")
- innodb
Ft stringResult Cache Limit ("innodb_ft_result_cache_limit")
- innodb
Ft stringServer Stopword Table ("innodb_ft_server_stopword_table")
- innodb
Lock numberWait Timeout ("innodb_lock_wait_timeout")
- innodb
Log booleanWriter Threads 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 stringPurge Lag The desired maximum purge lag in terms of transactions.
- innodb
Max numberPurge Lag Delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
- innodb
Stats stringPersistent Sample Pages 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 stringTransient Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
- interactive
Timeout number The number of seconds the server waits for activity on an interactive connection before closing it.
- local
Infile boolean ("local_infile")
- mandatory
Roles string ("mandatory_roles")
- max
Allowed numberPacket The maximum size of one packet or any generated/intermediate string.
- max
Binlog stringCache Size Sets the size of the transaction cache.
- max
Connect stringErrors ("max_connect_errors")
- max
Connections number ("max_connections")
- max
Execution stringTime ("max_execution_time")
- max
Heap stringTable Size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
- max
Prepared numberStmt Count ("max_prepared_stmt_count")
- mysql
Firewall booleanMode ("mysql_firewall_mode")
- mysql
Zstd numberDefault Compression Level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
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 numberTimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
- mysqlx
Deflate numberDefault Compression Level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx
Deflate numberMax Client Compression Level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx
Document numberId Unique Prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
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 booleanHello Notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Idle numberWorker Thread Timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
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 numberTimeout The number of seconds to wait for interactive clients to timeout.
- mysqlx
Lz4default numberCompression Level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx
Lz4max numberClient Compression Level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx
Max numberAllowed Packet The maximum size of network packets that can be received by X Plugin.
- mysqlx
Min numberWorker Threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.
- mysqlx
Read numberTimeout 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.
- mysqlx
Wait numberTimeout The number of seconds that X Plugin waits for activity on a connection.
- mysqlx
Write numberTimeout 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 numberDefault Compression Level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx
Zstd numberMax Client Compression Level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- net
Read numberTimeout The number of seconds to wait for more data from a connection before aborting the read.
- net
Write numberTimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
- parser
Max stringMem Size ("parser_max_mem_size")
- query
Alloc stringBlock Size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.
- query
Prealloc stringSize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.
- regexp
Time numberLimit 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)
- sort
Buffer stringSize Each session that must perform a sort allocates a buffer of this size.
- sql
Mode string ("sql_mode")
- sql
Require booleanPrimary Key ("sql_require_primary_key")
- sql
Warnings boolean ("sql_warnings")
- thread
Pool booleanDedicated Listeners 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.
- thread
Pool numberMax Transactions Limit 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.
- time
Zone string Initializes the time zone for each client that connects.
- tmp
Table stringSize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
- transaction
Isolation string ("transaction_isolation")
- wait
Timeout number The number of seconds the server waits for activity on a noninteractive connection before closing it.
- autocommit bool
("autocommit")
- big_
tables bool If enabled, the server stores all temporary tables on disk rather than in memory.
- binlog_
expire_ intlogs_ seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog_
row_ strmetadata 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_ strvalue_ options 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.
- binlog_
transaction_ boolcompression 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.
- 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_ intchunk_ size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
- connection_
memory_ strlimit Set the maximum amount of memory that can be used by a single user connection.
- cte_
max_ strrecursion_ depth ("cte_max_recursion_depth")
- default_
authentication_ strplugin ("default_authentication_plugin")
- foreign_
key_ boolchecks ("foreign_key_checks")
- generated_
random_ intpassword_ length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.
- global_
connection_ strmemory_ limit Set the total amount of memory that can be used by all user connections.
- global_
connection_ boolmemory_ tracking Determines whether the MySQL server calculates Global_connection_memory.
- group_
replication_ strconsistency - 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_ intstats_ expiry ("information_schema_stats_expiry")
- innodb_
buffer_ intpool_ dump_ pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
- innodb_
buffer_ intpool_ instances ("innodb_buffer_pool_instances")
- innodb_
buffer_ strpool_ size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
- innodb_
ddl_ strbuffer_ size 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_ intthreads 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_ boolenable_ stopword ("innodb_ft_enable_stopword")
- innodb_
ft_ intmax_ token_ size ("innodb_ft_max_token_size")
- innodb_
ft_ intmin_ token_ size ("innodb_ft_min_token_size")
- innodb_
ft_ intnum_ word_ optimize ("innodb_ft_num_word_optimize")
- innodb_
ft_ strresult_ cache_ limit ("innodb_ft_result_cache_limit")
- innodb_
ft_ strserver_ stopword_ table ("innodb_ft_server_stopword_table")
- innodb_
lock_ intwait_ timeout ("innodb_lock_wait_timeout")
- innodb_
log_ boolwriter_ threads 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_ strpurge_ lag The desired maximum purge lag in terms of transactions.
- innodb_
max_ intpurge_ lag_ delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
- innodb_
stats_ strpersistent_ sample_ pages 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_ strtransient_ sample_ pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
- interactive_
timeout int The number of seconds the server waits for activity on an interactive connection before closing it.
- local_
infile bool ("local_infile")
- mandatory_
roles str ("mandatory_roles")
- max_
allowed_ intpacket The maximum size of one packet or any generated/intermediate string.
- max_
binlog_ strcache_ size Sets the size of the transaction cache.
- max_
connect_ strerrors ("max_connect_errors")
- max_
connections int ("max_connections")
- max_
execution_ strtime ("max_execution_time")
- max_
heap_ strtable_ size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
- max_
prepared_ intstmt_ count ("max_prepared_stmt_count")
- mysql_
firewall_ boolmode ("mysql_firewall_mode")
- mysql_
zstd_ intdefault_ compression_ level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
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_ inttimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
- mysqlx_
deflate_ intdefault_ compression_ level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx_
deflate_ intmax_ client_ compression_ level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx_
document_ intid_ unique_ prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
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_ boolhello_ notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
idle_ intworker_ thread_ timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
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_ inttimeout The number of seconds to wait for interactive clients to timeout.
- mysqlx_
lz4default_ intcompression_ level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx_
lz4max_ intclient_ compression_ level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx_
max_ intallowed_ packet The maximum size of network packets that can be received by X Plugin.
- mysqlx_
min_ intworker_ threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.
- mysqlx_
read_ inttimeout 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.
- mysqlx_
wait_ inttimeout The number of seconds that X Plugin waits for activity on a connection.
- mysqlx_
write_ inttimeout 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_ intdefault_ compression_ level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx_
zstd_ intmax_ client_ compression_ level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- net_
read_ inttimeout The number of seconds to wait for more data from a connection before aborting the read.
- net_
write_ inttimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
- parser_
max_ strmem_ size ("parser_max_mem_size")
- query_
alloc_ strblock_ size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.
- query_
prealloc_ strsize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.
- regexp_
time_ intlimit 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)
- sort_
buffer_ strsize Each session that must perform a sort allocates a buffer of this size.
- sql_
mode str ("sql_mode")
- sql_
require_ boolprimary_ key ("sql_require_primary_key")
- sql_
warnings bool ("sql_warnings")
- thread_
pool_ booldedicated_ listeners 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.
- thread_
pool_ intmax_ transactions_ limit 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.
- time_
zone str Initializes the time zone for each client that connects.
- tmp_
table_ strsize 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.
- autocommit Boolean
("autocommit")
- big
Tables Boolean If enabled, the server stores all temporary tables on disk rather than in memory.
- binlog
Expire NumberLogs Seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog
Row StringMetadata 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 StringValue Options 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.
- binlog
Transaction BooleanCompression 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.
- completion
Type String ("completion_type")
- connect
Timeout Number The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
- connection
Memory NumberChunk Size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
- connection
Memory StringLimit Set the maximum amount of memory that can be used by a single user connection.
- cte
Max StringRecursion Depth ("cte_max_recursion_depth")
- default
Authentication StringPlugin ("default_authentication_plugin")
- foreign
Key BooleanChecks ("foreign_key_checks")
- generated
Random NumberPassword Length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.
- global
Connection StringMemory Limit Set the total amount of memory that can be used by all user connections.
- global
Connection BooleanMemory Tracking Determines whether the MySQL server calculates Global_connection_memory.
- group
Replication StringConsistency - 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 NumberStats Expiry ("information_schema_stats_expiry")
- innodb
Buffer NumberPool Dump Pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
- innodb
Buffer NumberPool Instances ("innodb_buffer_pool_instances")
- innodb
Buffer StringPool Size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
- innodb
Ddl StringBuffer Size 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 NumberThreads 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 BooleanEnable Stopword ("innodb_ft_enable_stopword")
- innodb
Ft NumberMax Token Size ("innodb_ft_max_token_size")
- innodb
Ft NumberMin Token Size ("innodb_ft_min_token_size")
- innodb
Ft NumberNum Word Optimize ("innodb_ft_num_word_optimize")
- innodb
Ft StringResult Cache Limit ("innodb_ft_result_cache_limit")
- innodb
Ft StringServer Stopword Table ("innodb_ft_server_stopword_table")
- innodb
Lock NumberWait Timeout ("innodb_lock_wait_timeout")
- innodb
Log BooleanWriter Threads 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 StringPurge Lag The desired maximum purge lag in terms of transactions.
- innodb
Max NumberPurge Lag Delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
- innodb
Stats StringPersistent Sample Pages 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 StringTransient Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
- interactive
Timeout Number The number of seconds the server waits for activity on an interactive connection before closing it.
- local
Infile Boolean ("local_infile")
- mandatory
Roles String ("mandatory_roles")
- max
Allowed NumberPacket The maximum size of one packet or any generated/intermediate string.
- max
Binlog StringCache Size Sets the size of the transaction cache.
- max
Connect StringErrors ("max_connect_errors")
- max
Connections Number ("max_connections")
- max
Execution StringTime ("max_execution_time")
- max
Heap StringTable Size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
- max
Prepared NumberStmt Count ("max_prepared_stmt_count")
- mysql
Firewall BooleanMode ("mysql_firewall_mode")
- mysql
Zstd NumberDefault Compression Level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
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 NumberTimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
- mysqlx
Deflate NumberDefault Compression Level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx
Deflate NumberMax Client Compression Level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx
Document NumberId Unique Prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
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 BooleanHello Notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Idle NumberWorker Thread Timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
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 NumberTimeout The number of seconds to wait for interactive clients to timeout.
- mysqlx
Lz4default NumberCompression Level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx
Lz4max NumberClient Compression Level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx
Max NumberAllowed Packet The maximum size of network packets that can be received by X Plugin.
- mysqlx
Min NumberWorker Threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.
- mysqlx
Read NumberTimeout 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.
- mysqlx
Wait NumberTimeout The number of seconds that X Plugin waits for activity on a connection.
- mysqlx
Write NumberTimeout 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 NumberDefault Compression Level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx
Zstd NumberMax Client Compression Level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- net
Read NumberTimeout The number of seconds to wait for more data from a connection before aborting the read.
- net
Write NumberTimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
- parser
Max StringMem Size ("parser_max_mem_size")
- query
Alloc StringBlock Size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.
- query
Prealloc StringSize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.
- regexp
Time NumberLimit 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)
- sort
Buffer StringSize Each session that must perform a sort allocates a buffer of this size.
- sql
Mode String ("sql_mode")
- sql
Require BooleanPrimary Key ("sql_require_primary_key")
- sql
Warnings Boolean ("sql_warnings")
- thread
Pool BooleanDedicated Listeners 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.
- thread
Pool NumberMax Transactions Limit 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.
- time
Zone String Initializes the time zone for each client that connects.
- tmp
Table StringSize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
- transaction
Isolation String ("transaction_isolation")
- wait
Timeout Number The number of seconds the server waits for activity on a noninteractive connection before closing it.
GetMysqlConfigurationsFilter
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
ociTerraform Provider.