On Mon, 19 Jul 2004 18:13:36 +0200, Jan Kirchhoff <kirchy@stripped> 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.
