Re: Serious Crash last Friday

Scott Marlowe dijo:

> On Thu, 20 Jun 2002, Henrik Steffen wrote:

> > I have now created a cronjob that will drop and recreate all indexes on a
> > daily basis.
> >
> > But shouldn't this be unnecessary ?

[...]

> A few questions.  Have you done any really heavy testing on your server to
> make sure it has no problems with its hardware or anything?  I've seen
> machines with memory errors or bad blocks on the hard drive slip into
> production and wreak havoc due to slow corruption of a database.

Also, if you are on ix86 hardware, try running memtest86 for a few hours
on it (www.teresaudio.com/memtest86).

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"La realidad se compone de muchos sueños, todos ellos diferentes,
pero en cierto aspecto, parecidos..." (Yo, hablando de sueños eróticos)