Re: Repeated messages about Removing tokens

Is it possible to remove/decommission/add nodes at the same time? You can't add twos nodes at the same time. Do you decommission a node while you are adding another node? *---* *VafaTech : A Total Solution for Data

Re: To find top 10 tables with top 10 sstables per read and top 10 tables with top tombstones per read ?

I think it's better to change you solution for your purpose. Tables, partitions , tombstones, statistics, sstables, query and monitoring in Cassandra are different! You need noSQL concept before doing anything. Best regards, *---* *VafaTech

Re: How to find which table partitions having the more reads per sstables ?

You can get read count per table (Total and TPS) in JMX. If you want to find hot partitions, you can use nodetool toppartitions without paying money! *---* *VafaTech : A Total Solution for Data Gathering & Analysis*

Re: [EXTERNAL] Cassandra 3.11.X upgrades

wrote: > Should upgradesstables not be run after every node is upgraded? If we need > to rollback then we will not be able to downgrade sstables to older > version. > > Regards > Manish > > On Tue, Mar 3, 2020 at 11:26 PM Hossein Ghiyasi Mehr < > ghiyasim...@gmail.com> wrot

Re: [EXTERNAL] Cassandra 3.11.X upgrades

It's more safe to upgrade one node before upgrading another node to avoid down time. After upgrading binary and package, run upgradesstables on candidate node then do it on all cluster nodes one by one. *---* *VafaTech :

Re: Cassandra is not showing a node up hours after restart

Which version of Cassandra did you install? deb or tar? If it's deb, its script should be used for start/stop. If it's tar, kill pid of cassandra to stop and use bin/cassandra to start. Stop doesn't need any other actions: drain, disable gossip & etc. Where do you use Cassandra?

Re: No progress in compactionstats

Hi, Check nodetool tpstats output. *---* *VafaTech : A Total Solution for Data Gathering & Analysis* *---* On Mon, Dec 2, 2019 at 10:56 AM Dipan Shah wrote: >

Re: "Maximum memory usage reached (512.000MiB), cannot allocate chunk of 1.000MiB"

your SLA, then the noisy messages become sources of >>> ideas to look at. >>> >>> >>> >>> One thing you’ll find out pretty quickly. There are a lot of knobs you >>> can turn with C*, too many to allow for easy answers on what you should >&

Re: Optimal backup strategy

0:42 AM Adarsh Kumar wrote: > Thanks Hossein, > > Just one more question is there any special SOP or consideration we have > to take for multi-site backup. > > Please share any helpful link, blog or steps documented. > > Regards, > Adarsh Kumar > > On Sun, Dec 1, 201

Re: "Maximum memory usage reached (512.000MiB), cannot allocate chunk of 1.000MiB"

ts to get chunks?if it has mechanism to clear chunks from > cache what causes to cannot allocate chunk? Can you point me to any > documention? > > On Sun, Dec 1, 2019, 12:03 PM Hossein Ghiyasi Mehr > wrote: > >> Chunks are part of sstables. When there is enough space in m

Re: Optimal backup strategy

e same cassandra >> topology ,So it is usable to do replay .But when restore to the >> same machine it is also usable . >> Using sstableloader cost too much time and more storage(though will >> reduce after restored) >> >> Hossein Ghiyasi Mehr 于2019年11月28日周四 下午7:40写道

Re: "Maximum memory usage reached (512.000MiB), cannot allocate chunk of 1.000MiB"

Chunks are part of sstables. When there is enough space in memory to cache them, read performance will increase if application requests it again. Your real answer is application dependent. For example write heavy applications are different than read heavy or read-write heavy. Real time

Re: Optimal backup strategy

commitlog backup isn't usable in another machine. Backup solution depends on what you want to do: periodic backup or backup to restore on other machine? Periodic backup is combine of snapshot and incremental backup. Remove incremental backup after new snapshot. Take backup to restore on other

Re: Select statement in batch

Hello, Batch isn't for selet only query, it's for transactional queries. If you want to read data, you should use select query (prepared or simple or etc.) On Fri, Oct 11, 2019 at 5:50 PM Inquistive allen wrote: > Hello Team, > > Wanted to understand the impacted of using a select statement

Re: TWCS and gc_grace_seconds

It needs to change gc_grace_seconds carefully because it has side effect on hinted handoff. On Fri, Oct 18, 2019 at 5:04 PM Paul Chandler wrote: > Hi Adarsh, > > You will have problems if you manually delete data when using TWCS. > > To fully understand why, I recommend reading this The Last

Re: Repair Issues

If the problem exist still, and all nodes are up, reboot them one by one. Then try to repair one node. After that repair other nodes one by one. On Fri, Oct 25, 2019 at 12:56 AM Ben Mills wrote: > > Thanks Jon! > > This is very helpful - allow me to follow-up and ask a question. > > (1) Yes,

Re: [EXTERNAL] Cassandra Export error in COPY command

xtract of some kind. You can get keys from the sstables, then > dedupe, then export rows one by one using the keys (kind of painful). How > large is the table you are trying to export? > > > > Sean Durity > > > > *From:* Hossein Ghiyasi Mehr > *Sent:* Saturday, September 21,

Re: [EXTERNAL] Cassandra Export error in COPY command

robably need to > write an extract of some kind. You can get keys from the sstables, then > dedupe, then export rows one by one using the keys (kind of painful). How > large is the table you are trying to export? > > > > Sean Durity > > > > *From:* Hossein Ghiyasi M

Cassandra Export error in COPY command

Hi all members, I want to export (pk, another_int_column) from single node using COPY command. But after about 1h 45m, I've got a lot of read errors: [image: image.png] I tried this action many times but after maximum 2h, it failed with the errors. Any idea may help me! Thanks.

Re: Update/where statement Adds Row

Update in Cassandra is upsert (update or insert). So when you update a row which isn't exist, it will create it. "IF EXIST" can be used in some queries. On Thu, Sep 12, 2019 at 8:35 AM A wrote: > I have an update statement that has a where clause with the primary key > (email,companyid). > >

Fwd: Cassandra Export error in COPY command

-- Forwarded message - From: Hossein Ghiyasi Mehr Date: Sun, Sep 8, 2019 at 11:38 AM Subject: Cassandra Export error in COPY command To: Hi all members, I want to export (pk, another_int_column) from single node using COPY command. But after about 1h 45m, I've got a lot of read