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. Irek S³onina wrote: > 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
