Originally Posted by thunder04
Keep in mind that /opt/zimbra/conf/my.cnf is created at initial install based on the amount of RAM installed in the server at that time and never thereafter updated.
So, if mysqltuner.pl ever reports that your innodb buffer pool is smaller than your innodb database, you'll need to increase that allocation by hand editing the Zimbra my.cnf file and restarting Zimbra.
mysqltuner.pl will report this, which as you can see is OK because the buffer size exceeds the database size:
If your values are the other way around, mysqltuner will flag that item with two exclamation points instead of the "[OK]" and then you need to edit the following:
[OK] InnoDB data size / buffer pool: 2.2G/2.5G
Zimbra's default is to specify the size in bytes (commented out above); we prefer to do so in MB to make it more readable. Both are acceptable formats for this variable.
malbec:~ # cat /opt/zimbra/conf/my.cnf | grep innodb_buffer_pool
# innodb_buffer_pool_size = 2452764672
innodb_buffer_pool_size = 2560M
Hope that helps,