RE: [CentOS] Painfully slow NetApp with databas

2008-11-06 Thread John
>>The critical components were the most frequent access/update patterns >>versus the physical organization of the primary table(s) and their >>_primary_ indexes, or hashes. Do DBMs still use those things? Prmary Indexes have a lot more to do with I/O than most people think. You really have to unde

RE: [CentOS] Painfully slow NetApp with databas

2008-11-06 Thread William L. Maltby
On Thu, 2008-11-06 at 16:32 -0500, David Ross wrote: > > There many factors which impact database i/o performance. You are comparing > two probably dissimilar i/o paths. Configuration differences (disk, > controller, connection, kernel parameters) may be part of the problem. > > Physical vs.

RE: [CentOS] Painfully slow NetApp with databas

2008-11-06 Thread David Ross
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Mindaugas Riauba > Sent: Thursday, November 06, 2008 3:45 AM > To: [EMAIL PROTECTED]; CentOS@centos.org > Subject: [CentOS] Painfully slow NetApp with databas > > We have long running problem with NetAp

Re: [CentOS] Painfully slow NetApp with databas

2008-11-06 Thread nate
Mindaugas Riauba wrote: > NetApp support is claiming that such performance is normal. Somehow > I do not believe that 2007 model should deliver such XXth century > performance levels. :) How many disks, what RPM are they running at, what I/O block size is being used and what protocol (NFS/iSCSI