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
posted @ 2020-11-23 04:57  Squidweber  阅读(76)  评论(0)    收藏  举报