Coming from a SQL Server shop, I now work with MySQL and I was curious.
What are the differences between MySQL's binary log and MSSQL's transaction log?
By the outlook thus far, it seems that there is only one binary log per MySQL instance as opposed to a transaction log per database as in MSSQL.
Best Answer
Answering only the MySQL Part of the Question
A binary log records completed SQL statements. You can have many binary logs. Under default settings, binary logs rotate at the 1G mark (see expire_logs_days and max_binlog_size).
You can see binary logs by running one of the following:
Ther current master log is always the last one in the list. To see just the last binary log, which is the current one, run this:
When it comes to InnoDB storage engine and transactions