Re: best way to clean up a column family? 60Gig of dangling data

2013-02-28 Thread Erik Forkalsud
Have you tried to (via jmx) call org.apache.cassandra.db.CompactionManager.forceUserDefinedCompaction() and give it the name of your SSTable file. It's a trick I use to aggressively get rid of expired data, i.e. if I have a column family where all data is written with a TTL of 30 days, any

Re: blob fields, bynary or hexa?

2012-04-18 Thread Erik Forkalsud
On 04/18/2012 03:02 AM, mdione@orange.com wrote: We're building a database to stock the avatars for our users in three sizes. Thing is, We planned to use the blob field with a ByteType validator, but if we try to inject the binary data as read from the image file, we get acannot parse

Re: How often to run `nodetool repair`

2013-08-01 Thread Erik Forkalsud
On 08/01/2013 01:16 PM, Andrey Ilinykh wrote: TTL is effectively DELETE; you need to run a repair once every gc_grace_seconds. If you don't, data might un-delete itself. How is it possible? Every replica has TTL, so it when it expires every replica has tombstone. I don't see how you

Re: CentOS - Could not setup cluster(snappy error)

2013-12-30 Thread Erik Forkalsud
You can add something like this to cassandra-env.sh : JVM_OPTS=$JVM_OPTS -Dorg.xerial.snappy.tempdir=/path/that/allows/executables - Erik - On 12/28/2013 08:36 AM, Edward Capriolo wrote: Check your fstabs settings. On some systems /tmp has noexec set and unpacking a library into temp and

Re: Cassandra consuming too much memory in ubuntu as compared to within windows, same machine.

2014-01-06 Thread Erik Forkalsud
On 01/04/2014 08:04 AM, Ertio Lew wrote: ... my dual boot 4GB(RAM) machine. ... -Xms4G -Xmx4G - You are allocating all your ram to the java heap. Are you using the same JVM parameters on the windows side? You can try to lower the heap size or add ram to your machine. - Erik -

Re: Doing rolling upgrades on two DCs

2016-08-08 Thread Erik Forkalsud
The low-risk approach would be to change one thing at a time, but I don't think there's a technical reason you couldn't change the commit log and data directory locations while updating to a new version. - EF On 08/08/2016 07:58 AM, Timon Wong wrote: Thank you! We would do a patch level

Re: Unable to connect to C* nodes except one node (same configuration)

2017-07-25 Thread Erik Forkalsud
On 07/25/2017 05:13 AM, Junaid Nasir wrote: |listen_address: 10.128.1.1 rpc_address: 10.128.1.1| Are these the values on all three nodes? If so, try with empty values: |listen_address: rpc_address:| or make sure each node has its own IP address configured.