MySQL的pxb格式_2. 安装MySQL

在MySQL

AB开发系统上构建下面的二进制：

·Linux 2.4.xx x86中的gcc2.95.3：

CFLAGS="-O2 -mcpu=pentiumpro"

CXX=gcc CXXFLAGS="-O2 -mcpu=pentiumpro -felide-constructors"

./configure --prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--enable-assembler --disable-shared --with-client-ldflags=-all-static

--with-mysqld-ldflags=-all-static

·Linux 2.4.x x86中的icc(Intel

C++ Compiler 8.1或更高版本)：

CC=icc CXX=icpc

CFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" CXXFLAGS="-O3

-unroll2 -ip -mp -no-gcc -restrict" ./configure --prefix=/usr/local/mysql

--localstatedir=/usr/local/mysql/data --libexecdir=/usr/local/mysql/bin

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --enable-assembler --disable-shared

--with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static

--with-embedded-server --with-innodb

请注意Intel编译器8.1版和更高版有不同的“纯”C(icc)驱动程序和C++(icpc)驱动程序；如果你使用icc8.0版本或较早的版本来构建MySQL，需要设置CXX=icc。

·Linux 2.4.xx Intel Itanium 2中的ecc(Intel C++ Itanium Compiler 7.0)：

CC=ecc CFLAGS="-O2

-tpp2 -ip -nolib_inline" CXX=ecc CXXFLAGS="-O2 -tpp2 -ip -nolib_inline"

./configure --prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

·Linux 2.4.xx Intel Itanium中的ecc(Intel

C++ Itanium Compiler 7.0)：

CC=ecc CFLAGS=-tpp1

CXX=ecc CXXFLAGS=-tpp1 ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile

·Linux 2.4.xx alpha中的ccc(Compaq

C V6.2-505 / Compaq C++ V6.3-006)：

CC=ccc CFLAGS="-fast

-arch generic" CXX=cxx CXXFLAGS="-fast -arch generic -noexceptions

-nortti" ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile --with-mysqld-ldflags=-non_shared

--with-client-ldflags=-non_shared --disable-shared

·Linux 2.x.xx ppc中的gcc2.95.4：

CC=gcc CFLAGS="-O3

-fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3 -fno-omit-frame-pointer

-felide-constructors -fno-exceptions -fno-rtti" ./configure

--prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data

--libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--disable-shared --with-embedded-server --with-innodb

·Linux 2.4.xx s390中的gcc2.95.3：

CFLAGS="-O2"

CXX=gcc CXXFLAGS="-O2 -felide-constructors" ./configure

--prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--disable-shared --with-client-ldflags=-all-static

--with-mysqld-ldflags=-all-static

·Linux 2.4.xx x86_64(AMD64)中的gcc3.2.1：

CXX=gcc

./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --disable-shared

·Sun Solaris 8 x86中的gcc3.2.3：

CC=gcc CFLAGS="-O3

-fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3

-fno-omit-frame-pointer -felide-constructors -fno-exceptions

-fno-rtti" ./configure --prefix=/usr/local/mysql

--localstatedir=/usr/local/mysql/data

--libexecdir=/usr/local/mysql/bin

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --disable-shared --with-inno

·Sun Solaris 8 SPARC中的gcc3.2：

CC=gcc CFLAGS="-O3

-fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3

-fno-omit-frame-pointer -felide-constructors -fno-exceptions

-fno-rtti" ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --enable-assembler

--with-named-z-libs=no --with-named-curses-libs=-lcurses

--disable-shared

·Sun Solaris 8 SPARC 64-bit中的gcc3.2：

CC=gcc CFLAGS="-O3

-m64 -fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3 -m64

-fno-omit-frame-pointer -felide-constructors -fno-exceptions

-fno-rtti" ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --with-named-z-libs=no

--with-named-curses-libs=-lcurses --disable-shared

·Sun Solaris 9 SPARC中的gcc2.95.3：

CC=gcc CFLAGS="-O3

-fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3 -fno-omit-frame-pointer

-felide-constructors -fno-exceptions -fno-rtti" ./configure

--prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--enable-assembler --with-named-curses-libs=-lcurses

--disable-shared

·Sun Solaris 9 SPARC中的cc-5.0(Sun

Forte 5.0)：

CC=cc-5.0 CXX=CC

ASFLAGS="-xarch=v9" CFLAGS="-Xa -xstrconst -mt -D_FORTEC_ -xarch=v9"

CXXFLAGS="-noex -mt -D_FORTEC_ -xarch=v9" ./configure

--prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--enable-assembler --with-named-z-libs=no

--enable-thread-safe-client --disable-shared

·IBM AIX 4.3.2 ppc中的gcc3.2.3：

CFLAGS="-O2

-mcpu=powerpc -Wa,-many " CXX=gcc CXXFLAGS="-O2

