The following tuning tips may help improve the performance of your database in an Iguana environment.

Specifying InnoDB Configuration Values for MySQL

If you are using a MySQL database, the following InnoDB configuration values are recommended:

• innodb_log_buffer_size=8M
• innodb_buffer_pool_size=512M
• innodb_log_file_size=512M

Setting up a Database Maintenance Plan for MS SQL

If you are using an MS SQL database, a Database Maintenance Plan is recommended. This will ensure that your database is safe and properly maintained. The following resources provide more information on creating a Database Maintenance Plan:

• Creating a SQL Server Maintenance Plan
• A video can be found here: Creating a Maintenance Plan in SSMS (free registration required)

Installing MS SQL on a Separate Partition

If you are using MS SQL, you should not install your database on the system. A better solution is to install your database on a separate partition with a large amount of available disk space. This will ensure that there will be enough space to store your database tables as they grow.