命令参数
系统环境：CentOS 5.7 x86_64
A、安装简介
用户名：mysql
安装目录：/usr/local/mysql-5.5.20
数据库目录：/data/mysql/data
源码包：mysql-5.5.21.tar.gz
自动部署脚本可在 下载
B、安装准备
/data/mysql
下载源码包
wget ://mirror.services.wisc.edu/mysql/ -P /usr/local/src
C、编译安装
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
补充：
从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