MariaDB System-Variablen

Siehe auch

Die Default-Werte der System-Variablen in den einzelnen Versionen von 10.5 bis 5.5 im Vergleich. System-Variablen, die beispielsweise auf https://mariadb.com/kb/en/library/server-system-variables/ mit „Dynamic: Yes“ gekennzeichnet sind, können zur Laufzeit des Servers angepasst werden.

Variable

10.5

10.4

10.3

10.2

10.1

10.0

5.5

alter_algorithm

DEFAULT

DEFAULT

DEFAULT

N/A

N/A

N/A

N/A

analyze_sample_percentage

100.000000

100.000000

N/A

N/A

N/A

N/A

N/A

aria_block_size

8192

8192

8192

8192

8192

8192

8192

aria_checkpoint_interval

30

30

30

30

30

30

30

aria_checkpoint_log_activity

1048576

1048576

1048576

1048576

1048576

1048576

1048576

aria_encrypt_tables

OFF

OFF

OFF

OFF

OFF

N/A

N/A

aria_force_start_after_recovery_failures

0

0

0

0

0

0

0

aria_group_commit

none

none

none

none

none

none

none

aria_group_commit_interval

0

0

0

0

0

0

0

aria_log_file_size

1073741824

1073741824

1073741824

1073741824

1073741824

1073741824

1073741824

aria_log_purge_type

immediate

immediate

immediate

immediate

immediate

immediate

immediate

aria_max_sort_file_size

9223372036853727232

9223372036853727232

9223372036853727232

9223372036853727232

9223372036853727232

9223372036853727232

9223372036853727232

aria_page_checksum

ON

ON

ON

ON

ON

ON

ON

aria_pagecache_age_threshold

300

300

300

300

300

300

300

aria_pagecache_buffer_size

134217728

134217728

134217728

134217728

134217728

134217728

134217728

aria_pagecache_division_limit

100

100

100

100

100

100

100

aria_pagecache_file_hash_size

512

512

512

512

512

512

N/A

aria_recover

N/A

N/A

N/A

N/A

NORMAL

NORMAL

NORMAL

aria_recover_options

BACKUP,QUICK

BACKUP,QUICK

BACKUP,QUICK

BACKUP,QUICK

N/A

N/A

N/A

aria_repair_threads

1

1

1

1

1

1

1

aria_sort_buffer_size

268434432

268434432

268434432

268434432

268434432

268434432

134217728

aria_stats_method

nulls_unequal

nulls_unequal

nulls_unequal

nulls_unequal

nulls_unequal

nulls_unequal

nulls_unequal

aria_sync_log_dir

NEWFILE

NEWFILE

NEWFILE

NEWFILE

NEWFILE

NEWFILE

NEWFILE

aria_used_for_temp_tables

ON

ON

ON

ON

ON

ON

ON

auto_increment_increment

1

1

1

1

1

1

1

auto_increment_offset

1

1

1

1

1

1

1

autocommit

ON

ON

ON

ON

ON

ON

ON

automatic_sp_privileges

ON

ON

ON

ON

ON

ON

ON

back_log

80

80

80

80

80

150

50

basedir

/usr/

/usr/

/usr

/usr

/usr

/usr

/usr

big_tables

OFF

OFF

OFF

OFF

OFF

OFF

OFF

binlog_annotate_row_events

ON

ON

ON

ON

OFF

OFF

OFF

binlog_cache_size

32768

32768

32768

32768

32768

32768

32768

binlog_checksum

CRC32

CRC32

CRC32

CRC32

NONE

NONE

NONE

binlog_commit_wait_count

0

0

0

0

0

0

N/A

binlog_commit_wait_usec

100000

100000

100000

100000

100000

100000

N/A

binlog_direct_non_transactional_updates

OFF

OFF

OFF

OFF

OFF

OFF

OFF

binlog_file_cache_size

16384

16384

16384

N/A

N/A

N/A

N/A

binlog_format

MIXED

MIXED

MIXED

MIXED

STATEMENT

STATEMENT

STATEMENT

binlog_optimize_thread_scheduling

ON

ON

ON

ON

ON

ON

ON

binlog_row_image

FULL

FULL

FULL

FULL

FULL

N/A

N/A

binlog_row_metadata

NO_LOG

N/A

N/A

N/A

N/A

N/A

N/A

binlog_stmt_cache_size

32768

32768

32768

32768

32768

32768

32768

bulk_insert_buffer_size

8388608

8388608

8388608

8388608

8388608

8388608

8388608

character_set_client

utf8

utf8

utf8

utf8

utf8

utf8

utf8

character_set_connection

utf8

utf8

utf8

utf8

utf8

utf8

utf8

character_set_database

latin1

latin1

latin1

latin1

latin1

latin1

latin1

character_set_filesystem

binary

binary

binary

binary

binary

binary

binary

character_set_results

utf8

utf8

utf8

utf8

utf8

utf8

utf8

character_set_server

latin1

latin1

latin1

latin1

latin1

latin1

latin1

character_set_system

utf8

utf8

utf8

utf8

utf8

utf8

utf8

character_sets_dir

/usr/share/mysql/charsets/

/usr/share/mysql/charsets/

/usr/share/mysql/charsets/

/usr/share/mysql/charsets/

/usr/share/mysql/charsets/

/usr/share/mysql/charsets/

/usr/share/mysql/charsets/

check_constraint_checks

ON

ON

ON

ON

N/A

N/A

N/A

collation_connection

utf8_general_ci

utf8_general_ci

utf8_general_ci

utf8_general_ci

utf8_general_ci

utf8_general_ci

utf8_general_ci

collation_database

latin1_swedish_ci

latin1_swedish_ci

latin1_swedish_ci

latin1_swedish_ci

latin1_swedish_ci

latin1_swedish_ci

latin1_swedish_ci

collation_server

latin1_swedish_ci

latin1_swedish_ci

latin1_swedish_ci

latin1_swedish_ci

latin1_swedish_ci

latin1_swedish_ci

latin1_swedish_ci

column_compression_threshold

100

100

100

N/A

N/A

N/A

N/A

column_compression_zlib_level

6

6

6

N/A

N/A

N/A

N/A

column_compression_zlib_strategy

DEFAULT_STRATEGY

DEFAULT_STRATEGY

DEFAULT_STRATEGY

N/A

N/A

N/A

N/A

column_compression_zlib_wrap

OFF

OFF

OFF

N/A

N/A

N/A

N/A

completion_type

NO_CHAIN

NO_CHAIN

NO_CHAIN

NO_CHAIN

NO_CHAIN

NO_CHAIN

NO_CHAIN

concurrent_insert

AUTO

AUTO

AUTO

AUTO

AUTO

AUTO

AUTO

connect_timeout

10

10

10

10

10

10

10

core_file

OFF

OFF

OFF

OFF

OFF

N/A

N/A

datadir

/var/lib/mysql/

/var/lib/mysql/

/var/lib/mysql/

/var/lib/mysql/

/var/lib/mysql/

/var/lib/mysql/

/var/lib/mysql/

date_format

%Y-%m-%d

%Y-%m-%d

%Y-%m-%d

%Y-%m-%d

%Y-%m-%d

%Y-%m-%d

%Y-%m-%d

deadlock_search_depth_long

15

15

15

15

15

15

15

deadlock_search_depth_short

4

4

4

4

4

4

4

deadlock_timeout_long

50000000

50000000

50000000

50000000

50000000

50000000

50000000

deadlock_timeout_short

10000

10000

10000

10000

10000

10000

10000

debug_no_thread_alarm

OFF

OFF

OFF

OFF

OFF

OFF

OFF

default_password_lifetime

0

0

N/A

N/A

N/A

N/A

N/A

default_storage_engine

InnoDB

InnoDB

InnoDB

InnoDB

InnoDB

InnoDB

InnoDB

default_week_format

0

0

0

0

0

0

0

delay_key_write

ON

ON

