Board logo

标题: MariaDB10.3使用Jemalloc [打印本页]
作者: admin    时间: 2021-9-3 16:40     标题: MariaDB10.3使用Jemalloc

MariaDB的安装可参考：CentOS8安装LNMP+phpMyAdmin 查看MariaDB的版本： [root@centos8 ~]# mysql -V mysql Ver 15.1 Distrib 10.3.17-MariaDB, for Linux (x86_64) using readline 5.1 先安装软件依赖包： [root@centos8 ~]# dnf -y install bzip2 gcc-c++ make lsof 安装Jemalloc： [root@centos8 ~]# tar -jxf jemalloc-5.2.1.tar.bz2 [root@centos8 ~]# cd jemalloc-5.2.1 [root@centos8 jemalloc-5.2.1]# ./configure [root@centos8 jemalloc-5.2.1]# make && make install [root@centos8 jemalloc-5.2.1]# ldconfig [root@centos8 jemalloc-5.2.1]# ln -sf /usr/local/lib/libjemalloc* /usr/lib/ [root@centos8 ~]# find / -name "mariadb.service" /sys/fs/cgroup/memory/system.slice/mariadb.service /sys/fs/cgroup/pids/system.slice/mariadb.service /sys/fs/cgroup/systemd/system.slice/mariadb.service /etc/systemd/system/multi-user.target.wants/mariadb.service /usr/lib/systemd/system/mariadb.service /usr/share/mariadb/systemd/mariadb.service [root@centos8 ~]# vi /usr/lib/systemd/system/mariadb.service 在 [Service] 下面插入： Environment="LD_PRELOAD=/usr/lib/libjemalloc.so" [root@centos8 ~]# systemctl daemon-reload [root@centos8 ~]# systemctl restart mariadb 验证MariaDB是否使用了Jemalloc： [root@centos8 ~]# lsof -n |grep jemalloc mysqld 1347 mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1395 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1416 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1417 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1418 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1419 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1420 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1421 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1422 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1423 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1424 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1425 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1426 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1453 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1454 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1455 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1456 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1457 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1460 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1461 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1462 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1463 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1464 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1467 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1468 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1469 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1470 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1477 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1483 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 mysqld 1347 1493 mysqld mysql mem REG 253,0 6123808 201799170 /usr/local/lib/libjemalloc.so.2 相关文章： MariaDB5.5使用Jemalloc，可参考：CentOS8_lnmp1.7_LNMPA_安装Cacti MySQL8.0使用Jemalloc，可参考：MySQL8.0使用Jemalloc



欢迎光临 blog.zhuohua.store (http://blog.zhuohua.store/) Powered by Discuz! 7.2