本文共 880 字,大约阅读时间需要 2 分钟。
第五章:Transactions
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
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/