T******r
发帖数: 861 | 1 我记得commit了才写到transcation log，然后checkpoint写到data file。对嘛？ |
c*****d
发帖数: 6045 | 2 我也是这么记的commit了才写到transcation log |
y****w
发帖数: 3747 | 3 应该要写的，不然对大uow太残忍了。 懂sql的来说说。
db2要写。
【在 c*****d 的大作中提到】
: 我也是这么记的commit了才写到transcation log
|
t****n
发帖数: 263 | 4 Of course uncommitted transaction should be written to the log. Otherwise,
how can it be rolled back if anything bad happens before it being committed.
A checkpoint writes dirty pages to disks. It doesn't give a shit to if the
transaction is committed or not.
【在 T******r 的大作中提到】
: 我记得commit了才写到transcation log，然后checkpoint写到data file。对嘛？
|
s**********o
发帖数: 14359 | 5 好像是写的，比如删除100B的记录，没删完之前LOG就开始增长了。 |
T******r
发帖数: 861 | 6 确实是写的
找到这么一段话
a log record may contain details of either a closed (committed) transaction
or an open (uncommitted) transaction, and in each case the data modified by
the transaction may or may not have been written to the data files,
depending on whether or not a checkpoint has occurred.
【在 s**********o 的大作中提到】
: 好像是写的，比如删除100B的记录，没删完之前LOG就开始增长了。
|
