Re: [PERFORM] Dell Perc/6

2008-02-13 Thread Tore Halset

Hello.

I think I started that discussion. We ended up buying a Dell 2900 with  
PERC 6/i and 10 * 145GB SAS 3,5 15KRpm discs. 6 of the SAS discs are  
in a raid 10 for the database, 2 in a mirror for the wal and the last  
2 in a mirror for the OS. We get 350MB/s writing and 380MB/s reading  
to/from the raid 10 area using dd. The OS is Ubuntu and the filesystem  
for the raid 10 is ext3.


The box is still under testing, but we plan to set it in production  
this week.


Regards,
 - Tore.

On Feb 12, 2008, at 17:32 , Craig James wrote:

Does anyone have performance info about the new Dell Perc/6  
controllers?  I found a long discussion (Dell vs HP) about the  
Perc/5, but nothing about Perc/6.  What's under the covers?


Here is the (abbreviated) info from Dell on this machine:
PowerEdge 1950 IIIQuad Core Intel® Xeon® E5405, 2x6MB Cache,  
2.0GHz, 1333MHz FSB
Additional Processors Quad Core Intel® Xeon® E5405, 2x6MB Cache,  
2.0GHz, 1333MHz FSB

Memory8GB 667MHz (4x2GB), Dual Ranked DIMMs
Hard Drive Configuration  Integrated SAS/SATA RAID 5, PERC 6/i  
Integrated


Thanks,
Craig

---(end of  
broadcast)---

TIP 1: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly




---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [PERFORM] Dell Perc/6

2008-02-13 Thread Dave Cramer


On 13-Feb-08, at 5:02 AM, Tore Halset wrote:


Hello.

I think I started that discussion. We ended up buying a Dell 2900  
with PERC 6/i and 10 * 145GB SAS 3,5 15KRpm discs. 6 of the SAS  
discs are in a raid 10 for the database, 2 in a mirror for the wal  
and the last 2 in a mirror for the OS. We get 350MB/s writing and  
380MB/s reading to/from the raid 10 area using dd. The OS is Ubuntu  
and the filesystem for the raid 10 is ext3.


Wow that's fantastic. Just to be sure, did you make sure that you read  
and wrote 2x memory to take the cache out of the measurement ?


Dave

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [PERFORM] Dell Perc/6

2008-02-13 Thread Merlin Moncure
On Feb 13, 2008 5:02 AM, Tore Halset [EMAIL PROTECTED] wrote:
 Hello.

 I think I started that discussion. We ended up buying a Dell 2900 with
 PERC 6/i and 10 * 145GB SAS 3,5 15KRpm discs. 6 of the SAS discs are
 in a raid 10 for the database, 2 in a mirror for the wal and the last
 2 in a mirror for the OS. We get 350MB/s writing and 380MB/s reading
 to/from the raid 10 area using dd. The OS is Ubuntu and the filesystem
 for the raid 10 is ext3.

Those are decent numbers.  Can you do a bonnie++ run and post the
results (specifically interested in seeks)?

merlin

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [PERFORM] Dell Perc/6

2008-02-13 Thread Tore Halset

On Feb 13, 2008, at 12:06, Dave Cramer wrote:



On 13-Feb-08, at 5:02 AM, Tore Halset wrote:


Hello.

I think I started that discussion. We ended up buying a Dell 2900  
with PERC 6/i and 10 * 145GB SAS 3,5 15KRpm discs. 6 of the SAS  
discs are in a raid 10 for the database, 2 in a mirror for the wal  
and the last 2 in a mirror for the OS. We get 350MB/s writing and  
380MB/s reading to/from the raid 10 area using dd. The OS is Ubuntu  
and the filesystem for the raid 10 is ext3.


Wow that's fantastic. Just to be sure, did you make sure that you  
read and wrote 2x memory to take the cache out of the measurement ?


Dave




The box have 16GB of ram, but my original test file was only 25GB.  
Sorry. Going to 33GB lowered the numbers for writing. Here you have  
some samples.


% sh -c dd if=/dev/zero of=bigfile bs=8k count=400  sync
3276800 bytes (33 GB) copied, 103.722 seconds, 316 MB/s
3276800 bytes (33 GB) copied, 99.669 seconds, 329 MB/s

% time dd if=bigfile of=/dev/null bs=8k
3276800 bytes (33 GB) copied, 85.4235 seconds, 384 MB/s
3276800 bytes (33 GB) copied, 85.4628 seconds, 383 MB/s

Regards,
 - Tore.

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [PERFORM] Dell Perc/6

2008-02-13 Thread Tore Halset

On Feb 13, 2008, at 20:45, Tore Halset wrote:

The box have 16GB of ram, but my original test file was only 25GB.  
Sorry. Going to 33GB lowered the numbers for writing. Here you have  
some samples.


% sh -c dd if=/dev/zero of=bigfile bs=8k count=400  sync
3276800 bytes (33 GB) copied, 103.722 seconds, 316 MB/s
3276800 bytes (33 GB) copied, 99.669 seconds, 329 MB/s

% time dd if=bigfile of=/dev/null bs=8k
3276800 bytes (33 GB) copied, 85.4235 seconds, 384 MB/s
3276800 bytes (33 GB) copied, 85.4628 seconds, 383 MB/s

Regards,
- Tore.


And here are the bonnie++ numbers. I am a bonnie++ newbie so I ran it  
with no options.


Version 1.03c   --Sequential Output-- --Sequential Input-  
--Random-
-Per Chr- --Block-- -Rewrite- -Per Chr- --Block--  
--Seeks--
MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec  
%CP  /sec %CP
harteigen32136M 83983  97 221757  40 106483  19 89603  97 268787   
22 886.1   1
--Sequential Create-- Random  
Create
-Create-- --Read--- -Delete-- -Create-- --Read---  
-Delete--
  files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec  
%CP  /sec %CP
 16 + +++ + +++ + +++ + +++ + +++  
+ +++
harteigen,32136M, 
83983,97,221757,40,106483,19,89603,97,268787,22,886.1,1,16,+,+++,++ 
+++,+++,+,+++,+,+++,+,+++,+,+++



Regards,
 - Tore.

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [PERFORM] Dell Perc/6

2008-02-12 Thread Greg Smith

On Tue, 12 Feb 2008, Craig James wrote:

Does anyone have performance info about the new Dell Perc/6 controllers?  I 
found a long discussion (Dell vs HP) about the Perc/5, but nothing about 
Perc/6.  What's under the covers?


The Perc/6i has an LSI Logic MegaRAID SAS 1078 chipset under the hood.  I 
know the Linux drivers for the card seemed to stabilize around October, 
there's a good sized list of compatible distributions on LSI's site. 
FreeBSD support has some limitations but basically works.  I haven't seen 
any benchmarks for the current version of the card yet.


--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


[PERFORM] Dell Perc/6

2008-02-12 Thread Craig James

Does anyone have performance info about the new Dell Perc/6 controllers?  I found a long 
discussion (Dell vs HP) about the Perc/5, but nothing about Perc/6.  What's 
under the covers?

Here is the (abbreviated) info from Dell on this machine:

PowerEdge 1950 IIIQuad Core Intel® Xeon® E5405, 2x6MB Cache, 2.0GHz, 
1333MHz FSB
Additional Processors Quad Core Intel® Xeon® E5405, 2x6MB Cache, 2.0GHz, 
1333MHz FSB
Memory8GB 667MHz (4x2GB), Dual Ranked DIMMs
Hard Drive Configuration  Integrated SAS/SATA RAID 5, PERC 6/i Integrated

Thanks,
Craig

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly