Leif Thuresson writes:
> I'm running MySQL 3.22.21 on a linux 2.2.26 system.
> I have noticed that I get these entries in the error logfile:
>
> ...
> mysqld restarted on Fri Jun 11 16:53:08 CEST 1999
> /usr/local/libexec/mysqld: ready for connections
> ...
>
> Does it mean that the server crashes and restarts itself or what ?
> It happens with an interval of 2-5 days. I haven't been able to
> correlate it to any special event in the client applications.
> Any idea what might be happening ?
>
> --leif
> ---------------------------------------------------------
> Leif Thuresson Tel: +46-18-4713860
> Uppsala University Fax: +46-18-4713833
> The Svedberg Laboratory E-mail: leif.thuresson@stripped
> P.O.Box 533
> S-751 21 Uppsala
> Sweden
Hello!
Without more information it is impossible to say what's
wrong for sure. It might be, that some query exceeds the
max_allowed_packet size (see mysqld --help) and that can
cause a crash. In this case you should try to increase
the value of this variable (mysqld -O max_allowed_packet=...)
Can you check if it is some specific query that kills MySQL?
Please read from the manual the section:
'What to do if MySQL keeps crashing'
and repost with mysqlbug.
Regards,
- Jani
--
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto: jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+