Configuration parameters
Contributors
Suggest changes
PDFs
NetApp recommends a few important MySQL configuration parameters to obtain optimal performance.
Parameters |
Values |
innodb_log_file_size |
256M |
innodb_flush_log_at_trx_commit |
2 |
innodb_doublewrite |
0 |
innodb_flush_method |
fsync |
innodb_buffer_pool_size |
11G |
innodb_io_capacity |
8192 |
innodb_buffer_pool_instances |
8 |
innodb_lru_scan_depth |
8192 |
open_file_limit |
65535 |
To set the parameters described in this section, you must change them in the MySQL configuration file (my.cnf). The NetApp best practices are a result of tests performed in-house.