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 2024-11-18