ON

ON

ON

ON

ON

delayed_insert_limit

100

100

100

100

100

100

100

delayed_insert_timeout

300

300

300

300

300

300

300

delayed_queue_size

1000

1000

1000

1000

1000

1000

1000

disconnect_on_expired_password

OFF

OFF

N/A

N/A

N/A

N/A

N/A

div_precision_increment

4

4

4

4

4

4

4

encrypt_binlog

OFF

OFF

OFF

OFF

OFF

N/A

N/A

encrypt_tmp_disk_tables

OFF

OFF

OFF

OFF

OFF

N/A

N/A

encrypt_tmp_files

OFF

OFF

OFF

OFF

OFF

N/A

N/A

engine_condition_pushdown

N/A

N/A

N/A

N/A

N/A

N/A

OFF

eq_range_index_dive_limit

200

200

0

0

N/A

N/A

N/A

error_count

0

0

0

0

0

0

0

event_scheduler

OFF

OFF

OFF

OFF

OFF

OFF

OFF

expensive_subquery_limit

100

100

100

100

100

100

100

expire_logs_days

0

0

0

0

0

0

0

explicit_defaults_for_timestamp

OFF

OFF

OFF

OFF

OFF

N/A

N/A

extra_max_connections

1

1

1

1

1

1

1

extra_port

0

0

0

0

0

0

0

flush

OFF

OFF

OFF

OFF

OFF

OFF

OFF

flush_time

0

0

0

0

0

0

0

foreign_key_checks

ON

ON

ON

ON

ON

ON

ON

ft_max_word_len

84

84

84

84

84

84

84

ft_min_word_len

4

4

4

4

4

4

4

ft_query_expansion_limit

20

20

20

20

20

20

20

ft_stopword_file

(built-in)

(built-in)

(built-in)

(built-in)

(built-in)

(built-in)

(built-in)

general_log

OFF

OFF

OFF

OFF

OFF

OFF

OFF

general_log_file

schulung.log

schulung.log

schulung.log

schulung.log

schulung.log

schulung.log

schulung.log

group_concat_max_len

1048576

1048576

1048576

1048576

1024

1024

1024

gtid_cleanup_batch_size

64

64

N/A

N/A

N/A

N/A

N/A

gtid_domain_id

0

0

0

0

0

0

N/A

gtid_ignore_duplicates

OFF

OFF

OFF

OFF

OFF

OFF

N/A

gtid_seq_no

0

0

0

0

0

0

N/A

gtid_strict_mode

OFF

OFF

OFF

OFF

OFF

OFF

N/A

have_compress

YES

YES

YES

YES

YES

YES

YES

have_crypt

YES

YES

YES

YES

YES

YES

YES

have_csv

N/A

N/A

N/A

N/A

N/A

N/A

YES

have_dynamic_loading

YES

YES

YES

YES

YES

YES

YES

have_geometry

YES

YES

YES

YES

YES

YES

YES

have_innodb

N/A

N/A

N/A

N/A

N/A

N/A

YES

have_ndbcluster

N/A

N/A

N/A

N/A

N/A

N/A

NO

have_openssl

YES

YES

YES

YES

YES

YES

DISABLED

have_partitioning

N/A

N/A

N/A

N/A

N/A

N/A

YES

have_profiling

YES

YES

YES

YES

YES

YES

YES

have_query_cache

YES

YES

YES

YES

YES

YES

YES

have_rtree_keys

YES

YES

YES

YES

YES

YES

YES

have_ssl

DISABLED

DISABLED

DISABLED

DISABLED

DISABLED

DISABLED

DISABLED

have_symlink

YES

YES

YES

YES

YES

YES

YES

histogram_size

254

254

0

0

0

0

N/A

histogram_type

DOUBLE_PREC_HB

DOUBLE_PREC_HB

SINGLE_PREC_HB

SINGLE_PREC_HB

SINGLE_PREC_HB

SINGLE_PREC_HB

N/A

host_cache_size

279

279

279

279

279

128

N/A

hostname

schulung.linuxfabrik.loc

schulung.linuxfabrik.loc

schulung.linuxfabrik.loc

schulung.linuxfabrik.loc

schulung.linuxfabrik.loc

schulung.linuxfabrik.loc

schulung.linuxfabrik.loc

identity

0

0

0

0

0

0

0

idle_readonly_transaction_timeout

0

0

0

N/A

N/A

N/A

N/A

idle_transaction_timeout

0

0

0

N/A

N/A

N/A

N/A

idle_write_transaction_timeout

0

0

0

N/A

N/A

N/A

N/A

ignore_builtin_innodb

OFF

OFF

OFF

OFF

OFF

OFF

OFF

in_predicate_conversion_threshold

1000

1000

1000

N/A

N/A

N/A

N/A

in_transaction

0

0

0

0

0

0

0

innodb_adaptive_flushing

ON

ON

ON

ON

ON

ON

ON

innodb_adaptive_flushing_lwm

10.000000

10.000000

10.000000

10.000000

10.000000

10.000000

N/A

innodb_adaptive_flushing_method

N/A

N/A

N/A

N/A

N/A

N/A

estimate

innodb_adaptive_hash_index

OFF

ON

ON

ON

ON

ON

ON

innodb_adaptive_hash_index_partitions

N/A

N/A

N/A

8

1

1

1

innodb_adaptive_hash_index_parts

8

8

8

8

N/A

N/A

N/A

innodb_adaptive_max_sleep_delay

0

150000

150000

150000

150000

150000

N/A

innodb_additional_mem_pool_size

N/A

N/A

N/A

N/A

8388608

8388608

8388608

innodb_api_bk_commit_interval

N/A

N/A

N/A

N/A

5

5

N/A

innodb_api_disable_rowlock

N/A

N/A

N/A

N/A

OFF

OFF

N/A

innodb_api_enable_binlog

N/A

N/A

N/A

N/A

OFF

OFF

N/A

innodb_api_enable_mdl

N/A

N/A

N/A

N/A

OFF

OFF

N/A

innodb_api_trx_level

N/A

N/A

N/A

N/A

0

0

N/A

innodb_autoextend_increment

64

64

64

64

64

64

8

innodb_autoinc_lock_mode

1

1

1

1

1

1

1

innodb_background_scrub_data_check_interval

0

3600

3600

3600

3600

N/A

N/A

innodb_background_scrub_data_compressed

OFF

OFF

OFF

OFF

OFF

N/A

N/A

innodb_background_scrub_data_interval

0

604800

604800

604800

604800

N/A

N/A

innodb_background_scrub_data_uncompressed

OFF

OFF

OFF

OFF

OFF

N/A

N/A

innodb_blocking_buffer_pool_restore

N/A

N/A

N/A

N/A

N/A

N/A

OFF

innodb_buf_dump_status_frequency

0

0

0

0

0

N/A

N/A

innodb_buffer_pool_chunk_size

134217728

134217728

134217728

134217728

N/A

N/A

N/A

innodb_buffer_pool_dump_at_shutdown

ON

ON

ON

ON

OFF

OFF

N/A

innodb_buffer_pool_dump_now

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_buffer_pool_dump_pct

25

25

25

25

100

100

N/A

innodb_buffer_pool_filename

ib_buffer_pool

ib_buffer_pool

ib_buffer_pool

ib_buffer_pool

ib_buffer_pool

ib_buffer_pool

N/A

innodb_buffer_pool_instances

1

1

1

1

8

8

1

innodb_buffer_pool_load_abort

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_buffer_pool_load_at_startup

ON

ON

ON

ON

OFF

OFF

N/A

innodb_buffer_pool_load_now

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_buffer_pool_populate

N/A

N/A

N/A

OFF

OFF

OFF

OFF

innodb_buffer_pool_restore_at_startup

N/A

N/A

N/A

N/A

N/A

N/A

0

innodb_buffer_pool_shm_checksum

N/A

N/A

N/A

N/A

N/A

N/A

