Manitou-Mail Home

5. Inverted full-text index management commands

5.1. Reindexing

manitou-mgr {{--clear-full-text-index} | {--reindex-full-text [--reindex-partitions=N-M] [--reindex-jobs=J] }}
[--conf=/path/to/configfile] [--quiet]

Options:
--clear-full-text-index
Clear the inverted full text index by truncating the relevant SQL tables. This is recommended before a complete rebuild of the index.
--reindex-full-text
Rebuild the full text index, either entirely, for one partition, or for a range of partitions. When this command is used, the configuration setting index_words is ignored.
--reindex-jobs
The number of child processes that may run in parallel to speed up reindexing on machines with multiple cores.
--reindex-partitions
When not specified, all partitions are indexed. If specified as a number (starting at 0), only this partition is reindexed. When specified as a range in N-M form, all partitions between N and M inclusive are reindexed. A partition designates a range of mail_id (internal unique message identifier), rather than a physical table. The size of these ranges is given by the configuration setting word_index_partsize in the runtime_info table.
--conf
Path to manitou-mdx configuration file (default: /etc/manitou-mdx.conf)
--quiet
No output unless an error occurs. The default is to output information messages in addition to error messages.

5.2. Partitioning the words table

manitou-mgr {{--do-partition-words} | {--undo-partition-words}}
[--dry-run] [--conf=/path/to/configfile]

Options:
--do-partition-words
Transform the words table into 28 smaller tables prefixed by word. Also create a view named words to read all of them through a sql union. The partitioning be used when the words table is so large than insert time becomes problematic. The event is also registered into the runtime_info table and taken into account by import. If a manitou-mdx process is connected to the database with index_words enabled, it should be terminated before launching this command.
--undo-partition-words
After the words table has been partitioned, this command undoes the setup by recreating a large unique words table. It also registered the event so that subsequent import and searches will use it as non-partitioned. If a manitou-mdx process is connected to the database with index_words enabled, it should be terminated before launching this command.
--dry-run
Display the SQL that would be executed instead of actually executing them.