You want to log only the changes made to the database objects and data on the MySQL system. Which log will do this by default?

Question

Options

• Ageneral query log
• Baudit log
• Cslow query log
• Dbinary log
• Eerror log

• A
  4% (2)
• C
  2% (1)
• D
  92% (47)
• E
  2% (1)

Explanation

The binary log records all DDL and DML statements that modify database objects or data (CREATE, ALTER, INSERT, UPDATE, DELETE, etc.), making it the go-to log for tracking changes - it's also the backbone of MySQL replication and point-in-time recovery. The general query log (A) logs every query sent to the server, including reads like SELECT, so it captures far more than just changes. The audit log (B) is an enterprise plugin focused on security/compliance auditing and is not enabled by default. The slow query log (C) captures queries exceeding a time threshold - it's about performance, not changes. The error log (E) records startup/shutdown events and errors, not data modifications.

Memory tip: Think "binary = binds changes" - the binary log is what MySQL uses to replay changes during replication, so by definition it only contains change events, not reads.

No community discussion yet for this question.