Home > Storage > PowerFlex > White Papers > Deploying MySQL Database on Dell PowerFlex with NVMe over TCP > MySQL configuration
The following configuration was used in MySQL tests. These configuration parameters were updated in the my.cnf file of the MySQL database application.
Perform the following steps update the my.cnf file:
#sudo vi /etc/my.cnf
[mysqld]
datadir=/MySQL_Data/mysqlnode01_data
socket=/MySQL_Data/mysqlnode01_data/mysql.sock
[client]
port=3306
socket=/MySQL_Data/mysqlnode01_data/mysql.sock
[mysqld]
log_bin=/Binary_Logs/mysqlnode01_binarylogs/binlog.index
innodb_log_group_home_dir=/RedoLogs/mysqlnode01_redologs/#innodb_redo
innodb_undo_directory=/UndoLogs/mysqlnode01_undologs/
log-error=/var/log/mysql/mysqld_n01.log
pid-file=/MySQL_Data/mysqlnode01_data/mysqld.pid
[mysqld] #Performance Stats
innodb_buffer_pool_size = 64G
large-pages
innodb_dedicated_server=1
innodb_read_io_threads=64
innodb_write_io_threads=64
innodb_io_capacity=275000
[mysqld] #Performance Stats 02
innodb_page_size=8192
innodb_doublewrite=0