manticoresoftware / manticoresoftware/manticoresearch
GitHub#69 ⁃ Request: Date index created in SHOW INDEX STATUS
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 12k
- Forks
- 642
- Avg merge
- 3d 12h
- Merged PRs (30d)
- 47
Description
Would be really nice is to have date index created in SHOW INDEX STATUS
- could just be a unix-timestamp, simple and unambiguous.
For a disk index, could literally be the modification time of the .sph file - when it was last built by indexer. (even new version loaded via --rotate)
For RT indexes I suppose that would work too, its when searchd first created the index. But don't know if the file ever gets later rewritten. I suppose for RT indexes, last update is more useful - when the index last received an update.
(at the moment, have to check via the filesystem, would be nicer if monitoring could just use SHOW INDEX STATUS )
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start at the SHOW INDEX STATUS implementation and trace how disk indexes use the .sph modification time and how RT indexes are created or updated. Clarify whether the reported value is creation time or last update time, including behavior after indexer --rotate. Done means monitoring can obtain the agreed Unix timestamp through SHOW INDEX STATUS without filesystem checks.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sql
- Domain
- databases, search
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100