ON

innodb_buffer_pool_shm_key

N/A

N/A

N/A

N/A

N/A

N/A

0

innodb_buffer_pool_size

134217728

134217728

134217728

134217728

134217728

134217728

134217728

innodb_change_buffer_max_size

25

25

25

25

25

25

N/A

innodb_change_buffering

all

all

all

all

all

all

all

innodb_checkpoint_age_target

N/A

N/A

N/A

N/A

N/A

N/A

0

innodb_checksum_algorithm

full_crc32

crc32

crc32

crc32

INNODB

innodb

N/A

innodb_checksums

N/A

ON

ON

ON

ON

ON

ON

innodb_cleaner_lsn_age_factor

N/A

N/A

N/A

DEPRECATED

HIGH_CHECKPOINT

high_checkpoint

N/A

innodb_cmp_per_index_enabled

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_commit_concurrency

0

0

0

0

0

0

0

innodb_compression_algorithm

zlib

zlib

zlib

zlib

zlib

N/A

N/A

innodb_compression_default

OFF

OFF

OFF

OFF

N/A

N/A

N/A

innodb_compression_failure_threshold_pct

5

5

5

5

5

5

N/A

innodb_compression_level

6

6

6

6

6

6

N/A

innodb_compression_pad_pct_max

50

50

50

50

50

50

N/A

innodb_concurrency_tickets

0

5000

5000

5000

5000

5000

500

innodb_corrupt_table_action

N/A

N/A

N/A

deprecated

assert

assert

assert

innodb_data_file_path

ibdata1:12M:autoextend

ibdata1:12M:autoextend

ibdata1:12M:autoextend

ibdata1:12M:autoextend

ibdata1:12M:autoextend

ibdata1:12M:autoextend

ibdata1:10M:autoextend

innodb_deadlock_detect

ON

ON

ON

ON

N/A

N/A

N/A

innodb_default_encryption_key_id

1

1

1

1

1

N/A

N/A

innodb_default_row_format

dynamic

dynamic

dynamic

dynamic

compact

N/A

N/A

innodb_defragment

OFF

OFF

OFF

OFF

OFF

N/A

N/A

innodb_defragment_fill_factor

0.900000

0.900000

0.900000

0.900000

0.900000

N/A

N/A

innodb_defragment_fill_factor_n_recs

20

20

20

20

20

N/A

N/A

innodb_defragment_frequency

40

40

40

40

40

N/A

N/A

innodb_defragment_n_pages

7

7

7

7

7

N/A

N/A

innodb_defragment_stats_accuracy

0

0

0

0

0

N/A

N/A

innodb_dict_size_limit

N/A

N/A

N/A

N/A

N/A

N/A

0

innodb_disable_sort_file_cache

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_disallow_writes

OFF

OFF

OFF

OFF

OFF

N/A

N/A

innodb_doublewrite

ON

ON

ON

ON

ON

ON

ON

innodb_empty_free_list_algorithm

N/A

N/A

N/A

DEPRECATED

LEGACY

legacy

N/A

innodb_encrypt_log

OFF

OFF

OFF

OFF

OFF

N/A

N/A

innodb_encrypt_tables

OFF

OFF

OFF

OFF

OFF

N/A

N/A

innodb_encrypt_temporary_tables

OFF

OFF

OFF

OFF

N/A

N/A

N/A

innodb_encryption_rotate_key_age

1

1

1

1

1

N/A

N/A

innodb_encryption_rotation_iops

100

100

100

100

100

N/A

N/A

innodb_encryption_threads

0

0

0

0

0

N/A

N/A

innodb_fake_changes

N/A

N/A

N/A

OFF

OFF

OFF

OFF

innodb_fast_checksum

N/A

N/A

N/A

N/A

N/A

N/A

OFF

innodb_fast_shutdown

1

1

1

1

1

1

1

innodb_fatal_semaphore_wait_threshold

600

600

600

600

600

N/A

N/A

innodb_file_format

N/A

N/A

N/A

Barracuda

Antelope

Antelope

Antelope

innodb_file_format_check

N/A

N/A

N/A

ON

ON

ON

ON

innodb_file_format_max

N/A

N/A

N/A

Antelope

Antelope

Antelope

Antelope

innodb_file_per_table

ON

ON

ON

ON

ON

ON

OFF

innodb_fill_factor

100

100

100

100

N/A

N/A

N/A

innodb_flush_log_at_timeout

1

1

1

1

1

1

N/A

innodb_flush_log_at_trx_commit

1

1

1

1

1

1

1

innodb_flush_method

fsync

fsync

fsync

N/A

N/A

N/A

N/A

innodb_flush_neighbor_pages

N/A

N/A

N/A

N/A

N/A

N/A

area

innodb_flush_neighbors

1

1

1

1

1

1

N/A

innodb_flush_sync

ON

ON

ON

ON

N/A

N/A

N/A

innodb_flushing_avg_loops

30

30

30

30

30

30

N/A

innodb_force_load_corrupted

OFF

OFF

OFF

OFF

OFF

OFF

OFF

innodb_force_primary_key

OFF

OFF

OFF

OFF

OFF

N/A

N/A

innodb_force_recovery

0

0

0

0

0

0

0

innodb_foreground_preflush

N/A

N/A

N/A

DEPRECATED

EXPONENTIAL_BACKOFF

exponential_backoff

N/A

innodb_ft_cache_size

8000000

8000000

8000000

8000000

8000000

8000000

N/A

innodb_ft_enable_diag_print

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_ft_enable_stopword

ON

ON

ON

ON

ON

ON

N/A

innodb_ft_max_token_size

84

84

84

84

84

84

N/A

innodb_ft_min_token_size

3

3

3

3

3

3

N/A

innodb_ft_num_word_optimize

2000

2000

2000

2000

2000

2000

N/A

innodb_ft_result_cache_limit

2000000000

2000000000

2000000000

2000000000

2000000000

2000000000

N/A

innodb_ft_sort_pll_degree

2

2

2

2

2

2

N/A

innodb_ft_total_cache_size

640000000

640000000

640000000

640000000

640000000

640000000

N/A

innodb_ibuf_accel_rate

N/A

N/A

N/A

N/A

N/A

N/A

100

innodb_ibuf_active_contract

N/A

N/A

N/A

N/A

N/A

N/A

1

innodb_ibuf_max_size

N/A

N/A

N/A

N/A

N/A

N/A

67092480

innodb_idle_flush_pct

100

100

100

100

100

N/A

N/A

innodb_immediate_scrub_data_uncompressed

OFF

OFF

OFF

OFF

OFF

N/A

N/A

innodb_import_table_from_xtrabackup

N/A

N/A

N/A

N/A

N/A

N/A

0

innodb_instant_alter_column_allowed

add_drop_reorder

add_drop_reorder

add_last

N/A

N/A

N/A

N/A

innodb_instrument_semaphores

N/A

N/A

N/A

OFF

OFF

N/A

N/A

innodb_io_capacity

200

200

200

200

200

200

200

innodb_io_capacity_max

2000

2000

2000

2000

2000

2000

N/A

innodb_kill_idle_transaction

N/A

N/A

N/A

0

0

0

0

innodb_large_prefix

N/A

N/A

N/A

ON

OFF

OFF

OFF

innodb_lazy_drop_table

N/A

N/A

N/A

N/A

N/A

N/A

0

innodb_lock_schedule_algorithm

fcfs

fcfs

fcfs

fcfs

fcfs

N/A

N/A

innodb_lock_wait_timeout

50

50

50

50

50

50

50

innodb_locking_fake_changes

N/A

N/A

N/A

OFF

ON

ON

ON

innodb_locks_unsafe_for_binlog

N/A

OFF

OFF

OFF

OFF

OFF

OFF

innodb_log_arch_dir

N/A

N/A

N/A

N/A

./

./

N/A

innodb_log_arch_expire_sec

N/A

N/A

N/A

0

0

0

