SQL: October 2010 Archives

Remove MySQL old bin log

Vote 0 Votes

MySQL 若有用 Replication 的話, 會持續有 bin log 產生, 舊的 bin log 若用不到了可以刪除之
find /var/lib/mysql -mtime +2 -name "*-bin.0*" -exec rm -f {} \;
刪除超過三天的 bin log

比較正規的方式是在 my.cf 定義 expire_logs_days,
然後用 mysqladmin flush-logs

About this Archive

This page is an archive of entries in the SQL category from October 2010.

SQL: September 2010 is the previous archive.

SQL: November 2010 is the next archive.

Find recent content on the main index or look in the archives to find all content.

Monthly Archives