Hello.
I have mysql-4.1.14 and 4.1.15 on PLD's.
When the Slave_IO_State is in 'Connecting to Master' state
because of the unreachable master host (timeouting)
the 'slave stop' or 'slave stop io_thread' tooks
minimum 2 minutes.
fe.:
mysql> stop slave io_thread;
Query OK, 0 rows affected (2 min 52.11 sec)
the processlist when waiting for death of thread:
*************************** 1. row ***************************
Id: 6
User: mysql
Host: 192.168.100.55:1148
db: NULL
Command: Query
Time: 9
State: Killing slave
Info: slave stop
*************************** 3. row ***************************
Id: 19
User: system user
Host:
db: NULL
Command: Connect
Time: 16
State: Connecting to master
Info: NULL
*************************** 4. row ***************************
Id: 20
User: system user
Host:
db: NULL
Command: Connect
Time: 16
State: Has read all relay log; waiting for the slave I/O thread to
update it
Info: NULL
If I do remember correctly then mysql versions 4.0.x was waiting about
30 secs to end the slave's threads.
I would be very grateful if sb will suggest something to cure this
situation.
Best Regards,
Irek Slonina
