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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]