mysql 5.5的libmysql_MySQL 5.5 编译详解

说明：蓝色=命令名称

浅绿=命令参数

浅蓝=选项

紫色=目录

系统环境：CentOS  5.7 x86_64

一、安装简介

用户名：：/usr/local/mysql-5.5.20数据库目录：/data/mysql/data源码包：mysql-5.5.21.tar.gz

二、安装准备

添加用户

useradd -s/sbin/nologin mysql

建立所需目录

mkdir-p/data/mysql/datachown -R mysql:mysql/data/mysql

安装编译所需文件或程序

yuminstallgcc gcc-c++ cmake  ncurses-devel bison

下载源码包

wgethttp://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.21.tar.gz/from/http://mirror.services.wisc.edu/mysql/  -P/usr/local/src

三、编译安装

cd/usr/local/srctarxvf mysql-5.5.21.tar.gzcdmysql-5.5.21

CFLAGS="-O3" CXX=gccCXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"cmake-DMYSQL_USER=mysql \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5.21 \

-DMYSQL_DATADIR=/data/mysql/data \

-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \

-DEXTRA_CHARSETS=all \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_EMBEDDED_SERVER=1  \

-DWITH_DEBUG=0注：详细参数见下文补充内容。

make-j2 && make install注：-j 用来指定CPU核心数，可加快编译速度，不加也可以。

chown-R mysql:mysql/usr/local/mysql-5.5.21/

mv/usr/local/src/mysql-5.5.21/support-files/my-large.cnf /etc/my.cnf注:在/usr/local/src/mysql-5.5.21/support-files/文件夹中有多个my-****.cnf 配置文件，具体用那一个配置文件根据自己实际情况。可以通过查看配置文件的头部信息来了解配置问价适合的配置。例如[root@localhost support-files]# head /usr/local/src/mysql-5.5.21/support-files/my-huge.cnf

# Example MySQL config file for very large systems.

#

# This is for a large system with memory of 1G-2G where the system runs mainly

# MySQL.

mv/usr/local/src/mysql-5.5.21/support-files/mysql.server /etc/init.d/mysqldchmod+x/etc/init.d/mysqldchkconfig--level 345mysqldon

/usr/local/mysql-5.5.21/scripts/mysql_install_db--user=mysql \

--defaults-file=/etc/my.cnf \

--basedir=/usr/local/mysql-5.5.21/ \

--datadir=/data/mysql/data/

echo"export PATH=/usr/local/mysql-5.5.21/bin:$PATH">>/etc/profilesource/etc/profile

补充：

从mysql5.5起，mysql源码安装开始使用cmake。下面是 mysql 5.5 与以前的参数对照：configure Command

CMake Command

./configure

cmake .

./configure --help

cmake . -LH or ccmake .

Parameter

configure Option

CMake Option

CMake Notes

Installation base directory

--prefix=/usr

-DCMAKE_INSTALL_PREFIX=/usr

mysqld directory

--libexecdir=/usr/sbin

-DINSTALL_SBINDIR=sbin

interpreted relative to prefix

Data directory

--localstatedir=/var/lib/mysql

-DMYSQL_DATADIR=/var/lib/mysql

Config directory (for my.cnf)

--sysconfdir=/etc/mysql

-DSYSCONFDIR=/etc/mysql

Plugin directory

--with-plugindir=/usr/lib64/mysql/plugin

-DINSTALL_PLUGINDIR=lib64/mysql/plugin

interpreted relative to prefix

Man page directory

--mandir=/usr/share/man

-DINSTALL_MANDIR=share/man

interpreted relative to prefix

Shared-data directory

--sharedstatedir=/usr/share/mysql

-DINSTALL_SHAREDIR=share

this is where aclocal/mysql.m4 should be installed

Library installation directory

--libdir=/usr/lib64/mysql

-DINSTALL_LIBDIR=lib64/mysql

interpreted relative to prefix

Header installation directory

--includedir=/usr/include/mysql

-DINSTALL_INCLUDEDIR=include/mysql

interpreted relative to prefix

Info doc directory

--infodir=/usr/share/info

-DINSTALL_INFODIR=share/info

interpreted relative to prefix

Parameter

configure Option

CMake Option

CMake Notes

readline library

--with-readline

-DWITH_READLINE=1

SSL library

--with-ssl=/usr

-DWITH_SSL=system

zlib library

--with-zlib-dir=/usr

-DWITH_ZLIB=system

libwrap library

--without-libwrap

-DWITH_LIBWRAP=0

Parameter

configure Option

CMake Option

CMake Notes

TCP/IP port number

--with-tcp-port-=3306

-DMYSQL_TCP_PORT=3306

UNIX socket file

--with-unix-socket-path=/tmp/mysqld.sock

-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock

Enable LOCAL for LOAD DATA

--enable-local-infile

-DENABLED_LOCAL_INFILE=1

Extra charsets

--with-extra-charsets=all

-DEXTRA_CHARSETS=all

default is "all"

Default charset

--with-charset=utf8

-DDEFAULT_CHARSET=utf8

Default collation

--with-collation=utf8_general_ci

-DDEFAULT_COLLATION=utf8_general_ci

Build the server

--with-server

none

Build the embedded server

--with-embedded-server

-DWITH_EMBEDDED_SERVER=1

libmysqld privilege control

--with-embedded-privilege-control

none

always enabled?

Install the documentation

--without-docs

none

Big tables

--with-big-tables, --without-big-tables

none

tables are big by default

mysqld user

--with-mysqld-user=mysql

-DMYSQL_USER=mysql

mysql is the default

Debugging

--without-debug

-DWITH_DEBUG=0

default is debugging disabled

GIS support

--with-geometry

none

always enabled?

Community features

--enable-community-features

none

always enabled

Profiling

--disable-profiling

-DENABLE_PROFILING=0

enabled by default

pstack

--without-pstack

none

pstack is removed

Assembler string functions

--enable-assembler

none

Build type

--build=x86_64-pc-linux-gnu

no equivalent

unneeded?

Cross-compile host

--host=x86_64-pc-linux-gnu

no equivalent

unneeded?

Client flag

--with-client-ldflags=-lstdc++

none

unneeded

Client flag

--enable-thread-safe-client

none

unneeded, clients are always thread safe

Comment

--with-comment='string'

-DWITH_COMMENT='string'

Shared/static binaries

--enable-shared --enable-static

none

there is only DISABLE_SHARED

Memory use

--with-low-memory

none

unneeded