Linux and SSD and how to decrease io delay : question, please

[Mariella Petrini <mariellapetrini@yahoo.com>]

Hi All,

I have been running Linux kernel 2.6.23 with Debian on

a 2 CPUs Dual-Core AMD Opteron(tm) Processor 2218.
I have been using an SSD drive (MTRON) connected to a
raid controller (LSI      MegaRAID 8704ELP) to contain
data stored on several databases.
Each database contains 20,000 files and there are 50
databases total (1,000,000 files distributed across 50
directories on the filesystem on the ssd).

The database server uses the databases very "write"
intensively.
An approximate percentage could be 20% reads versus
80% random writes.

No matter which filesystem type is used (I have tried
ext3, xfs, jfs, reiserfs) I see every few seconds
snapshots (the could last in the worst case up to 200
seconds, depending on the filesystem type) 
where the iowait on the ssd device goes approximately
over 50% (up to 100%) and 
the database server threads go to wait (get
suspended).

Is there any Linux kernel parameter or any Linux
parameter that could be varied that could help to
decrease the time spent to sync all the data to the
SSD device ?

Thanks in advance for your help,

Mariella





      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