第五章: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.
InnoDB 支持事务,但是MyASIM引擎不支持事务
第六章: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介绍
https://www.cnblogs.com/yanh0606/p/8213667.html
一:修改binlog日志位置
1.查询binlog位置show variables like 'log_%';
2.关闭mysql连接:systemctl stop mysqld
3.修改mysql binlog日志位置:
#vi /etc/my.cnf
[mysqld]
log_bin=/var/lib/mysql/binlogs/web1-bin
4.启动mysql连接:systemctl start mysqld
show variables like 'log_%';