-
Notifications
You must be signed in to change notification settings - Fork 2
/
my.cnf
97 lines (78 loc) · 2.1 KB
/
my.cnf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
#
# 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
skip-grant-tables
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
##################################################
# 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=4G
innodb_buffer_pool_instances=8
innodb_max_dirty_pages_pct_lwm=0
#etc
log_error_verbosity=3
innodb_page_cleaners=8
#nvdimm settings
innodb_use_nvdimm_buffer=true
innodb_nvdimm_buffer_pool_size=2G
innodb_nvdimm_buffer_pool_instances=2
innodb_nvdimm_pc_threshold_pct=15
innodb_nvdimm_home_dir=/mnt/pmem
#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=ON
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
# io settings
#innodb_io_capacity = 10000
#innodb_io_capacity_max = 20000
#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