System Variables

MariaDB starting with 10.5

The S3 storage engine has been available since MariaDB 10.5.4.

This page documents system variables related to the S3 storage engine.

See Server System Variables for a complete list of system variables and instructions on setting system variables.

Also see the Full list of MariaDB options, system and status variables

Variables

s3_access_key

• Description: The AWS access key to access your data. See mariadbd startup options for S3.

• Commandline: --s3-access-key=val

• Scope: Global

• Dynamic: No

• Data Type: String

• Default Value: (Empty)

• Introduced: MariaDB 10.5.4

s3_block_size

• Description: The default block size for a table, if not specified in CREATE TABLE. Set to 4M as default. See mysqld startup options for S3.

• Commandline: --s3-block-size=#

• Scope: Global

• Dynamic: Yes

• Data Type: Numeric

• Default Value: 4194304

• Range: 4194304 to 16777216

• Introduced: MariaDB 10.5.4

s3_bucket

• Description: The AWS bucket where your data should be stored. All MariaDB table data is stored in this bucket. See mysqld startup options for S3.

• Commandline: --s3-bucket=val

• Scope: Global

• Dynamic: No

• Data Type: String

• Default Value: MariaDB

• Introduced: MariaDB 10.5.4

s3_debug

• Description: Generates a trace file from libmarias3 on stderr (mysqld.err) for debugging the S3 protocol.

• Commandline: --s3-debug=[0|1]

• Scope: Global

• Dynamic:

  • Yes (>= MariaDB 10.6.17, MariaDB 10.11.7, MariaDB 11.0.5, MariaDB 11.1.4, MariaDB 11.2.3, MariaDB 11.3.2, MariaDB 11.4.1)

  • No (<= MariaDB 10.6.16, MariaDB 10.11.6, MariaDB 11.0.4, MariaDB 11.1.3, MariaDB 11.2.2, MariaDB 11.3.1)

• Data Type: Boolean

• Valid Values: 0 or 1

• Default Value: 0

• Introduced: MariaDB 10.5.4

s3_host_name

• Description: Hostname for the S3 service. "s3.amazonaws.com", Amazon S3 service, by default

• Commandline: --s3-host-name=val

• Scope: Global

• Dynamic: No

• Data Type: String

• Default Value: s3.amazonaws.com

• Introduced: MariaDB 10.5.4

s3_no_content_type

• Description: If true (false is default), disables the Content-Type header, required for some providers.

• Commandline: --s3-no-content-type=[0|1]

• Scope: Global

• Dynamic: No

• Data Type: Boolean

• Default Value: 0

• Introduced: MariaDB 11.6.2

s3_pagecache_age_threshold

• Description: This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in the page cache.

• Commandline: --s3-pagecache-age-threshold=val

• Scope: Global

• Dynamic: Yes

• Data Type: Numeric

• Default Value: 300

• Range: 100 to 18446744073709551615

• Introduced: MariaDB 10.5.4

s3_pagecache_buffer_size

• Description: The size of the buffer used for index blocks for S3 tables. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford. Size can be adjusted in blocks of 8192.

• Commandline: --s3-pagecache-buffer-size=val

• Scope: Global

• Dynamic: No

• Data Type: Numeric

• Default Value: 134217728 (128M)

• Range: 33554432 to 18446744073709551615

• Introduced: MariaDB 10.5.4

s3_pagecache_division_limit

• Description: The minimum percentage of warm blocks in key cache.

• Commandline: --s3-pagecache-division-limit=val

• Scope: Global

• Dynamic: Yes

• Data Type: Numeric

• Default Value: 100

• Range: 1 to 100

• Introduced: MariaDB 10.5.4

s3_pagecache_file_hash_size

• Description: Number of hash buckets for open files. Default 512. If you have a lot of S3 files open you should increase this for faster flush of changes. A good value is probably 1/10 of number of possible open S3 files.

• Commandline: --s3-pagecache-file-hash-size=#

• Scope: Global

• Dynamic: No

• Data Type: Numeric

• Default Value: 512

• Range: 32 to 16384

• Introduced: MariaDB 10.5.4

s3_port

• Description: The TCP port number on the S3 host to connect to. A values of 0 means determine automatically.

• Commandline: --s3-port=#

• Scope: Global

• Dynamic: No

• Data Type: Numeric

• Default Value: 0

• Range: 0 to 65535

• Introduced: MariaDB 10.5.7

s3_protocol_version

