Skip to content

Instantly share code, notes, and snippets.

@grambas

grambas/clean_mysql_bin_logs.sh

Last active November 2, 2020 19:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save grambas/aec61b74b2e76ef0749b8d2f6aa74e28 to your computer and use it in GitHub Desktop.
Save grambas/aec61b74b2e76ef0749b8d2f6aa74e28 to your computer and use it in GitHub Desktop.
Download ZIP
cleant mysq bin logs
Raw
clean_mysql_bin_logs.sh
docker exec -it -u root DB_CONTAINER_NAME /bin/bash
mysql -u root -p
PURGE BINARY LOGS BEFORE NOW(); # OR RESET MASTER;
# check option
SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME IN ('log_bin');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment