MySQL 5.5 编译详解,之前MySQL的编译选项大多数都支持。新旧版本之间的安装选项映射成大写字母，删除选项前面破折号，中间字符间
命令参数
系统环境：CentOS 5.7 x86_64
一、安装简介
用户名：mysql
安装目录：/usr/local/mysql-5.5.20
数据库目录：/data/mysql/data
源码包：mysql-5.5.21.tar.gz
自动部署脚本可在 下载
二、安装准备
/data/mysql
下载源码包
wget ://mirror.services.wisc.edu/mysql/ -P /usr/local/src
这本书给出了一份关于python这门优美语言的精要的参考。作者通过一个完整而清晰的入门指引将你带入python的乐园，随后在语法、类型和对象、运算符与表达式、控制流函数与函数编程、类及面向对象编程、模块和包、输入输出、执行环境等多方面给出了详尽的讲解。如果你想加入 python的世界，David M beazley的这本书可不要错过哦。 (封面是最新英文版的,中文版貌似只译到第二版)
三、编译安装
mysql-5.5.21
注：详细参数见下文补充内容。
&& make install
注：-j 用来指定CPU核心数，可加快编译速度，，不加也可以。
/usr/local/mysql-5.5.21/
on
/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/
/etc/profile
configure Command
CMake Command
./configure
cmake .
./configure --help
cmake . -LH or ccmake .
补充：
从mysql5.5起，mysql源码安装开始使用cmake。下面是 mysql 5.5 与以前的参数对照：
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
