SingleStore integration metrics

The official Datadog integration for monitoring SingleStore. It collects 94 metrics.

Official summary

Collect SingleStore metrics from leaves and aggregators.

Metric types

  • gauge (value at a point in time): 92
  • count (occurrences in the interval): 2

Metrics

Descriptions are the official definitions, unedited.

MetricTypeUnit
singlestore.aborted_clientsThe number of aborted connections caused by the client dying without closing the connection properly.gaugeconnection/second
singlestore.aborted_connectsThe number of failed attempts to connect to the server.gaugeconnection/second
singlestore.active_dedicated_admin_connectionsActive admin connections.gaugeconnection
singlestore.aggregators.average_roundtrip_latencyThe average ping roundtrip latency for a given aggregator.gaugemillisecond
singlestore.aggregators.opened_connectionsThe number of connections opened on a given aggregator.gaugeconnection
singlestore.auto_attach_remaining_secondsThe time remaining until the automatic rebalance triggered by an auto-attach operation will occur. Only applies to aggregators.gaugesecond
singlestore.average_garbage_collection_durationAverage duration of garbage collection.gaugesecond
singlestore.buffer_manager_cached_memoryTracks memory that was allocated by the Buffer Manager but is now cached and not in use. Limited to 25% of maximum_memory.gaugebyte
singlestore.buffer_manager_memoryTracks memory that is allocated by the Buffer Manager for SingleStore DB's built-in memory allocators.gaugebyte
singlestore.buffer_manager_unrecycled_memoryNumber of buffers ready to be recycled which have not yet been reclaimed.gaugebyte
singlestore.bytes_receivedThe number of bytes received per second from all clients.gaugebyte/second
singlestore.bytes_sentThe number of bytes sent per second sent to clients.gaugebyte/second
singlestore.connectionsThe number of successful or non-successful connection attempts to the server.gaugeconnection/second
singlestore.context_switch_missesThe number of times the scheduler tried to switch connections but failed.gaugeconnection/second
singlestore.context_switchesThe number of times any thread has switched connections because it deemed a connection idle.gaugeconnection/second
singlestore.cpu.cores_countThe number of cores on host.gaugecore
singlestore.cpu.guestTime spent running a virtual CPU for guest operating systems under the control of the Linux kernel.gaugepercent
singlestore.cpu.guest_niceTime spent running a nice guest (virtual CPU for guest operating systems under the control of the Linux kernel).gaugepercent
singlestore.cpu.idleTime spent in idle.gaugepercent
singlestore.cpu.iowaitTime spent waiting for I/O.gaugepercent
singlestore.cpu.irqTime spent on servicing interrupts.gaugepercent
singlestore.cpu.memsql_systemCPU usage by the SingleStore DB process, in kernel mode.gaugepercent
singlestore.cpu.memsql_totalCPU usage by the SingleStore DB process.gaugepercent
singlestore.cpu.memsql_userCPU usage by the SingleStore DB process, in user mode.gaugepercent
singlestore.cpu.niceCPU usage in nice mode.gaugepercent
singlestore.cpu.soft_irqTime spent on servicing soft interrupts.gaugepercent
singlestore.cpu.stealStolen time, which is the time spent in other operating systems when running in a virtualized environment.gaugepercent
singlestore.cpu.systemCPU usage in kernel modegaugepercent
singlestore.cpu.total_usedCPU usage in percent. It refers to the whole machine, and not to SingleStore DB cgroup.gaugepercent
singlestore.cpu.userCPU usage in user mode.gaugepercent
singlestore.disk.freeThe remaining disk space available.gaugebyte
singlestore.disk.read_bytesNumber of bytes read per second from the disk across all mount points.gaugebyte/second
singlestore.disk.totalThe total size of the disk.gaugebyte
singlestore.disk.usedThe amount of bytes used by the disk.gaugebyte
singlestore.disk.write_bytesNumber of bytes written per second to the disk across all mount points.gaugebyte/second
singlestore.disk_space_reserved_for_secondary_indexDisk space reserver for secondary index usage.gaugebyte
singlestore.execution_time_of_reads_pctWall-time percentage of all read queries.gaugepercent
singlestore.execution_time_of_write_pctWall-time percentage of all write queries.gaugepercent
singlestore.failed_read_queriesNumber of read queries per second which have failed.gaugequery/second
singlestore.failed_write_queriesNumber of write queries per second which have failed.gaugequery/second
singlestore.free_io_pool_memorySize of cached free buffers, which tracks how much memory in the IO pool is currently not in use. The maximum limit applies to each pool per partition on a node and can shrink if memory is reused. This variable can only be used to view the unused IO pool memory.gaugebyte
singlestore.idle_queueThe number of connections in the idle queue. This is a subset of threads_idle.gaugeconnection
singlestore.inflight_async_compilationsNumber of inflight asynchronous compilations currently running.gauge-
singlestore.ingest_errors_disk_space_useIngest errors disk space usage.gaugebyte
singlestore.leaves.average_roundtrip_latencyThe average ping roundtrip latency in milliseconds for a given leaf node.gaugemillisecond
singlestore.leaves.opened_connectionsThe number of connections opened on a given leaf node.gaugeconnection
singlestore.license_capacityLicense capacitygaugeunit
singlestore.maximum_cluster_capacityThe allowed memory capacity in the cluster based on the license. Only on the master aggregator.gaugebyte
singlestore.mem.cgroup_freeThe memory free capacity in percent of all processes of SingleStore DB cgroup.gaugepercent
singlestore.mem.cgroup_totalThe memory limit for the SingleStore DB node_id based on its cgroup membership.gaugebyte
singlestore.mem.cgroup_usedThe memory used by all processes of SingleStore DB cgroup.gaugebyte
singlestore.mem.freeThe remaining free memory capacity on the physical host as a percentage.gaugepercent
singlestore.mem.singlestore_used_memoryThe memory used by SingleStore DB process specified by node_id.gaugebyte
singlestore.mem.totalThe memory available on the physical host.gaugebyte
singlestore.mem.usedThe total memory used on the physical host.gaugebyte
singlestore.net.bytes_rxThe number of bytes received per second on each interface.gaugebyte/second
singlestore.net.bytes_txThe number of bytes sent per second on each interface.gaugebyte/second
singlestore.queriesThe number of statements executed by the server per second, including statements from clients and statements within stored programs.gaugequery/second
singlestore.query_compilation_failuresNumber of query compilation failures.gaugequery/second
singlestore.query_compilationsNumber of query compilations.gaugequery/second
singlestore.questionsThe number of statements executed by the server per second, excluding statements within stored programs.gaugequery/second
singlestore.ready_queueThe number of connections with pending queries not associated with threads.gaugeconnection
singlestore.rows_affected_by_writesNumber of rows affected by write queries.gaugerow/second
singlestore.rows_returned_by_readsNumber of rows returned by read queries.gaugerow/second
singlestore.seconds_until_expirationSeconds until expiration of the license.gaugesecond
singlestore.ssl.accept_renegotiatesReturns the number of start renegotiations in server mode.gaugeconnection/second
singlestore.ssl.acceptsReturns the number of started SSL/TLS handshakes in server mode.gaugeconnection/second
singlestore.ssl.client_connectsReturns the number of started SSL/TLS handshakes in client mode.gaugeconnection/second
singlestore.ssl.connect_renegotiatesReturns the number of start renegotiations in client mode.gaugeconnection/second
singlestore.ssl.finished_acceptsReturns the number of successfully established SSL/TLS sessions in server mode.gaugeconnection/second
singlestore.ssl.finished_connectsReturns the number of successfully established SSL/TLS sessions in client mode.gaugeconnection/second
singlestore.successful_read_queriesNumber of read queries per second which have successfully run.gaugequery/second
singlestore.successful_write_queriesNumber of write queries per second which have successfully run.gaugequery/second
singlestore.threads.backgroundBackground threads managed by the query scheduler, i.e. replication master queries and the scheduler thread.gaugethread
singlestore.threads.cachedNumber of kernel threads currently idle waiting for queries.gaugethread
singlestore.threads.connectedThe number of connections currently open.gaugethread
singlestore.threads.created.countThe number of threads created between check runs to handle connections.countthread
singlestore.threads.created.totalThe number of threads created to handle connections since server started.gaugethread
singlestore.threads.idleThe number of idle connections not associated with threads.gaugethread
singlestore.threads.runningThe number of threads that are currently active.gaugethread
singlestore.threads.shutdown.countThe number of threads shut down between check run.countthread
singlestore.threads.shutdown.totalThe number of threads shut down since the server started.gaugethread
singlestore.threads.waiting_for_disk_spaceThe number of threads currently blocked because the disk is full.gaugethread
singlestore.total_io_pool_memoryTotal size of all buffers allocated by the IO pool for that partition, including buffers currently in use and free buffers in Free_io_pool_memory. The maximum limit applies to each pool per partition on a node and does not shrink from its high value. This variable can only be used to view the total IO pool size.gaugebyte
singlestore.total_server_memoryTracks the node's overall memory use. Will not surpass the maximum_memory engine variable.gaugebyte
singlestore.transaction_buffer_wait_timeProvides a view into transaction buffer log performance. For more information, see the Using Durability and Recovery topic.gaugesecond
singlestore.transaction_log_flush_wait_timeCumulative amount of time commits have been waiting to flush to disk or across the network, if the database is running with sync durability or sync replication. For async, the value of Transaction_log_flush_wait_time should always be 0.gaugesecond
singlestore.uptimeThe amount of time, in seconds, that the server has been up.gaugesecond
singlestore.used_cluster_capacityThe amount of memory capacity existent in the cluster. This is the sum of maximum_memory from all nodes in the cluster. Only on the master aggregator.gaugebyte
singlestore.used_instance_license_unitsUsed license unitsgaugeunit
singlestore.workload_management.active_queriesThe number of queries currently running on this aggregator.gaugequery
singlestore.workload_management.active_threadsThe number of threads currently running per leaf due to queries originating from this aggregator.gaugethread
singlestore.workload_management.queued_queriesThe number of queued concurrent columnstore writes.gaugequery
singlestore.workload_management_active_connectionsThe number of connections per leaf allocated to queries originating from this aggregator.gaugeconnection

Official documentation

Official documentation for the SingleStore integration

Metric names and descriptions are the official Datadog integration definitions (Copyright Datadog, Inc., BSD-3-Clause), reproduced unedited. The full license terms are on the About page.