Insights mysql5 and mysql8 binlog variables

[dyrnq]

binlog_cache_size=32768                                         binlog_cache_size=32768
binlog_checksum=CRC32                                           binlog_checksum=CRC32
binlog_direct_non_transactional_updates=OFF                     binlog_direct_non_transactional_updates=OFF
                                                              > binlog_encryption=OFF
binlog_error_action=ABORT_SERVER                                binlog_error_action=ABORT_SERVER
                                                              > binlog_expire_logs_auto_purge=ON
                                                              > binlog_expire_logs_seconds=2592000
binlog_format=ROW                                               binlog_format=ROW
binlog_group_commit_sync_delay=0                                binlog_group_commit_sync_delay=0
binlog_group_commit_sync_no_delay_count=0                       binlog_group_commit_sync_no_delay_count=0
binlog_gtid_simple_recovery=ON                                  binlog_gtid_simple_recovery=ON
binlog_max_flush_queue_time=0                                   binlog_max_flush_queue_time=0
binlog_order_commits=ON                                         binlog_order_commits=ON
                                                              > binlog_rotate_encryption_master_key_at_startup=OFF
                                                              > binlog_row_event_max_size=8192
binlog_row_image=FULL                                           binlog_row_image=FULL
                                                              > binlog_row_metadata=FULL
                                                              > binlog_row_value_options=
binlog_rows_query_log_events=OFF                                binlog_rows_query_log_events=OFF
binlog_stmt_cache_size=32768                                    binlog_stmt_cache_size=32768
                                                              > binlog_transaction_compression=OFF
                                                              > binlog_transaction_compression_level_zstd=3
binlog_transaction_dependency_history_size=25000                binlog_transaction_dependency_history_size=25000
binlog_transaction_dependency_tracking=COMMIT_ORDER             binlog_transaction_dependency_tracking=COMMIT_ORDER
innodb_api_enable_binlog=OFF                                    innodb_api_enable_binlog=OFF
innodb_locks_unsafe_for_binlog=OFF                            <
log_bin=ON                                                      log_bin=ON
log_bin_basename=/bitnami/mysql/data/mysql-bin                  log_bin_basename=/bitnami/mysql/data/mysql-bin
log_bin_index=/bitnami/mysql/data/mysql-bin.index               log_bin_index=/bitnami/mysql/data/mysql-bin.index
log_bin_trust_function_creators=OFF                             log_bin_trust_function_creators=OFF
log_bin_use_v1_row_events=OFF                                   log_bin_use_v1_row_events=OFF
log_statements_unsafe_for_binlog=ON                             log_statements_unsafe_for_binlog=ON
max_binlog_cache_size=18446744073709547520                      max_binlog_cache_size=18446744073709547520
max_binlog_size=1073741824                                      max_binlog_size=1073741824
max_binlog_stmt_cache_size=18446744073709547520                 max_binlog_stmt_cache_size=18446744073709547520
sync_binlog=1                                                   sync_binlog=1

[dyrnq]

binlog_cache_size=32768                                         binlog_cache_size=32768
binlog_checksum=CRC32                                           binlog_checksum=CRC32
binlog_direct_non_transactional_updates=OFF                     binlog_direct_non_transactional_updates=OFF
binlog_encryption=OFF                                           binlog_encryption=OFF
binlog_error_action=ABORT_SERVER                                binlog_error_action=ABORT_SERVER
binlog_expire_logs_auto_purge=ON                              <
binlog_expire_logs_seconds=2592000                              binlog_expire_logs_seconds=2592000
binlog_format=ROW                                               binlog_format=ROW
binlog_group_commit_sync_delay=0                                binlog_group_commit_sync_delay=0
binlog_group_commit_sync_no_delay_count=0                       binlog_group_commit_sync_no_delay_count=0
binlog_gtid_simple_recovery=ON                                  binlog_gtid_simple_recovery=ON
binlog_max_flush_queue_time=0                                   binlog_max_flush_queue_time=0
binlog_order_commits=ON                                         binlog_order_commits=ON
binlog_rotate_encryption_master_key_at_startup=OFF              binlog_rotate_encryption_master_key_at_startup=OFF
binlog_row_event_max_size=8192                                  binlog_row_event_max_size=8192
binlog_row_image=FULL                                           binlog_row_image=FULL
binlog_row_metadata=FULL                                      | binlog_row_metadata=MINIMAL
binlog_row_value_options=                                       binlog_row_value_options=
binlog_rows_query_log_events=OFF                                binlog_rows_query_log_events=OFF
binlog_stmt_cache_size=32768                                    binlog_stmt_cache_size=32768
binlog_transaction_compression=OFF                              binlog_transaction_compression=OFF
binlog_transaction_compression_level_zstd=3                     binlog_transaction_compression_level_zstd=3
binlog_transaction_dependency_history_size=25000                binlog_transaction_dependency_history_size=25000
binlog_transaction_dependency_tracking=COMMIT_ORDER             binlog_transaction_dependency_tracking=COMMIT_ORDER
innodb_api_enable_binlog=OFF                                    innodb_api_enable_binlog=OFF
log_bin=ON                                                      log_bin=ON
log_bin_basename=/bitnami/mysql/data/mysql-bin                | log_bin_basename=/var/lib/mysql/binlog
log_bin_index=/bitnami/mysql/data/mysql-bin.index             | log_bin_index=/var/lib/mysql/binlog.index
log_bin_trust_function_creators=OFF                             log_bin_trust_function_creators=OFF
log_bin_use_v1_row_events=OFF                                   log_bin_use_v1_row_events=OFF
log_statements_unsafe_for_binlog=ON                             log_statements_unsafe_for_binlog=ON
max_binlog_cache_size=18446744073709547520                      max_binlog_cache_size=18446744073709547520
max_binlog_size=1073741824                                      max_binlog_size=1073741824
max_binlog_stmt_cache_size=18446744073709547520                 max_binlog_stmt_cache_size=18446744073709547520
                                                              > sql_log_bin=ON
sync_binlog=1                                                   sync_binlog=1

bitnami vs mysql

[dyrnq]

• 在 MySQL 5.7 及之前版本中，使用的是 expire_logs_days 参数，该参数以天为单位来控制日志过期。
• 从 MySQL 8 开始，expire_logs_days 被弃用，取而代之的是 binlog_expire_logs_seconds，提供了更精确的秒级控制。