xfs
[Top] [All Lists]

Re: Null files reloaded :-)

To: David Sparks <daves@xxxxxxxxxxxxxxx>
Subject: Re: Null files reloaded :-)
From: Thomas <thomas-lists@xxxxxxxxx>
Date: Fri, 23 Jul 2004 21:27:08 +0200
Cc: linux-xfs@xxxxxxxxxxx
In-reply-to: <410159BA.6060006@xxxxxxxxxxxxxxx>
References: <200407200444.21761.wizeman@xxxxxxxx> <410159BA.6060006@xxxxxxxxxxxxxxx>
Sender: linux-xfs-bounce@xxxxxxxxxxx
User-agent: Mozilla Thunderbird 1.6.3.1d (Windows/20040707)
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


<Prev in Thread] Current Thread [Next in Thread>