MySQL Binary Logging

MySQL 8.0.35 has binary logging enabled by default. Binary logging logs all statements that change data (such as INSERT, UPDATE, DELETE) as well as data definition statements (like CREATE, ALTER).

Please check that your MySQL initialization file, my.ini (located in the MySQL installation directory, typically C:\mysql\), includes the following line:

binlog_expire_logs_seconds=604800

Image

This has been corrected in the latest service packs of maintained versions and we recommend ensuring that you're on the latest version.

This line will automatically delete binary logs that are older than 7 days, which is the official recommendation from Trimble. However, in some cases, 7 days of binary logging can consume significant hard drive space. You may need to adjust this number to better fit your environment's needs.