Questions about SphinxSearch configuration source

several questions about source configuration. Assume that the configured source has the following

sql_query = \
    SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, \
        title, content \
    FROM documents

1) all non-full-text search fields after select must correspond to sql_attr_xxx = field_name ?
2) with regard to sql_attr_string, if it is written that this field will not be indexed, it will be saved, then this use is
3) is the index table structure self-defined sql_attr_string or sql_field_string

Jun.30,2022

official document: http://sphinxsearch.com/docs/...
sql_attr_ is to reduce the number of times to query the database after the index data is queried, and to obtain data directly from sphinx. Sql_field_ data is indexed.
whether all non-full-text search fields are used sql_attr_xxx = field_name look at your business scenario and your tradeoff between sphinx memory and mysql queries. Generally, only frequently queried fields are put in

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3c511-2c2e7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3c511-2c2e7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?