Evaluating engineering tools? Get the comparison in Google Sheets

Connection

cqlsh
Connect to ScyllaDB server using cqlsh

cqlsh -u -p
Connect to ScyllaDB with authentication

nodetool -h -p status
Check node status and cluster information

Basic CQL Commands

DESCRIBE KEYSPACES;
List all keyspaces

DESCRIBE TABLES;
List all tables

USE ;
Switch to a keyspace

DESCRIBE TABLE ;
Show table schema

SELECT * FROM LIMIT 10;
Query first 10 rows from a table

Monitoring Performance

nodetool status
Check cluster status

nodetool info
Show node information

nodetool tablestats
Display table statistics

nodetool tpstats
Show thread pool statistics

nodetool compactionstats
View compaction statistics

nodetool netstats
Network information

Admin Operations

nodetool repair
Run repair on a node

nodetool cleanup
Clean up keyspaces/tables

nodetool flush
Flush memtables to disk

nodetool compact
Force compaction

nodetool upgradesstables
Upgrade SSTables to current version

Metrics and Diagnostics

curl -X GET http://:9180/metrics
Get Prometheus metrics

curl -X GET http://:9180/storage_service/gossip_info
Get gossip state info

scylla-housekeeping status
Check ScyllaDB health

sudo scylla_io_setup
Configure and optimize I/O settings

Configuration

cat /etc/scylla/scylla.yaml
View configuration file

scyllatop
Real-time monitoring of ScyllaDB resources

nodetool getlogginglevels
Show current logging levels

nodetool setlogginglevel
Set logging level (TRACE/DEBUG/INFO/WARN/ERROR)