Before installing Zarafa Kopano Core on a server, it's really advisable to optimize the MySQL configuration.
The innodb_buffer_pool is the memory buffer that InnoDB uses to cache data and indexes of its tables. The larger you set this value, the less disk I/O is needed to access data in tables. On a dedicated Zarafa Kopano Core server, you may set this to up to 50% of the machine physical memory size. However, do not set it too large because competition for the physical memory might cause paging in the operating system, or even out of memory problems.
Tuning existing systems
To tune an existing Zarafa Kopano Core environment, follow these steps:
- Make a full backup of your database
- Stop the zarafaKopano Core-server process
- Wait a few minutes, too make sure the MySQL transaction logs are flushed
- Stop the MySQL server
- Make sure MySQL made a clean shutdown, check the mysql logs
- Change the innodb settings in the /etc/my.cnf
- Move the old ib_logfiles from the mysql datadir to /tmp
- Start mysql to activate the new settings
- If you changed the innodb_log_file_size, check the new size on the filesystem
- Check the mysql logs for errors
- Start the zarafaKopano Core-server process
Then the server will flush the transaction logs when it is shut down and the ib_log* files can be safely moved, without risk of losing data.