close
Mailspect Documentation
MySQL fine tuning for InnoDB optimization

For better MySQL performance, we recommended starting with clean MySQL installation using the following option in /etc/my.cnf:

innodb_buffer_pool_size = 2G ( ~ 50% of RAM available on host)
innodb_additional_mem_pool_size = 20M
innodb_log_buffer_size=16M
innodb_thread_concurrency=8
innodb_file_per_table

max_allowed_packet = 64M

Also, [mysqld] and [client] sections should contain the same "socket = /path/to/mysql.sock". See example bellow:

[mysqld]
socket=/var/lib/mysql/mysql.sock

[client]
socket=/var/lib/mysql/mysql.sock