-mcpu=powerpc -Wa,-many -felide-constructors -fno-exceptions

-fno-rtti" ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --with-named-z-libs=no

--disable-shared

·IBM AIX 4.3.3 ppc中的xlC_r(IBM

Visual Age C/C++ 6.0)：

CC=xlc_r

CFLAGS="-ma -O2 -qstrict -qoptimize=2 -qmaxmem=8192"

CXX=xlC_r CXXFLAGS ="-ma -O2 -qstrict -qoptimize=2

-qmaxmem=8192" ./configure --prefix=/usr/local/mysql

--localstatedir=/usr/local/mysql/data

--libexecdir=/usr/local/mysql/bin

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --with-named-z-libs=no

--disable-shared --with-innodb

·IBM AIX 5.1.0 ppc中的gcc3.3：

CFLAGS="-O2

-mcpu=powerpc -Wa,-many" CXX=gcc CXXFLAGS="-O2 -mcpu=powerpc

-Wa,-many -felide-constructors -fno-exceptions -fno-rtti"

./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --with-named-z-libs=no

--disable-shared

·IBM AIX 5.2.0 ppc中的xlC_r(IBM

Visual Age C/C++ 6.0)：

CC=xlc_r CFLAGS="-ma

-O2 -qstrict -qoptimize=2 -qmaxmem=8192" CXX=xlC_r CXXFLAGS="-ma

-O2 -qstrict -qoptimize=2 -qmaxmem=8192" ./configure

--prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data

--libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--with-named-z-libs=no --disable-shared

--with-embedded-server --with-innodb

·HP-UX 10.20 pa-risc1.1中的gcc3.1：

CFLAGS="-DHPUX

-I/opt/dce/include -O3 -fPIC" CXX=gcc CXXFLAGS="-DHPUX

-I/opt/dce /include -felide-constructors -fno-exceptions -fno-rtti

-O3 -fPIC" ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --with-pthread --with-named-thread-libs=-ldce

--with-lib-ccflags=-fPIC --disable-shared

·HP-UX 11.00 pa-risc中的aCC(HP

ANSI C++ B3910B A.03.50)：

CC=cc CXX=aCC

CFLAGS=+DAportable CXXFLAGS=+DAportable ./configure

--prefix=/usr/local/mysql

--localstatedir=/usr/local/mysql/data

--libexecdir=/usr/local/mysql/bin

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --disable-shared

--with-embedded-server --with-innodb

·HP-UX 11.11 pa-risc2.0 64bit中的aCC(HP

ANSI C++ B3910B A.03.33)：

CC=cc CXX=aCC

CFLAGS=+DD64 CXXFLAGS=+DD64 ./configure

--prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--disable-shared

·HP-UX 11.11 pa-risc2.0 32bit中的aCC(HP

ANSI C++ B3910B A.03.33)：

CC=cc CXX=aCC

CFLAGS="+DAportable" CXXFLAGS="+DAportable" ./configure

--prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data

--libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--disable-shared --with-innodb

·HP-UX 11.22 ia64 64bit中的aCC(HP

aC++/ANSI C B3910B A.05.50)：

CC=cc CXX=aCC

CFLAGS="+DD64 +DSitanium2" CXXFLAGS="+DD64 +DSitanium2"

./configure --prefix=/usr/local/mysql

--localstatedir=/usr/local/mysql/data

--libexecdir=/usr/local/mysql/bin

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --disable-shared

--with-embedded-server --with-innodb

·Apple Mac OS X 10.2 powerpc中的gcc3.1：

CC=gcc CFLAGS="-O3

-fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3

-fno-omit-frame-pointer -felide-constructors -fno-exceptions

-fno-rtti" ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --disable-shared

·FreeBSD 4.7 i386中的gcc2.95.4：

CFLAGS=-DHAVE_BROKEN_REALPATH ./configure

--prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--enable-assembler --with-named-z-libs=not-used

--disable-shared

·使用LinuxThreads的FreeBSD

4.7 i386中的gcc2.95.4：

CFLAGS="-DHAVE_BROKEN_REALPATH

-D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads"

CXXFLAGS="-DHAVE_BROKEN_REALPATH -D__USE_UNIX98 -D_REENTRANT

-D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads"

./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data

--libexecdir=/usr/local/mysql/bin

--enable-thread-safe-client --enable-local-infile

--enable-assembler --with-named-thread-libs="-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R

-D_THREAD_SAFE -I /usr/local/include/pthread/linuxthreads

-L/usr/local/lib -llthread -llgcc_r" --disable-shared

--with-embedded-server --with-innodb

·QNX Neutrino 6.2.1 i386中的gcc2.95.3qnx-nto 20010315：

CC=gcc CFLAGS="-O3

-fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3 -fno-omit-frame-pointer

-felide-constructors -fno-exceptions -fno-rtti" ./configure

--prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--disable-shared

