step 1. 因为是64位的系统,所以先要安装libunwind,32位系统可以忽略此步
wget http://download.savannah.gnu.org/releases/libunwind/libunwind-1.1.tar.gztar xvzf libunwind-1.1.tar.gz cd libunwind-1.1/CFLAGS=-fPIC ./configure --enable-sharedmakeCFLAGS=-fPICsudomakeCFLAGS=-fPIC install
step 2.安装Google Performance Tools
wget http://gperftools.googlecode.com/files/gperftools-2.0.tar.gztar xvzf gperftools-2.0.tar.gz cd gperftools-2.0/./configure --prefix=/usr/local/gperftoolsmake-j8sudomakeinstallsudo-isudoecho"/usr/local/gperftools/lib">/etc/ld.so.conf.d/usr_local_gperftools_lib.conf/sbin/ldconfig
step 3. 安装MySQL
tar xvzf mysql-5.5.29.tar.gz sudo groupadd mysqlsudo useradd -r-g mysql mysqlcd mysql-5.5.29/./configure --prefix=/usr/local/mysqlcmake .makesudomakeinstallcd/usr/local/mysqlsudochown-R mysql .sudochgrp-R mysql .sudo scripts/mysql_install_db --user=mysqlsudochown-R root .sudochown-R mysql datasudocp support-files/my-medium.cnf /etc/my.cnfsudo bin/mysqld_safe --user=mysql &sudocp support-files/mysql.server /etc/init.d/mysql.server
以后就可以使用/etc/init.d/mysql.server start来启动MySQL
step 4. 配置Google Performance Tools
sudovim/usr/local/mysql/bin/mysqld_safe
在# executing mysqld_safe的下一行,加上:export LD_PRELOAD=/usr/local/gperftools/lib/libtcmalloc.so重启MySQL后,输入下面命令来检测是否配置成功
sudo lsof -n|grep tcmallocmysqld 1315213171 mysql mem REG 8,7243196929363754/usr/local/gperftools/lib/libtcmalloc.so.4.1.0
如果看到上述的一行,就证明配置成功了。
原文地址:ubuntu server下使用Google Performance Tools优化MySQL性能, 感谢原作者分享。 我想去旅行,一个人背包,一个人旅行,