Skip to end of metadata
Go to start of metadata

The following is a list of frequently used stats available from statd_metadata.name.

Statistics are available as either counters or gauges. Counters are additive whereas a gauge captures a statistic at a given point of time and can be used to graph movement of that statistic.

Use the REGEXP function to query the following statistics. This example queries transactions per second from the prior 24 hours:

sql> USE clustrix_statd;
sql> SELECT timestamp, value, name 
     FROM clustrix_statd.statd_history 
     NATURAL JOIN clustrix_statd.statd_metadata 
     WHERE name REGEXP 'tps$' 
     AND timestamp > now() - interval 1 day 
     ORDER BY timestamp DESC; 

Connections

Metric NameREGEXPDescriptionMeasuresGraph as
clustrix.stats.connectionsconnectionsTotal number of connections to the clusterNumber of connectionscounter

Diagnostic

Metric NameREGEXPDescriptionMeasuresGraph as
clustrix.containers.countcontainers.countNumber of containers in use by ClustrixDBContainer Countgauge
clustrix.cluster.nodes_in_quorumnodes_in_quorumNumber of nodes currently online and in the clusterNumber of nodes onlinegauge
clustrix.stats.bigc_value.node.nnbigc_value.node.*XID value through which garbage collection will clean upBigC value by nodegauge
clustrix.stats.fc_wait_time.node.nnfc_wait_time.*Total time all queries spent waiting for flow control (inter-node communication)Time waiting on flow controlcounter
clustrix.stats.key_caches_updates.node.nnkey_caches_updates.node.Number of times the PD Cache issued update keys. This statistic is sometimes useful for support.PD Cache keys updatedcounter
clustrix.stats.layer_merge_bytes.node.nnlayer_merge_bytes.node.Size is bytes of layer merge operations by nodeLayer merge bytes by nodecounter
clustrix.stats.layer_merge_rows.node.nnlayer_merge_rows.node.Number of rows merged by layer merge operations by nodeLayer merge rows by nodecounter
clustrix.stats.pdcache_fetches.node.nnpdcache_fetches.node.Number of times the PD Cache fetched new PDsPD Cache fetches by nodecounter
clustrix.stats.pdcache_loaded.node.nnpdcache_loaded.node.Number of times the PD Cache loaded new PDsPD Cache loaded by nodecounter
clustrix.stats.qpc_missesqpc_missesNumber of times a query was missed by the QPCQuery Plan Cache, missescounter
clustrix.stats.qpc_recompilesqpc_recompilesNumber of times the QPC recompiled queriesQuery Plan Cache, recompilescounter
clustrix.stats.queries_not_using_indexesqueries_not_using_indexesNumber of queries on the cluster not using any indexQueries not using indexescounter

clustrix.stats.walltime_(read|write)_us

walltime_(read|write)_usTotal wall time (elapsed) of read or write queriesWall time of read or write queriescounter

Monitoring

Metric NameREGEXPDescriptionMeasuresGraph as
clustrix.rebalancer_(reprotects|deletes|rebalance|

redistributes|request|reranks|splits)

rebalancer_(reprotects|deletes|rebalance|

redistributes|request|reranks|splits)$'

Metrics for various Rebalancer actionsVarious Rebalancer actions.counter
clustrix.cluster.total_nodescluster.total_nodesThe total number of nodes configured for your cluster (not just in quorum)Total number of nodes gauge

Networking

Metric NameREGEXPDescriptionMeasuresGraph as

clustrix.io.network.latency_ms.avg.nodenn.(network interface)

latency_ms.avg.node.Network latency average per nodeNetwork Latency avg by nodegauge
clustrix.io.network.latency_ms.(min|max|avg)latency_ms....$Network latency min/max/avgNetwork latency min/max/avggauge

Performance

Metric NameREGEXPDescriptionMeasuresGraph as

clustrix.activity.core0.node.nn

