Re: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB

Mon, 09 May 2005 17:41:34 -0700

I use Redhat Advanced Server v4 (2.6 kernel) on my four dual opteron systems. I've had no real performance issues with the I/O scheduler, but that's because I run 8GB of ram with a huge key cache. I recommend taking the box to 8GB of ram, it's worth it. Definately use RAID 10.

----- Original Message ----- From: "Dathan Pattishall" <[EMAIL PROTECTED]>
To: "Richard Dale" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Monday, May 09, 2005 4:15 PM
Subject: RE: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB




-----Original Message-----
From: Richard Dale [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 08, 2005 9:37 PM
To: mysql@lists.mysql.com
Subject: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB

A new server is about to arrive here and will have have 8x15K
RPM spindles, dual Opteron processors and 4GB of RAM, and
will have around 100GB of database (primarily stock market
prices) - the SCSI controller will also have battery-backed
RAM too.  InnoDB will be used exclusively.

I've searched the list and seen varying reports of which
Linux kernels work best etc.

I'd be intersted to know the following:
a) Which 64 bit Linux distributions are good for the task?


      Suse 8.1 2.4.21-215-smp #1 SMP Tue Apr 27 16:05:19 UTC 2004
x86_64 unknown

b) Which 64 bit Linux distributions are bad for the task? 

2.6 the IO sceduler is still messed up.
     RedHat AS / Suse 9.x are messed up as well

c) Any comments on kernels, particularly with regard to 64
bit support and schedulers?  Any problems with the latest
kernels (2.6.11 & 2.6.12-rcX)?

d) Any recommendations for RAID volume setup 

Use RAID-10 split the disks evenly across each channel


e) Any MySQL optimisations for multiple spindles, onboard
caching, stripe sizes, RAID5 vs RAID10.


   Don't use RAID5, use Reiser FS if your using SUSE

f) Any MySQL reliability settings to take into account the
battery-backed RAM on the RAID controller?

I'm happy to collate the responses into a summary too.

I'm aware of the following discussions which describes a
reasonably grunty Dual AMD system with a similar
configuration to mine:
http://meta.wikimedia.org/wiki/Hardware_ordered_April_2005
http://meta.wikimedia.org/wiki/Hardware_order_May_2004

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]



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


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

Reply via email to