Re: 回复: mysql transaction log

MySQL does not have a thing such the Oracle transaction log.
But it has the Binary Log used by replication,
for this reason the binary log is server level and it is "decoupled"
from the storage engine concept.
Basically (if we consider the old good "statement" format) it is just a
file with commands that were executed on the master,
and then they are passed to the slaves, if any.
If you have the "binlog" option enabled on your server (this is the only
requirement for a server to work as a 'master')
you will have a set of log files (in binary format for compression
basically) that will contain all statement executed on the server
that changed data, this means no "select" statements.
It is quite easy to imagine that if you have this logging enabled from
the birth of the server keeping all binary logs will allow you to
'replay' logs on another server and rebuild the same situation.
To read the content of the binary logs MySQL provides the utility
[mysqlbinlog].

Just a splash on binary logging!

Read also on MySQL manual, it is a good exercise.

Cheers,

Claudio

On 5/4/2010 8:58 AM, Timo wrote:
> InnoDB support transaction. MyISAM does not support trantsaction.
>
> http://www.databasejournal.com/features/mysql/article.php/33 82171/Transactions-in-MySQL.htm
>
> 2010-05-04
>
>
>
> Best regards
> Timo Seven
> blog: http://zauc.wordpress.com
> #####请翻墙浏览，或者指定hosts到74.200.243.252### ####
> twitter: https://twitter.com/zauc
> ######也请翻墙浏览####################
> UNIX System Admin& MySQL DBA
>
>
>
> 发件人: Angelina Paul
> 发送时间: 2010-05-04 06:20
> 主 题: mysql transaction log
> 收件人: mysql@lists.mysql.com
>
>
>
> Please help me to understand more about the mysql transaction log (
> mysqlbinlog) file and its contents. Will it support only the innodb or all
> the storage engine types like MyISAM, InnoDB?
>
> Thanks,
>
> Arsh Paul




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

回复: mysql transaction log

--====003__MESSAGE__ID__54yg6f6h6y456345====
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

SW5ub0RCIHN1cHBvcnQgdHJhbnNhY3Rpb24uIE15SVNBTSBkb2VzIG5vdCBz dXBwb3J0IHRyYW50c2Fj
dGlvbi4NCg0KaHR0cDovL3d3dy5kYXRhYmFzZWpvdXJuYWwuY29tL2ZlYXR1 cmVzL215c3FsL2FydGlj
bGUucGhwLzMzODIxNzEvVHJhbnNhY3Rpb25zLWluLU15U1FMLmh0bSAgDQoN CjIwMTAtMDUtMDQNCg0K
DQoNCkJlc3QgcmVnYXJkcw0KVGltbyBTZXZlbg0KYmxvZzogaHR0cDovL3ph dWMud29yZHByZXNzLmNv
bQ0KIyMjIyPor7fnv7vlopnmtY/op4jvvIzmiJbogIXmjIflrppob3N0c+WI sDc0LjIwMC4yNDMuMjUy
IyMjIyMjIw0KdHdpdHRlcjogaHR0cHM6Ly90d2l0dGVyLmNvbS96YXVjDQoj IyMjIyPkuZ/or7fnv7vl
opnmtY/op4gjIyMjIyMjIyMjIyMjIyMjIyMjIw0KVU5JWCBTeXN0ZW0gQWRt aW4gJiBNeVNRTCBEQkEN
Cg0KDQoNCuWPkeS7tuS6ujogQW5nZWxpbmEgUGF1bCA8YXJzaHVwYXVsQGdt YWlsLmNvbT4NCuWPkemA
geaXtumXtDogMjAxMC0wNS0wNCAwNjoyMA0K5Li7IOmimDogbXlzcWwgdHJh bnNhY3Rpb24gbG9nDQrm
lLbku7bkuro6IG15c3FsQGxpc3RzLm15c3FsLmNvbQ0KDQoNCg0KUGxlYXNl IGhlbHAgbWUgdG8gdW5k
ZXJzdGFuZCBtb3JlIGFib3V0IHRoZSBteXNxbCB0cmFuc2FjdGlvbiBsb2cg KCANCm15c3FsYmlubG9n
KSBmaWxlIGFuZCBpdHMgY29udGVudHMuIFdpbGwgaXQgc3VwcG9ydCBvbmx5 IHRoZSBpbm5vZGIgb3Ig
YWxsIA0KdGhlIHN0b3JhZ2UgZW5naW5lIHR5cGVzIGxpa2UgTXlJU0FNLCBJ bm5vREI/IA0KDQpUaGFu
a3MsIA0KDQpBcnNoIFBhdWwg

--====003__MESSAGE__ID__54yg6f6h6y456345====--