Optimize MySQL/InnoDB using NVDIMM
- 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
- 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
- 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