>>>>> "Brandon" == Brandon Pulsipher <Brandon@stripped> writes:
Brandon> I am trying to squeeze every bit of extra speed out of MySQL 3.22 running on
Brandon> a dual processor Linux box with quite a bit of RAM. Does anyone have
Brandon> compile options or runtime options that they have found particularly
Brandon> helpful.
Brandon> I think we do everything at compile (-static is default, right?). But I
Brandon> have read that pgcc is faster than gcc. Right now I compile with gcc
Brandon> 2.7.2.3. Is the pgcc thing still true? And is there a downside to using
Brandon> pgcc?
Brandon> Thank you.
Brandon> -Brandon
Hi!
pgcc (and also egcs 1.1.2) makes the MySQL benchmarks about 11 % faster !
There is no downside that I know off.
Another option is to buy the Cygnus toolkit from www.cygnus.com; This
is very inexpensive, includes gcc 2.9 and gives you even better code
than pgcc! (The standard MySQL rpm:s are compiled with gcc 2.9 !)
We use the following configure line to get a fast MySQL version:
CFLAGS="-O6 -mpentium -fomit-frame-pointer" CXX=gcc CXXFLAGS="-O6 -mpentium
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti" ./configure
--prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static
--disable-shared
Regards,
Monty