N/A

innodb_log_archive

N/A

N/A

N/A

OFF

OFF

OFF

N/A

innodb_log_block_size

N/A

N/A

N/A

0

512

512

512

innodb_log_buffer_size

16777216

16777216

16777216

16777216

16777216

8388608

8388608

innodb_log_checksum_algorithm

N/A

N/A

N/A

DEPRECATED

INNODB

innodb

N/A

innodb_log_checksums

ON

ON

ON

ON

N/A

N/A

N/A

innodb_log_compressed_pages

ON

ON

ON

ON

ON

ON

N/A

innodb_log_file_size

100663296

50331648

50331648

50331648

50331648

50331648

5242880

innodb_log_files_in_group

1

2

2

2

2

2

2

innodb_log_group_home_dir

./

./

./

./

./

./

./

innodb_log_optimize_ddl

OFF

ON

ON

ON

N/A

N/A

N/A

innodb_log_write_ahead_size

8192

8192

8192

8192

N/A

N/A

N/A

innodb_lru_scan_depth

1024

1024

1024

1024

1024

1024

N/A

innodb_max_bitmap_file_size

N/A

N/A

N/A

0

104857600

104857600

104857600

innodb_max_changed_pages

N/A

N/A

N/A

0

1000000

1000000

1000000

innodb_max_dirty_pages_pct

75.000000

75.000000

75.000000

75.000000

75.000000

75.000000

75

innodb_max_dirty_pages_pct_lwm

0.000000

0.000000

0.000000

0.000000

0.001000

0.001000

N/A

innodb_max_purge_lag

0

0

0

0

0

0

0

innodb_max_purge_lag_delay

0

0

0

0

0

0

N/A

innodb_max_undo_log_size

10485760

10485760

10485760

10485760

N/A

N/A

N/A

innodb_merge_sort_block_size

N/A

N/A

N/A

N/A

N/A

N/A

1048576

innodb_mirrored_log_groups

N/A

N/A

N/A

0

1

1

1

innodb_mtflush_threads

N/A

N/A

N/A

8

8

N/A

N/A

innodb_old_blocks_pct

37

37

37

37

37

37

37

innodb_old_blocks_time

1000

1000

1000

1000

1000

1000

0

innodb_online_alter_log_max_size

134217728

134217728

134217728

134217728

134217728

134217728

N/A

innodb_open_files

2000

2000

2000

2000

2000

400

300

innodb_optimize_fulltext_only

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_page_cleaners

1

1

1

1

N/A

N/A

N/A

innodb_page_size

16384

16384

16384

16384

16384

16384

16384

innodb_prefix_index_cluster_optimization

OFF

OFF

OFF

OFF

OFF

N/A

N/A

innodb_print_all_deadlocks

OFF

OFF

OFF

OFF

OFF

OFF

OFF

innodb_print_lock_wait_timeout_info

N/A

N/A

N/A

N/A

OFF

OFF

N/A

innodb_purge_batch_size

300

300

300

300

300

300

20

innodb_purge_rseg_truncate_frequency

128

128

128

128

N/A

N/A

N/A

innodb_purge_threads

4

4

4

4

1

1

1

innodb_random_read_ahead

OFF

OFF

OFF

OFF

OFF

OFF

OFF

innodb_read_ahead

N/A

N/A

N/A

N/A

N/A

N/A

linear

innodb_read_ahead_threshold

56

56

56

56

56

56

56

innodb_read_io_threads

4

4

4

4

4

4

4

innodb_read_only

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_recovery_stats

N/A

N/A

N/A

N/A

N/A

N/A

OFF

innodb_recovery_update_relay_log

N/A

N/A

N/A

N/A

N/A

N/A

OFF

innodb_replication_delay

0

0

0

0

0

0

0

innodb_rollback_on_timeout

OFF

OFF

OFF

OFF

OFF

OFF

OFF

innodb_rollback_segments

N/A

128

128

128

128

128

128

innodb_safe_truncate

N/A

N/A

N/A

ON

N/A

N/A

N/A

innodb_sched_priority_cleaner

N/A

N/A

N/A

0

19

19

N/A

innodb_scrub_log

OFF

OFF

OFF

OFF

OFF

N/A

N/A

innodb_scrub_log_speed

256

256

256

256

256

N/A

N/A

innodb_show_locks_held

N/A

N/A

N/A

0

10

10

10

innodb_show_verbose_locks

N/A

N/A

N/A

0

0

0

0

innodb_simulate_comp_failures

N/A

N/A

N/A

N/A

0

0

0

innodb_sort_buffer_size

1048576

1048576

1048576

1048576

1048576

1048576

N/A

innodb_spin_wait_delay

4

4

4

4

6

6

6

innodb_stats_auto_recalc

ON

ON

ON

ON

ON

ON

N/A

innodb_stats_auto_update

N/A

N/A

N/A

N/A

N/A

N/A

1

innodb_stats_include_delete_marked

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_stats_method

nulls_equal

nulls_equal

nulls_equal

nulls_equal

nulls_equal

nulls_equal

nulls_equal

innodb_stats_modified_counter

0

0

0

0

0

0

0

innodb_stats_on_metadata

OFF

OFF

OFF

OFF

OFF

OFF

ON

innodb_stats_persistent

ON

ON

ON

ON

ON

ON

N/A

innodb_stats_persistent_sample_pages

20

20

20

20

20

20

N/A

innodb_stats_sample_pages

N/A

8

8

8

8

8

8

innodb_stats_traditional

ON

ON

ON

ON

ON

ON

ON

innodb_stats_transient_sample_pages

8

8

8

8

8

8

N/A

innodb_stats_update_need_lock

N/A

N/A

N/A

N/A

N/A

N/A

1

innodb_status_output

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_status_output_locks

OFF

OFF

OFF

OFF

OFF

OFF

N/A

innodb_strict_mode

ON

ON

ON

ON

OFF

OFF

OFF

innodb_support_xa

N/A

N/A

N/A

ON

ON

ON

ON

innodb_sync_array_size

1

1

1

1

1

1

N/A

innodb_sync_spin_loops

30

30

30

30

30

30

30

innodb_table_locks

ON

ON

ON

ON

ON

ON

ON

innodb_temp_data_file_path

ibtmp1:12M:autoextend

ibtmp1:12M:autoextend

ibtmp1:12M:autoextend

ibtmp1:12M:autoextend

N/A

N/A

N/A

innodb_thread_concurrency

0

0

0

0

0

0

0

innodb_thread_concurrency_timer_based

N/A

N/A

N/A

N/A

N/A

N/A

OFF

innodb_thread_sleep_delay

0

10000

10000

10000

10000

10000

10000

innodb_track_changed_pages

N/A

N/A

N/A

OFF

OFF

OFF

OFF

innodb_track_redo_log_now

N/A

N/A

N/A

OFF

N/A

N/A

N/A

innodb_undo_directory

./

./

./

./

.

.

N/A

innodb_undo_log_truncate

OFF

OFF

OFF

OFF

N/A

N/A

N/A

innodb_undo_logs

128

128

128

128

128

128

N/A

innodb_undo_tablespaces

0

0

0

0

0

0

N/A

innodb_use_atomic_writes

ON

ON

ON

ON

OFF

OFF

OFF

innodb_use_fallocate

N/A

N/A

N/A

OFF

OFF

OFF

OFF

innodb_use_global_flush_log_at_trx_commit

N/A

N/A

N/A

OFF

ON

ON

ON

innodb_use_mtflush

N/A

N/A

N/A

OFF

OFF

N/A

N/A

innodb_use_native_aio

ON

ON

ON

ON

ON

ON

ON

innodb_use_stacktrace

N/A

N/A

N/A

OFF

OFF

OFF

OFF

innodb_use_sys_malloc

N/A

N/A

N/A

N/A

ON

ON

ON

innodb_use_sys_stats_table

N/A

N/A

N/A

N/A

N/A

N/A

