Re: mysql in a startup/shutdown loop at 30 sec intervals

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Quoted text here. Click to load it

If you can, look at /var/log/messages on the server.  Is mysqld
aborting (e.g. segfaulting)?   Some versions do that.  It might or
might not have to do with corrupt tables, or it might be just some
query that tickles a bug.  And it's possible the query causing the
problem doesn't get logged because it never finishes.  In any case,
it's quitting for some reason, and unless there's a "mysqladmin
shutdown" in your log somewhere that I'm missing, that's not good.

I note that the last query before the connection numbers recycle
is in each case "select * from prestegious", although that query
seems to have completed.  Whether or not that has anything to do
with anything, I'm not sure.

Can you upgrade to a newer version?  That one's pretty old.

                        Gordon L. Burditt

Site Timeline