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 the my.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.