OFF

innodb_use_trim

N/A

N/A

N/A

ON

OFF

N/A

N/A

innodb_version

10.5.5

10.4.14

10.3.24

5.7.31

5.6.49-89.0

5.6.42-84.2

5.5.61-MariaDB-38.13

innodb_write_io_threads

4

4

4

4

4

4

4

insert_id

0

0

0

0

0

0

0

interactive_timeout

28800

28800

28800

28800

28800

28800

28800

join_buffer_size

262144

262144

262144

262144

262144

131072

131072

join_buffer_space_limit

2097152

2097152

2097152

2097152

2097152

2097152

2097152

join_cache_level

2

2

2

2

2

2

2

keep_files_on_create

OFF

OFF

OFF

OFF

OFF

OFF

OFF

key_buffer_size

134217728

134217728

134217728

134217728

134217728

134217728

134217728

key_cache_age_threshold

300

300

300

300

300

300

300

key_cache_block_size

1024

1024

1024

1024

1024

1024

1024

key_cache_division_limit

100

100

100

100

100

100

100

key_cache_file_hash_size

512

512

512

512

512

512

N/A

key_cache_segments

0

0

0

0

0

0

0

large_files_support

ON

ON

ON

ON

ON

ON

ON

large_page_size

0

0

0

0

0

0

0

large_pages

OFF

OFF

OFF

OFF

OFF

OFF

OFF

last_insert_id

0

0

0

0

0

0

0

lc_messages

en_US

en_US

en_US

en_US

en_US

en_US

en_US

lc_time_names

en_US

en_US

en_US

en_US

en_US

en_US

en_US

license

GPL

GPL

GPL

GPL

GPL

GPL

GPL

local_infile

ON

ON

ON

ON

ON

ON

ON

lock_wait_timeout

86400

86400

86400

86400

31536000

31536000

31536000

locked_in_memory

OFF

OFF

OFF

OFF

OFF

OFF

OFF

log

N/A

N/A

N/A

N/A

N/A

N/A

OFF

log_bin

OFF

OFF

OFF

OFF

OFF

OFF

OFF

log_bin_compress

OFF

OFF

OFF

OFF

N/A

N/A

N/A

log_bin_compress_min_len

256

256

256

256

N/A

N/A

N/A

log_bin_trust_function_creators

OFF

OFF

OFF

OFF

OFF

OFF

OFF

log_disabled_statements

sp

sp

sp

N/A

N/A

N/A

N/A

log_error

N/A

N/A

/var/lib/mysql/schulung.li…

/var/lib/mysql/schulung.li…

/var/lib/mysql/schulung.li…

/var/lib/mysql/schulung.li…

/var/lib/mysql/schulung.li…

log_output

FILE

FILE

FILE

FILE

FILE

FILE

FILE

log_queries_not_using_indexes

OFF

OFF

OFF

OFF

OFF

OFF

OFF

log_slave_updates

OFF

OFF

OFF

OFF

OFF

OFF

OFF

log_slow_admin_statements

ON

ON

ON

ON

OFF

N/A

N/A

log_slow_disabled_statements

sp

sp

sp

N/A

N/A

N/A

N/A

log_slow_filter

admin,filesort,filesort_on…

admin,filesort,filesort_on…

admin,filesort,filesort_on…

admin,filesort,filesort_on…

admin,filesort,filesort_on…

admin,filesort,filesort_on…

admin,filesort,filesort_on…

log_slow_queries

N/A

N/A

N/A

N/A

N/A

N/A

OFF

log_slow_rate_limit

1

1

1

1

1

1

1

log_slow_slave_statements

ON

ON

ON

ON

OFF

N/A

N/A

log_tc_size

24576

24576

24576

24576

24576

N/A

N/A

log_warnings

2

2

2

2

1

1

1

long_query_time

10.000000

10.000000

10.000000

10.000000

10.000000

10.000000

10.000000

low_priority_updates

OFF

OFF

OFF

OFF

OFF

OFF

OFF

lower_case_file_system

OFF

OFF

OFF

OFF

OFF

OFF

OFF

lower_case_table_names

0

0

0

0

0

0

0

master_verify_checksum

OFF

OFF

OFF

OFF

OFF

OFF

OFF

max_allowed_packet

16777216

16777216

16777216

16777216

4194304

1048576

1048576

max_binlog_cache_size

18446744073709547520

18446744073709547520

18446744073709547520

18446744073709547520

18446744073709547520

18446744073709547520

18446744073709547520

max_binlog_size

1073741824

1073741824

1073741824

1073741824

1073741824

1073741824

1073741824

max_binlog_stmt_cache_size

18446744073709547520

18446744073709547520

18446744073709547520

18446744073709547520

18446744073709547520

18446744073709547520

18446744073709547520

max_connect_errors

100

100

100

100

100

100

10

max_connections

151

151

151

151

151

151

151

max_delayed_threads

20

20

20

20

20

20

20

max_digest_length

1024

1024

1024

1024

1024

1024

N/A

max_error_count

64

64

64

64

64

64

64

max_heap_table_size

16777216

16777216

16777216

16777216

16777216

16777216

16777216

max_insert_delayed_threads

20

20

20

20

20

20

20

max_join_size

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

max_length_for_sort_data

1024

1024

1024

1024

1024

1024

1024

max_long_data_size

N/A

16777216

16777216

16777216

4194304

1048576

1048576

max_password_errors

4294967295

4294967295

N/A

N/A

N/A

N/A

N/A

max_prepared_stmt_count

16382

16382

16382

16382

16382

16382

16382

max_recursive_iterations

4294967295

4294967295

4294967295

4294967295

N/A

N/A

N/A

max_relay_log_size

1073741824

1073741824

1073741824

1073741824

1073741824

1073741824

0

max_rowid_filter_size

131072

131072

N/A

N/A

N/A

N/A

N/A

max_seeks_for_key

4294967295

4294967295

4294967295

4294967295

4294967295

4294967295

4294967295

max_session_mem_used

9223372036854775807

9223372036854775807

9223372036854775807

9223372036854775807

9223372036854775807

N/A

N/A

max_sort_length

1024

1024

1024

1024

1024

1024

1024

max_sp_recursion_depth

0

0

0

0

0

0

0

max_statement_time

0.000000

0.000000

0.000000

0.000000

0.000000

N/A

N/A

max_tmp_tables

32

32

32

32

32

32

32

max_user_connections

0

0

0

0

0

0

0

max_write_lock_count

4294967295

4294967295

4294967295

4294967295

4294967295

4294967295

4294967295

metadata_locks_cache_size

1024

1024

1024

1024

1024

1024

1024

metadata_locks_hash_instances

8

8

8

8

8

8

N/A

min_examined_row_limit

0

0

0

0

0

0

0

mrr_buffer_size

262144

262144

262144

262144

262144

262144

262144

multi_range_count

N/A

256

256

256

256

256

256

myisam_block_size

1024

1024

1024

1024

1024

1024

1024

myisam_data_pointer_size

6

6

6

6

6

6

6

myisam_max_sort_file_size

9223372036853727232

9223372036853727232

9223372036853727232

9223372036853727232

9223372036853727232

9223372036853727232

9223372036853727232

myisam_mmap_size

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

myisam_recover_options

BACKUP,QUICK

BACKUP,QUICK

BACKUP,QUICK

BACKUP,QUICK

DEFAULT

DEFAULT

DEFAULT

myisam_repair_threads

1

1

1

1

1

1

1

myisam_sort_buffer_size

134216704

134216704

134216704

134216704

134216704

134216704

8388608

myisam_stats_method

NULLS_UNEQUAL

NULLS_UNEQUAL

NULLS_UNEQUAL

NULLS_UNEQUAL

NULLS_UNEQUAL

nulls_unequal

nulls_unequal

myisam_use_mmap

OFF

OFF

OFF

OFF

OFF

OFF

OFF

mysql56_temporal_format

ON

