一、安装jemalloc,参考链接
jemalloc编译安装_m0_61237221的博客-CSDN博客
https://blog.csdn.net/m0_61237221/article/details/122023459二、配置软链接
ln -s /usr/local/lib/libjemalloc.so.2 /usr/lib64/libjemalloc.so.1
如果不配置会报错,无法正常启动mysql
Starting MySQL. mysqld_safe --malloc-lib must be located in one of the directories: /usr/lib /usr/lib64 /usr/lib/i386-linux-gnu /usr/lib/x86_64-linux-gnu ERROR! The server quit without updating PID file (/usr/local/mysql/run/mysql.pid). |
三、编辑/etc/my.cnf的[mysqld_safe]
添加malloc-lib=/usr/lib64/libjemalloc.so.1 如下:
[mysqld_safe]
malloc-lib=/usr/lib64/libjemalloc.so.1
四、重启mysql并验证是否生效
service mysqld restart
查看 jemalloc 是否生效:
lsof -n |grep jemalloc|grep mysql
![](https://img8.php1.cn/3cdc5/12d1d/a6e/f74038b49a23812e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5ZGo5piT5LiN5piT,size_20,color_FFFFFF,t_70,g_se,x_16)