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