MySQL Forums
Forum List  »  Replication

Re: How long replication takes?
Posted by: Heikki Tuuri
Date: January 01, 2005 04:57AM

Hi!

The output is from the slave.

"
...
---TRANSACTION 0 43551254, not started, process no 12688, OS thread id 81939
MySQL thread id 12, query id 41031 Has read all relay log; waiting for the I/O slave
...
0.52 inserts/s, 0.10 updates/s, 0.00 deletes/s, 1292.44 reads/s

...
*************************** 1. row ***************************
Id: 11
User: system user
Host:
db: NULL
Command: Connect
Time: 2946
State: Waiting for master to send event
Info: NULL
*************************** 2. row ***************************
Id: 12
User: system user
Host:
db: playng
Command: Connect
Time: 0
State: Reading event from the relay log
Info: COMMIT
*************************** 3. row ***************************
"

Looks like the slave is not hung. Looks like it is waiting for the master to send more of the binlog.

This would leave 2 possibilities:

1) The network is hung.

2) The master is hung, or the I/O thread in the master that reads the binlog and sends it to the slave is hung.

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php

Options: ReplyQuote


Subject
Views
Written By
Posted
9236
December 06, 2004 03:49AM
3645
December 06, 2004 03:51AM
3715
December 07, 2004 03:47PM
3450
December 18, 2004 12:30PM
3535
December 19, 2004 03:55AM
3743
December 30, 2004 11:45AM
Re: How long replication takes?
3311
January 01, 2005 04:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.