How to optimize Sphinx indexer "sorted"?

Question

MySQL

Please help! There is a table with 1.2 million records. Organized search on sphinx. Everything was fine, but now you need to reindex the table at least once a day. The server is simple, but you need to do it on it. About the start of the indexer, the server starts to go to bed and LA reaches 25-30. Began to google how to optimize. Googled this:

sql_query_range = SELECT MIN(id),MAX(id) FROM table
sql_range_step = 300
sql_query = SELECT id, title FROM table WHERE ID>=$start AND ID<=$end
sql_query_info = SELECT * FROM table WHERE ID=$id
sql_ranged_throttle = 500

Helped until the sphinx starts sorting:

sorted 193.0 Mhits, 95.7% done

Searched for solutions but didn't find anything. Please help. Thanks in advance.

Answer 1

We also have several million records in the database, and there are more than 10 such databases, all on the same server. We use delta-indexes
Regarding your decision - it is well described here . It looks like you also need to set a max_iops limit.

Answer 2

Through rt indexes, I have a database of more than 3 ml of records, the most optimal solution for me.