On Mon, 19 Jul 2004 18:13:36 +0200, Jan Kirchhoff <[EMAIL PROTECTED]> wrote: > Hi, > > We are currently using a 4.0.16-replication-setup (debian-linux, kernel > 2.4.21, xfs) of two 2.4ghz Intel-Pentium4 systems with 3gig RAM each > and SCSI-Hardware-Raid, connected via gigabit-ethernet. We are reaching > the limit of those systems and are going to buy new hardware as well as > upgrade to mysql 4.1.x. We will start testing our applications on 4.1.3 > within the next few weeks but our main problem is that we are not quite > sure what hardware to buy... > > We are planning to buy something like a dual-xeon system with 10-16gb of > RAM and hardware raid10 with 8 sata-disks and as much cache as possible. > Will mysql be able to use the ram efficiently or are we hitting limits? > AMD or Intel? 32bit or 64bit?
Whatever you do, get a 64 bit system. Opteron recommended, if you really prefer Intel and can get your hands on one of their 64-bit Xeons that is acceptable, although it may take a little longer for Linux to catch up. Even if the software isn't there yet (it is, it may just be a bit of a hassle to all get working), in the worst case you'll have to run it in 32-bit mode until you can figure that out. You can't use more than 2 gig most of the time / close to 4 gig if you hack things up right innodb cache on a 32 bit system. The rest of the memory will be used by the OS (less efficiently than on a 64-bit system though), but that may or may not be as efficient as innodb doing it. That depends a lot on your application's data access patterns. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
