---- Original Message -----
From: "Michael T. Babcock" <mbabcock@stripped>
To: "Bill Easton" <bill@stripped>
Cc: <mysql@stripped>; "Tom Thurnherr" <thurnherr@stripped>
Sent: Monday, October 28, 2002 4:18 PM
Subject: Re: database corrupted after power switched off
> Again, make sure you check how your OS deals with write caching
> and consider turning it off on the partition / disk you're using for
> DB storage.
I would certainly not do that. In fact, disk caches (for non 4.04 users) are
an excellent, be it a poor man's, way of having a SELECT cache. On my own
MySQL news server, with many recurring logins from the same people, disk
caches make an enormous difference. Since MySQL, through the disk cache,
effectively reads most of these SELECTS from memory, the speed of logins has
increased by an order of magnitude.
The proper way is NOT to disable disk cache, but to shut down mysqld
properly. In fact, I could make a cogent case stating that disabling disk
cache actually INCREASES the risk of corruption (because you can never hope
to expect a delayed write).
System Administrator Asarian-host.org
"If you were supposed to understand it,
we wouldn't call it code." - FedEx