I forgot to add that the reset slave command worked properly , deleting all the relay-bin files. After the reset slave, I restart the slave and the realy files didn't grow in number ( I got only ones of it ).
-----Messaggio originale----- Da: AESYS S.p.A. [Enzo Arlati] [mailto:[EMAIL PROTECTED] Inviato: giovedì 12 gennaio 2006 15.33 A: [EMAIL PROTECTED] Mysql. Com (E-mail) Oggetto: replica slave created more than 5000 relay-bin file in less than 45 minutes I got this strange situation, with 2 PC with win2000 and mysql 5.0.18 with the replica enabled. Apparently both the server and slave have no operation to do, but on the slave were created more than 5000 relay-bin file in less than 45 minutes I added some log, also they seems normal. Is the second time this happen today, but I have no idea of what can cause this. Do have someone an idea about that problem ? show full processlist; Id User Host db Command Time State Info ------ ----------- -------------- ----------- ------- ------ --------- ----------------------------- --------------------- 3 root localhost:1969 pmv_manager Sleep 82 (NULL) 219 pmv_manager localhost:2505 pmv_manager Sleep 44 (NULL) 829 system user (NULL) Connect 5033 Queueing master event to the relay log (NULL) 830 system user (NULL) Connect 12781 Reading event from the relay log (NULL) 853 root localhost:4977 (NULL) Query 0 (NULL) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Queueing master event to the relay log Master_Host: 192.168.201.120 Master_User: replicant Master_Port: 3306 Connect_Retry: 60 Master_Log_File: pmv_manager_log_bin.000017 Read_Master_Log_Pos: 4 Relay_Log_File: Arlati-E-relay-bin.005280 Relay_Log_Pos: 4 Relay_Master_Log_File: pmv_manager_log_bin.000017 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: pmv_manager.debug_log,pmv_manager.parametri_configu razione,pmv_manager.lista_fep,pmv_manager.stato_fep_slave Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 3312 Relay_Log_Space: 18984128 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 12556 1 row in set (0.30 sec) ************ ** MASTER ** ************ show master status; File Position Binlog_Do_DB Binlog_Ignore_DB -------------------------- -------- ------------ ---------------- pmv_manager_log_bin.000018 271 show binlog events; Log_name Pos Event_type Server_id End_log_pos Info -------------------------- ------ ----------- --------- ----------- --- ---------------------------------------------------------------------------- -------- pmv_manager_log_bin.000018 4 Format_desc 4 98 Server ver: 5.0.18-nt-log, Binlog ver: 4 pmv_manager_log_bin.000018 98 Query 4 146 use `pmv_manager`; insert into test1 ( idrow, data ) values ( 297, current_timestamp ) pmv_manager_log_bin.000018 244 Xid 4 271 COMMIT /* xid=14319 */ Enzo Arlati [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
