mysql命令

1 讲mysqlbinlog二进制日志转为可读

mysqlbinlog -v --base64-output=decode-rows /var/lib/mysql/mysql-bin.000086 \
--start-datetime='2022-05-27 00:00:00'  \
--stop-datetime='2022-05-28 00:00:00'   \
>./row.log

-- 查看详细的binlog
show binlog events;

-- 查看所有的binlog
show binary logs;

-- 查看binlog开启状态
show variables like 'log_%';

-- 滚动binlog日志
flush logs;

-- 查看自己本身最新的binlog位置
show master status;

-- 查看需要同步的节点的binlog位置
show slave status\G

-- 停止所有binlog同步
    stop slave;

-- 临时设置最大连接数
show variables like '%max_connections%';
set GLOBAL max_connections = 1024;
show variables like '%max_connections%';