my-nvdimm.cnf

#
# The MySQL database server configuration file.
#
[client]
user = root
port            = 3306
socket          = /tmp/mysql.sock

[mysql]
prompt=\u:\d>\_

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = /tmp/mysql.sock
#nice           = 0

[mysqld]
#
# * Basic Settings
#
default-storage-engine = innodb
pid-file        = /home/mijin/test_data/mysql.pid
socket          = /tmp/mysql.sock
port            = 3306
datadir         = /home/mijin/test_data/
log-error	= /home/mijin/test_data/mysql_error_nvdimm.log
#log-bin	= /home/mijin/test_data/mysql-bin.log

##settings for normal file
#innodb_data_file_path=ibdata1:1G:autoextend

##################################################
# Need to Modify
##################################################
#Log group path (iblog0, iblog1)
innodb_log_group_home_dir=/home/mijin/test_log/

#innodb page size
innodb_page_size=4KB

#
# * InnoDB
#

#file per table ON
innodb_file_per_table=1

#buffer settings
innodb_buffer_pool_size=18G
innodb_buffer_pool_instances=8
innodb_max_dirty_pages_pct_lwm=0

#nvdimm settings
innodb_use_nvdimm_buffer=true
innodb_nvdimm_buffer_pool_size=2G
innodb_nvdimm_buffer_pool_instances=1
innodb_nvdimm_pc_threshold_pct=5

#etc
log_error_verbosity=3
#innodb_adaptive_hash_index=OFF
innodb_page_cleaners=8

#transaction log settings
innodb_log_file_size=2G
innodb_log_files_in_group=3

# 0:every 1 seconds, 1:fsync on commits, 2:writes on commits
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=32M
innodb_flush_neighbors=0

#doublewrite and flush method
innodb_doublewrite=OFF
innodb_flush_method=O_DIRECT

#AIO control
innodb_use_native_aio=true
innodb_change_buffering=none
innodb_lru_scan_depth=1024

# etc settings
max_connections = 1024
open_files_limit = 24000
#wait_timeout = 100000
#innodb_empty_free_list_algorithm=backoff

# io settings
innodb_io_capacity = 100000
innodb_io_capacity_max = 200000
innodb_write_io_threads = 32
innodb_read_io_threads = 32

# monitoring settings
#performance-schema-instrument='wait/synch/mutex/innodb/%=ON'
#performance-schema-instrument='wait/synch/rwlock/innodb/%=ON'
#innodb_status_output = ON
#innodb_status_output_locks = ON

#single page flush cache settings
#innodb_use_spf_cache=true
#innodb_spf_cache_size=128M

#ssd cache settings
#innodb_use_ssd_cache=false
#innodb_ssd_cache_file=/home/mijin/test_data/ssd_cache.db
#innodb_ssd_cache_size=10G

#share_settings
#innodb_use_share=false
#innodb_share_device=/dev/sdb
#innodb_share_max=511