Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Jim C. Nasby
On Thu, Jul 28, 2005 at 05:00:44PM -0700, Mark Wong wrote: On Thu, 28 Jul 2005 16:55:55 -0700 Mark Wong [EMAIL PROTECTED] wrote: On Thu, 28 Jul 2005 18:48:09 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Thu, Jul 28, 2005 at 04:15:31PM -0700, Mark Wong wrote: On Thu, 28 Jul 2005

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Mark Wong
On Fri, 29 Jul 2005 14:39:08 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Thu, Jul 28, 2005 at 05:00:44PM -0700, Mark Wong wrote: On Thu, 28 Jul 2005 16:55:55 -0700 Mark Wong [EMAIL PROTECTED] wrote: On Thu, 28 Jul 2005 18:48:09 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote:

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Jim C. Nasby
On Fri, Jul 29, 2005 at 12:51:57PM -0700, Mark Wong wrote: Not sure I fully understand what you're trying to say, but it seems like it might still be worth trying my original idea of just turning all 80 disks into one giant RAID0/striped array and see how much more bandwidth you get out of

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Mark Wong
On Fri, 29 Jul 2005 14:57:42 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Fri, Jul 29, 2005 at 12:51:57PM -0700, Mark Wong wrote: Not sure I fully understand what you're trying to say, but it seems like it might still be worth trying my original idea of just turning all 80 disks into

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Josh Berkus
Mark, I have done that before actually, when the tablespace patch came out. I was able to get almost 40% more throughput with half the drives than striping all the disks together. That's not the figures you showed me. In your report last year it was 14%, not 40%. -- Josh Berkus Aglio

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Mark Wong
On Fri, 29 Jul 2005 13:35:32 -0700 Josh Berkus josh@agliodbs.com wrote: Mark, I have done that before actually, when the tablespace patch came out. I was able to get almost 40% more throughput with half the drives than striping all the disks together. That's not the figures you

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Mark Wong
On Fri, 29 Jul 2005 13:19:06 -0700 Luke Lonergan [EMAIL PROTECTED] wrote: Mark, On 7/29/05 12:51 PM, Mark Wong [EMAIL PROTECTED] wrote: Adaptec 2200s Have you tried non-RAID SCSI controllers in this configuration? When we used the Adaptec 2120s previously, we got very poor

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Jim C. Nasby
On Fri, Jul 29, 2005 at 01:11:35PM -0700, Mark Wong wrote: On Fri, 29 Jul 2005 14:57:42 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Fri, Jul 29, 2005 at 12:51:57PM -0700, Mark Wong wrote: Not sure I fully understand what you're trying to say, but it seems like it might still be

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Jim C. Nasby
On Wed, Jul 27, 2005 at 09:31:39PM -0700, Mark Wong wrote: After seeing the discussion about how bad the disk performance is with a lot of scsi controllers on linux, I'm wondering if we should run some disk tests to see how things look. I'd be very interested to see how FreeBSD compares to

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Jim C. Nasby
On Wed, Jul 27, 2005 at 07:32:34PM -0700, Josh Berkus wrote: This 4-way has 8GB of memory and four Adaptec 2200s controllers attached to 80 spindles (eight 10-disk arrays). For those familiar with the schema, here is a visual of the disk layout:

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Jim C. Nasby
On Thu, Jul 28, 2005 at 05:14:41PM -0500, Jim C. Nasby wrote: On Wed, Jul 27, 2005 at 09:31:39PM -0700, Mark Wong wrote: After seeing the discussion about how bad the disk performance is with a lot of scsi controllers on linux, I'm wondering if we should run some disk tests to see how

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Mark Wong
On Thu, 28 Jul 2005 17:19:34 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Thu, Jul 28, 2005 at 05:14:41PM -0500, Jim C. Nasby wrote: On Wed, Jul 27, 2005 at 09:31:39PM -0700, Mark Wong wrote: After seeing the discussion about how bad the disk performance is with a lot of scsi

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Mark Wong
On Thu, 28 Jul 2005 17:17:25 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Wed, Jul 27, 2005 at 07:32:34PM -0700, Josh Berkus wrote: This 4-way has 8GB of memory and four Adaptec 2200s controllers attached to 80 spindles (eight 10-disk arrays). For those familiar with the schema, here

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Jim C. Nasby
On Thu, Jul 28, 2005 at 04:15:31PM -0700, Mark Wong wrote: On Thu, 28 Jul 2005 17:17:25 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Wed, Jul 27, 2005 at 07:32:34PM -0700, Josh Berkus wrote: This 4-way has 8GB of memory and four Adaptec 2200s controllers attached to 80 spindles

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Mark Wong
On Thu, 28 Jul 2005 18:48:09 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Thu, Jul 28, 2005 at 04:15:31PM -0700, Mark Wong wrote: On Thu, 28 Jul 2005 17:17:25 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Wed, Jul 27, 2005 at 07:32:34PM -0700, Josh Berkus wrote: This 4-way has

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-27 Thread Josh Berkus
Mark, I'm starting to get results with dbt2 on a 4-way opteron system and wanted to share what I've got so far since people have told me in the past that this architecture is more interesting than the itanium2 that I've been using. This 4-way has 8GB of memory and four Adaptec 2200s

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-27 Thread Mark Wong
On Wed, Jul 27, 2005 at 07:32:34PM -0700, Josh Berkus wrote: Mark, I'm starting to get results with dbt2 on a 4-way opteron system and wanted to share what I've got so far since people have told me in the past that this architecture is more interesting than the itanium2 that I've been