>>>>> "Harry" == Harry Brueckner <brueckner@stripped> writes:
Harry> I run mysql 3.22.19b on my Linux server and in the past weeks I sometimes got
Harry> messages like:
Harry> mysqld restarted on Tue Apr 13 14:59:09 CEST 1999
Harry> /home/mysql-3.22.19b/libexec/mysqld: ready for connections
Harry> in my mysql.err file. The question I face now, is WHY did it get restarted or
Harry> what happened to mysqld ? The error log just says that it was restarted but
Harry> there is no information available about what happened.
Harry> The server answers like 30 questions per second during the day and the 24h
Harry> average is at approximately 10 questions per second.
Harry> I know it is kinda highly frequented but it handles it nicely except for this
Harry> restarting every few days or sometimes only once a week or so.
Harry> The problem is that I can not turn on logging but of course I am interested in
Harry> things that go wrong. The logfile MySQL provides right now would kinda overflow
Harry> my harddisks pretty fast. :-)
Harry> Any ideas how to get an idea about what the server is doing wrong ?
You can always do logging this by using the mysql-log-rotate script in
cron with some additional code that will notice a restart and move the
log file away.
Its very likely that its some specific query that gives mysqld
|• mysqld restarted||Harry Brueckner||14 Apr|
| • mysqld restarted||Michael Widenius||14 Apr|