Documentation

MySQL configuration

If you plan to have a lot of datas (e.g. more than 100.000 contacts), edit the MySQL configuration file (e.g. /etc/my.cnf ) and add this line :

max_allowed_packet=16M

under the section [mysqld_safe].

Having a large database of contacts and not increasing this parameter can lead to the incapacity to list these contacts in Nectil.

If you are to receive a lot of visits on your website, adjust these parameters :

max_connections=1000
table_cache=1024

If you want to use the NQL matchagainst operator, which uses the FULLTEXT INDEX feature of MySQL, adjust the min word length :

ft_min_word_len=3

A good value is 3, because user usually expects a three letters search to operate fast.

To use the matchagainst operator, you have to add a fulltext index on the field :

ALTER TABLE `contacts` ADD FULLTEXT (`SearchText`);

If you change this parameter after the beginning of the project, do not forget to rebuild the index :

REPAIR TABLE contacts QUICK;

Do not forget to adjust the Sushee configuration : add $GLOBALS['MySQLFullTextMinLength'] = 3; in Kernel/common/config.inc.php

For other advices about MySQL configuration, consult websites specialized in this area.