Hi,
I made plain index like https://www.sqlshack.com/manticore-search-a-continuation-of-the-sphinx-search-engine/
and got a problem. Manticore don’t show index via SHOW TABLES;
Can anyone please help me? Thanks a lot for any tips!
OS Win7 x64
I connect like this
MySQL -P9306 -h127.0.0.1
mysql> reload indexes;
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
Empty set (0.00 sec)
But index files were created in a proper place.
I:\MySQL\Manticore\Data\index\film
04.05.2022 21:29 .
04.05.2022 21:29 …
04.05.2022 21:29 8 144 .new.spa
04.05.2022 21:29 38 731 .new.spd
04.05.2022 21:29 950 .new.spe
04.05.2022 21:29 990 .new.sph
04.05.2022 21:29 16 050 .new.sphi
04.05.2022 21:29 1 749 .new.spi
04.05.2022 21:29 128 .new.spm
04.05.2022 21:29 340 .new.spp
04.05.2022 21:29 5 256 .new.spt
Index building command line
C:/Manticore/bin/indexer --config “C:\Manticore\manticore.conf_actor.in” --all --rotate
generated this output:
Manticore 4.2.0 15e927b28@211223 release
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2021, Manticore Software LTD (https://manticoresearch.com)
using config file ‘C:\Manticore\manticore.conf_actor.in’…
indexing index ‘film’…
collected 1000 docs, 0.0 MB
creating lookup: 1.0 Kdocs, 100.0% done
sorted 0.0 Mhits, 100.0% done
total 1000 docs, 93842 bytes
total 0.048 sec, 1918588 bytes/sec, 20444.88 docs/sec
total 3 reads, 0.000 sec, 16.6 kb/call avg, 0.0 msec/call avg
total 13 writes, 0.000 sec, 9.2 kb/call avg, 0.0 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=12820).
Manticore version 4.2.0 15e927b28@211223 release
Searchd.log:
[Wed May 4 21:29:40.626 2022] [3276] caught SIGHUP (seamless=0, in_rotate=0, need_rotate=0)
[Wed May 4 21:29:40.626 2022] [7484] rotating finished
My config file:
searchd {
listen = 127.0.0.1:9312
listen = 127.0.0.1:9306:mysql
listen = 127.0.0.1:9308:http
log = i:/MySQL/Manticore/log/searchd.log
query_log = i:/MySQL/Manticore/log/query.log
pid_file = i:/MySQL/Manticore/run/searchd.pid
data_dir = i:/MySQL/Manticore/data
query_log_format = sphinxql
seamless_rotate = 1
preopen_indexes = 1
binlog_path = i:/MySQL/Manticore/data/binlog
mysql_version_string = 8.0.29
}
source base
{
type = mysql
sql_host = localhost
sql_user = admin
sql_pass = mysql
sql_db = sakila
sql_port = 3306
}
source film: base
{
sql_query = select film_id, description from film;
sql_attr_uint = film_id
}
index film {
type = plain
morphology = stem_en
stopwords = C:/Manticore/share/stopwords/en
min_word_len = 3
source = film
path = i:/MySQL/Manticore/data/index/film/
}