Hi,
I would like to log all C* queries hitting cluster. Could someone please
tell me how can I do it at cluster level?
Will nodetool setlogginglevel work? If so, please share example with
library name.
C* version 3.11
If using dse then u can enable in dse.yaml.
# CQL slow log settings
cql_slow_log_options:
enabled: true
threshold_ms: 0
ttl_seconds: 259200
As far as my understanding says setlogginglevel is used for changing the
logging level as below but not for slow query .
- ALL
- TRACE
- DEBUG
Thanks Surbhi. I found another way. I used nodetool settraceprobability 1
and it is logging in system_traces.
How is it different from nodeool setlogginglevel?
Regards,
Nitan K.
Cassandra and Oracle Architect/SME
Datastax Certified Cassandra expert
Oracle 10g Certified
On Fri, May 25, 2018 at 1
nodeool setlogginglevel is only valid for below :
- org.apache.cassandra
- org.apache.cassandra.db
- org.apache.cassandra.service.StorageProxy
On 25 May 2018 at 09:01, Nitan Kainth wrote:
> Thanks Surbhi. I found another way. I used nodetool settraceprobability 1
> and it is logging
Please suggest me some good cluster monitoring tool for cassandra multi
region cluster.
I assume you are using open source cassandra and you can look at Prometheus
grafana for cassandra monitoring and lot information available in internet
regarding how to setup the Prometheus monitoring for cassandra .
Sent from my iPhone
> On May 25, 2018, at 9:23 AM, ANEESH KUMAR K.M wrote:
>
Thank you Hari for the details.
One more question, please suggest me some cluster managing too for
Cassandra cluster. Looking for opensource tools that will support to take
snapshot and restore via GUI.
Regards,
Aneesh
On Fri, May 25, 2018 at 10:00 PM, Harikrishnan Pillai <
hpil...@walmartlabs.c
So settraceprobability is better option than nodetool :)
Regards,
Nitan K.
Cassandra and Oracle Architect/SME
Datastax Certified Cassandra expert
Oracle 10g Certified
On Fri, May 25, 2018 at 12:15 PM, Surbhi Gupta
wrote:
> nodeool setlogginglevel is only valid for below :
>
>
>- org.apache
Hello,
Where I can have configurable codes in partition key as cassandra supports.
>
I am sorry I don't understand this.
1) How much data I can put in one partition ?
>
Well, Cassandra supports huge partitions. In practice, the value of 100 MB
per partition is often shared. I consider it's a go
Hello Matthias,
I don't think you really left :). Give this address a try instead:
user-unsubscr...@cassandra.apache.org
;-)
C*iao,
2018-05-24 23:37 GMT+01:00 Matthias Hübner :
> Ciao
>
Hello,
With more details on your criteria, it would be easier.
I used:
- SPM from Sematext (Commercial - dashboards out of the box)
- Datastax OpsCenter (Commercial, With DSE only nowadays)
- Grafana/Graphite or Prometheus (Open source - 'do it yourself' - but some
templates exist)
- Datadog (Co
Hello Aneesh,
Alain and I also worked on this project that you might find useful:
https://github.com/thelastpickle/docker-cassandra-bootstrap
It is a Docker Compose environment to showcase the Prometheus graphs that
we worked on. There's still a missing update, so do please check back soon,
but
Nate wrote a post about this exact topic. In case it is of some use:
http://thelastpickle.com/blog/2016/02/10/locking-down-apache-cassandra-logging.html
C*heers,
---
Alain Rodriguez - @arodream - al...@thelastpickle.com
France / Spain
The Last Pickle - Apache Cassandra Consult
Thanks Alain
Regards,
Nitan K.
Cassandra and Oracle Architect/SME
Datastax Certified Cassandra expert
Oracle 10g Certified
On Fri, May 25, 2018 at 2:05 PM, Alain RODRIGUEZ wrote:
> Nate wrote a post about this exact topic. In case it is of some use:
> http://thelastpickle.com/blog/2016/02/10/l
https://issues.apache.org/jira/browse/CASSANDRA-13983 was added to
cassandra 4.0
On Fri, May 25, 2018 at 8:24 AM, Nitan Kainth wrote:
> Hi,
>
> I would like to log all C* queries hitting cluster. Could someone please
> tell me how can I do it at cluster level?
> Will nodetool setlogginglevel w
this is awesome Jeff.
Regards,
Nitan K.
Cassandra and Oracle Architect/SME
Datastax Certified Cassandra expert
Oracle 10g Certified
On Fri, May 25, 2018 at 3:00 PM, Jeff Jirsa wrote:
> https://issues.apache.org/jira/browse/CASSANDRA-13983 was added to
> cassandra 4.0
>
>
>
> On Fri, May 25, 20
Hello Aneesh,
While this doesn't provide a GUI, tablesnap is a community tool that does a
great job at handling backups:
https://github.com/JeremyGrosser/tablesnap
Cheers,
Joaquin
Joaquin Casares
Consultant
Austin, TX
Apache Cassandra Consulting
http://www.thelastpickle.com
On Fri, May 25,
Good article about it on LI
https://www.linkedin.com/pulse/snap-cassandra-s3-tablesnap-vijaya-kumar-hosamani/
On May 25, 2018, 2:52 PM -0500, Joaquin Casares ,
wrote:
> Hello Aneesh,
>
> While this doesn't provide a GUI, tablesnap is a community tool that does a
> great job at handling backups:
I've run across this problem before - it seems like GNU tar interprets
changes in the link count as changes to the file, so if the file gets
compacted mid-backup it freaks out even if the file contents are
unchanged. I worked around it by just using bsdtar instead.
On Thu, May 24, 2018 at 6:08 AM
I looked at the source code for GNU tar, and it looks for a change in the
create time or (more likely) a change in the size.
This seems very strange to me — I would think that creating a snapshot would
cause a flush and then once the SSTables are written, hardlinks would be
created and the SSTa
20 matches
Mail list logo
