- 博客(3)
- 收藏
- 关注
原创 innodb related options
innodb_fast_shutdownDefault value: 1Valid value:0: InnoDB does a full purge and an insert buffer merge before a shutdown. These operations can take minutes, or even hours in extreme cases.1: InnoDB skips these operations at shutdown.2: InnoDB will just flu
2010-07-29 00:01:00 811
原创 Innodb Multi version(undo logs)
<br />Undo logs:<br /> <br />Undo logs in the rollback segment are divided into insert and update undo logs. <br />Insert undo logs are needed only in transaction rollback and can be discarded as soon as the transaction commits .
2010-07-28 16:15:00 708
原创 innodb_locks_unsafe_for_binlog && transaction isolation level
<br />innodb_locks_unsafe_for_binlog<br /> <br />ON => Record Locks (Read commited;Phantom read)<br />OFF => Next-key Locks (Repeatable read;avoid phantom read)<br /> <br /> Command-Line Format--innodb_locks_unsafe_for_binlogConfig-File Form
2010-07-27 20:17:00 1347
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人