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:24] – [Manticore Search adventures] Juanga Covas | linux:howtos:manticore-playground [23/08/2021 19:15] (actual) – [Comments] Juanga Covas | ||
---|---|---|---|
Línea 36: | 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 58: | 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 109: | 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 (' | ||
+ | </ | ||