1. 下载mysql的源码包,进行编译安装(略) 2. 下载安装google-perftools
3. 64位的系统需要安装libunwind软件包
1
2
3
4
5
| tar zxvf libunwind-0.99.tar.gz
cd libunwind-0.99
CFLAGS=-fPIC ./configure --enable-shared
make CFLAGS=-fPIC
make CFLAGS=-fPIC install
|
4. 安装google-perftools软件包
1
2
3
4
5
| tar zxvf google-perftools-1.7.tar.gz
cd google-perftools-1.7
mkdir /work/tc
./configure --prefix=/work/tc --disable-cpu-profiler --disable-heap-profiler--disable-heap-checker --disable-debugalloc --enable-minimal
make && make install
|
5. 复制动态链接库到系统目录
1
2
3
4
| cp /work/tc/lib/libtcmalloc_minimal.so.0.1.0 /usr/local/lib
ln -s /usr/local/lib/libtcmalloc_minimal.so.0.1.0 /usr/local/lib/libtcmalloc.so
ln -s /usr/local/lib/libtcmalloc_minimal.so.0.1.0 /usr/local/lib/libtcmalloc.so.0
ln -s /usr/local/lib/libtcmalloc_minimal.so.0.1.0 /usr/local/lib/libtcmalloc.so.0.1.0
|
6. 调整mysqld_safe配置文件
1
| vim /work/mysql5.5/bin/mysqld_safe
|
在此行文件的后面添加:
1
2
| # executing mysqld_safe
exportLD_PRELOAD="/usr/local/lib/libtcmalloc.so"
|
7. 重启mysql
1
| /etc/init.d/mysql restart
|
8. 验证
1
2
3
| [iyunv@localhost ~]# lsof -n | greptcmalloc
mysqld 17895 mysql mem REG 253,0 962769 534587 /usr/local/lib/libtcmalloc_minimal.so.0.1.0
[iyunv@localhost ~]#
|
|