Binary log format

Controls how changes are recorded in the binary logs. Row based logs the actual row changes, which is the most reliable format and is required for point-in-time recovery of individual databases. Statement based logs the SQL statements that were executed, and Mixed switches between the two automatically.

Row based logging is recommended, as statement and mixed logs cannot be safely filtered by database when replaying transactions.