relay log每秒产生很多小文件

syxian

[root@vas11 mysql]# ll  -h mysqld-relay-bin.22327*
-rw-rw---- 1 mysql mysql  287 10-10 04:25 mysqld-relay-bin.223270
-rw-rw---- 1 mysql mysql  287 10-10 04:25 mysqld-relay-bin.223271
-rw-rw---- 1 mysql mysql 1.4K 10-10 04:25 mysqld-relay-bin.223272
-rw-rw---- 1 mysql mysql  287 10-10 04:25 mysqld-relay-bin.223273
-rw-rw---- 1 mysql mysql  546 10-10 04:25 mysqld-relay-bin.223274
-rw-rw---- 1 mysql mysql  548 10-10 04:25 mysqld-relay-bin.223275
-rw-rw---- 1 mysql mysql  547 10-10 04:25 mysqld-relay-bin.223276
-rw-rw---- 1 mysql mysql  808 10-10 04:25 mysqld-relay-bin.223277
-rw-rw---- 1 mysql mysql  287 10-10 04:25 mysqld-relay-bin.223278
-rw-rw---- 1 mysql mysql  809 10-10 04:25 mysqld-relay-bin.223279

mysql> show variables like "%relay_log%";
+-----------------------+----------------+
| Variable_name         | Value          |
+-----------------------+----------------+
| max_relay_log_size    | 0              |
| relay_log             |                |
| relay_log_index       |                |
| relay_log_info_file   | relay-log.info |
| relay_log_purge       | ON             |
| relay_log_space_limit | 0              |
+-----------------------+----------------+
6 rows in set (0.00 sec)

[root@vas11 mysql]# cat /etc/my.cnf | grep  log-error
log-error=/var/log/mysqld.log

[root@vas11 mysql]# tail -n 200 /var/log/mysqld.log
111010 17:23:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'localvaslog.008763' position 3768110
111010 17:23:37 [Note] Slave: connected to master 'slave@10.10.131.250:3306',replication resumed in log 'localvaslog.008763' at position 3768110
111010 17:23:37 [Note] Slave: received end packet from server, apparent master shutdown:

后来查出是server-id重复了！