Pacific-Design.com

    
Home Index

1. Cassandra

2. Nodetool

Cassandra / Nodetool /


USE engine;

CREATE TABLE user (
  id int,
  first_name text,
  last_name text
  PRIMARY KEY(id, last_name)
) WITH CLUSTERING ORDER BY ( last_name DESC )

COPY user (id, first_name, last_name, city, phone) FROM student_flatfile.csv


#!/bin/bash
#---------------------------------------------------------------------------#
# Execute when IO is LOW  : ./health_check.sh low
# Execute when IO is HIGH : ./health_check.sh high 
#---------------------------------------------------------------------------#
nodetool cfstats | tee cfstats_$1.dat
nodetool compactionstats | tee compactionstats_$1.dat
nodetool gossipinfo | gossipinfo_$1.dat
nodetool info | tee info_$1.dat
nodetool netstats | netstats_$1.dat
nodetool proxyhistograms | tee proxyhistograms_$1.dat
nodetool rangekeysample | tee rangekeysample_$1.dat
nodetool ring | tee ring_$1.dat
nodetool statusbackup | tee statusbackup_$1.dat
nodetool statusbinary | tee statusbinary_$1.dat
nodetool statusgossip | tee statusgossip_$1.dat
nodetool statushandoff | tee statushandoff_$1.dat
nodetool status | tee status_$1.dat
nodetool statusthrift | tee statusthrift_$1.dat
nodetool toppartitions keyspace table 1000 | tee toppartitions_$1.dat
nodetool tpstats | tee tpstats_$1.dat
#---------------------------------------------------------------------------#