mysql安装优化参数.docVIP

Mysql编译安装参数优化 Mysql编译安装参数优化关键字: mysql compile 1. -static? 13% --with-client-ldflags -all-static?? --with-mysqld-ldflags -all-static静态链接提高13%性能2. -pgcc? 1%?? CFLAGS -O3 -mpentiumpro -mstack-align-double CXX gcc \ CXXFLAGS -O3 -mpentiumpro -mstack-align-double \ -felide-constructors -fno-exceptions -fno-rtti如果是Inter处理器，使用pgcc提高1%性能3. Unix Socket? 7.5%?? --with-unix-socket-path /usr/local/mysql/tmp/mysql.sock使用unix套接字链接提高7.5%性能，所以在windows下mysql性能肯定不如unix下面4. --enable-assembler 允许使用汇编模式 优化性能 ??下面是总体的编译文件 编译代码 CFLAGS -O3?CXX gcc?CXXFLAGS -O3?-felide-constructors?\ -fno-exceptions?-fno-rtti?-fomit-frame-pointer?-ffixed-ebp ./configure?\ --prefix /usr/local/mysql?--enable-assembler?\ --with-mysqld-ldflags -all-static --with-client-ldflags -all-static --with-unix-socket-path /usr/local/mysql/tmp/mysql.sock --with-charset utf8 --with-collation utf8_general_ci --with-extra-charsets all mysql编译安装 2007年03月19日 下午 05:42 安装mysql # tar zxvf mysql-4.0.14.tar.gz -C /setup # cd /setup/mysql-4.0.14 # groupadd mysql 2、编译安装MySQL 5.0.45/Mysql4.0.26（现在以mysql5为例） /usr/sbin/groupadd mysql/usr/sbin/useradd -g mysql mysqltar zxvf mysql-5.0.45.tar.gzcd mysql-5.0.45./configure –prefix /usr/local/webserver/mysql/ –without-debug –with-unix-socket-path /tmp/mysql.sock –with-client-ldflags -all-static –with-mysqld-ldflags -all-static –enable-assembler –with-extra-charsets gbk,gb2312,utf8 –with-pthread –enable-thread-safe-clientmake make installchmod +w /usr/local/webserver/mysqlchown -R mysql:mysql /usr/local/webserver/mysqlcp support-files/my-medium.cnf /usr/local/webserver/mysql/my.cnfcd ../ 附：以下为附加步骤，如果你想在这台服务器上运行MySQL数据库，则执行以下两步。如果你只是希望让PHP支持MySQL扩展库，能够连接其他服务器上的MySQL数据库，那么，以下两步无需执行。①、以mysql用户帐号的身份建立数据表： /usr/local/webserver/mysql/bin/mysql_install_db –defaults-file /usr/local/webserver/mysql/my.cnf –basedir /usr/local/webserver/mysql –datadir /usr/local/webserver/mysql/data –user mysql –pid-file /usr/local/webserver/mysql/mysql.pid –skip-locking –port 3306 –socket /t