On Saturday 10 March 2001 22:16, Justin wrote:
> Well thats good to know.. although this is sustained 24x7x365
>
> linux 2.2.14-5.0smp, uptime 170 days but e2fsk ok's the
> the database partition, which is a mirror.
>
> in an attempt to get stability, I've been running on the official
> 3.22.32 mysql binary for a month now .. it hasn't helped.
>
> Typically indexes get corrupted and cause selects to malfunction,
> OR, cause mysqld to crash, OR cause count(*) or distinct(*) queries
> to run in infinite loops, but not necessarily on the corrupt table.
> it seems to me index corruption can poison the server beyond the
> afflicted table.
We've had fairly bad luck with Linux 2.2.X and SMP for any kind of high-end
system. The DAC 960 SCSI controllers proved to be fairly problematic in this
environment. Sometimes updating the drivers helps. We have a couple of
systems that run much better when we do not use one of the CPUs.
If e2fsck says the partition is fine, then it might not be this problem.
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D f: +1 415 864 8388
San Francisco, CA 94103 w: http://www.quicknet.net
USA
---------------------------------------------------------------------
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
