Configuration Management

Overview

The MariaDB SkySQL Configuration Manager allows you to customize the values of many System Variables, which are called Configuration Variables within the Configuration Manager.

The "Configuration Manager" option is found in the SkySQL main menu (left navigation) and is visible after you have launched your first service.

What is configurable?

Available configuration parameters differ by service and topology.

For Distributed Transactions, only the default_time_zone is configurable in the Configuration Manager.

Enterprise Server

The following table lists parameter-availability by topology for Single Node Transactions (SNT), Replicated Transactions (RT), Single Node Analytics (SNA), and Multi-Node Analytics (MNA):

Parameter / Topology

SNT1

RT2

SNA3

MNA4

binlog_commit_wait_count

No

Yes

No

No

binlog_commit_wait_usec

No

Yes

No

No

cracklib_password_check

Yes

Yes

Yes

Yes

default_password_lifetime

Yes

Yes

Yes

Yes

default_time_zone

Yes

Yes

No

No

disconnect_on_expired_password

Yes

Yes

Yes

Yes

div_precision_increment

Yes

Yes

Yes

Yes

eq_range_index_dive_limit

Yes

Yes

Yes

Yes

event_scheduler

Yes

Yes

Yes

Yes

gtid_strict_mode

No

Yes

No

No

idle_readonly_transaction_timeout

Yes

Yes

Yes

Yes

idle_transaction_timeout

Yes

Yes

Yes

Yes

idle_write_transaction_timeout

Yes

Yes

Yes

Yes

innodb_flush_log_at_trx_commit

Yes

Yes

No

Yes

innodb_log_file_size

Yes

Yes

No

Yes

interactive_timeout

Yes

Yes

Yes

Yes

local_infile

Yes

Yes

Yes

Yes

log_warnings

Yes

Yes

Yes

Yes

long_query_time

Yes

Yes

Yes

Yes

lower_case_table_names

Yes

Yes

Yes

Yes

max_allowed_packet

Yes

Yes

Yes

Yes

max_password_errors

Yes

Yes

Yes

Yes

optimizer_search_depth

Yes

Yes

Yes

Yes

performance_schema

Yes

Yes

Yes

Yes

performance_schema_accounts_size

Yes

Yes

Yes

Yes

performance_schema_digests_size

Yes

Yes

Yes

Yes

performance_schema_events_stages_history_long_size

Yes

Yes

Yes

Yes

performance_schema_events_stages_history_size

Yes

Yes

Yes

Yes

performance_schema_events_statements_history_long_size

Yes

Yes

Yes

Yes

performance_schema_events_statements_history_size

Yes

Yes

Yes

Yes

performance_schema_events_waits_history_long_size

Yes

Yes

Yes

Yes

performance_schema_events_waits_history_size

Yes

Yes

Yes

Yes

performance_schema_hosts_size

Yes

Yes

Yes

Yes

performance_schema_max_cond_classes

Yes

Yes

Yes

Yes

performance_schema_max_cond_instances

Yes

Yes

Yes

Yes

performance_schema_max_digest_length

Yes

Yes

Yes

Yes

performance_schema_max_file_classes

Yes

Yes

Yes

Yes

performance_schema_max_file_handles

Yes

Yes

Yes

Yes

performance_schema_max_file_instances

Yes

Yes

Yes

Yes

performance_schema_max_mutex_classes

Yes

Yes

Yes

Yes

performance_schema_max_mutex_instances

Yes

Yes

Yes

Yes

performance_schema_max_rwlock_classes

Yes

Yes

Yes

Yes

performance_schema_max_rwlock_instances

Yes

Yes

Yes

Yes

performance_schema_max_socket_classes

Yes

Yes

Yes

Yes

performance_schema_max_socket_instances

Yes

Yes

Yes

Yes

performance_schema_max_stage_classes

Yes

Yes

Yes

Yes

performance_schema_max_statement_classes

Yes

Yes

Yes

Yes

performance_schema_max_table_handles

Yes

Yes

Yes

Yes

performance_schema_max_table_instances

Yes

Yes

Yes

Yes

performance_schema_max_thread_classes

Yes

Yes

Yes

Yes

performance_schema_max_thread_instances

Yes

Yes

Yes

Yes

performance_schema_session_connect_attrs_size

Yes

Yes

Yes

Yes

performance_schema_users_size

Yes

Yes

Yes

Yes

rpl_semi_sync_master_enabled

No

Yes

No

No

rpl_semi_sync_master_timeout

No

Yes

No

No

rpl_semi_sync_master_wait_no_slave

No

Yes

No

No

rpl_semi_sync_master_wait_point

No

Yes

No

No

rpl_semi_sync_slave_delay_master

No

Yes

No

No

rpl_semi_sync_slave_enabled

No

Yes

No

No

rpl_semi_sync_slave_kill_conn_timeout

No

Yes

No

No

server_audit

Yes

Yes

Yes

Yes

server_audit_logging

Yes

Yes

Yes

Yes

simple_password_check_digits

Yes

Yes

