Skip to content

Instantly share code, notes, and snippets.

@exuan

exuan/purge-binay-logs.sql

Created October 26, 2015 10:38
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 exuan/57cb3bb7c6d6616c26d4 to your computer and use it in GitHub Desktop.
Save exuan/57cb3bb7c6d6616c26d4 to your computer and use it in GitHub Desktop.
Download ZIP
清理MySQL bin log
Raw
purge-binay-logs.sql
PURGE BINARY LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY);
PURGE BINARY LOGS TO 'mysql-bin.000082';
/**
* 重置
*/
RESET MASTER;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment