Hi,
I have a configuration with 1 master and 2 slaves; all servers are correctly running mysql-max-4.0.20.
All is fine, but I'm observing a strange usage of logs. On one of the slaves I have:
mysql> show slave status \G *************************** 1. row *************************** Master_Host: idb Master_User: root Master_Port: 3306 Connect_retry: 60 Master_Log_File: db-bin.3322 Read_Master_Log_Pos: 1013397930 Relay_Log_File: www4-relay-bin.009 Relay_Log_Pos: 174693397 Relay_Master_Log_File: db-bin.3322 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: mysql Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 1013397930 Relay_log_space: 174693397 1 row in set (0.00 sec)
and the relay log is 170MB. I don't want relay logs to grow so big; what I'd like Mysql
to do is to destroy the relay-log file as soon as the SQL thread is finished. (usually relay logs
grow up to 4GB in 1GB chunks, so this example doesn't show my problem in all its extent).
Similar problem on the master (db):
-rw-rw---- 1 mysql mysql 196122 Jan 23 2004 db-bin.3319 -rw-rw---- 1 mysql mysql 1073772277 Sep 13 14:55 db-bin.3320 -rw-rw---- 1 mysql mysql 1073773581 Sep 15 10:18 db-bin.3321 -rw-rw---- 1 mysql mysql 1019108019 Sep 17 09:08 db-bin.3322 -rw-rw---- 1 mysql mysql 42 Sep 15 10:18 db-bin.index
There are 3 GB of logs that no one needs anymore. Since the master knows that all
the slaves are correctly aligned up to a certain MASTER_LOG_POS, can't
it automatically remove the logs up to that position?
On another slave where I set set-variable = max_relay_log_size=25000000 set-variable = relay_log_space_limit=50000000
max_relay_log_size seems to be respected, but the problem remains: after having the data inserted in the DB those logs are useless.
Can't Mysql automatically purge logs when they are not needed anymore?
Thanks,
-- Nico Sabbi - Officine Digitali - Bologna Tel. 051 - 4187565
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]