Custom Memory Allocator configuration for MariaDB

mariadb_malloc.adoc

Steps to configure Custom Malloc library for MariaDB

• Install Prefered malloc library.

  1. Jemalloc

     $ yum install jemalloc

  2. tcmalloc

     $ yum install gperftools-libs

• Create configuration file to use jemalloc.

  1. Jemalloc

     # cat > /etc/systemd/system/mariadb.service.d/mariadb.conf <<EOF
     [Service]
     Environment="LD_PRELOAD=/usr/lib64/libjemalloc.so.1"
     EOF

  2. tcmalloc

     # cat > /etc/systemd/system/mariadb.service.d/mariadb.conf <<EOF
     [Service]
     Environment="LD_PRELOAD=/usr/lib64/libtcmalloc.so.4.4.5"
     EOF

• Reload systemd configuration

  # systemctl daemon-reload

• Restart mariadb

  # systemctl restart mariadb

• Verify libary is loaded

  sudo lsof -p $(pidof mysqld) | grep mem | grep -E "jem|tcm"