Jani Tolonen wrote:
> 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 ?
> >
> 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
>
>
Yes - I realise that this is not enough information to track the problem.
My first question
was only the verify if the server actually restarts itself after a crash. I
have recompilded
mysqld with the --width-debug switch and I hope to gett more info next time
a restart
happens. I'm trying to avoid turning on logging since I fear it will
degrade the performance
of my applications significantly. I'll try to gather more info and get
back
Thanks for your help.
--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
