Epic
The requested article is not available. Either it doesn't apply to this version of the product or the relevant information is organized differently in this version of the docs. You can search, browse, or go back to the other version.
Configuration parameters
Contributors
Suggest changes
PDFs
Collection of separate PDF docs
Creating your file...
This may take a few minutes. Thanks for your patience.
Your file is ready
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.
