Muestra las diferencias entre dos versiones de la página.
Ambos lados, revisión anteriorRevisión previaPróxima revisión | Revisión previa | ||
linux:howtos:manticore-playground [23/08/2021 18:16] – [Manticore Search adventures] Juanga Covas | linux:howtos:manticore-playground [23/08/2021 19:15] (actual) – [Comments] Juanga Covas | ||
---|---|---|---|
Línea 16: | Línea 16: | ||
**Other notes** | **Other notes** | ||
- | * A concept to understand is "RT mode" | + | * A confusing |
- | * REAL-TIME MODE requires no index definition in the configuration file and // | + | * REAL-TIME MODE **requires** no index definition in the configuration file and having a // |
- | * PLAIN MODE allows to specify index schema in config which will be read on Manticore start and created if missing. This mode is especially useful for plain indexes that are built upon indexing data from an external storage. Dropping indexes is only possible by removing them from the configuration file or by removing the path setting and sending a HUP signal to the server or restarting it. You can still use RT indexes in Plain Mode: | + | * PLAIN MODE allows to specify index schema in config which will be read on Manticore start and created if missing. This mode is especially useful for plain indexes that need to be built from an external storage. Dropping indexes is only possible by removing them from the configuration file or by removing the path setting and sending a HUP signal to the server or restarting it.\\ **You can still use REAL-TIME INDEX (RT indexes) in this Plain Mode** since [[https:// |
- | | + | |
Línea 37: | Línea 36: | ||
listen = 127.0.0.1: | listen = 127.0.0.1: | ||
listen = 127.0.0.1: | listen = 127.0.0.1: | ||
- | # | + | # |
log = E:/ | log = E:/ | ||
query_log = E:/ | query_log = E:/ | ||
pid_file = E:/ | pid_file = E:/ | ||
- | | + | # PLAIN MODE is enabled by omitting " |
+ | # | ||
+ | # data_dir = E:/ | ||
query_log_format = sphinxql | query_log_format = sphinxql | ||
} | } | ||
Línea 59: | Línea 60: | ||
.\bin\searchd -c manticore.conf.in | .\bin\searchd -c manticore.conf.in | ||
- | To ensure a fast connection, use '' | + | To ensure a fast connection, use '' |
mysql -P9306 -h127.0.0.1 | mysql -P9306 -h127.0.0.1 | ||
Línea 110: | Línea 111: | ||
# can also be escaped using \. Escaping is required if # is present in database credential in source declarations. | # can also be escaped using \. Escaping is required if # is present in database credential in source declarations. | ||
+ | ===== Source ===== | ||
+ | |||
+ | Nice usage of '' | ||
+ | |||
+ | A table to keep some indexing information | ||
+ | CREATE TABLE `product_search_status` | ||
+ | `id` varchar(30) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, | ||
+ | `value` bigint(20) UNSIGNED NOT NULL, | ||
+ | PRIMARY KEY (`id`) USING BTREE | ||
+ | ) ENGINE = InnoDB; | ||
+ | |||
+ | < | ||
+ | # we set unicode charset and wait_timeout to a high value to prevent connection timeout errors | ||
+ | sql_query_pre = SET NAMES utf8 | ||
+ | sql_query_pre = SET SESSION wait_timeout=3600 | ||
+ | # we store the index time for information | ||
+ | sql_query_pre = REPLACE INTO product_search_status (id, value) VALUES (' | ||
+ | # we set start-end document ids so that manticore will know where to start and stop indexing | ||
+ | sql_query_range = SELECT MIN(id), MAX(id) FROM product | ||
+ | sql_range_step = 10000 | ||
+ | # this is the main query to create documents | ||
+ | sql_query = SELECT \ | ||
+ | id, \ | ||
+ | name AS name_ft, \ | ||
+ | | ||
+ | name \ | ||
+ | FROM product \ | ||
+ | WHERE id >= $start AND id <= $end | ||
+ | # we store the most recent document id for information | ||
+ | sql_query_post_index = REPLACE INTO product_search_status (id, value) VALUES (' | ||
+ | </ | ||