Posted on 04-08-2013 07:33 AM
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?
Posted on 04-08-2013 07:50 AM
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.