下面的二进制是在由其它用户提供给MySQL AB的第三方系统上构建而成。这是免费赠送；MySQL

AB没有完全控制这些系统，因此我们只能对在这些系统上构建的二进制提供有限的支持。

·

SCO Unix 3.2v5.0.7 i386中的gcc2.95.3:

CFLAGS="-O3

-mpentium" LDFLAGS=-static CXX=gcc CXXFLAGS="-O3 -mpentium

-felide-constructors" ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --with-named-z-libs=no

--enable-thread-safe-client --disable-shared

·SCO UnixWare 7.1.4 i386中的CC3.2:

CC=cc CFLAGS="-O"

CXX=CC ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --with-named-z-libs=no

--enable-thread-safe-client --disable-shared --with-readline

·CO OpenServer 6.0.0 i386中的CC3.2:

CC=cc CFLAGS="-O"

CXX=CC ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--with-named-z-libs=no --enable-thread-safe-client

--disable-shared --with-readline

·Compaq Tru64 OSF/1 V5.1 732

alpha中的cc/cxx(Compaq

C V6.3-029i / DIGITAL C++ V6.1-027):

CC="cc -pthread"

CFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed

-speculate all" CXX="cxx -pthread" CXXFLAGS="-O4 -ansi_alias

-fast -inline speed -speculate all -noexceptions -nortti"

./configure --prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--with-named-thread-libs="-lpthread -lmach -lexc -lc"

--disable-shared --with-mysqld-ldflags=-all-static

·

SGI Irix 6.5 IP32中的gcc3.0.1:

CC=gcc CFLAGS="-O3

-fno-omit-frame-pointer" CXXFLAGS="-O3

-fno-omit-frame-pointer -felide-constructors -fno-exceptions

-fno-rtti" ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --disable-shared

·FreeBSD/sparc64 5.0中的gcc3.2.1:

CFLAGS=-DHAVE_BROKEN_REALPATH ./configure

--prefix=/usr/local/mysql

--localstatedir=/usr/local/mysql/data

--libexecdir=/usr/local/mysql/bin

--with-extra-charsets=complex --enable-thread-safe-client

--enable-local-infile --disable-shared --with-innodb

在MySQL AB过去提供的二进制软件包中应用了下面的编译选项。这些二进制不再进行更新，但是在这里列出了这些编译选项供参考。

·

Linux 2.2.xx SPARC中的egcs1.1.2:

CC=gcc CFLAGS="-O3

-fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3 -fno-omit-frame-pointer

-felide-constructors -fno-exceptions -fno-rtti" ./configure

--prefix=/usr/local/mysql --with-extra-charsets=complex

--enable-thread-safe-client --enable-local-infile

--enable-assembler --disable-shared

·Linux 2.2.x x686中的gcc2.95.2:

CFLAGS="-O3 -mpentiumpro"

CXX=gcc CXXFLAGS="-O3 -mpentiumpro -felide-constructors -fno-exceptions

-fno-rtti" ./configure --prefix=/usr/local/mysql

--enable-assembler --with-mysqld-ldflags=-all-static

--disable-shared --with-extra-charsets=complex

·SunOS 4.1.4 2 sun4c中的gcc2.7.2.1:

CC=gcc CXX=gcc

CXXFLAGS="-O3 -felide-constructors" ./configure --prefix=/usr/local/mysql

--disable-shared --with-extra-charsets=complex

--enable-assembler

·SunOS 5.5.1(及以上版本)sun4u中的egcs1.0.3a或2.90.27或gcc2.95.2和更新版:

·

CC=gcc CFLAGS="-O3"

CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"

./configure --prefix=/usr/local/mysql --with-low-memory

--with-extra-charsets=complex --enable-assembler

·SunOS 5.6 i86pc中的gcc2.8.1:

CC=gcc CXX=gcc

CXXFLAGS=-O3 ./configure --prefix=/usr/local/mysql

--with-low-memory --with-extra-charsets=complex

·BSDI BSD/OS 3.1 i386中的gcc2.7.2.1:

CC=gcc CXX=gcc

CXXFLAGS=-O ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex

·BSDI BSD/OS 2.1 i386中的gcc2.7.2:

CC=gcc CXX=gcc

CXXFLAGS=-O3 ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex

·AIX 4.2中的gcc2.7.2.2：

CC=gcc CXX=gcc

CXXFLAGS=-O3 ./configure --prefix=/usr/local/mysql

--with-extra-charsets=complex

如果你有更好的上述配置选项，可以向MySQL

internals邮件列表发送邮件。请参见1.7.1.1节，“The MySQL邮件列表”。

在我们的站点中列出的MySQL 5.1发布的RPM分发版是由MySQL

AB产生的。

如果你想要编译MySQL调试版本，应当在前面的configure命令中加上--with-debug或--with-debug=full，并去掉-fomit-frame-pointer选项。