mysql不常用命令备忘录

# 节点状态
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';

Comments are closed, but trackbacks and pingbacks are open.