...
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:
innodb_ft_min_token_size=1After 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!
Timezone
Ensure that the timezone of MySQL is the same as the timezone configured in apache php and CLI php.
...