How can I tune the database for better performance?

The database parameters are tuned for systems with 1 GB RAM (for ISO CD images). If you have higher RAM, please change the following in the "my.cnf" MySQL configuration file under /etc/mysql or /etc directory.

• For a machine running with 512 MB of RAM, you can set these to:
  key_buffer=128M table_cache=1024 sort_buffer=64M read_buffer=2M record_buffer=4M
• For a machine running with 1 GB of RAM, you can set these to:
  key_buffer=256M table_cache=2048 sort_buffer=128M read_buffer=2M record_buffer=8M
• For a machine running with 2 GB of RAM, you can set these to:
  key_buffer=512M table_cache=3072 sort_buffer=256M read_buffer=2M record_buffer=8M
• For a machine running with 4 GB of RAM, you can set these to:
  key_buffer=1G table_cache=4096 sort_buffer=512M read_buffer=2M record_buffer=8M

Note: Please take a back up of this file before you make any changes. In case you are uncomfortable making these changes, please send a mail to support@caligare.com so that we can assist you in doing this.