Re: high write latency on a single table

2019-07-26 Thread CPC
36 > 0 > Max10.00 322381.14 25109.16 129557750 >1629722 > > 3) RF=3 > > 4)CL QUORUM > > 5) Single insert prepared statement. no LOGGED/UNLOGGED batch or LWT > > > On Thu, 18 Jul 2019 at 20:51, Rajsekh

Re: high write latency on a single table

2019-07-25 Thread mehmet bursali
5.1.12 (cassandra 3.11).We have a high local write latency on> > a single table. All other tables in our keyspace  have normal latencies> > like 0.02 msec,even tables that have more write tps and more data. Below> > you can find two table descriptions and their latencies.

Re: high write latency on a single table

2019-07-24 Thread CPC
16 129557750 >1629722 > > 3) RF=3 > > 4)CL QUORUM > > 5) Single insert prepared statement. no LOGGED/UNLOGGED batch or LWT > > > On Thu, 18 Jul 2019 at 20:51, Rajsekhar Mallick > wrote: > > Hello, > > Kindly post below details > &g

Re: high write latency on a single table

2019-07-24 Thread mehmet bursali
e using DSE 5.1.12 (cassandra 3.11).We have a high local write latency on> > a single table. All other tables in our keyspace  have normal latencies> > like 0.02 msec,even tables that have more write tps and more data. Below> > you can find two table descriptions and their la

Re: high write latency on a single table

2019-07-22 Thread CPC
sadm@bipcas00 conf]$ nodetool tablehistograms tims >>>> MESSAGE_HISTORY_STATE >>>> tims/MESSAGE_HISTORY_STATE histograms >>>> Percentile SSTables Write Latency Read LatencyPartition Size >>>>Cell Count >>>>

Re: high write latency on a single table

2019-07-22 Thread Rajsekhar Mallick
1 >>> 75% 6.00 35.43379.02 5722 >>>7 >>> 95%10.00 4055.27 785.94 61214 >>> 310 >>> 98%10.00 74975.55

Re: high write latency on a single table

2019-07-22 Thread Ben Slater
3.31 42.5136 >> 0 >> Max10.00 322381.14 25109.16 129557750 >> 1629722 >> >> 3) RF=3 >> >> 4)CL QUORUM >> >> 5) Single insert prepared statement.

Re: high write latency on a single table

2019-07-22 Thread CPC
9 at 20:51, Rajsekhar Mallick > wrote: > >> Hello, >> >> Kindly post below details >> >> 1. Nodetool cfstats for both the tables. >> 2. Nodetool cfhistograms for both the tables. >> 3. Replication factor of the tables. >> 4. Consistency with which write

Re: high write latency on a single table

2019-07-19 Thread CPC
t; > On 2019/07/18 15:48:09, CPC wrote: > > Hi all,> > > > > Our cassandra cluster consist of two dc and every dc we have 10 nodes. > We> > > are using DSE 5.1.12 (cassandra 3.11).We have a high local write latency > on> > > a single table. All other

Re: high write latency on a single table

2019-07-18 Thread Rajsekhar Mallick
transactions or Batch writes or Prepared statements) Thanks On 2019/07/18 15:48:09, CPC wrote: > Hi all,> > > Our cassandra cluster consist of two dc and every dc we have 10 nodes. We> > are using DSE 5.1.12 (cassandra 3.11).We have a high local write latency on> > a

high write latency on a single table

2019-07-18 Thread CPC
Hi all, Our cassandra cluster consist of two dc and every dc we have 10 nodes. We are using DSE 5.1.12 (cassandra 3.11).We have a high local write latency on a single table. All other tables in our keyspace have normal latencies like 0.02 msec,even tables that have more write tps and more data