Hello.
I was unable to reproduce this behavior on official binaries
of 4.1.16 and 5.0.17 versions. I'm not sure about possible reasons
for you of such a delay. Check if the problem still exists on binaries
of the latest releases from mysql.com. Play with different versions of
glibc. Find out if decreasing of different %timeout% variables affects
the length of the delay before dieing of Slave_IO thread.
> 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
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
