BAUMEISTER Alexandre writes:
> Heikki,
> If I run Mysql without having any client connected nor doing any
> "mysqladmin xxx" command, the is no Warning messages. Only :
>
> 010326 11:43:29 mysqld started
> Innobase: Started
> /usr/local/mysql/libexec/mysqld: ready for connections
>
> If I do "mysqladmin ping" , "mysqladmin status" ... no problems.
>
> As soon as I run my daemons :
>
> 010326 11:47:28 Warning: Got signal 14 from thread 4
> 010326 11:47:30 Warning: Got signal 14 from thread 4
> 010326 11:47:32 Warning: Got signal 14 from thread 4
> 010326 11:47:34 Warning: Got signal 14 from thread 4
>
> another thing really interesting is that if I do a lot of
> "mysqladmin proc", then the Warning messages are paused.
>
> I explain. I'm doing a "tail -f myserver.err" on a console. Then I
> see that about each 2 seconds I got a "Warning ... message".
>
> On another console I do "mysqladmin proc" and as soons as I get the
> result I do another "mysqladmin proc" and so on ...
>
> Then I noticed that while I'm doing "mysqladmin proc", the "Warning"
> messages are no more send to error log.
>
> A soon as I stop doing "mysqladmin proc", the "Warning" messages are
> coming back :(
>
> This seems very incomprehensible to me, but I though maybe this
> could be a clue for you.
>
> NB: I did the test with "mysqladmin ping" , "mysqladmin status" and
> it's the same than with "mysqladmin proc".
>
> Regards,
> Alex.
>
>
>
Hi!
Seems like Innobase has introduced some timeout ( I do not see how) on
the sleeping connections.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php