Skip to main content
Question

Flush Binary Logs Every setting

  • April 8, 2013
  • 1 reply
  • 7 views

Forum|alt.badge.img+11

I'm curious as to what frequency others are using for this setting, one week, two, one month, etc..

And what does that exactly flush? all logs for all devices?

1 reply

Forum|alt.badge.img+10
  • Contributor
  • April 8, 2013

I think this will answer your question.

http://dev.mysql.com/doc/refman/5.5/en/binary-log.html

As for how long, that depends for each environment and how they're setting up replication, high availability, or if they're doing it at all. For those who are using a single JSS server with MySQL on the same box and have no plans to replicate the database, you may not even need to have binary logging turned on.