Yes

Yes

simple_password_check_letters_same_case

Yes

Yes

Yes

Yes

simple_password_check_minimal_length

Yes

Yes

Yes

Yes

simple_password_check_other_characters

Yes

Yes

Yes

Yes

slave_compressed_protocol

No

Yes

No

No

slave_parallel_mode

No

Yes

No

No

slave_parallel_threads

No

Yes

No

No

slave_parallel_workers

No

Yes

No

No

slow_query_log

Yes

Yes

Yes

Yes

sql_mode

Yes

Yes

Yes

No

strict_password_validation

Yes

Yes

Yes

Yes

sync_binlog

No

Yes

No

No

sync_master_info

No

Yes

No

No

sync_relay_log

No

Yes

No

No

sync_relay_log_info

No

Yes

No

No

system_versioning_alter_history

Yes

Yes

Yes

Yes

thread_cache_size

Yes

Yes

Yes

Yes

thread_handling

Yes

Yes

Yes

Yes

thread_pool_idle_timeout

Yes

Yes

Yes

Yes

thread_pool_max_threads

Yes

Yes

Yes

Yes

thread_pool_priority

Yes

Yes

Yes

Yes

thread_pool_size

Yes

Yes

Yes

Yes

tx_isolation

Yes

Yes

Yes

Yes

wait_timeout

Yes

Yes

Yes

Yes

1:

Single Node Transactions

2:

Replicated Transactions

3:

Single Node Analytics

4:

Multi-Node Analytics

Allowed Values

Enterprise Server

Configuration Variable

Allowed Values

Comments

binlog_commit_wait_count

0, 5, 25, 100, 500, 1000, 5000

Only Replicated Transactions

binlog_commit_wait_usec

0, 10000, 100000, 500000, 1000000

Only Replicated Transactions

cracklib_password_check

OFF, ON, FORCE, FORCE_PLUS_PERMANENT

default_password_lifetime

0, 7, 14, 30, 90, 180, 365

default_time_zone

a valid IANA time zone value

Only Single Node Transactions & Replicated Transactions

disconnect_on_expired_password

OFF, ON

div_precision_increment

0, 4, 38

eq_range_index_dive_limit

0, 200, 2000, 6000, 12000, 20000

event_scheduler

ON, OFF

gtid_strict_mode

OFF, ON

Only Replicated Transactions

idle_readonly_transaction_timeout

0, 300, 600, 3600, 86400, 604800, 31536000

idle_transaction_timeout

0, 300, 600, 3600, 86400, 604800, 31536000

idle_write_transaction_timeout

0, 300, 600, 3600, 86400, 604800, 31536000

innodb_flush_log_at_trx_commit

0, 1, 2

Not Single Node Analytics

innodb_log_file_size

1MB, 512MB, 1GB, 4GB, 8GB, 16GB, 32GB, 64GB, 128GB

Not Single Node Analytics

interactive_timeout

300, 600, 3600, 28800, 86400

local_infile

OFF, ON

log_warnings

1, 2, 3, 4, 9

long_query_time

10ms, 20ms, 30ms, 40ms, 50ms, 60ms, 70ms, 80ms, 90ms, 100ms, 150ms, 200ms, 300ms, 500ms, 1s, 2s, 3s, 4s, 5s, 6s, 7s, 8s, 9s, 10s, 15s, 20s, 30s, 1m, 2m, 3m, 5m, 10m, 15m

lower_case_table_names

0, 1, 2

max_allowed_packet

33554432, 67108864, 268435456, 536870912, 1073741824

max_password_errors

1, 5, 10, 50, 4294967295

optimizer_search_depth

0, 8, 16, 32, 48, 56, 62

performance_schema

OFF, ON

performance_schema_accounts_size

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_digests_size

-1, 0, 10, 50, 100, 200

performance_schema_events_stages_history_long_size

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_events_stages_history_size

-1, 0, 16, 128, 256, 512, 1024

performance_schema_events_statements_history_long_size

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_events_statements_history_size

-1, 0, 16, 128, 256, 512, 1024

performance_schema_events_waits_history_long_size

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_events_waits_history_size

-1, 0, 16, 128, 256, 512, 1024

performance_schema_hosts_size

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_max_cond_classes

0, 40, 90, 150, 200, 250

performance_schema_max_cond_instances

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_max_digest_length

0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_max_file_classes

0, 40, 80, 150, 210, 250

performance_schema_max_file_handles

-1, 0, 16, 128, 1024, 8192, 32768

performance_schema_max_file_instances

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_max_mutex_classes

0, 40, 90, 150, 210, 250

performance_schema_max_mutex_instances

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_max_rwlock_classes

0, 50, 90, 150, 200, 250

performance_schema_max_rwlock_instances

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_max_socket_classes

0, 10, 40, 90, 150, 200, 250

performance_schema_max_socket_instances

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_max_stage_classes

0, 40, 90, 160, 210, 250

performance_schema_max_statement_classes

Autosized or 0

performance_schema_max_table_handles

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_max_table_instances

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_max_thread_classes

