Threads_background
5
Background threads managed by the query scheduler, i.e. replication master queries and the scheduler thread.
Threads_idle
0
The number of idle connections not associated with threads.
Ready_queue
0
The number of connections with pending queries not associated with threads.
Idle_queue
0
The number of connections in the idle queue. This is a subset of threads_idle.
Context_switches
57
The number of times any thread has switched connections because it deemed a connection idle.
Context_switch_misses
0
The number of times the scheduler tried to switch connections but failed.
Workload_management_queued_queries
0
The number of queries being delayed due to workload management on this aggregator.
Workload_management_active_queries
0
The number of queries currently running on this aggregator.
Workload_management_active_threads
0
The number of threads currently running per leaf due to queries originating from this aggregator.
Workload_management_active_connections
0
The number of connections per leaf allocated to queries originating from this aggregator.
Columnstore_ingest_management_queued_queries
0
The number of queued concurrent columnstore writes.
Columnstore_ingest_management_active_queries
0
The number of running columnstore writes inserting into the in-memory segment.
Columnstore_ingest_management_max_concurrency
0
The maximum number of queries that can run concurrently. The value 0 indicates that this limit is not set.
Columnstore_ingest_management_estimated_segments_to_flush
0
The number of segments estimated to be created based on the amount of data in the in-memory segment.
Columnstore_ingest_management_estimated_memory
0.000 MB
The estimated amount of memory used by the in-memory segments.
Auto_attach_remaining_seconds
0
The time remaining until the automatic rebalance triggered by an auto-attach operation will occur. Only applies to aggregators.
Data_directory
/var/lib/memsql/data
The directory containing snapshots, transaction logs, and columnstore blob files.
Plancache_directory
/var/lib/memsql/plancache
Directory path for the plancache directory, which contains compiled plans used for codegen.
Transaction_logs_directory
var/lib/memsql/master-3306/data/logs
Always the logs subfolder of datadir. This is where transaction logs are stored.
Segments_directory
var/lib/memsql/master-3306/data/columns
Always the columns subfolder of datadir. This is where columnstore blobs are stored.
Snapshots_directory
var/lib/memsql/master-3306/data/snapshots
Always the snapshots subfolder of datadir. This is where snapshot files live.
threads_waiting_for_disk_space
0
The number of threads currently blocked because the disk is full.
Malloc_transaction_cached_memory
323.3 MB
The memory allocated to caching transaction objects.
Buffer_manager_memory
7.4 (+7.4) MB
Tracks memory that is allocated by the Buffer Manager for SingleStore Helios’s built-in memory allocators.
Buffer_manager_cached_memory
1.0 (+1.0) MB
Tracks memory that was allocated by the Buffer Manager but is now cached and not in use. Limited to 25% of maximum_memory.
Buffer_manager_unrecycled_memory
0.0 MB
Number of buffers ready to be recycled which have not yet been reclaimed.
Alloc_vector_index
Tracks memory used by vector indexes in megabytes.
Tracks memory used by vector indexes in megabytes.
Alloc_skiplist_tower
Tracks the memory used by the towers for skiplist indexes. Each skiplist index utilizes on average 40 bytes of memory per row using this allocator. It's important to note that the exact amount of memory used per row is probabilistic because it depends on the randomized tower height of the particular row being indexed. Skiplist indexes are a part of SingleStore’s indexing mechanism, especially for rowstore tables. These indexes are designed to maintain data in a sorted order to optimize search operations. It also gets used for in-memory rowstore segments for columnstores.
Alloc_variable
Tracks the memory allocated for variable-length columns inside rowstore tables, or for other variable-length memory allocations inside query execution. This can include memory used for operations like sorting, joins, or other in-memory operations that require variable-length data structures. This is relevant especially for workloads that heavily utilize variable-length columns or perform complex query operations necessitating significant variable-length memory allocations. It also gets used for in-memory rowstore segments for columnstores.
Alloc_table_autostats
Memory usage for autostats on columnstore tables.
Alloc_table_primary
Tracks the memory used for on-row data for rowstore tables and also the in-memory segment of columnstore tables. It represents the amount of memory allocated for storing the actual data rows that reside in the primary storage of the system.
Alloc_deleted_version
Memory used to mark rows as deleted in rowstore tables.
Alloc_internal_key_node
Bytes used for HASH index buckets.
Alloc_hash_buckets
Memory used for HASH index buckets.
Alloc_table_metadata_cache
Bytes used for table entries used by DDL.
Alloc_unit_images
This variable measures the bytes allocated to unit images, which contain metadata and bytecode necessary to execute an individual plan. In essence, unit images are a representation of compiled query plans that SingleStore uses to execute SQL queries efficiently.
It also measures memory used for compiled table code modules that are in active use. These code modules contain code used to access rows in the tables.
Alloc_unit_ifn_thunks
Bytes allocated to thunks. These are stub functions assembled by the interpreter to obey the x64 ABI.
Alloc_object_code_images
Bytes attributed to mapping .mo files into memory.
Alloc_compiled_unit_sections
This variable is used to track the memory allocated by the dynamic object loader for code, table code objects and globals specific to each compiled unit or plan. In simpler terms, it represents the memory footprint for sections of compiled query plans or units, which are essential for query execution in SingleStore.
Alloc_databases_list_entry
Bytes used for database entries used by DDL.
Alloc_plan_cache
Bytes allocated for plan objects within the plancache.
Alloc_query_execution
Memory used for running queries on the node. Only present if queries are currently executing.
Alloc_durability_large
Tracks memory used to allocate transaction buffers to group commit rows to disk, as well as temporary buffers to write backups or take snapshots.
alloc_client_connection
Bytes allocated for outgoing connections to other nodes in the workspace.
Alloc_protocol_packet
Bytes allocated for result set protocol objects.
Alloc_table_memory
Tracks the memory stored inside all rowstore tables.
Alloc_variable_bucket_<number>
number = (16, 24, 32, 40, 48,...5680)
The variable allocator is split into buckets with different allocation sizes. Allocations <= 16 bytes use the 16 bytes bucket; allocations between 17 and 24 bytes use the 24 bytes bucket, and so on. Alloc_variable_bucket_16 shows information about the 16 bytes bucket. Each of these is a subset of Alloc_variable.
Alloc_variable_allocated
Memory currently active from the variable length allocator.
Successful_read_queries
0
Number of read queries which have successfully run since server startup.
Successful_write_queries
0
Number of write queries which have successfully run since server startup.
Failed_read_queries
0
Number of read queries which have failed since server startup.
Failed_write_queries
0
Number of write queries which have failed since server startup.
Rows_returned_by_reads
0
Number of rows returned by read queries since server startup.
Rows_affected_by_writes
0
Number of rows affected by write queries since server startup.
Execution_time_of_reads
0 ms
Total wall-time of all read queries since server startup.
Execution_time_of_write
0 ms
Total wall-time of all writer queries since server startup.
Transaction_buffer_wait_time
0 ms
Provides a view into transaction buffer log performance. For more information, see the Using Durability and Recovery topic.
Transaction_log_flush_wait_time
0 ms
Cumulative 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.
Row_lock_wait_time
0 ms
Cumulative amount of time spent waiting on row locks by any write query.
Free_io_pool_memory
Max 16 MB
Size 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.
Total_io_pool_memory
Max 16 MB
Total 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.
Gv_clock
Represents the current timestamp of the server's logical clock.
Effective_module_cache_max_size_mb
Memory allocated (in MBs) used to cache query object code images, as derived from compiled_images_eviction_memory_limit_percent and compiled_images_eviction_memory_limit_mb. Refer to Managing Plancache Memory and Disk Usage for more information.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4