Since the config files below are delta, I would recommend you go ahead and change config.php.distto set sphinx index to delta as default.

define('SPHINX_INDEX', 'ttrss, delta');// Index name in Sphinx configuration. You can specify multiple indexes// as a comma-separated string.

I changed config.php.dist to include the delta index by default since the attached files are delta.One for mariadb/mysql and the other for postgresql.

Steps would be as follows:1. Install Sphinx, i.e. yum install sphinx2. Select the config file for your database (mariadb/mysql or postgresql)3. Make the necessary changes (instructions on what to change in the comments of each config)4. Change to the Sphinx conf directory5. Rename sphinx.conf to sphinx.conf.dist6. Rename the ttrss specific config you just modified to sphinx.conf7. Run /bin/indexer --all to initialize the database8. Start the sphinx process, i.e. systemctl start searchd.service9. Enable the service to ensure startup at system initialization, i.e. systemctl enable searchd.service10. Setup cron to run indexer:@daily /bin/indexer --rotate ttrss >/dev/null 2>&0 # Same as 0 0 * * **/20 * * * * /bin/indexer --rotate delta >/dev/null 2>&0 # Every 20 minutes11. And, last but not least, remember to enable sphinx in the ttrss config.php:define('SPHINX_ENABLED', true);

This thread is great and helped me get Sphinx running. I had one issue and it took a while to fix and is perhaps Ubuntu specific. Perhaps you could add this to the steps at the beginning of this thread.

To get the Sphinx server to start on Ubuntu, you have to go to /etc/defaults and edit the file sphinxsearch to change the line that is "start=no" to "start=yes".

There were a few changes made in Sphinx v2.2.6 which require changes to sphinx.conf.The most important being related to binlog_path which can cause searchd not to start.The recommendation is to explicitly define it in the configuration file. In addition, several parameters are no longer needed, and will generate warnings if you have them defined.

Here are the links to the new sample configuration files. Fox, could you consider updatingthe wiki page? Thanks!

I have seen an area where sphinx could be optimised.Currently the delta pulls the last 24h of records and indexes again, this could be quite large for some people, on a separate project I use sql_query_pre command to store data in the DB relating to the position to go from on each delta.

source ttrss{ type = mysql # this is a MARIADB/MYSQL database sql_host = database # this is your hostname, typically localhost sql_user = ttrss # this is the ttrss_user name you defined sql_pass = ttrss # this is the ttrss_user password you defined sql_db = ttrss # this is the name of the ttrss MARIADB/MYSQL database sql_port = 3306 # optional, default is 3306 for MARIADB/MYSQL sql_query_pre = SET NAMES utf8