Sphinx索引旋转时间戳

Question

Is there a way to get the timestamp when an index has been last rotated by sphinx? Preferably with PHP.

So, for example I issue an indexer --all --rotate command via cron at night. I would like to get the timestamp from that operation in case the index rotation was successful (i.e. sphinx was reloaded with new indexes). Apparently I would also like to get a list of available indexes from sphinx, but that is out of scope for this question.

Answer 1

Just use a sql_query_post_index

http://sphinxsearch.com/docs/current.html#conf-sql-query-post-index

to record it somewhere.

Looking in that table, would also give you the list of indexes :)