Created
September 9, 2022 23:31
-
-
Save m4tlch/23714e89f26d88e1acae2d7d999e46a8 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
https://askubuntu.com/a/1390848 | |
With MySQL8, they have turned on binary logging by default and the default purge (expiry/deletion) of binary logs is set to 30days. | |
Once you are in your SSH and in mysql, you can use the below commands | |
To show binary logs | |
mysql> SHOW BINARY LOGS; | |
To Purge binary logs manually until some point | |
mysql> PURGE BINARY LOGS TO 'binlog.000142'; | |
Change automatic default purge expiry from 30days (deafault) to 3days | |
mysql> SET GLOBAL binlog_expire_logs_seconds = (60*60*24*3); | |
Query OK, 0 rows affected (0.00 sec) | |
mysql> SET PERSIST binlog_expire_logs_seconds = (60*60*24*3); | |
Query OK, 0 rows affected (0.01 sec) | |
The above value is in seconds, i.e. 3 days in seconds = (60 seconds x 60 minutes x 24 hours x 3 days) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment