答复: nodetool repair and compact

[Xiangfei Ni <xi...@cm-dt.com>]

Hi James and Jon,
Thank you very much for  your advice, I will go through the article.
By the way,is there any official documentation for instructing the detail of nodetool command,the web pages in datastax are just brief instruction.

Best Regards,

倪项菲/ David Ni
中移德电网络科技有限公司
Virtue Intelligent Network Ltd, co.
Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei
Mob: +86 13797007811|Tel: + 86 27 5024 2516

发件人: James Shaw <jx...@gmail.com>
发送时间: 2018年4月2日 21:56
收件人: user@cassandra.apache.org
主题: Re: nodetool repair and compact

you may use:  nodetool upgradesstables -a keyspace_name table_name
it will re-write this table's sstable files to current version, while re-writing, will evit droppable tombstones (expired +  gc_grace_seconds (default 10 days) ), if partition cross different files, they will still be kept, but most droppable tombstones gone and size reduced.
It works well for ours.



On Mon, Apr 2, 2018 at 12:45 AM, Jon Haddad <jo...@jonhaddad.com>> wrote:
You’ll find the answers to your questions (and quite a bit more) in this blog post from my coworker: http://thelastpickle.com/blog/2016/07/27/about-deletes-and-tombstones.html

Repair doesn’t clean up tombstones, they’re only removed through compaction.  I advise taking care with nodetool compact, most of the time it’s not a great idea for a variety of reasons.  Check out the above post, if you still have questions, ask away.



On Apr 1, 2018, at 9:41 PM, Xiangfei Ni <xi...@cm-dt.com>> wrote:

Hi All,
  I want to delete the expired tombstone, someone uses nodetool repair ,but someone uses compact,so I want to know which one is the correct way,
  I have read the below pages from Datastax,but the page just tells us how to use the command,but doesn’t tell us what it is exactly dose,
  https://docs.datastax.com/en/cassandra/3.0/cassandra/tools/toolsRepair.html
   could anybody tell me how to clean the tombstone and give me some materials include the detailed instruction about the nodetool command and options?Web link is also ok.
  Thanks very much
Best Regards,

倪项菲/ David Ni
中移德电网络科技有限公司
Virtue Intelligent Network Ltd, co.
Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei
Mob: +86 13797007811<tel:+86%20137%209700%207811>|Tel: + 86 27 5024 2516<tel:+86%2027%205024%202516>