core0.node.*TIL CPU core-0 utilization by nodeTil CPU Core-0 by nodegauge

clustrix.activity.til_avg

til_avg$Average core utilization for the cluster, excluding core-0Average Til CPUgauge
clustrix.activity.til_avg.node.nntil_avg.node.*Average TIL core (non core-0) utilization per node in a clusterAverage Til CPU by nodegauge
clustrix.activity.til_(min|max|avg).node.nntil_(min|max|avg).node.TIL CPU core (non core-0) utilization min/max/avgTil CPU min/max/avg by nodegauge

clustrix.activity.til_max

til_max$Max core utilization for the cluster, excluding core-0Max Til CPUgauge
clustrix.activity.til_max.node.nntil_max.node.*Average TIL core (non core-0) utilization per node in a clusterMax Til CPU by nodegauge

clustrix.cpu.load_(min|max)

cpu.load_...$CPU Core min/max database utilization onlyDatabase CPU min/maxgauge
clustrix.cpu.load.node.nn.cpu.0load.node.*.cpu.0CPU Core-0 by node database utilization onlyDatabase CPU Core only core-0 by nodegauge
clustrix.cpu.load.node.nn.cpu.nnload.node.*.cpu.[^0]\d*CPU Cores excluding core-0 by node database utilization onlyDatabase CPU core excluding core-0 by nodegauge
clustrix.lockman.wait_ms.(min|max|avg)lockman.wait_ms....$Total time all queries spent waiting on locksTime waiting on query locksgauge
clustrix.qpsqps$Cluster wide Queries per secondCluster QPSgauge
clustrix.response_time.read_usresponse_time.read_usCluster query read latency, number of queries divided by runtimeCluster read latencygauge
clustrix.response_time.write_usresponse_time.write_usCluster query write latency, number of queries divided by runtimeCluster write latencygauge
clustrix.stats.executing_sessionsexecuting_sessionsThe number of sessions currently executingSessions currently executinggauge
clustrix.stats.qps_total.node.nnqps_total.nodeQueries per second by nodeQPS by nodecounter
clustrix.stats.tm_cpu_waittime_ustm_cpu_waittimeThe total amount of time queries spent waiting due to the fair schedulerFair Scheduler wait timecounter
clustrix.stats.tps_total.node.nntps_total.nodeTransactions per second by nodeTPS by nodecounter
clustrix.tpstps$Cluster wide Transactions per secondCluster TPSgauge

Queries

Metric NameREGEXPDescriptionMeasuresGraph as
clustrix.stats.Com_(delete|insert|select|update)Com_(delete|insert|select|update)$Number of queries separated by query typeQueries by typecounter
clustrix.stats.Com_(delete|insert|select|update)_usCom_(delete|insert|select|update)_usAmount of run time by query typeTime per query typegauge
clustrix.stats.runtime_read_usruntime_read_usTotal runtime of read queriesRuntime of read queriescounter
clustrix.stats.runtime_write_usruntime_write_usTotal runtime of write queriesRuntime of write queriescounter

Replication

Metric NameREGEXPDescriptionMeasuresGraph as
clustrix.replication.slave.relay_log_bytes.(slave)relay_log_bytes[^_]Size in bytes of the relay logs for the replication slaveRelay log bytes for all slavesgauge
clustrix.replication.slave.bytes_read.(slave)slave.bytes_readBytes read by the replication slaveBytes read by slavecounter
clustrix.replication.slave.events_read.(slave)events_readNumber of events read by the replication slaveEvents read by slavecounter
clustrix.replication.slave.seconds_behind_master.(slave)seconds_behind_masterSeconds behind master value for all replication slavesSlave seconds behind mastergauge

Rows

Metric NameREGEXPDescriptionMeasuresGraph as

clustrix.containers.rows_read.node.nn

rows_read.node..$Number of rows read by node at the container levelRows read by node, containercounter

clustrix.containers.rows_written.node.nn

