-----BEGIN PGP SIGNED MESSAGE-----
On Tue, 24 Jun 2003, David Griffiths wrote:
> I'm surprised there is not more interest in this; is it that not many
> work with large-ish (10+ gig) databases that need high-end performance?
Many of our customers do.
> A 64-bit CPU won't have the 4-gig memory limit that a 32-bit processor
> will; even worse, Linux is apparently limited to about a 2-gig process.
It depends - there is a BIGMEM patch from Andrea Arcangeli that raised
that limit to 3.5 GB on 32bit systems. I think the patch is in the
mainline kernel as well by now.
> SuSe Enterprise Linux supports 512-gigabyte processes with 16
> processors. Imagine 10 gigabyte database all in memory.
> Even better, larger file sizes - no more 2-gig files. Max file size is
> 9-Exabytes ( "9" followed by 18 "0's" ). All the posts I see about
> people trying to get around the 2 gig file limit should be really
Actually, you can create larger files on 32bit Linux systems as well. It's
just that the file system and the C library must have support for LFS
(Large File Support):
> I guess I'm just surprised by lack of interest. I've been bugging our
> CTO once a week about this, and hopefully should have a server on my
> desk by mid summer to late fall.
Have fun with it!
> If you're interested, SuSe has a good PDF on AMD64 and SuSe Enterprise Linux
> Anyone have some practical experience with the software and hardware?
Yes, we do have two AMD64 systems (one dual Opteron with 1GB of RAM),
running SLES here. Quite impressive. We also have some Itanium (1/2)
systems and SGI kindly gave us access to an "Altix" system (16 x 900MHz
Intel Itanium-2, 32GB of RAM). So MySQL runs quite happily on 64bit
The main benefit of a 64 bit platform is that MySQL can handle more
concurrent threads and that you can give more than 4GB of memory to MySQL
The disadvantage is that MySQL will be about 3-5 % slower because of the
extra memory usage 64 bit pointers require (Structures are aligned to be
64 bit aligned, which makes the structures bigger and reduces the CPU
cache usage, more stack space is used for registers). We tested this on
Sun Solaris, using the Sun Forte compilers, but I assume this applies to
other architectures as well.
For technical support contracts, visit https://order.mysql.com/?ref=mlgr
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer <lenz@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer
/_/ /_/\_, /___/\___\_\___/ Hamburg, Germany
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/
-----END PGP SIGNATURE-----