Enabling jemalloc on Percona Server for MySQL 5.7 and 8.0 Series

jemalloc on Percona Server for MySQLThe benefits of jemalloc versus glibc memory allocator for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) there is less memory fragmentation, and thus more efficient resource management of the server memory. For MySQL 5.6, installing jemalloc is enough to enable it when starting the MySQL process. However, for MySQL 5.7 and 8.0.X series, you will need to take a few extra steps.

Enabling jemalloc on Percona Server for MySQL

Installing the jemalloc package is simple for Percona. This is because the library is available on the Percona repository, which is available for both apt and yum package management:

Once you have the repo, just run the install command (according to your OS) to install it:

Now that the package is installed, we need to make MySQL working with it. And now, it depends on how you are starting MySQL:

Using systemd Services (systemctl Command)

If you are using systemd services (using systemctl commands), you need to execute the following steps:

1-) The unit file provided with Percona Server (/usr/lib/systemd/system/mysqld.service) has the following lines in it:


The /etc/sysconfig/mysql  file should contain new-line-separated variable assignments. See systemd docs https://www.freedesktop.org/software/systemd/man/systemd.exec.html#EnvironmentFile= for the explanation. So the final result will be a file like this:

2-) Start MySQL

Starting Manually

If you are starting it manually, in the command line, you need to specify the library in the LD_PRELOAD. So the command to initialize will be similar to this one:

Check if MySQL is Using jemalloc


And you can also do it manually:

Or:

Conclusion

This blog post was written to update the guidelines of jemalloc. Important to mention that using the recommendations above regarding systemd, the changes will persist across MySQL upgrades.

Finally, jemalloc still is a good memory allocator and I consider it part of the best practices that should be implemented before the deployment in production.

Useful Resources

Finally, you can reach us through the social networks, our forum, or access our material using the links presented below:

Share this post

Leave a Reply