NVDIMM Caching for MySQL 5.7

Optimize MySQL/InnoDB using NVDIMM

Publication

Mijin An, Jonghyeok Park, Tianzheng Wang, Beomseok Nam, and Sang-Won Lee. 2023. NV-SQL: Boosting OLTP Performance with Non-Volatile DIMMs. Proc. VLDB Endow. 16, 6 (February 2023), 1453–1465. https://doi.org/10.14778/3583140.3583159

Build and install

Clone the source code:

$ git clone https://github.com/meeeejin/mysql-57-nvdimm-caching.git

Modify the PASSWD value in the build script:

$ vi build.sh
#!/bin/bash
BASE_DIR=`pwd -P`
BUILD_DIR=$BASE_DIR/bld
PASSWD="sudo-passwd"
...

Run the script file:

$ ./build.sh

The above command will compile and build the source code with the default option (i.e., caching new-orders and order-line pages). The available options are:

Option	Description
—origin	No caching (Vanilla version)
—origin-monitor	No caching but monitoring the flush status
—nc	Caching New-Orders and Order-Line pages (`default`)
—nc-st	Caching New-Orders, Order-Line and Stock pages
—nc-st-od	Caching New-Orders, Order-Line, Stock and Orders pages
—mtr	Caching New-Orders, Order-Line, Stock and Orders pages with mtr logging enabled

If you want the vanilla version, you can run the script as follows:

$ ./build.sh --origin

Run

Add the following three server variables to the my.cnf file:

System Variable	Description
innodb_use_nvdimm_buffer	Specifies whether to use NVDIMM cache. true or false.
innodb_nvdimm_buffer_pool_size	The size in bytes of the NVDIMM cache. The default value is 2GB.
innodb_nvdimm_buffer_pool_instances	The number of regions that the NVDIMM cache is divided into. The default value is 1.
innodb_nvdimm_pc_threshold_pct	Wakeup the NVDIMM page cleaner when this % of free pages remaining. The default value is 5.
innodb_nvdimm_home_dir	NVDIMM-aware files resident directory

For example:

$ vi my.cnf
...
innodb_use_nvdimm_buffer=true
innodb_nvdimm_buffer_pool_size=2G
innodb_nvdimm_buffer_pool_instances=1
innodb_nvdimm_pc_threshold_pct=5
innodb_nvdimm_home_dir=/mnt/pmem
...

Run the MySQL server:

$ ./bld/bin/mysqld --defaults-file=my.cnf