[Vtigercrm-developers] my.cnf setup

[Adam Heinz]

On Mon, Apr 9, 2012 at 11:25 PM, Richard Hills <richard at tw.co.nz> wrote:
> I have recently installed vtiger on a vps in the cloud for the first
> time and am having some issues with CPU usage related to the mysql
> database. Can anyone suggest a my.cnf setup which would be best suited
> for vtiger?
>
> I am running a VPS with 1.5g of ram.

http://www.mysqlperformanceblog.com/2007/11/01/innodb-performance-optimization-basics/

innodb_buffer_pool_size is the really important one.  I run servers as
small as 0.5GB with sub-100ms response times, but that only works for
small databases that fit into the innodb buffer.  You can measure your
database size with

http://forums.mysql.com/read.php?108,201578,201578