Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of tomas.nunez@groupalia.com
 designates 209.85.214.171 as permitted sender)
MIME-Version: 1.0
Date: Fri, 17 May 2013 18:00:49 +0200
Message-ID: 
 <CAPFraJvRnxKo8AOLz5TunFjurkkDUQ_Zsmoqgx3NkP3aEBDqmw@mail.gmail.com>
Subject: Logging Cassandra queries
From: =?ISO-8859-1?Q?Tom=E0s_N=FAnez?= <tomas.nunez@groupalia.com>
To: user <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=e89a8ff1cf862bb13a04dcec1635

--e89a8ff1cf862bb13a04dcec1635
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi!

For quite time I've been having some unexpected loadavg in the cassandra
servers. I suspect there are lots of uncontrolled queries to the cassandra
servers causing this load, but the developers say that there are none, and
the load is due to cassandra internal processes.

Trying to get to the bottom, I've been looking into completed ReadStage and
MutationStage through JMX, and the numbers seem to confirm my theory, but
I'd like to go one step forward and, if possible, list all the queries from
the webservers to the cassandra cluster (just one node would be enough).

I've been playing with cassandra loglevels, and I can see when a Read or a
Write is done, but it would be better if I could knew the CF of the query.
For my tests I've put the in the log4j.server
" log4j.rootLogger=3DDEBUG,stdout,R", writing and reading a test CF, and I
can't see the name of it anywhere.

For the test I'm using Cassandra 0.8.4 (yes, still), as my production
servers, and also 1.0.11. Maybe this changes in 1.1? Maybe I'm doing
something wrong? Any hint?

And... could I be more precise when enabling logging? Because right now,
with *log4j.rootLogger=3DDEBUG,stdout,R* I'm getting a lot of information I
won't use ever, and I'd like to enable just what I need to see gets and
seds....

Thanks in advance,
Tom=E0s

--e89a8ff1cf862bb13a04dcec1635
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi!<div><br></div><div>For quite time I&#39;ve been having=
 some unexpected loadavg in the cassandra servers. I suspect there are lots=
 of uncontrolled queries to the cassandra servers causing this load, but th=
e developers say that there are none, and the load is due to cassandra inte=
rnal processes.=A0</div>
<div><br></div><div>Trying to get to the bottom, I&#39;ve been looking into=
 completed ReadStage and MutationStage through JMX, and the numbers seem to=
 confirm my theory, but I&#39;d like to go one step forward and, if possibl=
e, list all the queries from the webservers to the cassandra cluster (just =
one node would be enough).=A0</div>
<div><br></div><div>I&#39;ve been playing with cassandra loglevels, and I c=
an see when a Read or a Write is done, but it would be better if I could kn=
ew the CF of the query. For my tests I&#39;ve put the in the log4j.server &=
quot;=A0log4j.rootLogger=3DDEBUG,stdout,R&quot;, writing and reading a test=
 CF, and I can&#39;t see the name of it anywhere.</div>
<div><br></div><div>For the test I&#39;m using Cassandra 0.8.4 (yes, still)=
, as my production servers, and also 1.0.11. Maybe this changes in 1.1? May=
be I&#39;m doing something wrong? Any hint?</div><div><br></div><div style>
And... could I be more precise when enabling logging? Because right now, wi=
th <i>log4j.rootLogger=3DDEBUG,stdout,R</i>=A0I&#39;m getting a lot of info=
rmation I won&#39;t use ever, and I&#39;d like to enable just what I need t=
o see gets and seds....</div>
<div style><br></div><div style>Thanks in advance,=A0</div><div style>Tom=
=E0s</div><div><br></div></div>

--e89a8ff1cf862bb13a04dcec1635--