StorNext Storage Manager
StorNext Storage Manager uses a MySQL database for storing managed StorNext file system information.
StorNext Storage Manager can run on Linux MDCs and requires a Storage Manager license. Tuning the MySQL database can improve the performance of Storage Manager and other parts StorNext.
MySQL innodb_buffer_pool_size
The InnoDB buffer pool is used to cache the data and indexes of MySQL InnoDB database tables.
Increasing the size of the InnoDB buffer pool will allow MySQL to keep more of the working database set memory resident, thereby reducing the amount of disk access required to read datasets from the file system. The InnoDB buffer pool size is determined by the parameter innodb_buffer_pool_size in the /usr/adic/mysql/my.cnf file.
Increasing this value can improve the performance of Storage Manager operations that require large queries. However, setting this value too high can inefficiently remove memory from the free pool that could otherwise be used by the StorNext file system or other applications, and could lead to memory starvation issues on the system.
Prior to StorNext 5 release 5.2, the default value of innodb_buffer_pool_size was 384 M. As of StorNext 5 release 5.2, the default setting is 8 G. The following are the default values for the StorNext Appliances:
| Metadata Controller | Size |
|---|---|
| M220 | 10 GB |
| M330 | 5 GB |
| M44x | 10 GB |
| M66x | 40 GB |
| Xcellis | 10 GB |
If the value of innodb_bufer_pool_size is not set, the MySQL default value of 128 M is used. However, Quantum recommends setting this value to at least 8 GB (except on the M330 where 5 GB is recommended). This value may need to be decreased if memory starvation is observed or if the Linux Out-of-Memory (OOM) Killer is triggered.
To change this value, modify the /usr/adic/mysql/my.cnf file and change the innodb_buffer_pool_size setting in the .mysqld.group.
Example /usr/adic/mysql/my.cnf:
[mysqld]
innodb_buffer_pool_size = 8G
Both Storage Manager and MySQL will need to be restarted for the change to /usr/adic/mysql/my.cnf to take effect by executing the following commands:
|
|
