Database Tuning Best Practices
Follow database tuning guidelines to maximize the performance of the database.
- Database considerations for larger installations
-
If you have significant library exchanges per hour rates (that is, greater than 300) with multiple libraries attached to a single STA server and a long history with STA, you might need to make adjustments to two InnoDB buffer pool parameters in the MySQL configuration file,
/etc/my.cnf
. To change these parameters, first stop STA, then modify themy.cnf
file, and then restart STA to activate the new values.The key parameters that may need adjusting based on your server configuration are as follows.
innodb_buffer_pool_size
— 24GB or greater. The value should be 70–80 percent of the STA server's physical memory.innodb_buffer_pool_instances
— 8 minium. More buffer pools improve concurrent processing.