> -----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]