• Description: Protocol used to communication with S3. "Auto" is the default. If you get errors like "8 Access Denied" when you are connecting to another service provider, then try to change this option. The reason for this variable is that Amazon has changed some parts of the S3 protocol since they originally introduced it but other service providers are still using the original protocol. Can also be set numerically.

  • Auto (0):

  • Original or (1): Same as "Auto". Deprecated from MariaDB 10.6.17, MariaDB 10.11.7, MariaDB 11.0.5, MariaDB 11.1.4, MariaDB 11.2.3, MariaDB 11.3.2, MariaDB 11.4.1.

  • Amazon (2) Same as "Auto". Deprecated from MariaDB 10.6.17, MariaDB 10.11.7, MariaDB 11.0.5, MariaDB 11.1.4, MariaDB 11.2.3, MariaDB 11.3.2, MariaDB 11.4.1.

  • Legacy (3): v1 protocol. From MariaDB 10.6.17, MariaDB 10.11.7, MariaDB 11.0.5, MariaDB 11.1.4, MariaDB 11.2.3, MariaDB 11.3.2, MariaDB 11.4.1

  • Path (4): From MariaDB 10.6.17, MariaDB 10.11.7, MariaDB 11.0.5, MariaDB 11.1.4, MariaDB 11.2.3, MariaDB 11.3.2, MariaDB 11.4.1

  • Domain (5): From MariaDB 10.6.17, MariaDB 10.11.7, MariaDB 11.0.5, MariaDB 11.1.4, MariaDB 11.2.3, MariaDB 11.3.2, MariaDB 11.4.1

• Commandline: --s3-protocol-version=val

• Scope: Global

• Dynamic: Yes

• Data Type: Enum

• Valid Values:

  • Auto(0) , Original (1), Amazon (2), Legacy (3), Path (4), Domain (5) (>= MariaDB 10.6.17, MariaDB 10.11.7, MariaDB 11.0.5, MariaDB 11.1.4, MariaDB 11.2.3, MariaDB 11.3.2, MariaDB 11.4.1)

  • Auto, Original, Amazon (<= MariaDB 10.6.16, MariaDB 10.11.6, MariaDB 11.0.4, MariaDB 11.1.3, MariaDB 11.2.2, MariaDB 11.3.1)

• Default Value: Auto

• Introduced: MariaDB 10.5.4

s3_provider

• Description: Enable S3 provider specific compatibility tweaks. "Default", "Amazon", or "Huawei".

  • Default:

  • Amazon: Effectively sets s3_protocol_version to 5 (Domain), overriding any other setting it may have.

  • Huawei: Effectively sets s3_no_content_type to 1, overriding any other setting it may have.

• Commandline: --s3-provider=val

• Scope: Global

• Dynamic: Yes

• Data Type: enum

• Valid Values: Default, Amazon, Huawei

• Default Value: Default

• Introduced: MariaDB 10.6.20, MariaDB 10.11.10, MariaDB 11.2.6, MariaDB 11.4.4, MariaDB 11.6.2

s3_region

• Description: The AWS region where your data should be stored. See mysqld startup options for S3.

• Commandline: --s3-region=val

• Scope: Global

• Dynamic: No

• Data Type: String

• Default Value: (Empty)

• Introduced: MariaDB 10.5.4

s3_replicate_alter_as_create_select

• Description: When converting S3 table to local table, log all rows in binary log. This allows the slave to replicate CREATE TABLE .. SELECT FROM s3_table even it the slave doesn't have access to the original s3_table.

• Commandline: --s3-replicate-alter-as-create-select=[0|1]

• Scope: Global

• Dynamic: No

• Data Type: Boolean

• Default Value: 1

• Introduced: MariaDB 10.5.4

s3_secret_key

• Description: The AWS secret key to access your data. See mysqld startup options for S3.

• Commandline: --s3-secret-key=val

• Scope: Global

• Dynamic: No

• Data Type: String

• Default Value: (Empty)

• Introduced: MariaDB 10.5.4

s3_slave_ignore_updates

• Description: Should be set if master and slave share the same S3 instance. This tells the slave that it can ignore any updates to the S3 tables as they are already applied on the master.

• Commandline: --s3-slave-ignore-updates=[0|1]

• Scope: Global

• Dynamic: No

• Data Type: Boolean

• Default Value: 0

• Introduced: MariaDB 10.5.4

s3_ssl_no_verify

• Description: If true, SSL certificate verification for the S3 endpoint is disabled

• Commandline: --s3-ssl-no-verify=[0|1]

• Scope: Global

• Dynamic: No

• Data Type: Boolean

• Default Value: 0

• Introduced: MariaDB 10.6.20, MariaDB 10.11.10, MariaDB 11.2.6, MariaDB 11.4.4, MariaDB 11.6.2

s3_use_http

• Description: If enabled, HTTP will be used instead of HTTPS.

• Commandline: --s3-use-http=[0|1]

• Scope: Global

• Dynamic: No

• Data Type: Boolean

• Default Value: 0

• Introduced: MariaDB 10.5.7

See Also

Using the S3 Storage Engine

_{This page is licensed: CC BY-SA / Gnu FDL}