ON

ON

ON

ON

N/A

N/A

net_buffer_length

16384

16384

16384

16384

16384

16384

16384

net_read_timeout

30

30

30

30

30

30

30

net_retry_count

10

10

10

10

10

10

10

net_write_timeout

60

60

60

60

60

60

60

old

OFF

OFF

OFF

OFF

OFF

OFF

OFF

old_alter_table

DEFAULT

DEFAULT

DEFAULT

OFF

OFF

OFF

OFF

old_passwords

OFF

OFF

OFF

OFF

OFF

OFF

OFF

open_files_limit

16384

16384

32184

32184

4184

964

962

optimizer_prune_level

1

1

1

1

1

1

1

optimizer_search_depth

62

62

62

62

62

62

62

optimizer_selectivity_sampling_limit

100

100

100

100

100

100

N/A

optimizer_switch

index_merge=on,index_merge…

index_merge=on,index_merge…

index_merge=on,index_merge…

index_merge=on,index_merge…

index_merge=on,index_merge…

index_merge=on,index_merge…

index_merge=on,index_merge…

optimizer_trace

enabled=off

enabled=off

N/A

N/A

N/A

N/A

N/A

optimizer_trace_max_mem_size

1048576

1048576

N/A

N/A

N/A

N/A

N/A

optimizer_use_condition_selectivity

4

4

1

1

1

1

N/A

performance_schema

OFF

OFF

OFF

OFF

OFF

OFF

OFF

performance_schema_accounts_size

-1

-1

-1

-1

-1

-1

N/A

performance_schema_digests_size

-1

-1

-1

-1

-1

-1

N/A

performance_schema_events_stages_history_long_size

-1

-1

-1

-1

-1

-1

N/A

performance_schema_events_stages_history_size

-1

-1

-1

-1

-1

-1

N/A

performance_schema_events_statements_history_long_size

-1

-1

-1

-1

-1

-1

N/A

performance_schema_events_statements_history_size

-1

-1

-1

-1

-1

-1

N/A

performance_schema_events_transactions_history_long_size

-1

N/A

N/A

N/A

N/A

N/A

N/A

performance_schema_events_transactions_history_size

-1

N/A

N/A

N/A

N/A

N/A

N/A

performance_schema_events_waits_history_long_size

-1

-1

-1

-1

-1

-1

10000

performance_schema_events_waits_history_size

-1

-1

-1

-1

-1

-1

10

performance_schema_hosts_size

-1

-1

-1

-1

-1

-1

N/A

performance_schema_max_cond_classes

90

90

80

80

80

80

80

performance_schema_max_cond_instances

-1

-1

-1

-1

-1

-1

1000

performance_schema_max_digest_length

1024

1024

1024

1024

1024

1024

N/A

performance_schema_max_file_classes

80

50

50

50

50

50

50

performance_schema_max_file_handles

32768

32768

32768

32768

32768

32768

32768

performance_schema_max_file_instances

-1

-1

-1

-1

-1

-1

10000

performance_schema_max_index_stat

-1

N/A

N/A

N/A

N/A

N/A

N/A

performance_schema_max_memory_classes

320

N/A

N/A

N/A

N/A

N/A

N/A

performance_schema_max_metadata_locks

-1

N/A

N/A

N/A

N/A

N/A

N/A

performance_schema_max_mutex_classes

210

200

200

200

200

200

200

performance_schema_max_mutex_instances

-1

-1

-1

-1

-1

-1

1000000

performance_schema_max_prepared_statements_instances

-1

N/A

N/A

N/A

N/A

N/A

N/A

performance_schema_max_program_instances

-1

N/A

N/A

N/A

N/A

N/A

N/A

performance_schema_max_rwlock_classes

50

40

40

40

40

40

30

performance_schema_max_rwlock_instances

-1

-1

-1

-1

-1

-1

1000000

performance_schema_max_socket_classes

10

10

10

10

10

10

N/A

performance_schema_max_socket_instances

-1

-1

-1

-1

-1

-1

N/A

performance_schema_max_sql_text_length

1024

N/A

N/A

N/A

N/A

N/A

N/A

performance_schema_max_stage_classes

160

160

160

150

150

150

N/A

performance_schema_max_statement_classes

222

202

200

188

178

180

N/A

performance_schema_max_statement_stack

10

N/A

N/A

N/A

N/A

N/A

N/A

performance_schema_max_table_handles

-1

-1

-1

-1

-1

-1

100000

performance_schema_max_table_instances

-1

-1

-1

-1

-1

-1

50000

performance_schema_max_table_lock_stat

-1

N/A

N/A

N/A

N/A

N/A

N/A

performance_schema_max_thread_classes

50

50

50

50

50

50

50

performance_schema_max_thread_instances

-1

-1

-1

-1

-1

-1

1000

performance_schema_session_connect_attrs_size

-1

-1

-1

-1

-1

-1

N/A

performance_schema_setup_actors_size

-1

100

100

100

100

100

N/A

performance_schema_setup_objects_size

-1

100

100

100

100

100

N/A

performance_schema_users_size

-1

-1

-1

-1

-1

-1

N/A

pid_file

/var/lib/mysql/schulung.pi…

/var/lib/mysql/schulung.pi…

/var/lib/mysql/schulung.li…

/var/lib/mysql/schulung.li…

/var/lib/mysql/schulung.li…

/var/lib/mysql/schulung.li…

/var/lib/mysql/schulung.li…

plugin_dir

/usr/lib64/mysql/plugin/

/usr/lib64/mysql/plugin/

/usr/lib64/mysql/plugin/

/usr/lib64/mysql/plugin/

/usr/lib64/mysql/plugin/

/usr/lib64/mysql/plugin/

/usr/lib64/mysql/plugin/

plugin_maturity

gamma

gamma

gamma

unknown

unknown

unknown

unknown

port

3306

3306

3306

3306

3306

3306

3306

preload_buffer_size

32768

32768

32768

32768

32768

32768

32768

profiling

OFF

OFF

OFF

OFF

OFF

OFF

OFF

profiling_history_size

15

15

15

15

15

15

15

progress_report_time

5

5

5

5

5

5

5

protocol_version

10

10

10

10

10

10

10

pseudo_slave_mode

OFF

OFF

OFF

OFF

OFF

OFF

OFF

pseudo_thread_id

3

8

9

9

3

3

3

query_alloc_block_size

16384

16384

16384

16384

16384

8192

8192

query_cache_limit

1048576

1048576

1048576

1048576

1048576

1048576

1048576

query_cache_min_res_unit

4096

4096

4096

4096

4096

4096

4096

query_cache_size

1048576

1048576

1048576

1048576

1048576

0

0

query_cache_strip_comments

OFF

OFF

OFF

OFF

OFF

OFF

OFF

query_cache_type

OFF

OFF

OFF

OFF

OFF

ON

ON

query_cache_wlock_invalidate

OFF

OFF

OFF

OFF

OFF

OFF

OFF

query_prealloc_size

24576

24576

24576

24576

24576

8192

8192

rand_seed1

80318488

521980650

92550769

560362417

851523898

0

0

rand_seed2

989035964

169480473

1020700256

164721452

676822670

0

0

range_alloc_block_size

4096

4096

4096

4096

4096

4096

4096

read_binlog_speed_limit

0

0

0

0

N/A

N/A

N/A

read_buffer_size

131072

131072

131072

131072

131072

131072

131072

read_only

OFF

OFF

OFF

OFF

OFF

OFF

OFF

read_rnd_buffer_size

262144

262144

262144

262144

262144

262144

262144

relay_log_info_file

relay-log.info

relay-log.info

relay-log.info

relay-log.info

relay-log.info

relay-log.info

relay-log.info

relay_log_purge

ON

ON

ON

ON

ON

ON

ON

relay_log_recovery

OFF

OFF

OFF

OFF

OFF

OFF

OFF

relay_log_space_limit

0

0

0

0