rows_written.node..$Number of rows written by node at the container levelRows written by node, containercounter
clustrix.containers.rows_(deleted|inserted|replaced)rows_(deleted|inserted|replaced)$Number of rows deleted, inserted and updated at the container levelRows, deleted, inserted, updatedcounter
clustrix.containers.rows_(read|written)containers.rows_(read|written)$Number of rows read and written at the container levelRows read and written, containercounter

clustrix.containers.rows_deleted

rows_deleted$Number of rows deletes at the container levelRows deleted, container levelcounter

clustrix.containers.rows_inserted

rows_inserted$Number of rows inserted at the container levelRows inserted, container levelcounter

clustrix.containers.rows_read

containers.rows_read$Number of rows read at the container levelRows read, container levelcounter

clustrix.containers.rows_replaced

rows_replaced$Number of rows updated at the container levelRows updated, container levelcounter

clustrix.containers.rows_written

rows_written$Number of rows written at the container levelRows written, container levelcounter
clustrix.stats.tm_rows_outputtm_rows_outputNumber of rows written by queriesRows written, transaction managercounter
clustrix.stats.tm_rows_readtm_rows_readNumber of rows read by queriesRows read, transaction managercounter

Storage

Metric NameREGEXPDescriptionMeasuresGraph as
clustrix.capacity.disks.(avg|max|min)_used_percent[avg|max|min]_used_percentThe min/max/avg disk capacity usedPercentage of disks in usegauge

clustrix.io.disk.bytes_read.node.nn.disk.(disk segment)

disk.bytes_read.node.Not applicable for virtual environments (i.e. i3s).Bytes read at the kernel levelcounter
clustrix.io.disk.bytes_written.node.nn.disk.(disk segment)disk.bytes_written.node.Not applicable for virtual environments (i.e. i3s).Bytes written at the kernel levelcounter
clustrix.io.disk.pct_utilization.node.nn.disk.(disk segment)disk.pct_utilization.nodeDisk utilization metric for individual physical disks hosting the vdev file (e.g. through an md RAID device)Disk utilizationgauge
clustrix.io.disk.read_latency_ms.node.nn.disk.(disk segment)read_latency_ms.node.Average read latency from IO time over the same periodStorage read latency, kernel level by nodegauge
clustrix.io.disk.write_latency_ms.node.nn.disk.(disk segment)write_latency_ms.node.Average write latency from IO time over the same periodStorage write latency, kernel level by nodegauge
clustrix.io.vdevs.bytes_readbytes_read$Device1 bytes read, cluster levelDevice1 bytes read, cluster levelcounter
clustrix.io.vdev.bytes_read.node.nn.vdev.3bytes_read.node.*.vdev.3Device1 bytes read by nodeDevice1 bytes read by nodecounter
clustrix.io.vdevs.bytes_read_per_secbytes_read_per_secDevice1 bytes read per secondDevice1 bytes read per secondgauge
clustrix.io.vdevs.bytes_writttenbytes_written$Device1 bytes written, cluster levelDevice1 bytes written, cluster levelcounter
clustrix.io.vdev.bytes_written.node.nn.vdev.3bytes_written.node.*.vdev.3Device1 bytes written by nodeDevice1 bytes written by nodecounter
clustrix.io.vdevs.bytes_written_per_secbytes_written_per_secDevice1 bytes written per secondDevice1 bytes written per secondgauge
clustrix.io.vdev.read_latency_us.node.nn.vdev.3read_latency_us.node.*.vdev.3Device1 read latency by nodeDevice1 read latency by nodegauge
clustrix.io.vdev.sync_latency_us.node.nn.vdev.3sync_latency_us.node.*.vdev.3Device1 sync latency by nodeDevice1 sync latency by nodegauge
clustrix.io.vdev.write_latency_us.node.nn.vdev.3write_latency_us.node.*.vdev.3Device1 write latency by nodeDevice1 write latency by nodegauge
  • No labels