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