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]
