Skip to content

Instantly share code, notes, and snippets.

@ezbz

ezbz/cassandra.column.families

Created February 23, 2013 14:35
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ezbz/5019989 to your computer and use it in GitHub Desktop.
Save ezbz/5019989 to your computer and use it in GitHub Desktop.
Download ZIP
Graphitus Dashboards for Cassandra
Raw
cassandra.column.families
{
"averageSeries": false,
"columns": 2,
"refresh": true,
"refreshIntervalSeconds": 30,
"title": "Cassandra Column Family",
"user": "erez",
"width": 700,
"defaultLineWidth": 2,
"height": 350,
"hoursBack": 6,
"legend": true,
"data": [
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.RecentReadLatencyMicros,${split-index},\"averageSeries\")",
"title": "Recent Read Latency Microseconds"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.TotalReadLatencyMicros,${split-index},\"nonNegativeDerivative\")",
"title": "Total Read Latency Microseconds"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.RecentWriteLatencyMicros,${split-index},\"averageSeries\")",
"title": "Recent Write Latency Microseconds"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.TotalWriteLatencyMicros,${split-index},\"nonNegativeDerivative\")",
"title": "Total Write Latency Microseconds"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.ReadCount,${split-index},\"nonNegativeDerivative\")",
"title": "Read Count"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.WriteCount,${split-index},\"nonNegativeDerivative\")",
"title": "Write Count"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.*RowSize,4,\"averageSeries\")",
"title": "Row Size"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.*DiskSpaceUsed,4,\"averageSeries\")",
"title": "Disk Space"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.CompressionRatio,${split-index},\"averageSeries\")",
"title": "Compression Ratio"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.MemtableColumnsCount,${split-index},\"nonNegativeDerivative\")",
"title": "Memtable Column Count"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.MemtableDataSize,${split-index},\"nonNegativeDerivative\")",
"title": "Memtable Data Size"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.MemtableSwitchCount,${split-index},\"nonNegativeDerivative\")",
"title": "Memtable Switch Count"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.PendingTasks,${split-index},\"averageSeries\")",
"title": "Pending Tasks"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.Caches.${ColumnFamily}.KeyCache.Requests,${split-index},\"nonNegativeDerivative\")",
"title": "Key Cache Requests"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.Caches.${ColumnFamily}.KeyCache.RecentHitRate,${split-index},\"averageSeries\")",
"title": "Key Cache Recent Hit Rate"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.Caches.${ColumnFamily}.KeyCache.Hits,${split-index},\"nonNegativeDerivative\")",
"title": "Key Cache Hits"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.Caches.${ColumnFamily}.KeyCache.{Capacity,Size},${split-index},\"averageSeries\")",
"title": "Key Cache Capacity/Size"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.Caches.${ColumnFamily}.RowCache.Requests,${split-index},\"nonNegativeDerivative\")",
"title": "Row Cache Requests"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.Caches.${ColumnFamily}.RowCache.RecentHitRate,${split-index},\"averageSeries\")",
"title": "Row Cache Recent Hit Rate"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.Caches.${ColumnFamily}.RowCache.Hits,${split-index},\"nonNegativeDerivative\")",
"title": "Row Cache Hits"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.Caches.${ColumnFamily}.RowCache.{Capacity,Size},${split-index},\"averageSeries\")",
"title": "Row Cache Capacity/Size"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.BloomFilterFalseRatio,${split-index},\"averageSeries\")",
"title": "BloomFilter False Ratio"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.BloomFilterFalsePositives,${split-index},\"averageSeries\")",
"title": "BloomFilter False Positives"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.RecentBloomFilterFalseRatio,${split-index},\"averageSeries\")",
"title": "Recent BloomFilter False Ratio"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.RecentBloomFilterFalsePositives,${split-index},\"averageSeries\")",
"title": "Recent BloomFilter False Positives"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.LiveSSTableCount,${split-index},\"averageSeries\")",
"title": "Live SSTable Count"
},
{
"target": "groupByNode(servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies.${ColumnFamily}.UnleveledSSTables,${split-index},\"averageSeries\")",
"title": "Unleveled SSTables"
}
],
"parameters": {
"cluster": {
"metadata": {
"cluster": "cass1"
},
"analytics": {
"cluster": "cass2"
}
},
"datacenter": {
"All": {
"dc": "*"
},
"Chicago": {
"dc": "chi"
},
"LA": {
"dc": "la"
},
"New York": {
"dc": "ny"
}
},
"ColumnFamily": {
"type": "dynamic",
"query": "servers.cass${cluster}_${dc}dc1_8080.ColumnFamilies",
"index": 3,
"showAll": true
},
"group-by": {
"Host" : {
"split-index" : 1
},
"ColumnFamily" : {
"split-index" : 3,
"ColumnFamily" : "*",
"cluster" : "*"
}
}
}
}
Raw
cassandra.servers
{
"averageSeries": false,
"columns": 2,
"defaultLineWidth": 2,
"height": 350,
"legend": true,
"refresh": true,
"refreshIntervalSeconds": 300,
"timeBack": "6h",
"title": "Cassandra Servers",
"user": "erez",
"width": 700,
"data": [
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.com_sun_management_UnixOperatingSystem.SystemLoadAverage,1,\"averageSeries\")",
"title": "Load Average"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.com_sun_management_UnixOperatingSystem.FreePhysicalMemorySize,1,\"averageSeries\")",
"title": "Free Physical Memory"
},
{
"target": "groupByNode(nonNegativeDerivative(servers.${cluster}*${dc}dc1_*.ColumnFamilies.*.WriteCount),3,\"sumSeries\")",
"title": "Writes by ColumnFamily"
},
{
"target": "groupByNode(nonNegativeDerivative(servers.${cluster}*${dc}dc1_*.ColumnFamilies.*.ReadCount),3,\"sumSeries\")",
"title": "Reads by ColumnFamily"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.CompactionManager.PendingTasks,1,\"averageSeries\")",
"title": "Compaction Pending Tasks"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Stage.*.PendingTasks,3,\"averageSeries\")",
"title": "Stage Panding Tasks"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Stage.*.ActiveCount,3,\"averageSeries\")",
"title": "Stage Active Count"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.heap.HeapMemoryUsage_used,1,\"averageSeries\")",
"title": "Heap Memory Usage"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.heap.NonHeapMemoryUsage_used,1,\"averageSeries\")",
"title": "Non Heap Memory Usage"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.gc.ConcurrentMarkSweep.CollectionTime,1,\"nonNegativeDerivative\")",
"title": "GC - ConcurrentMarkSweep Collection Time"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.gc.ConcurrentMarkSweep.CollectionCount,1,\"nonNegativeDerivative\")",
"title": "GC - ConcurrentMarkSweep Collection Count"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.gc.ParNew.CollectionTime,1,\"nonNegativeDerivative\")",
"title": "GC - ParNew Collection Time"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.gc.ParNew.CollectionCount,1,\"nonNegativeDerivative\")",
"title": "GC - ParNew Collection Count"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Threading.ThreadCount,1,\"averageSeries\")",
"title": "Thread Count"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Threading.TotalStartedThreadCount,1,\"nonNegativeDerivative\")",
"title": "Total Thread Count"
}
],
"parameters": {
"datacenter": {
"All": {
"dc": "*"
},
"LA": {
"dc": "la"
},
"New York": {
"dc": "ny"
},
"Chicago": {
"dc": "chi"
}
},
"Cluster": {
"metadata": {
"cluster": "cass1"
},
"analytics": {
"cluster": "cass2"
}
}
}
}
Raw
cassandra.servers.internals
{
"averageSeries": false,
"columns": 2,
"defaultLineWidth": 2,
"height": 350,
"legend": true,
"refresh": true,
"refreshIntervalSeconds": 300,
"timeBack": "6h",
"title": "Cassandra Servers Internals",
"user": "erez",
"width": 700,
"data": [
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Commitlog.PendingTasks,1,\"nonNegativeDerivative\")",
"title": "CommitLog Pending Tasks"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Commitlog.TotalCommitlogSize,1,\"nonNegativeDerivative\")",
"title": "CommitLog Total Size"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.CompactionManager.PendingTasks,1,\"averageSeries\")",
"title": "CompactionManager Pending Tasks"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.ReadOperations,1,\"nonNegativeDerivative\")",
"title": "StorageProxy Read Operations"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.WriteOperations,1,\"nonNegativeDerivative\")",
"title": "StorageProxy Write Operations"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.RangeOperations,1,\"nonNegativeDerivative\")",
"title": "StorageProxy Range Operations"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.RecentWriteLatencyMicros,1,\"averageSeries\")",
"title": "StorageProxy Recent Write Latency Micros"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.RecentRangeLatencyMicros,1,\"averageSeries\")",
"title": "StorageProxy Recent Range Latency Micros"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.RecentReadLatencyMicros,1,\"averageSeries\")",
"title": "StorageProxy Recent Read Latency Micros"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.TotalWriteLatencyMicros,1,\"nonNegativeDerivative\")",
"title": "StorageProxy Total Write Latency Micros"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.TotalRangeLatencyMicros,1,\"nonNegativeDerivative\")",
"title": "StorageProxy Total Range Latency Micros"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.TotalReadLatencyMicros,1,\"nonNegativeDerivative\")",
"title": "StorageProxy Total Read Latency Micros"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.HintsInProgress,1,\"averageSeries\")",
"title": "StorageProxy Hints In Progress"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageProxy.TotalHints,1,\"nonNegativeDerivative\")",
"title": "StorageProxy Total Hints"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageService.ExceptionCount,1,\"averageSeries\")",
"title": "StorageService Exception Count"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.StorageService.Load,1,\"averageSeries\")",
"title": "StorageService Load"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.MessagingService.RecentTotalTimouts,1,\"nonNegativeDerivative\")",
"title": "MessagingService Recent Total Timeouts"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.MessagingService.TotalTimeouts,1,\"nonNegativeDerivative\")",
"title": "StorageService Total Timeouts"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Internal.*.ActiveCount,3,\"averageSeries\")",
"title": "Internal Stage Active Count"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Internal.*.CompletedTasks,3,\"averageSeries\")",
"title": "Internal Stage Completed Tasks"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Internal.*.*BlockedTasks,3,\"averageSeries\")",
"title": "Internal Stage Blocked Tasks"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Internal.*.PendingTasks,3,\"averageSeries\")",
"title": "Internal Stage Pending Tasks"
},
{
"target": "groupByNode(servers.${cluster}*${dc}dc1_8080.Internal.*.ActiveCount,3,\"averageSeries\")",
"title": "Internal Stage Active Count"
}
],
"parameters": {
"datacenter": {
"All": {
"dc": "*"
},
"LA": {
"dc": "la"
},
"New York": {
"dc": "ny"
},
"Chicago": {
"dc": "chi"
}
},
"Cluster": {
"metadata": {
"cluster": "cass1"
},
"analytics": {
"cluster": "cass2"
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment