Re: Null files reloaded :-)

[Thomas <thomas-lists@xxxxxxxxx>]

Hey there,

David Sparks wrote:

> The real world example is database files.  What happens if a busy 
> mysql database making a lot of inserts has the fs brought down 
> uncleanly?  Are sections of the file nulled or is the entire file nulled?

Some real-world experiences ...
I'm running a busy database-server running only mysql on it (dual 
athlon-mp, 2GB ram).
The filesystem for the mysql-databases is xfs.
In the old kernel-2.4.19-days I had a lot of crashes of this machines 
while the database was under load.
The worst things I've ever seen have been index-corruption, nothing a 
mysqlrepair can't handle.
Never had nulled files or parts of files.

Since upgrading that machine to 2.4.25 everything runs smooth and 
without crashes ... thanks for that great filesystem :-).


Regards,

Thomas