On Thu, Mar 01, 2007 at 08:19:49PM +0100, Edgar Fu? wrote:
> I've no idea whether this problem is actually LFS related or
> I was just hitting a coincidence.
> 
> We have performance problems on our mySQL server. As analysis
> showed that disk I/O, in particular seeks, were the problem,
> I thought it might be worth to try LFS. So we dumped the
> database, set up an LFS partition on a development server and
> fed the dump into mysql. First, everything went as expected
> (mysqld being CPU bound). Then, as most of the database seems
> to have been written, we observed ioflush consuming 100% CPU
> load. From then on, any attempt to access the LFS partition
> (ls, du) locked up in vnlock state.

IMHO: LFS really isn't suitable for databases - every random
write operation can fragment the file on disk. Do a few
thousand random writes and the database files will be very
fragmented.

While it'll still all work, I'm sure this can't be efficient.

This is from my testing, anyway. I'm pretty sure it's correct.

Cheers,
-- 
stix