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 <jxys...@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 <j...@jonhaddad.com<mailto:j...@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 <xiangfei...@cm-dt.com<mailto:xiangfei...@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>