Page tree

Versions Compared

Key

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

...

To tune the MySQL please change/add the following setting to the MySQL configuration file, usually /etc/my.cnf or /etc/mysql/my.cnf, below the [mysqld] section:

...

innodb_buffer_pool_size = 
innodb_log_file_size = 
innodb_log_buffer_size = 32M
max_allowed_packet = 16M
max_connections = [threads parameter in server.cfg] * 2 + 1
#innodb_file_per_table
#innodb_data_file_path = ibdata1:100G;ibdata2:100G:autoextend
#innodb_autoextent_increment = 1000
#query_cache_size = 32MB
#innodb_flush_method = O_DSYNC or O_DIRECT


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

...