[prev in list] [next in list] [prev in thread] [next in thread] 

List:       cassandra-user
Subject:    Opscenter's Meaning of 'Requests'
From:       Arun Kumar K <arunk786 () gmail ! com>
Date:       2013-12-30 11:50:36
Message-ID: CAO7gJeg5ryntDxUtdz8Oya+96scXWLudyBJQ3MxFcqw8TXR=CQ () mail ! gmail ! com
[Download RAW message or body]

Hi Guys,

I have started understanding Cassandra and am working with it recently.

I have created two Column Families. For CF1, a write is an insert into a
unique row with all column values. Eg:

      Key Col1  Col2   Col3
      k1  c11   c12   c13
      k2  c21   c22   c23

For CF2. a write is an insert into a time stamped column of a row. Eg:

     Key  timeCol1  timeCol2
     k1   ct11
     k1              ct12
     k2    ct21
     k2               ct22

I am using YCSB and using thrift based *client.batch_mutate()* call. For
CF1, i send all column vals for a row through the call. For CF2, i send the
new column vals for a row.

Now say opscenter reports the "write requests" as say 1000 *operations*/sec
when a record count is say 10000 records.

OpsCenter API docs say 'Write Requests" as "requests per second".

What does an operation/request mean from opscenter perspective? Does it
mean unique row inserts across all column families ? Does it mean count of
each mutations for a row ?

How does opscenter identify a unique operation/request ? Is it related or
dependent on the row count or mutation count of batch_mutate() call ?

From application perspective an operation means differently for both column
families.

Can some one guide me ?

Thanks,

Arun

[Attachment #3 (text/html)]

<div dir="ltr"><p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">

Hi Guys,</p><p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">

I have started understanding Cassandra and am working with it recently.</p><p \
style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">

I have created two Column Families. For CF1, a write is an insert into a unique row \
with all column values. Eg:</p><pre \
style="margin-top:0px;margin-bottom:10px;padding:5px;border:0px;font-size:14px;vertica \
l-align:baseline;background-color:rgb(238,238,238);font-family:Consolas,Menlo,Monaco,&#39;Lucida \
Console&#39;,&#39;Liberation Mono&#39;,&#39;DejaVu Sans Mono&#39;,&#39;Bitstream Vera \
Sans Mono&#39;,&#39;Courier \
New&#39;,monospace,serif;overflow:auto;width:auto;max-height:600px;word-wrap:normal;color:rgb(0,0,0);line-height:18px">


<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,&#39;Lucida \
Console&#39;,&#39;Liberation Mono&#39;,&#39;DejaVu Sans Mono&#39;,&#39;Bitstream Vera \
Sans Mono&#39;,&#39;Courier New&#39;,monospace,serif">      Key Col1  Col2   Col3  k1 \
c11   c12   c13  k2  c21   c22   c23
</code></pre><p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">

For CF2. a write is an insert into a time stamped column of a row. Eg:</p><pre \
style="margin-top:0px;margin-bottom:10px;padding:5px;border:0px;font-size:14px;vertica \
l-align:baseline;background-color:rgb(238,238,238);font-family:Consolas,Menlo,Monaco,&#39;Lucida \
Console&#39;,&#39;Liberation Mono&#39;,&#39;DejaVu Sans Mono&#39;,&#39;Bitstream Vera \
Sans Mono&#39;,&#39;Courier \
New&#39;,monospace,serif;overflow:auto;width:auto;max-height:600px;word-wrap:normal;color:rgb(0,0,0);line-height:18px">


<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,&#39;Lucida \
Console&#39;,&#39;Liberation Mono&#39;,&#39;DejaVu Sans Mono&#39;,&#39;Bitstream Vera \
Sans Mono&#39;,&#39;Courier New&#39;,monospace,serif">     Key  timeCol1  timeCol2  \
k1   ct11  k1              ct12
     k2    ct21
     k2               ct22
</code></pre><p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">

I am using YCSB and using thrift based <strong \
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">client.batch_mutate()</strong> \
call. For CF1, i send all column vals for a row through the call. For CF2, i send the \
new column vals for a row.</p>

<p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">Now say opscenter \
reports the &quot;write requests&quot; as say 1000 <strong \
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">operations</strong>/sec \
when a record count is say 10000 records.</p>

<p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">OpsCenter API docs say \
&#39;Write Requests&quot; as &quot;requests per second&quot;.  </p>

<p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">What does an \
operation/request mean from opscenter perspective? Does it mean unique row inserts \
across all column families ? Does it mean count of each mutations for a row ? </p>

<p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">How does opscenter \
identify a unique operation/request ? Is it related or dependent on the row count or \
mutation count of batch_mutate() call ?</p>

<p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">From application \
perspective an operation means differently for both column families.</p>

<p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">Can some one guide me \
?</p>

<p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">Thanks, </p>

<p style="margin:0px 0px \
1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,&#39;Liberation \
Sans&#39;,&#39;DejaVu Sans&#39;,sans-serif;line-height:18px">Arun</p>

</div>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic