Hi.
Well, what's the problem with using isamchk in detail?
Shut down the mysql daemon, run "isamchk" on all tables to find out
which are corrupted and run "isamchk -r" on those. Then restart
mysqld. Do not forget to make backup copies of the tables in question
beforehand, in case anything unexpected happens.
You can get more information about your version of isamchk with
"isamchk --help".
If you still have some problem, please describe in detail what you
have tried and where you got stuck.
Bye,
Benjamin.
On Thu, May 16, 2002 at 10:56:27AM +0400, [EMAIL PROTECTED] wrote:
> Hello:
>
> Can anybody help me out to repair my database & tables using ISAMCHK
> utility. The MySQL server version is 3.21.33b installed on BSD server.
>
> Many thanks
> Sheni
>
> Details of the problem that we are facing now:
>
> We are facing a serious problem with the MySQL server installed on our web
> server (BSD/OS). The server was working fine till last week. Since then it
> started crashing. It crashes 2-3 times a day. Every time we have to kill
> the process and restart the server (UNIX). Not only the MySQL server the
> entire server crashes because of the load on the CPU.
>
> ###CPU STATE###
> load averages: 1.00, 1.00, 0.92 02:47:57
> 278 processes: 13 running, 265 sleeping
> CPU states: 0.0% user, 98.4% nice, 1.6% system, 0.0% interrupt, 0.0% idle
> Memory: Real: 40M/94M Virt: 217M/1481M Free: 342M
> PID PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
> 270 94 4 4420K 2024K run 43:48 97.17% 97.17% mysqld
> ##############
>
> The MySQL version is 3.21.33b . Since its an old version I couldn't find
> out any information regarding the issue from the MySQL web site.
>
> We have got 4-5 MySQL databases on this server.
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
