27 lines
831 B
INI
27 lines
831 B
INI
[client]
|
|
default-character-set = utf8mb4
|
|
|
|
[mysql]
|
|
default-character-set = utf8mb4
|
|
|
|
[mysqld]
|
|
character-set-server = utf8mb4
|
|
collation-server = utf8mb4_unicode_ci
|
|
init-connect = 'SET NAMES utf8mb4'
|
|
|
|
# 生产慢查询观测：应用日志记录 SQL 形状，MySQL 原生日志记录超过阈值的语句。
|
|
# performance_schema 默认开启，使用 events_statements_summary_by_digest 做聚合分析。
|
|
slow_query_log = ON
|
|
long_query_time = 0.5
|
|
log_slow_admin_statements = ON
|
|
|
|
# 时间点恢复基础：binlog 由 scripts/archive-binlog.sh 每分钟归档到 OSS 备份桶。
|
|
# 本地按 7 天自动过期，归档与本地保留策略见 scripts/backup-online.sh。
|
|
server-id = 1
|
|
log_bin = mysql-bin
|
|
binlog_format = ROW
|
|
binlog_row_image = FULL
|
|
binlog_expire_logs_seconds = 604800
|
|
sync_binlog = 1
|
|
innodb_flush_log_at_trx_commit = 1
|