本文共 880 字，大约阅读时间需要 2 分钟。

第五章：Transactions

• Performing transactions
• Using savepoints
• Isolation levels
• Locking

Transactions should also satisfy Atomicity, Consistency, Isolation, and Durability(ACID) properties.

InnoDB , the default storage engine in MySQL, supports transactions whereas MyISAM does not support them.

第六章：Binary Logging

• Using binary logging
• Binary log format
• Extracting statements from a binary log
• Ignoring databases to write to a binary log
• Relocating binary logs

The binary log is not used for statements such as SELECT or SHOW that do not modify data

Using binary logging

使用binlog介绍

一：修改binlog日志位置

1.查询binlog位置show variables like 'log_%';

2.关闭mysql连接：systemctl stop mysqld

#vi /etc/my.cnf        [mysqld]        log_bin=/var/lib/mysql/binlogs/web1-bin

4.启动mysql连接：systemctl start mysqld

show variables like 'log_%';

转载地址：http://otaii.baihongyu.com/