Question
We moved from one hosting to another. Had to reinstall MeiliSearch, but it turned out that search artifacts remained in the database. Now, when I enter a query in the search, it displays not only the desired value and the value with a typo, but also what is not included in the search area itself. How can I completely reindex the table?
Answer
In the ttm__search_settings
table, the Delete from index
button allows you to manually remove rows from the index.
If you pass table_id/*ALL*
, the search index for the entire specified table will be deleted.
Then use index_it
for the desired table — Totum will resend everything from the table to the search database.
To understand what duplicates are there, you can use the h_search_it
button. The result will be:
{
"hits": [
{
"title": "Test",
"index": 11,
"pk": "41-1",
"catalog": "test",
"_formatted": {},
"estimatedTotalHits": 4,
"query": "test",
"limit": 20,
"offset": 0,
"processingTimeMs": 0
},
{
"title": "Example 2",
"index": 12,
"pk": "42-1",
"catalog": "example",
"_formatted": {},
"estimatedTotalHits": 4,
"query": "example",
"limit": 20,
"offset": 0,
"processingTimeMs": 0
}
]
}
PK
is Primary key
— everything is stored in the search database by them.