How to optimize sphinx?

Question

Sphinx

There is a Mysql database and a tbl_products table that is almost 1GB in size.
1st question - currently the searchd service consumes about 400 MB of RAM on average. - this is normal? Is it possible to reduce RAM consumption and how?
Question 2 - the tbl_products table is updated twice a day and, accordingly, it needs to be reindexed, and this takes about 2 minutes of time and the site simply does not open during the execution of the command: indexer --all --rotate
Is it possible to somehow optimize this so that during indexing time - did the site function normally?

Answer 1

1. This is a) normal b) not much at all. You can reduce it by deleting the indexes you don't need.
But in general, 40% of the base is normal in my opinion.
2. sphinxsearch.com/docs/current.html#live-updates and down.
You can deltaindexes, you can RT.

Answer 2

about reducing the use of RAM - I will not say anything, like 400 MB is not much at all.
As for reindexing, not all goods change twice a day, you only need to reindex what changes. Read the documentation about delta indexes.

Answer 3

With a penny price of memory, does it make sense to fight for 400 megabytes then? save 5 bucks on server rent per month ?
lower the priority of this command through nice and ionice.
Well, do you have a single-core vpsk for a gig of memory in some very Russian hoster?