[PHOENIX-195] Gather and maintain stats for HBase tables in a designated HBase table

• Type: Sub-task
• Status: Resolved
• Resolution: Duplicate
• old issue number: 64
• Assignee: ramkrishna.s.vasudevan
• Reporter: James R. Taylor
• Created: 10/Mar/14 23:46
• Updated: 19/Sep/14 19:10
• Resolved: 19/Sep/14 19:10

Description

Our current stats gathering is way too simplistic - it's only keeping a cache per client connection to a cluster for the min and max key for a table. Instead, we should:

1. have a system table that stores the stats
2. create a coprocessor that updates the stats during compaction (i.e. using the preCompactSelection, postCompactSelection, preCompact, postCompact methods)
3. keep a kind of histogram - the key boundary of every N bytes within a region. Perhaps we can do a delta update on minor compaction and a complete update on major compaction.
4. keep the min key/max key of a table in the stats table too