0, 50, 90, 150, 210, 250

performance_schema_max_thread_instances

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_session_connect_attrs_size

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

performance_schema_users_size

-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576

rpl_semi_sync_master_enabled

OFF, ON

Only Replicated Transactions

rpl_semi_sync_master_timeout

1000, 10000, 30000, 60000, 120000, 600000

Only Replicated Transactions

rpl_semi_sync_master_wait_no_slave

OFF, ON

Only Replicated Transactions

rpl_semi_sync_master_wait_point

AFTER_SYNC, AFTER_COMMIT

Only Replicated Transactions

rpl_semi_sync_slave_delay_master

OFF, ON

Only Replicated Transactions

rpl_semi_sync_slave_enabled

OFF, ON

Only Replicated Transactions

rpl_semi_sync_slave_kill_conn_timeout

0, 5, 10, 30, 60

Only Replicated Transactions

server_audit

OFF, ON, FORCE, FORCE_PLUS_PERMANENT

server_audit_logging

ON, OFF

simple_password_check_digits

0, 1, 2, 5, 10

simple_password_check_letters_same_case

0, 1, 2, 5, 10

simple_password_check_minimal_length

0, 1, 8, 12, 16, 20, 32

simple_password_check_other_characters

0, 1, 2, 5, 10

slave_compressed_protocol

ON, OFF

Only Replicated Transactions

slave_parallel_mode

none, minimal, conservative, optimistic, aggressive

Only Replicated Transactions

slave_parallel_threads

0, 2, 4, 8, 16, 32, 64, 128, 256

Only Replicated Transactions

slave_parallel_workers

0, 2, 4, 8, 16, 32, 64, 128, 256

Only Replicated Transactions

slow_query_log

ON, OFF

sql_mode

0 or more of the following: DB2, MSSQL, ORACLE, POSTGRESQL

Not Multi-Node Analytics

strict_password_validation

OFF, ON

sync_binlog

0, 1, 10, 100, 1000, 10000, 100000

Only Replicated Transactions

sync_master_info

0, 1, 10, 100, 1000, 10000, 100000

Only Replicated Transactions

sync_relay_log

0, 1, 10, 100, 1000, 10000, 100000

Only Replicated Transactions

sync_relay_log_info

0, 1, 10, 100, 1000, 10000, 100000

Only Replicated Transactions

system_versioning_alter_history

ERROR, KEEP

thread_cache_size

0, 128, 256, 512, 1024, 2048, 4096

thread_handling

ONE-THREAD-PER-CONNECTION, NO-THREADS, POOL-OF-THREADS

thread_pool_idle_timeout

1, 300, 600, 3600, 86400, 604800, 31536000

thread_pool_max_threads

0, 128, 256, 512, 1024, 2048, 4096

thread_pool_priority

high, low, auto

thread_pool_size

0, 16, 32, 64, 128, 256, 512, 1024, 2048

tx_isolation

READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE

wait_timeout

300, 600, 3600, 28800, 86400

MariaDB MaxScale

Section

Parameter

Allowed Values

MariaDBMon

detect_stale_master

Default, TRUE

MariaDBMon

detect_stale_slave

Default, TRUE, FALSE

MariaDBMon

detect_standalone_master

Default, TRUE, FALSE

MariaDBMon

failcount

Default, 1, 5, 10

MariaDBMon

monitor_interval

500, 1000, 2000, 5000, 10000, 15000, 30000, 60000

ReadWriteSplit

causal_reads

Default, TRUE, FALSE

ReadWriteSplit

causal_reads_timeout

Default, 5, 10, 30, 60

ReadWriteSplit

delayed_retry

Default, TRUE, FALSE

ReadWriteSplit

delayed_retry_timeout

Default, 5, 10, 30, 60

ReadWriteSplit

master_accept_reads

Default, TRUE, FALSE

ReadWriteSplit

master_reconnection

Default, TRUE, FALSE

ReadWriteSplit

max_slave_connections

Default, 10%, 25%, 33%, 50%

ReadWriteSplit

max_slave_replication_lag

Default, 10 30 60 120 600 1800 3600

ReadWriteSplit

slave_selection_criteria

Default, LEAST_GLOBAL_CONNECTIONS, LEAST_ROUTER_CONNECTIONS, LEAST_BEHIND_MASTER, LEAST_CURRENT_OPERATIONS, ADAPTIVE_ROUTING

ReadWriteSplit

strict_multi_stmt

Default, TRUE, FALSE

ReadWriteSplit

strict_sp_calls

Default, TRUE, FALSE

ReadWriteSplit

transaction_replay

Default, TRUE, FALSE

ReadWriteSplit

transaction_replay_attempts

Default, 1, 5, 10

ReadWriteSplit

transaction_replay_max_size

Default, 1M, 16M, 32M, 64M

ReadWriteSplit

transaction_replay_retry_on_deadlock

Default, TRUE, FALSE

ReadWriteSplit

use_sql_variables_in

Default, MASTER, ALL