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

[Peter J Milanese]

I would go raid 10. This made a huge difference on one of my systems. You could probably
get fancier than that, but r10 works well. A different fs would likely help. You said
nothing about the layout of the db, but I'm sure you have that under control.

P

-----------------
Sent from my NYPL BlackBerry Handheld.


----- Original Message -----
From:  [gunmuse@stripped]
Sent: 05/09/2005 09:39 PM
To: "Jeremiah Gowdy" <jgowdy@stripped>; "Dathan Pattishall"
<dathan@stripped>; "Richard Dale" <richard@stripped>;
<mysql@stripped>
Subject: RE: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB

Why not Raid 3 and take advantage of disk write and read performance.

Raid 3 isn't commonly used because it has CPU overhead.  But at the same
time Apache causes CPU overhead waiting for the data from the drives.

I am buying this exact same server With 32 Gig of ram.

Frankly the slowest thing in my current Raid 5 server is still waiting for
the disks to read.  That is what prompted me to think bigger processors,
more ram and faster motherboard to compensate for using a Raid 3 to overcome
the slowest hardware in my server.

Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183


-----Original Message-----
From: Jeremiah Gowdy [mailto:jgowdy@stripped]
Sent: Monday, May 09, 2005 6:37 PM
To: Dathan Pattishall; Richard Dale; mysql@stripped
Subject: Re: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB


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" <dathan@stripped>
To: "Richard Dale" <richard@stripped>; <mysql@stripped>
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:richard@stripped]
> Sent: Sunday, May 08, 2005 9:37 PM
> To: mysql@stripped
> 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/mysql?unsub=1
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1