The servers are hosted on a network that has 99.999% uptime, also i am the
one monitoring the server.

To explain further, everything on the server is working fine except on some
occasions
that the table or the index gets corrupted and i have to run myisamchk to
repair it.  So, do you
know of any other reasons why the table/index arbituarily crashes?

For example of errors or index crashing

1. Warning: MySQL: Unable to save result set in /home/me/...
2. Incorrect key file for table: Contact
3. myisamchk: warning: Table is marked as crashed


Thanks
-----Original Message-----
From: gerald_clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:12 AM
To: Jason Hall
Cc: '[EMAIL PROTECTED]'
Subject: Re: Tables/Index Crashing?


Power failure/unplug/turn-off server.
kill -9
OS crash.
Operating handheld radios next to the server.

I am sure others can come up with more.

Jason Hall wrote:

>What are some of the reasons why table/index key crashes?
>
>sql, query
>
>
>---------------------------------------------------------------------
>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

Reply via email to