0

0

0

replicate_annotate_row_events

ON

ON

ON

ON

OFF

OFF

OFF

replicate_events_marked_for_skip

REPLICATE

REPLICATE

REPLICATE

REPLICATE

REPLICATE

replicate

replicate

report_port

3306

3306

3306

3306

3306

3306

3306

require_secure_transport

OFF

N/A

N/A

N/A

N/A

N/A

N/A

rowid_merge_buff_size

8388608

8388608

8388608

8388608

8388608

8388608

8388608

rpl_recovery_rank

N/A

N/A

N/A

N/A

N/A

0

0

rpl_semi_sync_master_enabled

OFF

OFF

OFF

N/A

N/A

N/A

N/A

rpl_semi_sync_master_timeout

10000

10000

10000

N/A

N/A

N/A

N/A

rpl_semi_sync_master_trace_level

32

32

32

N/A

N/A

N/A

N/A

rpl_semi_sync_master_wait_no_slave

ON

ON

ON

N/A

N/A

N/A

N/A

rpl_semi_sync_master_wait_point

AFTER_COMMIT

AFTER_COMMIT

AFTER_COMMIT

N/A

N/A

N/A

N/A

rpl_semi_sync_slave_delay_master

OFF

OFF

OFF

N/A

N/A

N/A

N/A

rpl_semi_sync_slave_enabled

OFF

OFF

OFF

N/A

N/A

N/A

N/A

rpl_semi_sync_slave_kill_conn_timeout

5

5

5

N/A

N/A

N/A

N/A

rpl_semi_sync_slave_trace_level

32

32

32

N/A

N/A

N/A

N/A

secure_auth

ON

ON

ON

ON

ON

OFF

OFF

secure_timestamp

NO

NO

NO

N/A

N/A

N/A

N/A

server_id

1

1

1

1

0

0

0

session_track_schema

ON

ON

ON

ON

N/A

N/A

N/A

session_track_state_change

OFF

OFF

OFF

OFF

N/A

N/A

N/A

session_track_system_variables

autocommit,character_set_c…

autocommit,character_set_c…

autocommit,character_set_c…

N/A

N/A

N/A

N/A

session_track_transaction_info

OFF

OFF

OFF

OFF

N/A

N/A

N/A

skip_external_locking

ON

ON

ON

ON

ON

ON

ON

skip_name_resolve

OFF

OFF

OFF

OFF

OFF

OFF

OFF

skip_networking

OFF

OFF

OFF

OFF

OFF

OFF

OFF

skip_parallel_replication

OFF

OFF

OFF

OFF

OFF

N/A

N/A

skip_replication

OFF

OFF

OFF

OFF

OFF

OFF

OFF

skip_show_database

OFF

OFF

OFF

OFF

OFF

OFF

OFF

slave_compressed_protocol

OFF

OFF

OFF

OFF

OFF

OFF

OFF

slave_ddl_exec_mode

IDEMPOTENT

IDEMPOTENT

IDEMPOTENT

IDEMPOTENT

IDEMPOTENT

IDEMPOTENT

N/A

slave_domain_parallel_threads

0

0

0

0

0

0

N/A

slave_exec_mode

STRICT

STRICT

STRICT

STRICT

STRICT

STRICT

STRICT

slave_load_tmpdir

/tmp

/tmp

/tmp

/tmp

/tmp

/tmp

/tmp

slave_max_allowed_packet

1073741824

1073741824

1073741824

1073741824

1073741824

1073741824

1073741824

slave_net_timeout

60

60

60

60

3600

3600

3600

slave_parallel_max_queued

131072

131072

131072

131072

131072

131072

N/A

slave_parallel_mode

optimistic

conservative

conservative

conservative

conservative

N/A

N/A

slave_parallel_threads

0

0

0

0

0

0

N/A

slave_parallel_workers

0

0

0

0

N/A

N/A

N/A

slave_run_triggers_for_rbr

NO

NO

NO

NO

NO

N/A

N/A

slave_skip_errors

OFF

OFF

OFF

OFF

OFF

OFF

OFF

slave_sql_verify_checksum

ON

ON

ON

ON

ON

ON

ON

slave_transaction_retries

10

10

10

10

10

10

10

slave_transaction_retry_errors

1158,1159,1160,1161,1205,1…

1158,1159,1160,1161,1205,1…

1213,1205

N/A

N/A

N/A

N/A

slave_transaction_retry_interval

0

0

0

N/A

N/A

N/A

N/A

slow_launch_time

2

2

2

2

2

2

2

slow_query_log

OFF

OFF

OFF

OFF

OFF

OFF

OFF

slow_query_log_file

schulung-slow.log

schulung-slow.log

schulung-slow.log

schulung-slow.log

schulung-slow.log

schulung-slow.log

schulung-slow.log

socket

/var/lib/mysql/mysql.sock

/var/lib/mysql/mysql.sock

/var/lib/mysql/mysql.sock

/var/lib/mysql/mysql.sock

/var/lib/mysql/mysql.sock

/var/lib/mysql/mysql.sock

/var/lib/mysql/mysql.sock

sort_buffer_size

2097152

2097152

2097152

2097152

2097152

2097152

2097152

sql_auto_is_null

OFF

OFF

OFF

OFF

OFF

OFF

OFF

sql_big_selects

ON

ON

ON

ON

ON

ON

ON

sql_big_tables

N/A

N/A

N/A

N/A

N/A

N/A

OFF

sql_buffer_result

OFF

OFF

OFF

OFF

OFF

OFF

OFF

sql_if_exists

OFF

N/A

N/A

N/A

N/A

N/A

N/A

sql_log_bin

ON

ON

ON

ON

ON

ON

ON

sql_log_off

OFF

OFF

OFF

OFF

OFF

OFF

OFF

sql_low_priority_updates

N/A

N/A

N/A

N/A

N/A

N/A

OFF

sql_max_join_size

N/A

N/A

N/A

N/A

N/A

N/A

18446744073709551615

sql_mode

STRICT_TRANS_TABLES,ERROR_…

STRICT_TRANS_TABLES,ERROR_…

STRICT_TRANS_TABLES,ERROR_…

STRICT_TRANS_TABLES,ERROR_…

NO_AUTO_CREATE_USER,NO_ENG…

N/A

N/A

sql_notes

ON

ON

ON

ON

ON

ON

ON

sql_quote_show_create

ON

ON

ON

ON

ON

ON

ON

sql_safe_updates

OFF

OFF

OFF

OFF

OFF

OFF

OFF

sql_select_limit

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

sql_slave_skip_counter

0

0

0

0

0

0

0

sql_warnings

OFF

OFF

OFF

OFF

OFF

OFF

OFF

standard_compliant_cte

ON

ON

ON

ON

N/A

N/A

N/A

storage_engine

InnoDB

InnoDB

InnoDB

InnoDB

InnoDB

InnoDB

InnoDB

stored_program_cache

256

256

256

256

256

256

256

strict_password_validation

ON

ON

ON

ON

ON

N/A

N/A

sync_binlog

0

0

0

0

0

0

0

sync_frm

ON

ON

ON

ON

ON

ON

ON

sync_master_info

10000

10000

10000

10000

10000

0

0

sync_relay_log

10000

10000

10000

10000

10000

0

0

sync_relay_log_info

10000

10000

10000

10000

10000

0

0

system_time_zone

CEST

CEST

CEST

CEST

CEST

CEST

CEST

system_versioning_alter_history

ERROR

ERROR

ERROR

N/A

N/A

N/A

N/A

system_versioning_asof

DEFAULT

DEFAULT

DEFAULT

N/A

N/A

N/A

N/A

table_definition_cache

400

400

400

400

400

400

400

table_open_cache

2000

2000

2000

2000

2000

400

400

table_open_cache_instances

4

4

8

8

N/A

N/A

N/A

tcp_keepalive_interval

0

0

0

N/A

N/A

N/A

N/A

