Sorry, I might not have been clear, the mySQL server magically restarted itself once it crashed apparently, I got woken up with a call saying the homepage had a 'funny message', and when I hopped into the mysql console it said it had been up 1 hour 30 minutes (considering it said it was up for 40 days last night, and top still says up for 40 days, and some tables were corrupt, I assume mySQL crashed).
(over here trying to figure out how to make show all tables pipe into check table), William. ----- Original Message ----- From: "Gerald Clark" <[EMAIL PROTECTED]> To: "William_dw -- Sqlcoders" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 12:32 PM Subject: Re: MySQL Server crash... > Run myisamchk BEFORE you start the server! > > William_dw -- Sqlcoders wrote: > > >Hiya, > >We're running a 1gz server which crashed around an hour ago and I'm trying > >to find out why, > >it's averaging 60 queries per second according to mysql status and I figure > >that's why the server crashed although it had happily handled 15 million > >questions up to that point. > > > >Is there a logfile which would tell me what caused mysql to crash? while it > >restarted just fine it did cause some problems (got the nice 'Warning: > >Couldn't save resultset' message on the front page of the website). > > > >Oh and is there a way to check all tables in a single command with SQL > >instead of using myisamchk? I don't like the idea of using flush tables and > >then running myisamchk with a lag between the two operations for something > >to happen. > > > >Thanks in advance for any advice, > >William. > > > > > >--------------------------------------------------------------------- > >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 > > > > > > > --------------------------------------------------------------------- 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