Removing mysql-binlog's?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
4 views
Is it possible to remove binlog'and without fear for replication of database? In this case, to do with the mysql-bin.index?

Thanks in advance for your answers.
by | 4 views

4 Answers

0 like 0 dislike
You can make the logs older than a specific date
PURGE MASTER LOGS BEFORE '2010-10-08 00:00:00';
by
0 like 0 dislike
better to let the muscle itself cleans up old logs, e.g. option:
\r
[mysqld] . . . expire_logs_days = 5 . . . 

will cause the muscle to clean logs older than 5 days.
by
0 like 0 dislike
There is a method of finding those logs that are still being used (not transferred to slave)
Excerpt from dev.mysql.com/doc/refman/5.1/en/purge-binary-logs.htm
\r
To safely purge binary log files, follow this procedure:
1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list.
4.Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5.Purge all log files up to but not including the target file.
\r
by
0 like 0 dislike
Thanks for the replies.
It is a pity that the "Right" answer can be only one answer.
by

Related questions

0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
3 answers
110,608 questions
257,186 answers
0 comments
26,951 users