Sphinx
SFX uses Sphinx, an SQL full-text search engine, for Author information indexing and searching.
When using Sphinx, indexing does not occur automatically as it does for regular MySQL indexes and therefore needs to be scheduled. As a result, there is a new event scheduler in the MySQL process list in SFX version 4.
The Sphinx programs included in SFX are:
- Indexer – the program that creates the index
- Searched – the search daemon used to perform searches
The following tables store Author information in SFX version 4:
- KB_AUTHORS
- KB_AUTHORS_SPHINX
- KB_AUTHORS_DELTA
- KB_AUTHORS_SPHINX_DELTA
The delta tables are included to avoid recreating the index for every new author entry in the table. Instead, new authors are added to the delta table, and only the delta table is reindexed immediately. SFX uses a scheduled task that runs every night to merge the delta table into the main index.