Comments on: Enabling and Disabling Jemalloc on Percona Server

By: geyilat696

geyilat696 — Wed, 22 Jan 2020 00:19:23 +0000

Is it tutorial actual for MySQL 8.0 ?
Looks like not for me.

root@server:~# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 18.04.3 LTS
Release: 18.04

root@server:~# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 33
Server version: 8.0.18-9 Percona Server (GPL), Release ‘9’, Revision ’53e606f’

root@server:~# apt-cache search jemalloc
libjemalloc-dev – development files and documentation for jemalloc
libjemalloc1 – general-purpose scalable concurrent malloc(3) implementation

root@server:~# dpkg -L libjemalloc1
/.
/usr
/usr/lib
/usr/lib/x86_64-linux-gnu
/usr/lib/x86_64-linux-gnu/libjemalloc.so.1
/usr/share
/usr/share/doc
/usr/share/doc/libjemalloc1
/usr/share/doc/libjemalloc1/README
/usr/share/doc/libjemalloc1/changelog.Debian.gz
/usr/share/doc/libjemalloc1/copyright

root@server:~# cat /etc/sysconfig/mysql
LD_PRELOAD=/usr/lib/x86_64-linux-gnu/libjemalloc.so.1

root@server:~# sudo /etc/init.d/mysql start
[ ok ] Starting mysql (via systemctl): mysql.service.

root@server:~# pt-mysql-summary –ask-pass | grep -A5 -i “memory management”
# Memory management library ##################################
jemalloc is not enabled in mysql config for process with id 1079
# The End ####################################################

By: Daniel Guzmán Burgos

Daniel Guzmán Burgos — Wed, 15 Jan 2020 19:27:11 +0000

For systemd the procedure is different:

After installing the jemalloc package, add the line:

LD_PRELOAD=/usr/lib64/libjemalloc.so.1 #(or whatever is the path of the jemalloc library)

Inside the file /etc/sysconfig/mysql (if it doesn’t exist, create it)
And restart.

By: GravatarRei

GravatarRei — Fri, 09 Aug 2019 04:16:19 +0000

In reply to Lee. use the stable version like jemmalloc 3.6.0-11 (from apt-get install libjemmaloc1)

By: Lee

Lee — Thu, 27 Sep 2018 01:51:19 +0000

I am using mysql-5.7.22 and 23, these two versions, using jemalloc-5.1, combined with MTS, there will be a problem with the memory leak, after the jemalloc is disabled, the memory usage is normal.

By: Olivier Doucet

Olivier Doucet — Mon, 24 Apr 2017 15:19:26 +0000

Please note that this requires Percona Toolkit 3.0+ 😉

By: Daniel Guzmán Burgos

Daniel Guzmán Burgos — Fri, 06 Jan 2017 14:06:19 +0000

In reply to Seveny Media. Hi! Yes, you're right. For apt the package name is libjemalloc1. I'll fix the post. Thanks for catching it up!

By: Seveny Media

Seveny Media — Thu, 05 Jan 2017 21:39:06 +0000

Running Persona Server 5.7 here and wasn’t able to find a package called ‘jemalloc’

# apt-cache search jemalloc
libjemalloc-dev – development files and documentation for jemalloc
libjemalloc1 – general-purpose scalable concurrent malloc(3) implementation
libjemalloc1-dbg – debug symbols for jemalloc

Installed ‘libjemalloc1’ and it works perfectly:

# pt-mysql-summary | grep -A5 -i “memory management”
# Memory management library ##################################
jemalloc enabled in MySQL config for process with ID 24470
Using jemalloc from /usr/lib/x86_64-linux-gnu/libjemalloc.so.1
# The End ####################################################