MySQL启用 jemalloc

1、安装操作系统基本组件

yum install bzip2 autoconf make automake gcc c++ -y

2、下载软件

wget https://github.com/jemalloc/jemalloc/releases/download/5.3.0/jemalloc-5.3.0.tar.bz2

3、编译安装

tar xjvf jemalloc-5.3.0.tar.bz2
cd jemalloc-5.3.0
./autogen.sh
./configure
make -j 4
make install

4、启用jemalloc

--声明库文件
cat >> /etc/sysconfig/mysql <<EOF
LD_PRELOAD=/usr/local/lib/libjemalloc.so
EOF

--mysql启动文件引用

vim /etc/systemd/system/mysql_3306.service

EnvironmentFile=-/etc/sysconfig/mysql


--重新启动MySQL
systemctl restart mysql_3306

5、验证jemalloc

[root@test ~]# lsof -p `netstat -nlpt |grep 3306|awk '{print $NF}'|awk -F'/' '{print $1}'` |grep jemalloc
mysqld  31661 mysql  mem    REG              253,1    4397688   4215752 /usr/local/lib/libjemalloc.so.2


[root@test ~]# lsof -Pn -p $(pidof mysqld) | grep jemalloc
mysqld  31661 mysql  mem    REG              253,1    4397688   4215752 /usr/local/lib/libjemalloc.so.2