MySQL 编译参数说明
安装MySQL 安装前确认以下包已经装好gcc gcc-c++ ncurses-devel
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
tar zxvf mysql-5.4.0-beta.tar.gz
cd mysql-5.4.0-beta
CFLAGS=”-O6 -mpentiumpro -fomit-frame-pointer” CXX=gcc CXXFLAGS=”-O6 -mpentiumpro -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti”
./configure –prefix=/usr/local/mysql –localstatedir=/usr/local/mysql/var/ –with-server-suffix=-enterprise-gpl –without-debug –with-big-tables –with-extra-charsets=latin1,gb2312,big5,utf8,GBK –with-extra-charsets=all –with-pthread –enable-static –enable-thread-safe-client –with-client-ldflags=-all-static –with-mysqld-ldflags=-all-static –enable-assembler –without-innodb –without-ndb-debug –without-isam –with-federated-storage-engine
make && make install
cp support-files/my-medium.cnf /usr/local/mysql/my.cnf
/usr/local/mysql/bin/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data –user=mysql
?my.cnf文件记得注销–skip-federated引擎功能再启动mysql
?./mysqld_safe –defaults-file=/usr/local/mysql/my.cnf –user=mysql &
?
mysql编译参数说明:根据 ./configure –help 查看支持配置的参数
?
-pgcc和-O6编译
CFLAGS=”-O6 -mpentiumpro -fomit-frame-pointer” CXX=gcc CXXFLAGS=”-O6 -mpentiumpro -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti”
总体性能可提高10%,当然如果服务器不是用奔腾处理器,就不必用它了,因为它是专为奔腾系统设计的
?
-static静态编译
–enable-static
–with-client-ldflags=-all-static
–with-mysqld-ldflags=-all-static
以静态方式编译客户端和服务端,能提高13%性能
?
–enable-thread-safe-client
以线程方式编译客户端
?
–without-innodb
去掉innodb表支持,innodb是一种支持事务处理的表,适合企业级应用
?
–without-isam
去掉isam表类型支持,现在很少用了,isam表是一种依赖平台的表
?
–without-ndb-debug
取消导航调试
?
–localstatedir=/usr/local/mysql/var/
日志文件目录
?
–with-server-suffix=-enterprise-gpl
给MySQL加个后缀名,在用mysql登录的时候在版本号的后面可以看到
?
–without-debug
去除诊断模式,如果用–with-debug=full编译,大多数查询慢20%
?
–with-big-tables
大表支持
?
–with-extra-charsers=gbk,gb2312,utf8
设置支持gbk,gb2312,utf8字符集
?
–with-pthread
强制使用pthread库(posix线程库)
?
–enable-assembler
使用一些字符函数来汇编版本
?
–with-federated-storage-engine
这个参数已经被废除,代替它的是–with-plugin系列
?
cp support-files/my-medium.cnf /usr/local/mysql/my.cnf
mysql/support-files里面有配置文件范本,根据实际情