I think you've got it a little wrong. In MySQL, transaction log is different from bin-log. Transaction logs are used only for Innodb while bin-logs are optional and capture data related to all the storage engines. I believe, you cannot read thru the transaction logs and these logs files (used in cyclic fashion) are only for the purpose of Instance recovery other than providing transaction support. Bin logs, on the other hand are used mainly for two purposes - replication and PTR (point-in-time recovery). A small utility called mysqlbinlog can read through the bin logs and generate SQL file which is very handy if you need to take up PTR or just want to verify any details.
Hope that helps! Regards, Nitin ----- Original Message ---- From: Angelina Paul <[email protected]> To: [email protected] Sent: Tue, May 4, 2010 3:49:35 AM Subject: mysql transaction log 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/[email protected]
