disabled_binlog: System Variables Comparison

Overview

Total Variables
707
Common to All
647
Different Values
66

Configuration: Tier 12G (innodb_buffer_pool_size = 12GB)

Servers:

All System Variables 707 variables

Variable Name Mysql 8.4.8 Mysql 8.4.8-lru Percona Server 8.4.8-8 Percona Server 8.4.8-8-orig Percona Server 8.4.8-8-patch Percona Server No Optimization 8.4.8-8 Percona Server Optimization 8.4.8-8 Percona Server Thread Stat 8.4.9-9
activate_all_roles_on_login OFF OFF OFF OFF OFF OFF OFF OFF
admin_address N/A N/A N/A N/A N/A N/A N/A N/A
admin_port 33062 33062 33062 33062 33062 33062 33062 33062
admin_ssl_ca N/A N/A N/A N/A N/A N/A N/A N/A
admin_ssl_capath N/A N/A N/A N/A N/A N/A N/A N/A
admin_ssl_cert N/A N/A N/A N/A N/A N/A N/A N/A
admin_ssl_cipher N/A N/A N/A N/A N/A N/A N/A N/A
admin_ssl_crl N/A N/A N/A N/A N/A N/A N/A N/A
admin_ssl_crlpath N/A N/A N/A N/A N/A N/A N/A N/A
admin_ssl_key N/A N/A N/A N/A N/A N/A N/A N/A
admin_tls_ciphersuites N/A N/A N/A N/A N/A N/A N/A N/A
admin_tls_version TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3
authentication_policy *,, *,, *,, *,, *,, *,, *,, *,,
auto_generate_certs ON ON ON ON ON ON ON ON
auto_increment_increment 1 1 1 1 1 1 1 1
auto_increment_offset 1 1 1 1 1 1 1 1
autocommit ON ON ON ON ON ON ON ON
automatic_sp_privileges ON ON ON ON ON ON ON ON
back_log 4096 4096 4096 4096 4096 4096 4096 4096
basedirDIFFERENT /home/bogdan.degtyariov/mysql-nvme/servers/mysql-8.4.8-linux-glibc2.28-x86_64/ /home/bogdan.degtyariov/mysql-nvme/servers/mysql-8.4.8-linux-glibc2.28-x86_64-patch4-62c9244/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch4-62c9244/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch4-62c9244/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.9-9-Linux.x86_64.glibc2.34/
big_tables OFF OFF OFF OFF OFF OFF OFF OFF
bind_address 0.0.0.0 0.0.0.0 0.0.0.0 0.0.0.0 0.0.0.0 0.0.0.0 0.0.0.0 0.0.0.0
binlog_cache_size 32768 32768 32768 32768 32768 32768 32768 32768
binlog_checksum CRC32 CRC32 CRC32 CRC32 CRC32 CRC32 CRC32 CRC32
binlog_ddl_skip_rewriteDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
binlog_direct_non_transactional_updates OFF OFF OFF OFF OFF OFF OFF OFF
binlog_encryption OFF OFF OFF OFF OFF OFF OFF OFF
binlog_error_action ABORT_SERVER ABORT_SERVER ABORT_SERVER ABORT_SERVER ABORT_SERVER ABORT_SERVER ABORT_SERVER ABORT_SERVER
binlog_expire_logs_auto_purge ON ON ON ON ON ON ON ON
binlog_expire_logs_seconds 2592000 2592000 2592000 2592000 2592000 2592000 2592000 2592000
binlog_format ROW ROW ROW ROW ROW ROW ROW ROW
binlog_group_commit_sync_delay 0 0 0 0 0 0 0 0
binlog_group_commit_sync_no_delay_count 0 0 0 0 0 0 0 0
binlog_gtid_simple_recovery ON ON ON ON ON ON ON ON
binlog_max_flush_queue_time 0 0 0 0 0 0 0 0
binlog_order_commits ON ON ON ON ON ON ON ON
binlog_rotate_encryption_master_key_at_startup OFF OFF OFF OFF OFF OFF OFF OFF
binlog_row_event_max_size 8192 8192 8192 8192 8192 8192 8192 8192
binlog_row_image FULL FULL FULL FULL FULL FULL FULL FULL
binlog_row_metadata MINIMAL MINIMAL MINIMAL MINIMAL MINIMAL MINIMAL MINIMAL MINIMAL
binlog_row_value_options N/A N/A N/A N/A N/A N/A N/A N/A
binlog_rows_query_log_events OFF OFF OFF OFF OFF OFF OFF OFF
binlog_skip_flush_commandsDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
binlog_space_limitDIFFERENT N/A N/A 0 0 0 0 0 0
binlog_stmt_cache_size 32768 32768 32768 32768 32768 32768 32768 32768
binlog_transaction_compression OFF OFF OFF OFF OFF OFF OFF OFF
binlog_transaction_compression_level_zstd 3 3 3 3 3 3 3 3
binlog_transaction_dependency_history_size 25000 25000 25000 25000 25000 25000 25000 25000
block_encryption_mode aes-128-ecb aes-128-ecb aes-128-ecb aes-128-ecb aes-128-ecb aes-128-ecb aes-128-ecb aes-128-ecb
buffered_error_log_filename N/A N/A N/A N/A N/A N/A N/A N/A
buffered_error_log_sizeDIFFERENT N/A N/A 0 0 0 0 0 0
build_idDIFFERENT 60e69111136df8068c515991173666e67a1f0ec2 6f125d1cc97f2049244bdba7fb171d066d77e6b7 4cbb74c3680358d1524fc12d3bce2e712f7aaa25 2669afd480c3e2c292fe1408982baa29b407d5cb 2669afd480c3e2c292fe1408982baa29b407d5cb 2669afd480c3e2c292fe1408982baa29b407d5cb 4cbb74c3680358d1524fc12d3bce2e712f7aaa25 cbc3335ce42c45a7249b41910c645cf5c09bc20d
bulk_insert_buffer_size 268435456 268435456 268435456 268435456 268435456 268435456 268435456 268435456
caching_sha2_password_auto_generate_rsa_keys ON ON ON ON ON ON ON ON
caching_sha2_password_digest_rounds 5000 5000 5000 5000 5000 5000 5000 5000
caching_sha2_password_private_key_path private_key.pem private_key.pem private_key.pem private_key.pem private_key.pem private_key.pem private_key.pem private_key.pem
caching_sha2_password_public_key_path public_key.pem public_key.pem public_key.pem public_key.pem public_key.pem public_key.pem public_key.pem public_key.pem
character_set_client utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4
character_set_connection utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4
character_set_database utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4
character_set_filesystem binary binary binary binary binary binary binary binary
character_set_results utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4
character_set_server utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4
character_set_system utf8mb3 utf8mb3 utf8mb3 utf8mb3 utf8mb3 utf8mb3 utf8mb3 utf8mb3
character_sets_dirDIFFERENT /home/bogdan.degtyariov/mysql-nvme/servers/mysql-8.4.8-linux-glibc2.28-x86_64/share/charsets/ /home/bogdan.degtyariov/mysql-nvme/servers/mysql-8.4.8-linux-glibc2.28-x86_64-patch4-62c9244/share/charsets/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch4-62c9244/share/charsets/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/share/charsets/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/share/charsets/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/share/charsets/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch4-62c9244/share/charsets/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.9-9-Linux.x86_64.glibc2.34/share/charsets/
check_proxy_users OFF OFF OFF OFF OFF OFF OFF OFF
collation_connection utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
collation_database utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci
collation_server utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci utf8mb4_unicode_ci
completion_type NO_CHAIN NO_CHAIN NO_CHAIN NO_CHAIN NO_CHAIN NO_CHAIN NO_CHAIN NO_CHAIN
concurrent_insert AUTO AUTO AUTO AUTO AUTO AUTO AUTO AUTO
connect_timeout 60 60 60 60 60 60 60 60
connection_memory_chunk_size 8192 8192 8192 8192 8192 8192 8192 8192
connection_memory_limit 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
core_file OFF OFF OFF OFF OFF OFF OFF OFF
create_admin_listener_thread OFF OFF OFF OFF OFF OFF OFF OFF
cte_max_recursion_depth 1000 1000 1000 1000 1000 1000 1000 1000
datadirDIFFERENT /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/ /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/ /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/ /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/ /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/ /home/bogdan.degtyariov/mysql-nvme/data/percona-server-no-optimization_8.4.8-8_tier12G_threadpool/ /home/bogdan.degtyariov/mysql-nvme/data/percona-server-optimization_8.4.8-8_tier12G_threadpool/ /home/bogdan.degtyariov/mysql-nvme/data/percona-server-thread-stat_8.4.9-9_tier12G_threadpool/
default_collation_for_utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
default_password_lifetime 0 0 0 0 0 0 0 0
default_storage_engine InnoDB InnoDB InnoDB InnoDB InnoDB InnoDB InnoDB InnoDB
default_table_encryption OFF OFF OFF OFF OFF OFF OFF OFF
default_tmp_storage_engine InnoDB InnoDB InnoDB InnoDB InnoDB InnoDB InnoDB InnoDB
default_week_format 0 0 0 0 0 0 0 0
delay_key_write ON ON ON ON ON ON ON ON
delayed_insert_limit 100 100 100 100 100 100 100 100
delayed_insert_timeout 300 300 300 300 300 300 300 300
delayed_queue_size 1000 1000 1000 1000 1000 1000 1000 1000
disabled_storage_engines N/A N/A N/A N/A N/A N/A N/A N/A
disconnect_on_expired_password ON ON ON ON ON ON ON ON
div_precision_increment 4 4 4 4 4 4 4 4
encrypt_tmp_filesDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
end_markers_in_json OFF OFF OFF OFF OFF OFF OFF OFF
enforce_gtid_consistency OFF OFF OFF OFF OFF OFF OFF OFF
enforce_storage_engine N/A N/A N/A N/A N/A N/A N/A N/A
eq_range_index_dive_limit 200 200 200 200 200 200 200 200
error_count 0 0 0 0 0 0 0 0
event_scheduler ON ON ON ON ON ON ON ON
expand_fast_index_creationDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
explain_format TRADITIONAL TRADITIONAL TRADITIONAL TRADITIONAL TRADITIONAL TRADITIONAL TRADITIONAL TRADITIONAL
explain_json_format_version 1 1 1 1 1 1 1 1
explicit_defaults_for_timestamp ON ON ON ON ON ON ON ON
external_user N/A N/A N/A N/A N/A N/A N/A N/A
flush OFF OFF OFF OFF OFF OFF OFF OFF
flush_time 0 0 0 0 0 0 0 0
foreign_key_checks ON ON ON ON ON ON ON ON
ft_boolean_syntax + -><()~*:""&| + -><()~*:""&| + -><()~*:""&| + -><()~*:""&| + -><()~*:""&| + -><()~*:""&| + -><()~*:""&| + -><()~*:""&|
ft_max_word_len 84 84 84 84 84 84 84 84
ft_min_word_len 4 4 4 4 4 4 4 4
ft_query_expansion_limit 20 20 20 20 20 20 20 20
ft_query_extra_word_charsDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
ft_stopword_file (built-in) (built-in) (built-in) (built-in) (built-in) (built-in) (built-in) (built-in)
general_log OFF OFF OFF OFF OFF OFF OFF OFF
general_log_fileDIFFERENT /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/beast-node8.log /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/beast-node8.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/beast-node8.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/beast-node8.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/beast-node8.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server-no-optimization_8.4.8-8_tier12G_threadpool/beast-node8.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server-optimization_8.4.8-8_tier12G_threadpool/beast-node8.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server-thread-stat_8.4.9-9_tier12G_threadpool/beast-node8.log
generated_random_password_length 20 20 20 20 20 20 20 20
global_connection_memory_limit 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
global_connection_memory_tracking OFF OFF OFF OFF OFF OFF OFF OFF
group_concat_max_len 1024 1024 1024 1024 1024 1024 1024 1024
group_replication_consistency BEFORE_ON_PRIMARY_FAILOVER BEFORE_ON_PRIMARY_FAILOVER BEFORE_ON_PRIMARY_FAILOVER BEFORE_ON_PRIMARY_FAILOVER BEFORE_ON_PRIMARY_FAILOVER BEFORE_ON_PRIMARY_FAILOVER BEFORE_ON_PRIMARY_FAILOVER BEFORE_ON_PRIMARY_FAILOVER
gtid_executed N/A N/A N/A N/A N/A N/A N/A N/A
gtid_executed_compression_period 0 0 0 0 0 0 0 0
gtid_mode OFF OFF OFF OFF OFF OFF OFF OFF
gtid_next AUTOMATIC AUTOMATIC AUTOMATIC AUTOMATIC AUTOMATIC AUTOMATIC AUTOMATIC AUTOMATIC
gtid_owned N/A N/A N/A N/A N/A N/A N/A N/A
gtid_purged N/A N/A N/A N/A N/A N/A N/A N/A
have_backup_locksDIFFERENT N/A N/A YES YES YES YES YES YES
have_backup_safe_binlog_infoDIFFERENT N/A N/A YES YES YES YES YES YES
have_compress YES YES YES YES YES YES YES YES
have_dynamic_loading YES YES YES YES YES YES YES YES
have_geometry YES YES YES YES YES YES YES YES
have_profiling YES YES YES YES YES YES YES YES
have_query_cache NO NO NO NO NO NO NO NO
have_rtree_keys YES YES YES YES YES YES YES YES
have_snapshot_cloningDIFFERENT N/A N/A YES YES YES YES YES YES
have_statement_timeout YES YES YES YES YES YES YES YES
have_symlink DISABLED DISABLED DISABLED DISABLED DISABLED DISABLED DISABLED DISABLED
histogram_generation_max_mem_size 20000000 20000000 20000000 20000000 20000000 20000000 20000000 20000000
host_cache_size 703 703 703 703 703 703 703 703
hostname beast-node8.tp.int.percona.com beast-node8.tp.int.percona.com beast-node8.tp.int.percona.com beast-node8.tp.int.percona.com beast-node8.tp.int.percona.com beast-node8.tp.int.percona.com beast-node8.tp.int.percona.com beast-node8.tp.int.percona.com
identity 0 0 0 0 0 0 0 0
immediate_server_version 999999 999999 999999 999999 999999 999999 999999 999999
information_schema_stats_expiry 86400 86400 86400 86400 86400 86400 86400 86400
init_connect N/A N/A N/A N/A N/A N/A N/A N/A
init_file N/A N/A N/A N/A N/A N/A N/A N/A
init_replica N/A N/A N/A N/A N/A N/A N/A N/A
init_slave N/A N/A N/A N/A N/A N/A N/A N/A
innodb_adaptive_flushing ON ON ON ON ON ON ON ON
innodb_adaptive_flushing_lwm 10 10 10 10 10 10 10 10
innodb_adaptive_hash_index OFF OFF OFF OFF OFF OFF OFF OFF
innodb_adaptive_hash_index_parts 8 8 8 8 8 8 8 8
innodb_adaptive_max_sleep_delay 150000 150000 150000 150000 150000 150000 150000 150000
innodb_api_bk_commit_interval 5 5 5 5 5 5 5 5
innodb_api_disable_rowlock OFF OFF OFF OFF OFF OFF OFF OFF
innodb_api_enable_binlog OFF OFF OFF OFF OFF OFF OFF OFF
innodb_api_enable_mdl OFF OFF OFF OFF OFF OFF OFF OFF
innodb_api_trx_level 0 0 0 0 0 0 0 0
innodb_autoextend_increment 64 64 64 64 64 64 64 64
innodb_autoinc_lock_mode 2 2 2 2 2 2 2 2
innodb_buffer_pool_chunk_size 134217728 134217728 134217728 134217728 134217728 134217728 134217728 134217728
innodb_buffer_pool_dump_at_shutdown OFF OFF OFF OFF OFF OFF OFF OFF
innodb_buffer_pool_dump_now OFF OFF OFF OFF OFF OFF OFF OFF
innodb_buffer_pool_dump_pct 25 25 25 25 25 25 25 25
innodb_buffer_pool_filename ib_buffer_pool ib_buffer_pool ib_buffer_pool ib_buffer_pool ib_buffer_pool ib_buffer_pool ib_buffer_pool ib_buffer_pool
innodb_buffer_pool_in_core_file OFF OFF OFF OFF OFF OFF OFF OFF
innodb_buffer_pool_instances 2 2 2 2 2 2 2 2
innodb_buffer_pool_load_abort OFF OFF OFF OFF OFF OFF OFF OFF
innodb_buffer_pool_load_at_startup OFF OFF OFF OFF OFF OFF OFF OFF
innodb_buffer_pool_load_now OFF OFF OFF OFF OFF OFF OFF OFF
innodb_buffer_pool_size 12884901888 12884901888 12884901888 12884901888 12884901888 12884901888 12884901888 12884901888
innodb_change_buffer_max_size 25 25 25 25 25 25 25 25
innodb_change_buffering none none none none none none none none
innodb_checksum_algorithm crc32 crc32 crc32 crc32 crc32 crc32 crc32 crc32
innodb_cleaner_lsn_age_factorDIFFERENT N/A N/A high_checkpoint high_checkpoint high_checkpoint high_checkpoint high_checkpoint high_checkpoint
innodb_cmp_per_index_enabled OFF OFF OFF OFF OFF OFF OFF OFF
innodb_commit_concurrency 0 0 0 0 0 0 0 0
innodb_compressed_columns_thresholdDIFFERENT N/A N/A 96 96 96 96 96 96
innodb_compressed_columns_zip_levelDIFFERENT N/A N/A 6 6 6 6 6 6
innodb_compression_failure_threshold_pct 5 5 5 5 5 5 5 5
innodb_compression_level 6 6 6 6 6 6 6 6
innodb_compression_pad_pct_max 50 50 50 50 50 50 50 50
innodb_concurrency_tickets 5000 5000 5000 5000 5000 5000 5000 5000
innodb_corrupt_table_actionDIFFERENT N/A N/A assert assert assert 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:12M:autoextend ibdata1:12M:autoextend
innodb_data_home_dir N/A N/A N/A N/A N/A N/A N/A N/A
innodb_ddl_buffer_size 1048576 1048576 1048576 1048576 1048576 1048576 1048576 1048576
innodb_ddl_threads 4 4 4 4 4 4 4 4
innodb_deadlock_detect ON ON ON ON ON ON ON ON
innodb_dedicated_server OFF OFF OFF OFF OFF OFF OFF OFF
innodb_default_row_format dynamic dynamic dynamic dynamic dynamic dynamic dynamic dynamic
innodb_directories N/A N/A N/A N/A N/A N/A N/A N/A
innodb_disable_sort_file_cache OFF OFF OFF OFF OFF OFF OFF OFF
innodb_doublewrite ON ON ON ON ON ON ON ON
innodb_doublewrite_batch_size 0 0 0 0 0 0 0 0
innodb_doublewrite_dir N/A N/A N/A N/A N/A N/A N/A N/A
innodb_doublewrite_files 2 2 2 2 2 2 2 2
innodb_doublewrite_pages 128 128 128 128 128 128 128 128
innodb_empty_free_list_algorithmDIFFERENT N/A N/A legacy legacy legacy legacy legacy legacy
innodb_encrypt_online_alter_logsDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
innodb_extend_and_initialize ON ON ON ON ON ON ON ON
innodb_fast_shutdown 1 1 1 1 1 1 1 1
innodb_file_per_table ON ON ON ON ON ON ON ON
innodb_fill_factor 100 100 100 100 100 100 100 100
innodb_flush_log_at_timeout 1 1 1 1 1 1 1 1
innodb_flush_log_at_trx_commit 1 1 1 1 1 1 1 1
innodb_flush_method O_DIRECT O_DIRECT O_DIRECT O_DIRECT O_DIRECT O_DIRECT O_DIRECT O_DIRECT
innodb_flush_neighbors 0 0 0 0 0 0 0 0
innodb_flush_sync ON ON ON ON ON ON ON ON
innodb_flushing_avg_loops 30 30 30 30 30 30 30 30
innodb_force_index_records_in_rangeDIFFERENT N/A N/A 0 0 0 0 0 0
innodb_force_load_corrupted OFF OFF OFF OFF OFF OFF OFF OFF
innodb_force_recovery 0 0 0 0 0 0 0 0
innodb_fsync_threshold 0 0 0 0 0 0 0 0
innodb_ft_aux_table N/A N/A N/A N/A N/A N/A N/A N/A
innodb_ft_cache_size 8000000 8000000 8000000 8000000 8000000 8000000 8000000 8000000
innodb_ft_enable_diag_print OFF OFF OFF OFF OFF OFF OFF OFF
innodb_ft_enable_stopword ON ON ON ON ON ON ON ON
innodb_ft_ignore_stopwordsDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
innodb_ft_max_token_size 84 84 84 84 84 84 84 84
innodb_ft_min_token_size 3 3 3 3 3 3 3 3
innodb_ft_num_word_optimize 2000 2000 2000 2000 2000 2000 2000 2000
innodb_ft_result_cache_limit 2000000000 2000000000 2000000000 2000000000 2000000000 2000000000 2000000000 2000000000
innodb_ft_server_stopword_table N/A N/A N/A N/A N/A N/A N/A N/A
innodb_ft_sort_pll_degree 2 2 2 2 2 2 2 2
innodb_ft_total_cache_size 640000000 640000000 640000000 640000000 640000000 640000000 640000000 640000000
innodb_ft_user_stopword_table N/A N/A N/A N/A N/A N/A N/A N/A
innodb_idle_flush_pct 100 100 100 100 100 100 100 100
innodb_io_capacity 10000 10000 10000 10000 10000 10000 10000 10000
innodb_io_capacity_max 20000 20000 20000 20000 20000 20000 20000 20000
innodb_lock_wait_timeout 50 50 50 50 50 50 50 50
innodb_log_buffer_size 268435456 268435456 268435456 268435456 268435456 268435456 268435456 268435456
innodb_log_checksums ON ON ON ON ON ON ON ON
innodb_log_compressed_pages ON ON ON ON ON ON ON ON
innodb_log_file_size 50331648 50331648 50331648 50331648 50331648 50331648 50331648 50331648
innodb_log_files_in_group 2 2 2 2 2 2 2 2
innodb_log_group_home_dir ./ ./ ./ ./ ./ ./ ./ ./
innodb_log_spin_cpu_abs_lwm 80 80 80 80 80 80 80 80
innodb_log_spin_cpu_pct_hwm 50 50 50 50 50 50 50 50
innodb_log_wait_for_flush_spin_hwm 400 400 400 400 400 400 400 400
innodb_log_write_ahead_size 8192 8192 8192 8192 8192 8192 8192 8192
innodb_log_writer_threads ON ON ON ON ON ON ON ON
innodb_lru_scan_depth 1024 1024 1024 1024 1024 1024 1024 1024
innodb_max_dirty_pages_pct 90.000000 90.000000 90.000000 90.000000 90.000000 90.000000 90.000000 90.000000
innodb_max_dirty_pages_pct_lwm 10.000000 10.000000 10.000000 10.000000 10.000000 10.000000 10.000000 10.000000
innodb_max_purge_lag 0 0 0 0 0 0 0 0
innodb_max_purge_lag_delay 0 0 0 0 0 0 0 0
innodb_max_undo_log_size 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824
innodb_monitor_disable N/A N/A N/A N/A N/A N/A N/A N/A
innodb_monitor_enableDIFFERENT all all latch all all latch latch latch
innodb_monitor_reset N/A N/A N/A N/A N/A N/A N/A N/A
innodb_monitor_reset_all N/A N/A N/A N/A N/A N/A N/A N/A
innodb_numa_interleave ON ON ON ON ON ON ON ON
innodb_old_blocks_pct 37 37 37 37 37 37 37 37
innodb_old_blocks_time 1000 1000 1000 1000 1000 1000 1000 1000
innodb_online_alter_log_max_size 134217728 134217728 134217728 134217728 134217728 134217728 134217728 134217728
innodb_open_files 65536 65536 65536 65536 65536 65536 65536 65536
innodb_optimize_fulltext_only OFF OFF OFF OFF OFF OFF OFF OFF
innodb_page_cleaners 2 2 2 2 2 2 2 2
innodb_page_size 16384 16384 16384 16384 16384 16384 16384 16384
innodb_parallel_read_threads 10 10 10 10 10 10 10 10
innodb_print_all_deadlocks OFF OFF OFF OFF OFF OFF OFF OFF
innodb_print_ddl_logs OFF OFF OFF OFF OFF OFF OFF OFF
innodb_print_lock_wait_timeout_infoDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
innodb_purge_batch_size 300 300 300 300 300 300 300 300
innodb_purge_rseg_truncate_frequency 128 128 128 128 128 128 128 128
innodb_purge_threads 4 4 4 4 4 4 4 4
innodb_random_read_ahead OFF OFF OFF OFF OFF OFF OFF OFF
innodb_read_ahead_threshold 56 56 56 56 56 56 56 56
innodb_read_io_threads 16 16 16 16 16 16 16 16
innodb_read_only OFF OFF OFF OFF OFF OFF OFF OFF
innodb_records_in_rangeDIFFERENT N/A N/A 0 0 0 0 0 0
innodb_redo_log_archive_dirs N/A N/A N/A N/A N/A N/A N/A N/A
innodb_redo_log_capacity 4294967296 4294967296 4294967296 4294967296 4294967296 4294967296 4294967296 4294967296
innodb_redo_log_encrypt OFF OFF OFF OFF OFF OFF OFF OFF
innodb_replication_delay 0 0 0 0 0 0 0 0
innodb_rollback_on_timeout ON ON ON ON ON ON ON ON
innodb_rollback_segments 128 128 128 128 128 128 128 128
innodb_segment_reserve_factor 12.500000 12.500000 12.500000 12.500000 12.500000 12.500000 12.500000 12.500000
innodb_show_locks_heldDIFFERENT N/A N/A 10 10 10 10 10 10
innodb_sort_buffer_size 1048576 1048576 1048576 1048576 1048576 1048576 1048576 1048576
innodb_spin_wait_delay 6 6 6 6 6 6 6 6
innodb_spin_wait_pause_multiplier 50 50 50 50 50 50 50 50
innodb_stats_auto_recalc ON ON ON ON ON ON ON ON
innodb_stats_include_delete_marked OFF OFF OFF OFF OFF OFF OFF OFF
innodb_stats_method nulls_equal nulls_equal nulls_equal nulls_equal nulls_equal nulls_equal nulls_equal nulls_equal
innodb_stats_on_metadata OFF OFF OFF OFF OFF OFF OFF OFF
innodb_stats_persistent ON ON ON ON ON ON ON ON
innodb_stats_persistent_sample_pages 20 20 20 20 20 20 20 20
innodb_stats_transient_sample_pages 8 8 8 8 8 8 8 8
innodb_status_output OFF OFF OFF OFF OFF OFF OFF OFF
innodb_status_output_locks OFF OFF OFF OFF OFF OFF OFF OFF
innodb_strict_mode ON ON ON ON ON ON ON ON
innodb_sync_array_size 1 1 1 1 1 1 1 1
innodb_sync_spin_loops 30 30 30 30 30 30 30 30
innodb_sys_tablespace_encryptDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
innodb_table_locks ON ON ON ON ON ON ON ON
innodb_temp_data_file_path ibtmp1:12M:autoextend ibtmp1:12M:autoextend ibtmp1:12M:autoextend ibtmp1:12M:autoextend ibtmp1:12M:autoextend ibtmp1:12M:autoextend ibtmp1:12M:autoextend ibtmp1:12M:autoextend
innodb_temp_tablespace_encryptDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
innodb_temp_tablespaces_dir ./#innodb_temp/ ./#innodb_temp/ ./#innodb_temp/ ./#innodb_temp/ ./#innodb_temp/ ./#innodb_temp/ ./#innodb_temp/ ./#innodb_temp/
innodb_thread_concurrency 0 0 0 0 0 0 0 0
innodb_thread_sleep_delay 10000 10000 10000 10000 10000 10000 10000 10000
innodb_tmpdir N/A N/A N/A N/A N/A N/A N/A N/A
innodb_undo_directory ./ ./ ./ ./ ./ ./ ./ ./
innodb_undo_log_encrypt OFF OFF OFF OFF OFF OFF OFF OFF
innodb_undo_log_truncate ON ON ON ON ON ON ON ON
innodb_undo_tablespaces 2 2 2 2 2 2 2 2
innodb_use_fdatasync ON ON ON ON ON ON ON ON
innodb_use_native_aio ON ON ON ON ON ON ON ON
innodb_validate_tablespace_paths ON ON ON ON ON ON ON ON
innodb_versionDIFFERENT 8.4.8 8.4.8 8.4.8-8 8.4.8-8 8.4.8-8 8.4.8-8 8.4.8-8 8.4.9-9
innodb_write_io_threads 16 16 16 16 16 16 16 16
insert_id 0 0 0 0 0 0 0 0
interactive_timeout 300 300 300 300 300 300 300 300
internal_tmp_mem_storage_engine TempTable TempTable TempTable TempTable TempTable TempTable TempTable TempTable
jemalloc_detectedDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
jemalloc_profilingDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
join_buffer_size 4194304 4194304 4194304 4194304 4194304 4194304 4194304 4194304
keep_files_on_create OFF OFF OFF OFF OFF OFF OFF OFF
key_buffer_size 67108864 67108864 67108864 67108864 67108864 67108864 67108864 67108864
key_cache_age_threshold 300 300 300 300 300 300 300 300
key_cache_block_size 1024 1024 1024 1024 1024 1024 1024 1024
key_cache_division_limit 100 100 100 100 100 100 100 100
keyring_operations ON ON ON ON ON ON ON ON
kill_idle_transactionDIFFERENT N/A N/A 0 0 0 0 0 0
large_files_support ON ON ON ON ON ON ON ON
large_page_size 0 0 0 0 0 0 0 0
large_pages OFF OFF OFF OFF OFF OFF OFF OFF
last_insert_id 0 0 0 0 0 0 0 0
lc_messages en_US en_US en_US en_US en_US en_US en_US en_US
lc_messages_dirDIFFERENT /home/bogdan.degtyariov/mysql-nvme/servers/mysql-8.4.8-linux-glibc2.28-x86_64/share/ /home/bogdan.degtyariov/mysql-nvme/servers/mysql-8.4.8-linux-glibc2.28-x86_64-patch4-62c9244/share/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch4-62c9244/share/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/share/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/share/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/share/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch4-62c9244/share/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.9-9-Linux.x86_64.glibc2.34/share/
lc_time_names en_US en_US en_US en_US en_US en_US en_US en_US
license GPL GPL GPL GPL GPL GPL GPL GPL
local_infile OFF OFF OFF OFF OFF OFF OFF OFF
lock_wait_timeout 31536000 31536000 31536000 31536000 31536000 31536000 31536000 31536000
locked_in_memory OFF OFF OFF OFF OFF OFF OFF OFF
log_bin OFF OFF OFF OFF OFF OFF OFF OFF
log_bin_basename N/A N/A N/A N/A N/A N/A N/A N/A
log_bin_index N/A N/A N/A N/A N/A N/A N/A N/A
log_bin_trust_function_creators OFF OFF OFF OFF OFF OFF OFF OFF
log_errorDIFFERENT /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/mysql-error.log /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/mysql-error.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/mysql-error.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/mysql-error.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/mysql-error.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server-no-optimization_8.4.8-8_tier12G_threadpool/mysql-error.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server-optimization_8.4.8-8_tier12G_threadpool/mysql-error.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server-thread-stat_8.4.9-9_tier12G_threadpool/mysql-error.log
log_error_services log_filter_internal; log_sink_internal log_filter_internal; log_sink_internal log_filter_internal; log_sink_internal log_filter_internal; log_sink_internal log_filter_internal; log_sink_internal log_filter_internal; log_sink_internal log_filter_internal; log_sink_internal log_filter_internal; log_sink_internal
log_error_suppression_list N/A N/A N/A N/A N/A N/A N/A N/A
log_error_verbosity 3 3 3 3 3 3 3 3
log_output FILE FILE FILE FILE FILE FILE FILE FILE
log_queries_not_using_indexes OFF OFF OFF OFF OFF OFF OFF OFF
log_query_errors N/A N/A N/A N/A N/A N/A N/A N/A
log_raw OFF OFF OFF OFF OFF OFF OFF OFF
log_replica_updates OFF OFF OFF OFF OFF OFF OFF OFF
log_slave_updates OFF OFF OFF OFF OFF OFF OFF OFF
log_slow_admin_statements OFF OFF OFF OFF OFF OFF OFF OFF
log_slow_extra OFF OFF OFF OFF OFF OFF OFF OFF
log_slow_filter N/A N/A N/A N/A N/A N/A N/A N/A
log_slow_rate_limitDIFFERENT N/A N/A 1 1 1 1 1 1
log_slow_rate_typeDIFFERENT N/A N/A session session session session session session
log_slow_replica_statements OFF OFF OFF OFF OFF OFF OFF OFF
log_slow_slave_statements OFF OFF OFF OFF OFF OFF OFF OFF
log_slow_sp_statementsDIFFERENT N/A N/A ON ON ON ON ON ON
log_slow_verbosity N/A N/A N/A N/A N/A N/A N/A N/A
log_statements_unsafe_for_binlog ON ON ON ON ON ON ON ON
log_throttle_queries_not_using_indexes 0 0 0 0 0 0 0 0
log_timestamps UTC UTC UTC UTC UTC UTC UTC UTC
long_query_time 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000
low_priority_updates OFF OFF OFF OFF OFF OFF OFF OFF
lower_case_file_system OFF OFF OFF OFF OFF OFF OFF OFF
lower_case_table_names 0 0 0 0 0 0 0 0
mandatory_roles N/A N/A N/A N/A N/A N/A N/A N/A
master_verify_checksum OFF OFF OFF OFF OFF OFF OFF OFF
max_allowed_packet 67108864 67108864 67108864 67108864 67108864 67108864 67108864 67108864
max_binlog_cache_size 18446744073709547520 18446744073709547520 18446744073709547520 18446744073709547520 18446744073709547520 18446744073709547520 18446744073709547520 18446744073709547520
max_binlog_size 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824
max_binlog_stmt_cache_size 18446744073709547520 18446744073709547520 18446744073709547520 18446744073709547520 18446744073709547520 18446744073709547520 18446744073709547520 18446744073709547520
max_connect_errors 1000000 1000000 1000000 1000000 1000000 1000000 1000000 1000000
max_connections 2000 2000 2000 2000 2000 2000 2000 2000
max_delayed_threads 20 20 20 20 20 20 20 20
max_digest_length 1024 1024 1024 1024 1024 1024 1024 1024
max_error_count 1024 1024 1024 1024 1024 1024 1024 1024
max_execution_time 0 0 0 0 0 0 0 0
max_heap_table_size 268435456 268435456 268435456 268435456 268435456 268435456 268435456 268435456
max_insert_delayed_threads 20 20 20 20 20 20 20 20
max_join_size 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
max_length_for_sort_data 4096 4096 4096 4096 4096 4096 4096 4096
max_points_in_geometry 65536 65536 65536 65536 65536 65536 65536 65536
max_prepared_stmt_count 1000000 1000000 1000000 1000000 1000000 1000000 1000000 1000000
max_relay_log_size 0 0 0 0 0 0 0 0
max_seeks_for_key 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
max_slowlog_filesDIFFERENT N/A N/A 0 0 0 0 0 0
max_slowlog_sizeDIFFERENT N/A N/A 0 0 0 0 0 0
max_sort_length 1024 1024 1024 1024 1024 1024 1024 1024
max_sp_recursion_depth 0 0 0 0 0 0 0 0
max_user_connections 0 0 0 0 0 0 0 0
max_write_lock_count 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
min_examined_row_limit 1000 1000 1000 1000 1000 1000 1000 1000
myisam_data_pointer_size 6 6 6 6 6 6 6 6
myisam_max_sort_file_size 9223372036853727232 9223372036853727232 9223372036853727232 9223372036853727232 9223372036853727232 9223372036853727232 9223372036853727232 9223372036853727232
myisam_mmap_size 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
myisam_recover_options OFF OFF OFF OFF OFF OFF OFF OFF
myisam_sort_buffer_size 134217728 134217728 134217728 134217728 134217728 134217728 134217728 134217728
myisam_stats_method nulls_unequal nulls_unequal nulls_unequal nulls_unequal nulls_unequal nulls_unequal nulls_unequal nulls_unequal
myisam_use_mmap OFF OFF OFF OFF OFF OFF OFF OFF
mysql_native_password_proxy_users OFF OFF OFF OFF OFF OFF OFF OFF
mysqlx_bind_address * * * * * * * *
mysqlx_compression_algorithms DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM
mysqlx_connect_timeout 30 30 30 30 30 30 30 30
mysqlx_deflate_default_compression_level 3 3 3 3 3 3 3 3
mysqlx_deflate_max_client_compression_level 5 5 5 5 5 5 5 5
mysqlx_document_id_unique_prefix 0 0 0 0 0 0 0 0
mysqlx_enable_hello_notice ON ON ON ON ON ON ON ON
mysqlx_idle_worker_thread_timeout 60 60 60 60 60 60 60 60
mysqlx_interactive_timeout 28800 28800 28800 28800 28800 28800 28800 28800
mysqlx_lz4_default_compression_level 2 2 2 2 2 2 2 2
mysqlx_lz4_max_client_compression_level 8 8 8 8 8 8 8 8
mysqlx_max_allowed_packet 67108864 67108864 67108864 67108864 67108864 67108864 67108864 67108864
mysqlx_max_connections 100 100 100 100 100 100 100 100
mysqlx_min_worker_threads 2 2 2 2 2 2 2 2
mysqlx_port 33060 33060 33060 33060 33060 33060 33060 33060
mysqlx_port_open_timeout 0 0 0 0 0 0 0 0
mysqlx_read_timeout 30 30 30 30 30 30 30 30
mysqlx_socket /tmp/mysqlx.sock /tmp/mysqlx.sock /tmp/mysqlx.sock /tmp/mysqlx.sock /tmp/mysqlx.sock /tmp/mysqlx.sock /tmp/mysqlx.sock /tmp/mysqlx.sock
mysqlx_ssl_ca N/A N/A N/A N/A N/A N/A N/A N/A
mysqlx_ssl_capath N/A N/A N/A N/A N/A N/A N/A N/A
mysqlx_ssl_cert N/A N/A N/A N/A N/A N/A N/A N/A
mysqlx_ssl_cipher N/A N/A N/A N/A N/A N/A N/A N/A
mysqlx_ssl_crl N/A N/A N/A N/A N/A N/A N/A N/A
mysqlx_ssl_crlpath N/A N/A N/A N/A N/A N/A N/A N/A
mysqlx_ssl_key N/A N/A N/A N/A N/A N/A N/A N/A
mysqlx_wait_timeout 28800 28800 28800 28800 28800 28800 28800 28800
mysqlx_write_timeout 60 60 60 60 60 60 60 60
mysqlx_zstd_default_compression_level 3 3 3 3 3 3 3 3
mysqlx_zstd_max_client_compression_level 11 11 11 11 11 11 11 11
net_buffer_length 16384 16384 16384 16384 16384 16384 16384 16384
net_buffer_shrink_intervalDIFFERENT N/A N/A 0 0 0 0 0 0
net_read_timeout 30 30 30 30 30 30 30 30
net_retry_count 10 10 10 10 10 10 10 10
net_write_timeout 60 60 60 60 60 60 60 60
ngram_token_size 2 2 2 2 2 2 2 2
offline_mode OFF OFF OFF OFF OFF OFF OFF OFF
old_alter_table OFF OFF OFF OFF OFF OFF OFF OFF
open_files_limit 1000000 1000000 1000000 1000000 1000000 1000000 1000000 1000000
optimizer_max_subgraph_pairs 100000 100000 100000 100000 100000 100000 100000 100000
optimizer_prune_level 1 1 1 1 1 1 1 1
optimizer_search_depth 62 62 62 62 62 62 62 62
optimizer_switchDIFFERENT index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched... index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched... index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched... index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched... index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched... index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched... index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched... index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched...
optimizer_trace enabled=off,one_line=off enabled=off,one_line=off enabled=off,one_line=off enabled=off,one_line=off enabled=off,one_line=off enabled=off,one_line=off enabled=off,one_line=off enabled=off,one_line=off
optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer_trace_limit 1 1 1 1 1 1 1 1
optimizer_trace_max_mem_size 1048576 1048576 1048576 1048576 1048576 1048576 1048576 1048576
optimizer_trace_offset -1 -1 -1 -1 -1 -1 -1 -1
original_commit_timestamp 36028797018963968 36028797018963968 36028797018963968 36028797018963968 36028797018963968 36028797018963968 36028797018963968 36028797018963968
original_server_version 999999 999999 999999 999999 999999 999999 999999 999999
parser_max_mem_size 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
partial_revokes OFF OFF OFF OFF OFF OFF OFF OFF
password_history 0 0 0 0 0 0 0 0
password_require_current OFF OFF OFF OFF OFF OFF OFF OFF
password_reuse_interval 0 0 0 0 0 0 0 0
percona_telemetry.grace_intervalDIFFERENT N/A N/A 86400 86400 86400 86400 86400 86400
percona_telemetry.history_keep_intervalDIFFERENT N/A N/A 604800 604800 604800 604800 604800 604800
percona_telemetry.scrape_intervalDIFFERENT N/A N/A 86400 86400 86400 86400 86400 86400
percona_telemetry.telemetry_root_dirDIFFERENT N/A N/A /usr/local/percona/telemetry/ps /usr/local/percona/telemetry/ps /usr/local/percona/telemetry/ps /usr/local/percona/telemetry/ps /usr/local/percona/telemetry/ps /usr/local/percona/telemetry/ps
percona_telemetry_disableDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
performance_schemaDIFFERENT OFF ON ON OFF OFF ON ON ON
performance_schema_accounts_sizeDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_digests_sizeDIFFERENT 0 10000 10000 0 0 10000 10000 10000
performance_schema_error_sizeDIFFERENT 5551 5551 5724 5724 5724 5724 5724 5790
performance_schema_events_stages_history_long_sizeDIFFERENT 0 10000 10000 0 0 10000 10000 10000
performance_schema_events_stages_history_sizeDIFFERENT 0 10 10 0 0 10 10 10
performance_schema_events_statements_history_long_sizeDIFFERENT 0 10000 10000 0 0 10000 10000 10000
performance_schema_events_statements_history_sizeDIFFERENT 0 10 10 0 0 10 10 10
performance_schema_events_transactions_history_long_sizeDIFFERENT 0 10000 10000 0 0 10000 10000 10000
performance_schema_events_transactions_history_sizeDIFFERENT 0 10 10 0 0 10 10 10
performance_schema_events_waits_history_long_sizeDIFFERENT 0 10000 10000 0 0 10000 10000 10000
performance_schema_events_waits_history_sizeDIFFERENT 0 10 10 0 0 10 10 10
performance_schema_hosts_sizeDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_cond_classesDIFFERENT 0 150 150 0 0 150 150 150
performance_schema_max_cond_instancesDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_digest_lengthDIFFERENT 0 1024 1024 0 0 1024 1024 1024
performance_schema_max_digest_sample_age 60 60 60 60 60 60 60 60
performance_schema_max_file_classesDIFFERENT 0 80 80 0 0 80 80 80
performance_schema_max_file_handlesDIFFERENT 0 32768 32768 0 0 32768 32768 32768
performance_schema_max_file_instancesDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_index_statDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_logger_classesDIFFERENT N/A N/A N/A N/A N/A N/A N/A 80
performance_schema_max_memory_classesDIFFERENT 0 470 530 0 0 530 530 530
performance_schema_max_metadata_locksDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_meter_classesDIFFERENT 0 30 30 0 0 30 30 30
performance_schema_max_metric_classesDIFFERENT 0 600 600 0 0 600 600 600
performance_schema_max_mutex_classesDIFFERENT 0 350 350 0 0 350 350 350
performance_schema_max_mutex_instancesDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_prepared_statements_instancesDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_program_instancesDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_rwlock_classesDIFFERENT 0 100 100 0 0 100 100 100
performance_schema_max_rwlock_instancesDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_socket_classesDIFFERENT 0 10 10 0 0 10 10 10
performance_schema_max_socket_instancesDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_sql_text_lengthDIFFERENT 0 1024 1024 0 0 1024 1024 1024
performance_schema_max_stage_classesDIFFERENT 0 175 175 0 0 175 175 175
performance_schema_max_statement_classesDIFFERENT 0 220 228 0 0 228 228 228
performance_schema_max_statement_stackDIFFERENT 0 10 10 0 0 10 10 10
performance_schema_max_table_handlesDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_table_instancesDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_table_lock_statDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_max_thread_classesDIFFERENT 0 100 100 0 0 100 100 100
performance_schema_max_thread_instancesDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_session_connect_attrs_sizeDIFFERENT 0 512 512 0 0 512 512 512
performance_schema_setup_actors_sizeDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_setup_objects_sizeDIFFERENT 0 -1 -1 0 0 -1 -1 -1
performance_schema_show_processlist OFF OFF OFF OFF OFF OFF OFF OFF
performance_schema_users_sizeDIFFERENT 0 -1 -1 0 0 -1 -1 -1
persist_only_admin_x509_subject N/A N/A N/A N/A N/A N/A N/A N/A
persist_sensitive_variables_in_plaintext ON ON ON ON ON ON ON ON
persisted_globals_load ON ON ON ON ON ON ON ON
pid_file /tmp/mysql_benchmark.pid /tmp/mysql_benchmark.pid /tmp/mysql_benchmark.pid /tmp/mysql_benchmark.pid /tmp/mysql_benchmark.pid /tmp/mysql_benchmark.pid /tmp/mysql_benchmark.pid /tmp/mysql_benchmark.pid
plugin_dirDIFFERENT /home/bogdan.degtyariov/mysql-nvme/servers/mysql-8.4.8-linux-glibc2.28-x86_64/lib/plugin/ /home/bogdan.degtyariov/mysql-nvme/servers/mysql-8.4.8-linux-glibc2.28-x86_64-patch4-62c9244/lib/plugin/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch4-62c9244/lib/plugin/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/lib/plugin/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/lib/plugin/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch3/lib/plugin/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.8-8-Linux.x86_64.glibc2.34-lru-patch4-62c9244/lib/plugin/ /home/bogdan.degtyariov/mysql-nvme/servers/Percona-Server-8.4.9-9-Linux.x86_64.glibc2.34/lib/plugin/
port 3306 3306 3306 3306 3306 3306 3306 3306
preload_buffer_size 32768 32768 32768 32768 32768 32768 32768 32768
print_identified_with_as_hex OFF OFF OFF OFF OFF OFF OFF OFF
profiling OFF OFF OFF OFF OFF OFF OFF OFF
profiling_history_size 15 15 15 15 15 15 15 15
protocol_compression_algorithms zlib,zstd,uncompressed zlib,zstd,uncompressed zlib,zstd,uncompressed zlib,zstd,uncompressed zlib,zstd,uncompressed zlib,zstd,uncompressed zlib,zstd,uncompressed zlib,zstd,uncompressed
protocol_version 10 10 10 10 10 10 10 10
proxy_protocol_networks N/A N/A N/A N/A N/A N/A N/A N/A
proxy_user N/A N/A N/A N/A N/A N/A N/A N/A
pseudo_replica_mode OFF OFF OFF OFF OFF OFF OFF OFF
pseudo_slave_mode OFF OFF OFF OFF OFF OFF OFF OFF
pseudo_thread_idDIFFERENT 14 14 15 15 15 15 15 15
query_alloc_block_size 8192 8192 8192 8192 8192 8192 8192 8192
query_prealloc_size 8192 8192 8192 8192 8192 8192 8192 8192
rand_seed1 0 0 0 0 0 0 0 0
rand_seed2 0 0 0 0 0 0 0 0
range_alloc_block_size 4096 4096 4096 4096 4096 4096 4096 4096
range_optimizer_max_mem_size 8388608 8388608 8388608 8388608 8388608 8388608 8388608 8388608
rbr_exec_mode STRICT STRICT STRICT STRICT STRICT STRICT STRICT STRICT
read_buffer_size 2097152 2097152 2097152 2097152 2097152 2097152 2097152 2097152
read_only OFF OFF OFF OFF OFF OFF OFF OFF
read_rnd_buffer_size 4194304 4194304 4194304 4194304 4194304 4194304 4194304 4194304
regexp_stack_limit 8000000 8000000 8000000 8000000 8000000 8000000 8000000 8000000
regexp_time_limit 32 32 32 32 32 32 32 32
relay_log beast-node8-relay-bin beast-node8-relay-bin beast-node8-relay-bin beast-node8-relay-bin beast-node8-relay-bin beast-node8-relay-bin beast-node8-relay-bin beast-node8-relay-bin
relay_log_basenameDIFFERENT /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/beast-node8-relay-bin /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/beast-node8-relay-bin /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/beast-node8-relay-bin /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/beast-node8-relay-bin /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/beast-node8-relay-bin /home/bogdan.degtyariov/mysql-nvme/data/percona-server-no-optimization_8.4.8-8_tier12G_threadpool/beast-node8-relay-bin /home/bogdan.degtyariov/mysql-nvme/data/percona-server-optimization_8.4.8-8_tier12G_threadpool/beast-node8-relay-bin /home/bogdan.degtyariov/mysql-nvme/data/percona-server-thread-stat_8.4.9-9_tier12G_threadpool/beast-node8-relay-bin
relay_log_indexDIFFERENT /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/beast-node8-relay-bin.index /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/beast-node8-relay-bin.index /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/beast-node8-relay-bin.index /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/beast-node8-relay-bin.index /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/beast-node8-relay-bin.index /home/bogdan.degtyariov/mysql-nvme/data/percona-server-no-optimization_8.4.8-8_tier12G_threadpool/beast-node8-relay-bin.index /home/bogdan.degtyariov/mysql-nvme/data/percona-server-optimization_8.4.8-8_tier12G_threadpool/beast-node8-relay-bin.index /home/bogdan.degtyariov/mysql-nvme/data/percona-server-thread-stat_8.4.9-9_tier12G_threadpool/beast-node8-relay-bin.index
relay_log_purge ON ON ON ON ON ON ON ON
relay_log_recovery OFF OFF OFF OFF OFF OFF OFF OFF
relay_log_space_limit 0 0 0 0 0 0 0 0
replica_allow_batching ON ON ON ON ON ON ON ON
replica_checkpoint_group 512 512 512 512 512 512 512 512
replica_checkpoint_period 300 300 300 300 300 300 300 300
replica_compressed_protocol OFF OFF OFF OFF OFF OFF OFF OFF
replica_enable_event N/A N/A N/A N/A N/A N/A N/A N/A
replica_exec_mode STRICT STRICT STRICT STRICT STRICT STRICT STRICT STRICT
replica_load_tmpdir /tmp /tmp /tmp /tmp /tmp /tmp /tmp /tmp
replica_max_allowed_packet 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824
replica_net_timeout 60 60 60 60 60 60 60 60
replica_parallel_type LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK
replica_parallel_workers 4 4 4 4 4 4 4 4
replica_pending_jobs_size_max 134217728 134217728 134217728 134217728 134217728 134217728 134217728 134217728
replica_preserve_commit_order ON ON ON ON ON ON ON ON
replica_skip_errors OFF OFF OFF OFF OFF OFF OFF OFF
replica_sql_verify_checksum ON ON ON ON ON ON ON ON
replica_transaction_retries 10 10 10 10 10 10 10 10
replica_type_conversions N/A N/A N/A N/A N/A N/A N/A N/A
replication_optimize_for_static_plugin_config OFF OFF OFF OFF OFF OFF OFF OFF
replication_sender_observe_commit_only OFF OFF OFF OFF OFF OFF OFF OFF
report_host N/A N/A N/A N/A N/A N/A N/A N/A
report_password N/A N/A N/A N/A N/A N/A N/A N/A
report_port 3306 3306 3306 3306 3306 3306 3306 3306
report_user N/A N/A N/A N/A N/A N/A N/A N/A
require_row_format OFF OFF OFF OFF OFF OFF OFF OFF
require_secure_transport OFF OFF OFF OFF OFF OFF OFF OFF
restrict_fk_on_non_standard_key ON ON ON ON ON ON ON ON
resultset_metadata FULL FULL FULL FULL FULL FULL FULL FULL
rpl_read_size 8192 8192 8192 8192 8192 8192 8192 8192
rpl_stop_replica_timeout 31536000 31536000 31536000 31536000 31536000 31536000 31536000 31536000
rpl_stop_slave_timeout 31536000 31536000 31536000 31536000 31536000 31536000 31536000 31536000
schema_definition_cache 256 256 256 256 256 256 256 256
secondary_engine_cost_threshold 100000.000000 100000.000000 100000.000000 100000.000000 100000.000000 100000.000000 100000.000000 100000.000000
secure_file_priv NULL NULL NULL NULL NULL NULL NULL NULL
secure_log_path N/A N/A N/A N/A N/A N/A N/A N/A
select_into_buffer_size 131072 131072 131072 131072 131072 131072 131072 131072
select_into_disk_sync OFF OFF OFF OFF OFF OFF OFF OFF
select_into_disk_sync_delay 0 0 0 0 0 0 0 0
server_id 1 1 1 1 1 1 1 1
server_id_bits 32 32 32 32 32 32 32 32
server_uuidDIFFERENT e4aef67a-49d4-11f1-8425-ac1f6bc846a9 b7d26b56-4de7-11f1-abaf-ac1f6bc846a9 864aad80-4fa9-11f1-be80-ac1f6bc846a9 c9ed7daf-49ea-11f1-a4b8-ac1f6bc846a9 81c5c610-495c-11f1-907a-ac1f6bc846a9 28a2a7f0-5380-11f1-a743-ac1f6bc846a9 260abfc5-5373-11f1-9ff1-ac1f6bc846a9 a7f8b49b-58ca-11f1-8fa0-ac1f6bc846a9
session_track_gtids OFF OFF OFF OFF OFF OFF OFF OFF
session_track_schema ON ON ON ON ON ON ON ON
session_track_state_change OFF OFF OFF OFF OFF OFF OFF OFF
session_track_system_variables time_zone,autocommit,character_set_client,character_set_results,character_set_connection time_zone,autocommit,character_set_client,character_set_results,character_set_connection time_zone,autocommit,character_set_client,character_set_results,character_set_connection time_zone,autocommit,character_set_client,character_set_results,character_set_connection time_zone,autocommit,character_set_client,character_set_results,character_set_connection time_zone,autocommit,character_set_client,character_set_results,character_set_connection time_zone,autocommit,character_set_client,character_set_results,character_set_connection time_zone,autocommit,character_set_client,character_set_results,character_set_connection
session_track_transaction_info OFF OFF OFF OFF OFF OFF OFF OFF
set_operations_buffer_size 262144 262144 262144 262144 262144 262144 262144 262144
sha256_password_auto_generate_rsa_keys ON ON ON ON ON ON ON ON
sha256_password_private_key_path private_key.pem private_key.pem private_key.pem private_key.pem private_key.pem private_key.pem private_key.pem private_key.pem
sha256_password_proxy_users OFF OFF OFF OFF OFF OFF OFF OFF
sha256_password_public_key_path public_key.pem public_key.pem public_key.pem public_key.pem public_key.pem public_key.pem public_key.pem public_key.pem
show_create_table_skip_secondary_engine OFF OFF OFF OFF OFF OFF OFF OFF
show_create_table_verbosity OFF OFF OFF OFF OFF OFF OFF OFF
show_gipk_in_create_table_and_information_schema ON ON ON ON ON ON ON ON
skip_external_locking ON ON ON ON ON ON ON ON
skip_name_resolve ON ON ON ON ON ON ON ON
skip_networking OFF OFF OFF OFF OFF OFF OFF OFF
skip_replica_start OFF OFF OFF OFF OFF OFF OFF OFF
skip_show_database OFF OFF OFF OFF OFF OFF OFF OFF
skip_slave_start OFF OFF OFF OFF OFF OFF OFF OFF
slave_allow_batching ON ON ON ON ON ON ON ON
slave_checkpoint_group 512 512 512 512 512 512 512 512
slave_checkpoint_period 300 300 300 300 300 300 300 300
slave_compressed_protocol OFF OFF OFF OFF OFF OFF OFF OFF
slave_exec_mode STRICT STRICT STRICT STRICT STRICT STRICT STRICT STRICT
slave_load_tmpdir /tmp /tmp /tmp /tmp /tmp /tmp /tmp /tmp
slave_max_allowed_packet 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824 1073741824
slave_net_timeout 60 60 60 60 60 60 60 60
slave_parallel_type LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK LOGICAL_CLOCK
slave_parallel_workers 4 4 4 4 4 4 4 4
slave_pending_jobs_size_max 134217728 134217728 134217728 134217728 134217728 134217728 134217728 134217728
slave_preserve_commit_order ON ON ON ON ON ON ON ON
slave_skip_errors OFF OFF OFF OFF OFF OFF OFF OFF
slave_sql_verify_checksum ON ON ON ON ON ON ON ON
slave_transaction_retries 10 10 10 10 10 10 10 10
slave_type_conversions N/A N/A N/A N/A N/A N/A N/A N/A
slow_launch_time 2 2 2 2 2 2 2 2
slow_query_log ON ON ON ON ON ON ON ON
slow_query_log_always_write_timeDIFFERENT N/A N/A 10.000000 10.000000 10.000000 10.000000 10.000000 10.000000
slow_query_log_fileDIFFERENT /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/slow.log /home/bogdan.degtyariov/mysql-nvme/data/mysql_8.4.8_tier12G/slow.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/slow.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/slow.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server_8.4.8-8_tier12G/slow.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server-no-optimization_8.4.8-8_tier12G_threadpool/slow.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server-optimization_8.4.8-8_tier12G_threadpool/slow.log /home/bogdan.degtyariov/mysql-nvme/data/percona-server-thread-stat_8.4.9-9_tier12G_threadpool/slow.log
slow_query_log_use_global_control N/A N/A N/A N/A N/A N/A N/A N/A
socket /tmp/mysql_benchmark.sock /tmp/mysql_benchmark.sock /tmp/mysql_benchmark.sock /tmp/mysql_benchmark.sock /tmp/mysql_benchmark.sock /tmp/mysql_benchmark.sock /tmp/mysql_benchmark.sock /tmp/mysql_benchmark.sock
sort_buffer_size 4194304 4194304 4194304 4194304 4194304 4194304 4194304 4194304
source_verify_checksum OFF OFF OFF OFF OFF OFF OFF OFF
sql_auto_is_null OFF OFF OFF OFF OFF OFF OFF OFF
sql_big_selects ON ON ON ON ON ON ON ON
sql_buffer_result OFF OFF OFF OFF OFF OFF OFF OFF
sql_generate_invisible_primary_key OFF OFF OFF OFF OFF OFF OFF OFF
sql_log_bin ON ON ON ON ON ON ON ON
sql_log_off OFF OFF OFF OFF OFF OFF OFF OFF
sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
sql_notes ON ON ON ON ON ON ON ON
sql_quote_show_create ON ON ON ON ON ON ON ON
sql_replica_skip_counter 0 0 0 0 0 0 0 0
sql_require_primary_key OFF OFF OFF OFF OFF OFF OFF OFF
sql_safe_updates OFF OFF OFF OFF OFF OFF OFF OFF
sql_select_limit 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
sql_slave_skip_counter 0 0 0 0 0 0 0 0
sql_warnings OFF OFF OFF OFF OFF OFF OFF OFF
ssl_ca ca.pem ca.pem ca.pem ca.pem ca.pem ca.pem ca.pem ca.pem
ssl_capath N/A N/A N/A N/A N/A N/A N/A N/A
ssl_cert server-cert.pem server-cert.pem server-cert.pem server-cert.pem server-cert.pem server-cert.pem server-cert.pem server-cert.pem
ssl_cipher N/A N/A N/A N/A N/A N/A N/A N/A
ssl_crl N/A N/A N/A N/A N/A N/A N/A N/A
ssl_crlpath N/A N/A N/A N/A N/A N/A N/A N/A
ssl_fips_mode OFF OFF OFF OFF OFF OFF OFF OFF
ssl_key server-key.pem server-key.pem server-key.pem server-key.pem server-key.pem server-key.pem server-key.pem server-key.pem
ssl_session_cache_mode ON ON ON ON ON ON ON ON
ssl_session_cache_timeout 300 300 300 300 300 300 300 300
statement_id 26 26 26 26 26 26 26 26
stored_program_cache 256 256 256 256 256 256 256 256
stored_program_definition_cache 256 256 256 256 256 256 256 256
super_read_only OFF OFF OFF OFF OFF OFF OFF OFF
sync_binlog 1 1 1 1 1 1 1 1
sync_master_info 10000 10000 10000 10000 10000 10000 10000 10000
sync_relay_log 10000 10000 10000 10000 10000 10000 10000 10000
sync_relay_log_info 10000 10000 10000 10000 10000 10000 10000 10000
sync_source_info 10000 10000 10000 10000 10000 10000 10000 10000
system_time_zone UTC UTC UTC UTC UTC UTC UTC UTC
table_definition_cache 65536 65536 65536 65536 65536 65536 65536 65536
table_encryption_privilege_check OFF OFF OFF OFF OFF OFF OFF OFF
table_open_cache 65536 65536 65536 65536 65536 65536 65536 65536
table_open_cache_instances 64 64 64 64 64 64 64 64
table_open_cache_triggersDIFFERENT N/A N/A 524288 524288 524288 524288 524288 524288
tablespace_definition_cache 256 256 256 256 256 256 256 256
temptable_max_mmap 0 0 0 0 0 0 0 0
temptable_max_ram 4294967296 4294967296 4294967296 4294967296 4294967296 4294967296 4294967296 4294967296
temptable_use_mmap OFF OFF OFF OFF OFF OFF OFF OFF
terminology_use_previous NONE NONE NONE NONE NONE NONE NONE NONE
tf_sequence_table_max_upper_boundDIFFERENT N/A N/A 1048576 1048576 1048576 1048576 1048576 1048576
thread_cache_size 256 256 256 256 256 256 256 256
thread_handlingDIFFERENT one-thread-per-connection one-thread-per-connection one-thread-per-connection one-thread-per-connection one-thread-per-connection pool-of-threads pool-of-threads pool-of-threads
thread_pool_high_prio_modeDIFFERENT N/A N/A transactions transactions transactions transactions transactions transactions
thread_pool_high_prio_ticketsDIFFERENT N/A N/A 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295
thread_pool_idle_timeoutDIFFERENT N/A N/A 60 60 60 60 60 60
thread_pool_max_threadsDIFFERENT N/A N/A 100000 100000 100000 2000 2000 2000
thread_pool_oversubscribeDIFFERENT N/A N/A 3 3 3 3 3 3
thread_pool_sizeDIFFERENT N/A N/A 80 80 80 80 80 80
thread_pool_stall_limitDIFFERENT N/A N/A 500 500 500 500 500 500
thread_stack 524288 524288 524288 524288 524288 524288 524288 524288
thread_statisticsDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
time_zone SYSTEM SYSTEM SYSTEM SYSTEM SYSTEM SYSTEM SYSTEM SYSTEM
timestampDIFFERENT 1778131437.242012 1778579327.171964 1778772517.675376 1778140842.491603 1778079731.888247 1779194555.838603 1779188968.040655 1779776308.023003
tls_certificates_enforced_validation OFF OFF OFF OFF OFF OFF OFF OFF
tls_ciphersuites N/A N/A N/A N/A N/A N/A N/A N/A
tls_version TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3 TLSv1.2,TLSv1.3
tmp_table_size 268435456 268435456 268435456 268435456 268435456 268435456 268435456 268435456
tmpdir /tmp /tmp /tmp /tmp /tmp /tmp /tmp /tmp
transaction_alloc_block_size 8192 8192 8192 8192 8192 8192 8192 8192
transaction_allow_batching OFF OFF OFF OFF OFF OFF OFF OFF
transaction_isolation REPEATABLE-READ REPEATABLE-READ REPEATABLE-READ REPEATABLE-READ REPEATABLE-READ REPEATABLE-READ REPEATABLE-READ REPEATABLE-READ
transaction_prealloc_size 4096 4096 4096 4096 4096 4096 4096 4096
transaction_read_only OFF OFF OFF OFF OFF OFF OFF OFF
unique_checks ON ON ON ON ON ON ON ON
updatable_views_with_limit YES YES YES YES YES YES YES YES
use_secondary_engine ON ON ON ON ON ON ON ON
userstatDIFFERENT N/A N/A OFF OFF OFF OFF OFF OFF
versionDIFFERENT 8.4.8 8.4.8 8.4.8-8 8.4.8-8 8.4.8-8 8.4.8-8 8.4.8-8 8.4.9-9
version_commentDIFFERENT MySQL Community Server - GPL MySQL Community Server (GPL), Release , Revision e8e314a9 Percona Server (GPL), Release 8, Revision 1c288264 Percona Server (GPL), Release 8, Revision 1c288264 Percona Server (GPL), Release 8, Revision 1c288264 Percona Server (GPL), Release 8, Revision 1c288264 Percona Server (GPL), Release 8, Revision 1c288264 Percona Server (GPL), Release 9, Revision 627bc2ec
version_compile_machine x86_64 x86_64 x86_64 x86_64 x86_64 x86_64 x86_64 x86_64
version_compile_os Linux Linux Linux Linux Linux Linux Linux Linux
version_compile_zlibDIFFERENT 1.3.1 1.3.1 1.3.1 1.3.1 1.3.1 1.3.1 1.3.1 1.3.2
version_suffix N/A N/A N/A N/A N/A N/A N/A N/A
wait_timeout 300 300 300 300 300 300 300 300
warning_count 0 0 0 0 0 0 0 0
windowing_use_high_precision ON ON ON ON ON ON ON ON
xa_detach_on_prepare ON ON ON ON ON ON ON ON