# 节点状态
show master status \G;
# 检查binlog
show variables like 'log_bin';
# binlog事件
show binlog events;
# show + set
show variables like '%skip_name_resolve%';
set global skip_name_resolve=0;
# 查看链接数
show variables like '%max_connections%';
# 设置链接数
set GLOBAL max_connections=5500;
# 清理binlog
purge binary logs to 'mysql-bin.000007';
SQL
Comments are closed, but trackbacks and pingbacks are open.