pinpoint数据过大,清理hbase
查看数据目录大小
# du -sh /home/pinpoint/hbase/data/default/* | grep G
21G ApplicationTraceIndex
76G TraceV2
进入hbase数据库
# /opt/hbase/hbase-1.2.6/bin/hbase shell
hbase(main):001:0> list
TABLE
AgentEvent
AgentInfo
AgentLifeCycle
AgentStatV2
ApiMetaData
ApplicationIndex
ApplicationMapStatisticsCallee_Ver2
ApplicationMapStatisticsCaller_Ver2
ApplicationMapStatisticsSelf_Ver2
ApplicationStatAggre
ApplicationTraceIndex
HostApplicationMap_Ver2
SqlMetaData_Ver2
StringMetaData
TraceV2
15 row(s) in 0.1670 seconds
=> ["AgentEvent", "AgentInfo", "AgentLifeCycle", "AgentStatV2", "ApiMetaData", "ApplicationIndex", "ApplicationMapStatisticsCallee_Ver2", "ApplicationMapStatisticsCaller_Ver2", "ApplicationMapStatisticsSelf_Ver2", "ApplicationStatAggre", "ApplicationTraceIndex", "HostApplicationMap_Ver2", "SqlMetaData_Ver2", "StringMetaData", "TraceV2"]
修改TraceV2表TTL数据保存时间7天
# 查看表详情
hbase(main):002:0> describe 'TraceV2'
# 禁用表
hbase(main):002:0> disable 'TraceV2'
# 修改TTL为7天:604800
hbase(main):002:0> alter 'TraceV2' , {NAME=>'S',TTL=>'604800'}
# 启用表
hbase(main):002:0> enable 'TraceV2'
# 进行收缩
hbase(main):002:0> major_compact 'TraceV2'
修改ApplicationTraceIndex表TTL数据保存时间14天
# 查看表详情
hbase(main):002:0> describe 'ApplicationTraceIndex'
# 禁用表
hbase(main):002:0> disable 'ApplicationTraceIndex'
# 修改TTL为7天:604800
hbase(main):002:0> alter 'ApplicationTraceIndex' , {NAME=>'I',TTL=>'1209600'}
# 启用表
hbase(main):002:0> enable 'ApplicationTraceIndex'
# 进行收缩
hbase(main):002:0> major_compact 'ApplicationTraceIndex'
查看收缩后大小
# du -sh /home/pinpoint/hbase/data/default/* | grep G
8.0G ApplicationTraceIndex
11G TraceV2

浙公网安备 33010602011771号