Size Of Binary Logs

• mysqld appends a numeric extension to the binary log basename.
  • The number increases each time the server creates a new log file.
    • Thus creating an ordered series of files.

• The server creates a new binary log file each time it starts or flushes the logs.

• The server also creates a new binary log file automatically when the current log's size reaches max_binlog_size.
  • A binary log file may become larger than max_binlog_size if large transactions are used because a transaction is written to the file in one piece, never split between files.

What does the slow query log contain?

---

---

© 2007 John Michael Pierobon

Notes