I have a replication server that is running out of disk space because of old relay binary log files.
Both it and the master server are version 4.0.20.
I have a cron script that maintains a 3 day history of binary log files on the master server.
Has someone figured out a way to manage the number relay log files so that someone doesn't have to check a replication server to see if the filesystem for the MySQL data directory hasn't been filled by old relay log files that haven't been accessed for some specified time?
Bill:
Doublecheck to make sure your SQL thread is running ( SHOW SLAVE STATUS). Relay logs should get deleted as soon as they are processed by the SQL thread. Another potential problem - if you do not change the default config, and leave less than 1 GB for the relay log partition you will have a problem. Either put them on a bigger partition, or set max-relay-log-size to a lower value.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
