MySQL Binary Logging

Tekla PowerFab
2024i
Tekla PowerFab Tekla PowerFab GO
2024
Tekla PowerFab Tekla PowerFab GO
2023i
Tekla PowerFab Tekla PowerFab GO
2023
Tekla PowerFab Tekla PowerFab GO
2022i
Tekla PowerFab Tekla PowerFab GO
2022
Tekla PowerFab Tekla PowerFab GO
binlog
MySQL
C:\mysql
binary
Logging
8.0.35
Drive Filling Up

MySQL 8.0.35 has binary logging enabled by default. Binary logging logs all statements that change data (such as INSERTUPDATEDELETE) as well as data definition statements (like CREATEALTER).

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
binlog_expire_logs_seconds

 

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.

Note:
You can save changes to the my.ini file at any time, but the changes will not take effect until the MySQL service has been stopped and started again.

 

Fanden Sie das hilfreich?