tcp_keepalive_probes

0

0

0

N/A

N/A

N/A

N/A

tcp_keepalive_time

0

0

0

N/A

N/A

N/A

N/A

tcp_nodelay

ON

ON

N/A

N/A

N/A

N/A

N/A

thread_cache_size

151

151

151

151

0

0

0

thread_concurrency

N/A

10

10

10

10

10

10

thread_handling

one-thread-per-connection

one-thread-per-connection

one-thread-per-connection

one-thread-per-connection

one-thread-per-connection

one-thread-per-connection

one-thread-per-connection

thread_pool_dedicated_listener

OFF

N/A

N/A

N/A

N/A

N/A

N/A

thread_pool_exact_stats

OFF

N/A

N/A

N/A

N/A

N/A

N/A

thread_pool_idle_timeout

60

60

60

60

60

60

60

thread_pool_max_threads

65536

65536

65536

65536

1000

500

500

thread_pool_oversubscribe

3

3

3

3

3

3

3

thread_pool_prio_kickup_timer

1000

1000

1000

1000

N/A

N/A

N/A

thread_pool_priority

auto

auto

auto

auto

N/A

N/A

N/A

thread_pool_size

2

2

2

2

2

2

2

thread_pool_stall_limit

500

500

500

500

500

500

500

thread_stack

299008

299008

299008

299008

299008

294912

294912

time_format

%H:%i:%s

%H:%i:%s

%H:%i:%s

%H:%i:%s

%H:%i:%s

%H:%i:%s

%H:%i:%s

time_zone

SYSTEM

SYSTEM

SYSTEM

SYSTEM

SYSTEM

SYSTEM

SYSTEM

timed_mutexes

N/A

OFF

OFF

OFF

OFF

OFF

OFF

timestamp

1601408860.765599

1601408615.276448

1601408455.863730

1601408341.263592

1601407950.075947

1601407621.473868

1601406662.319570

tls_version

TLSv1.1,TLSv1.2,TLSv1.3

TLSv1.1,TLSv1.2,TLSv1.3

N/A

N/A

N/A

N/A

N/A

tmp_disk_table_size

18446744073709551615

18446744073709551615

18446744073709551615

18446744073709551615

N/A

N/A

N/A

tmp_memory_table_size

16777216

16777216

16777216

16777216

N/A

N/A

N/A

tmp_table_size

16777216

16777216

16777216

16777216

16777216

16777216

16777216

tmpdir

/tmp

/tmp

/tmp

/tmp

/tmp

/tmp

/tmp

transaction_alloc_block_size

8192

8192

8192

8192

8192

8192

8192

transaction_prealloc_size

4096

4096

4096

4096

4096

4096

4096

tx_isolation

REPEATABLE-READ

REPEATABLE-READ

REPEATABLE-READ

REPEATABLE-READ

REPEATABLE-READ

REPEATABLE-READ

REPEATABLE-READ

tx_read_only

OFF

OFF

OFF

OFF

OFF

OFF

N/A

unique_checks

ON

ON

ON

ON

ON

ON

ON

updatable_views_with_limit

YES

YES

YES

YES

YES

YES

YES

use_stat_tables

PREFERABLY_FOR_QUERIES

PREFERABLY_FOR_QUERIES

NEVER

NEVER

NEVER

NEVER

N/A

userstat

OFF

OFF

OFF

OFF

OFF

OFF

OFF

version

10.5.5-MariaDB

10.4.14-MariaDB

10.3.24-MariaDB

10.2.33-MariaDB

10.1.46-MariaDB

10.0.38-MariaDB

5.5.66-MariaDB

version_compile_machine

x86_64

x86_64

x86_64

x86_64

x86_64

x86_64

x86_64

version_compile_os

Linux

Linux

Linux

Linux

Linux

Linux

Linux

version_malloc_library

system

system

system

system

N/A

N/A

N/A

version_source_revision

5b3d3792e28fc7a875c7060f77…

ddffcad64c9ff3299037eed9df…

4668e079eed635c9ff19a39e58…

N/A

N/A

N/A

N/A

wait_timeout

28800

28800

28800

28800

28800

28800

28800

warning_count

0

0

0

0

0

0

0

wsrep_auto_increment_control

ON

ON

ON

ON

ON

N/A

N/A

wsrep_causal_reads

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_certification_rules

strict

strict

strict

strict

strict

N/A

N/A

wsrep_certify_nonpk

ON

ON

ON

ON

ON

N/A

N/A

wsrep_cluster_name

my_wsrep_cluster

my_wsrep_cluster

my_wsrep_cluster

my_wsrep_cluster

my_wsrep_cluster

N/A

N/A

wsrep_convert_lock_to_trx

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_data_home_dir

/var/lib/mysql/

/var/lib/mysql/

/var/lib/mysql/

/var/lib/mysql/

/var/lib/mysql/

N/A

N/A

wsrep_debug

NONE

NONE

OFF

OFF

OFF

N/A

N/A

wsrep_desync

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_dirty_reads

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_drupal_282555_workaround

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_forced_binlog_format

NONE

NONE

NONE

NONE

NONE

N/A

N/A

wsrep_gtid_domain_id

0

0

0

0

0

N/A

N/A

wsrep_gtid_mode

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_gtid_seq_no

0

N/A

N/A

N/A

N/A

N/A

N/A

wsrep_ignore_apply_errors

7

7

N/A

N/A

N/A

N/A

N/A

wsrep_load_data_splitting

OFF

OFF

ON

ON

ON

N/A

N/A

wsrep_log_conflicts

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_max_ws_rows

0

0

0

0

0

N/A

N/A

wsrep_max_ws_size

2147483647

2147483647

2147483647

2147483647

2147483647

N/A

N/A

wsrep_mysql_replication_bundle

0

0

0

0

0

N/A

N/A

wsrep_node_incoming_address

AUTO

AUTO

AUTO

AUTO

AUTO

N/A

N/A

wsrep_node_name

schulung.linuxfabrik.loc

schulung.linuxfabrik.loc

schulung.linuxfabrik.loc

schulung.linuxfabrik.loc

schulung.linuxfabrik.loc

N/A

N/A

wsrep_on

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_osu_method

TOI

TOI

TOI

TOI

TOI

N/A

N/A

wsrep_patch_version

wsrep_26.22

wsrep_26.22

wsrep_25.24

wsrep_25.24

wsrep_25.24

N/A

N/A

wsrep_provider

none

none

none

none

none

N/A

N/A

wsrep_recover

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_reject_queries

NONE

NONE

NONE

NONE

NONE

N/A

N/A

wsrep_replicate_myisam

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_restart_slave

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_retry_autocommit

1

1

1

1

1

N/A

N/A

wsrep_slave_fk_checks

ON

ON

ON

ON

ON

N/A

N/A

wsrep_slave_threads

1

1

1

1

1

N/A

N/A

wsrep_slave_uk_checks

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_sr_store

table

table

N/A

N/A

N/A

N/A

N/A

wsrep_sst_donor_rejects_queries

OFF

OFF

OFF

OFF

OFF

N/A

N/A

wsrep_sst_method

rsync

rsync

rsync

rsync

rsync

N/A

N/A

wsrep_sst_receive_address

AUTO

AUTO

AUTO

AUTO

AUTO

N/A

N/A

wsrep_start_position

00000000-0000-0000-0000-00…

00000000-0000-0000-0000-00…

00000000-0000-0000-0000-00…

00000000-0000-0000-0000-00…

00000000-0000-0000-0000-00…

N/A

N/A

wsrep_strict_ddl

OFF

N/A

N/A

N/A

N/A

N/A

N/A

wsrep_sync_wait

0

0

0

0

0

N/A

N/A

wsrep_trx_fragment_size

0

0

N/A

N/A

N/A

N/A

N/A

wsrep_trx_fragment_unit

bytes

bytes

N/A

N/A

N/A

N/A

N/A

Built on 2022-06-03