select version();# mysql version (8.0)
show master logs;# master binlog
show master status;# master 状态
show global variables like '%log_bin%';# binlog 是否开启
show global variables like 'log_bin_basename';# binlog 地址
show global variables like 'max_binlog_size';# binlog 最大单文件大小 (默认1G)
show global variables like 'binlog_format';# binlog 格式(STATEMENT, ROW, MIXED), 默认ROW
show global variables like 'binlog_expire_logs_seconds'# binlog 过期时间 (默认30天)
show global variables like 'expire_logs_days'# binlog 过期时间 (mysql 8.0 已废弃, 改用 binlog_expire_logs_seconds)
1. 查看配置信息select version(); # mysql version (8.0)show master logs; # master binlogshow master status; # master 状态show global variables like '%log_bin%'; # binlog 是否开启show global variables like 'log_bin