dosubot[bot] commented on issue #8046: URL: https://github.com/apache/incubator-devlake/issues/8046#issuecomment-2347994310
<!-- Answer --> No, deleting binary files that are only a few MB in size will not significantly help create free space in the database. The rapid increase in MySQL disk consumption is primarily caused by the large size of the binary logs generated after each data collection cycle. To manage disk space effectively, you should consider purging old binary logs or setting up automated purging. For example, you can purge old binary logs with the following command: ```sql PURGE BINARY LOGS BEFORE '2023-03-22 15:30:00'; ``` Or set up automated purging by configuring the `expire_logs_days` global variable: ```sql SET GLOBAL expire_logs_days = 1; ``` This approach will help manage the disk space more effectively <sup>[[1]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.18/Troubleshooting/MySqlSizeIssue.md)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
