Behavior:
Starting with DocuWare Version 7.6 we also support MySQL version 8. Due to a software bug, we currently only support up to version 8.0.28.
Additional details can be found here: Systemrequirements & MySQL Bug
Starting with MySQL 8, the feature binary logging was introduced. In rare cases, DocuWare Support was able to observe that the binary logging grows in storage size and can cause problems.
Starting with DocuWare Version 7.10, the retention of binary logs for the ‘internal database’ has been adjusted to 7 days. This only applies to new installations.
Systems that are updated to DocuWare 7.10 must be adjusted manually!
All ‘external’ MySQL databases must maintain and adjust this setting themselves.
Starting with DocuWare Version 7.6 we also support MySQL version 8. Due to a software bug, we currently only support up to version 8.0.28.
Additional details can be found here: Systemrequirements & MySQL Bug
Starting with MySQL 8, the feature binary logging was introduced. In rare cases, DocuWare Support was able to observe that the binary logging grows in storage size and can cause problems.
Starting with DocuWare Version 7.10, the retention of binary logs for the ‘internal database’ has been adjusted to 7 days. This only applies to new installations.
Systems that are updated to DocuWare 7.10 must be adjusted manually!
All ‘external’ MySQL databases must maintain and adjust this setting themselves.
Solution:
Please keep in mind, that DocuWare Support can only assist with limited know-how on database maintenance. Find some advice here: /knowledgebase/article/KBA-36576
/msdyn_blobfile/$value)
Under no circumstances delete the created files directly on the drive!
This will cause the MySQL database to no longer be operational. Thus, DocuWare will not be usable.
To clear the data, use the correct command provided by the database. Purge Binary Logs
After removing the binary logs with the above command, please follow the steps below to apply a lasting solution.
Please keep in mind, that DocuWare Support can only assist with limited know-how on database maintenance. Find some advice here: /knowledgebase/article/KBA-36576
Under no circumstances delete the created files directly on the drive!
This will cause the MySQL database to no longer be operational. Thus, DocuWare will not be usable.
To clear the data, use the correct command provided by the database. Purge Binary Logs
After removing the binary logs with the above command, please follow the steps below to apply a lasting solution.
- Navigate to the installation folder of your MySQL database
- If you are using the “internal Database” you will find it in the default path, e.g. "C:\Program Files\DocuWare\Internal Database V3"
- Modify the available "my.ini" file by adding the key binlog_expire_logs_seconds
- Specify a value in seconds for storing the binary logs (default 30 days)
- A shorter value will limit the number of files created and hence reducing the required storage space
- Restart the MySQL database after applying the change in the "my.ini" file
In the below screenshot, the value has been reduced to 7 days. The calculation of the value can be found here: binlog_expire_logs_seconds
Additional information on this database feature can be found here: