答复: nodetool repair and compact

2018-04-02 Thread Xiangfei Ni
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 发送时间: 2018年4月2日 21:56 收件人: user@cassandra.apache.org 主题: Re: nodetool repair and compact you may use: nodetool upgradesstables -a keyspace_name table_name

Re: nodetool repair and compact

2018-04-02 Thread Alain RODRIGUEZ
I have just this been told that my first statement is inaccurate: If 'upgradesstable' is run as a routine operation, you might forget about > it and suffer consequences. 'upgradesstable' is not only doing the > compaction. I should probably have checked upgradesstable closely before making this

Re: nodetool repair and compact

2018-04-02 Thread Alain RODRIGUEZ
Hi, 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. > Nice tip

Re: nodetool repair and compact

2018-04-02 Thread James Shaw
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

Re: nodetool repair and compact

2018-04-01 Thread Jon Haddad
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’r

nodetool repair and compact

2018-04-01 Thread Xiangfei Ni
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, ht