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

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 NetApp

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: snip 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 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