Answer the question
In order to leave comments, you need to log in
Sphinx. How to organize a search exception from the main index when updating rt?
There are 3 indexes
index sql_client_inter_comment_index
{
source = client_inter_comment
path = /var/lib/sphinxsearch/indexes/client_inter_comment_sql
.....
}
index rt_client_inter_comment_index
{
type = rt
path = /var/lib/sphinxsearch/indexes/client_inter_comment_rt
rt_field = comment
....
rt_mem_limit = 128M
}
index client_inter_comment_index
{
type = distributed
local = sql_client_inter_comment_index
local = rt_client_inter_comment_index
}
select * from client_inter_comment_index ....
+------+---------+----------------+---------+
| id | comp_id | comp_client_id | comment |
+------+---------+----------------+---------+
| 1 | 1 | 47 | тестирование |
select * from client_inter_comment_index where MATCH ('@тестирование*');
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question