What do you mean by refreshing an RT index?
My database tables (which used for search) frequently get updated.So when i use the RT index,how would i update ,insert & delete (refresh the RT index).
Would i get the real time data in RT index when i import from the MySQL database…?
The idea of the RT indexes is simple: you decide yourself when and what to insert into them. Normally if you want to have your data both in MySQL and an RT index then after you insert something into MySQL from you applicaiton you need to make a similar insert into Manticore too, the same for DELETE and REPLACE.
There’s no mechanism to sync from MySQL to an RT index yet.
Take our interactive course - introduction into real-time indexes.