Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

HideElements
metastrue
commentstrue
childpagestrue
watchtrue
likestrue

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:

  1. Make a full backup of your database
  2. Stop the zarafaKopano Core-server process
  3. Wait a few minutes, too make sure the MySQL transaction logs are flushed
  4. Stop the MySQL server
  5. Make sure MySQL made a clean shutdown, check the mysql logs
  6. Change the innodb settings in the /etc/my.cnf
  7. Move the old ib_logfiles from the mysql datadir to /tmp
  8. Start mysql to activate the new settings
  9. If you changed the innodb_log_file_size, check the new size on the filesystem
  10. Check the mysql logs for errors
  11. 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.

...