RE: Opteron HOWTO - #mysql Freenode

2005-05-17 Thread Richard Dale
Over the last week I added in lots of comments pasted in from various
places.  I'd appreciate those running with Opteron and MySQL to have a close
look at the WIKI and make any amendments/suggestions.

http://hashmysql.org/index.php?title=Opteron_HOWTO

My Opteron server will be here shortly and I'll do some performance testing
on RAID5 (8 disks) versus RAID 10 (8 disks, 2 channels).  I'll also do some
performance tests with 128MB cache and 512MB cache on the SCSI card to let
you know if that makes a difference.

Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
  markets in Australia, Asia, Canada, Europe, UK  USA -
www.premiumdata.net 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Opteron HOWTO - #mysql Freenode

2005-05-17 Thread Kevin Burton
Richard Dale wrote:
Over the last week I added in lots of comments pasted in from various
places.  I'd appreciate those running with Opteron and MySQL to have a close
look at the WIKI and make any amendments/suggestions.
http://hashmysql.org/index.php?title=Opteron_HOWTO
My Opteron server will be here shortly and I'll do some performance testing
on RAID5 (8 disks) versus RAID 10 (8 disks, 2 channels)
 

Awesome!  Thats great news...
I reconfigured one of our slaves from RAID5 to RAID1 and setup the 
controller as writeback and caching the stripes.  I'm getting about 75% 
additional performance.  I wanted to put the controller on additional 
channels but it turns out that I need a stupid proprietary cable from 
Dell to accomplish this.  I'm not sure what benchmark I could see from 
using two channels then.

My gut though in our config says that we won't see any performance 
increase since I'm not maxing out the IO on each channel (but I might be 
wrong).

I'd love to see your numbers here.
--
Use Rojo (RSS/Atom aggregator)! - visit http://rojo.com. 
See irc.freenode.net #rojo if you want to chat.

Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html
  Kevin A. Burton, Location - San Francisco, CA
 AIM/YIM - sfburtonator,  Web - http://peerfear.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]