Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


The charset is set on creation of the concrete DB in the next step.

Full text index optimization

For proper functionality of the termportal search the minimum index token length must be set to 1:

After changing this values the indexes must be rebuild:

Rebuild the index if you just changed some of the above settings:

Code Block
set GLOBAL innodb_optimize_fulltext_only=ON;
OPTIMIZE TABLE terms_term;

On MySQL 5.7 the innodb_optimize_fulltext_only flag should be kept disabled, since there the rebuild of the index does not properly work!


Ensure that the timezone of MySQL is the same as the timezone configured in apache php and CLI php.