【MySQL】杂项

查看事务隔离级别

SELECT @@tx_isolation;

设置事务隔离级别

//设置read uncommitted级别：
set session transaction isolation level read uncommitted;
//设置read committed级别：
set session transaction isolation level read committed;
//设置repeatable read级别：
set session transaction isolation level repeatable read;
//设置serializable级别：
set session transaction isolation level serializable;

binlog三种格式，分别为Statement,MiXED,以及ROW！

查看bin_log相关的信息

show variables like '%bin_log%';

查看binlog

mysqlbinlog --no-defaults -v -v --base64-output=decode-rows mysql-bin.000003 >cc.log

配置写死

transaction-isolation = READ-COMMITTED

binlog日志格式

binlog_format = row // 通过命令行修改 SET GLOBAL binlog_format = 'ROW';

binlog 日志目录

log-bin = /Users/abs/workspace/abs/logs/mysql-bin.log
expire-logs-days = 14
max-binlog-size = 500M
server-id = 1