如何刷新二进制日志

Question

I read a comment on another post that InnoDB can be optimized for speed by not flushing binary logs on every commit.

This is the first time I hear about this, so what are these binary logs and what's this flushing all about? Why should I do it (and when not to do it) and how?

Answer 1

MySQL's binary log acts as the database equivalent the journal in a journaling file system. Every query gets logged in it, so that if the DB crashes at some point, you can "replay" the binary log and rebuild the DB with minimal pain. It's also used in replication.

More details here: http://dev.mysql.com/doc/refman/5.1/en/binary-log.html