dosubot[bot] commented on issue #8046:
URL:
https://github.com/apache/incubator-devlake/issues/8046#issuecomment-2347988551
<!-- Answer -->
The size of binary logs can rapidly increase due to the large size of the
binary logs generated after each data collection cycle in DevLake.
To purge old binary logs, follow these steps:
1. **Connect to your MySQL server** using the MySQL client or any other
database management tool such as PhpMyAdmin, MySQL Workbench, etc.
2. **Check the current status of your binary log files**:
```sql
SHOW BINARY LOGS;
```
This will display a list of all the binary log files that are currently
available on your MySQL server.
3. **Determine the last binary log file that you want to keep**. This is the
file that you want to retain for any future point-in-time recovery or
replication purposes.
4. **Purge all binary logs that are older than the binary log file that you
want to retain**:
```sql
PURGE BINARY LOGS BEFORE 'DATE';
```
Replace `DATE` with the specific date and time up to which you want to
purge the binary logs, formatted as 'YYYY-MM-DD hh:mm:ss'. For example:
```sql
PURGE BINARY LOGS BEFORE '2023-03-22 15:30:00';
```
5. **Verify the purge was successful** by running the `SHOW BINARY LOGS;`
command again.
### Automating the Purge of Old Binary Logs
1. **Set the `expire_logs_days` global variable** to the number of days that
you want to keep binary logs for:
```sql
SET GLOBAL expire_logs_days = 1;
```
### Skipping Binary Logs
1. **Set the `skip-log-bin` configuration option** directly in the
`docker-compose.yaml` file:
```yaml
services:
mysql:
image: mysql:8
volumes:
- mysql-storage:/var/lib/mysql
restart: always
ports:
- "127.0.0.1:3306:3306"
environment:
MYSQL_ROOT_PASSWORD: admin
MYSQL_DATABASE: lake
MYSQL_USER: merico
MYSQL_PASSWORD: merico
command:
--character-set-server=utf8mb4
--collation-server=utf8mb4_bin
--skip-log-bin
```
2. **Restart the MySQL container**:
```bash
docker-compose restart mysql
```
These steps will help you manage the size of binary logs effectively
<sup>[[1]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.18/Troubleshooting/MySqlSizeIssue.md)</sup><sup>[[2]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.17/Troubleshooting/MySqlSizeIssue.md)</sup><sup>[[3]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.19/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: dev-unsubscr...@devlake.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
