Optimize Zarafa and MySQL / MariaDB

Is your Zarafa installation up and running? Great job! If you haven’t thought about changing the default settings yet, then you’ve come to the right place.

Zarafas documentation gives you a good idea of how much system memory should be allocated to MySQL and Zarafa.

About 50% of the memory will be occupied by Zarafas and MySQL. About 20% should stay free. The size of the remaining 30% will determine how many users you’re able to serve. Please enter the amount of your system’s memory and change the recommended ratios so that at least 20% stays free.

I’ve had good experiences with the recommended settings. A prepared MySQL configuration with the fixed values can be found in pietmas repository.

All the following values are given in MB, which you might need to convert:

Zarafa Memory Calculator

System

	Recommended	Your value	Ratio	Working
Memory total	2048 MB	MB
Memory used	1525,864 MB	454,569 MB	89%	=total instance + (total connection * max_connections) + total zarafa
Memory free	522,136 MB	57,431 MB	11%
Zarafa users	9	1		=threads

MySQL – /etc/mysql/my.cnf

Parameter	Default value	Recommended	Ratio	Working
innodb_buffer_pool_size	128,000 MB	128,000 MB	%	=memory * ratio
innodb_log_buffer_size	8,000 MB	32,000 MB
key_buffer_size	128,000 MB	16,000 MB
query_cache_size	1,000 MB	32,000 MB
tmp_table_size	32,000 MB	32,000 MB
max_connections	100	3,00	%	=floor(((memory – total instance) / ratio) / total connection; 0)
Total (each instance)	297,000 MB	240,000 MB
—
binlog_cache_size	0,031 MB	0,031 MB
join_buffer_size	0,125 MB	0,125 MB
max_allowed_packet	4,000 MB	16,000 MB
read_buffer_size	0,125 MB	1,000 MB
read_rnd_buffer_size	0,250 MB	0,250 MB
sort_buffer_size	2,000 MB	1,000 MB
thread_stack	0,281 MB	0,250 MB
Total (each connection)	6,812 MB	18,656 MB
—
innodb_log_file_size	48,000 MB	32,000 MB	%	=innodb_buffer _pool_size * ratio
Total (filesystem)	48,000 MB	32,000 MB

Zarafa – /etc/mysql/server.cfg

Parameter	Default value	Recommended	Ratio	Working
cache_cell_size	256,000 MB	128,000 MB	%	=memory * ratio
cache_object_size	5,000 MB	0,100 MB
cache_indexedobject_size	16,000 MB	0,500 MB
cache_quota_size	1,000 MB	1,000 MB
cache_acl_size	1,000 MB	1,000 MB
cache_store_size	1,000 MB	1,000 MB
cache_user_size	1,000 MB	1,000 MB
cache_userdetails_size	25,000 MB	25,000 MB
cache_server_size	1,000 MB	1,000 MB
threads	8	1		=floor((max_conn ections – 1) / 2; 0)
Total	307,000 MB	158,600 MB

Update
Beginning from zarafa 7.2.4 all values are calculated during first installation. Updaters can run the installed script

/usr/share/doc/zarafa/zarafa-pietma/install-optimization.sh

Links