> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability.md).

# High Availability

- [Analyzing Queries](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/analyzing-queries-in-columnstore.md): Tools for inspecting active MariaDB ColumnStore queries: SHOW PROCESSLIST for the local User Module and the getActiveSQLStatements mcsadmin command for cluster-wide query state.
- [Performance Concepts](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/mariadb-columnstore-performance-concepts.md): Performance concepts for MariaDB ColumnStore: PrimProc query optimization and orchestration, Extent Map metadata for I/O reduction, batch primitive steps, and shared storage for failover.
- [Performance Related Configuration Settings](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/mariadb-columnstore-performance-related-configuration-settings.md): Performance-related ColumnStore.xml settings for MariaDB ColumnStore, including NumBlocksPct cache size and TotalUmMemory limits, edited via getConfig and setConfig on the PM1 node.
- [Query Tuning](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning.md): MariaDB ColumnStore query tuning optimizes analytics using data types, joins, projection elimination, WHERE clauses, and EXPLAIN for performance insights.
- [Collecting Statistics with ANALYZE TABLE](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/collect-statistics-with-analyze-table-for-mariadb-enterprise-columnstore.md): Optimizer statistics collected with ANALYZE TABLE in MariaDB Enterprise ColumnStore 6 enable circular inner joins and help ExeMgr choose better join orders for analytical queries.
- [Query Tuning Recommendations](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/query-tuning-recommendations-for-mariadb-enterprise-columnstore.md): Query tuning recommendations for MariaDB ColumnStore: select only required columns, avoid large single-threaded ORDER BY and LIMIT sorts, and follow analytical best practices.
- [Query Plans and Optimizer Trace](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/query-plans-and-optimizer-trace.md): MariaDB ColumnStore's query plans and Optimizer Trace show how analytical queries run in parallel across its distributed, columnar architecture, aiding performance tuning.
- [Execution Plan (CSEP)](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/query-plans-and-optimizer-trace/columnstore-execution-plan-csep-for-mariadb-enterprise-columnstore.md): The ColumnStore Execution Plan (CSEP) is the internal query-plan representation in MariaDB ColumnStore, generated from SELECT\_LEX and viewable through calSetTrace.
- [Job Steps](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/query-plans-and-optimizer-trace/job-steps-for-mariadb-enterprise-columnstore.md): Job steps in MariaDB ColumnStore: ExeMgr translates the CSEP into a job list of distributed and multi-threaded steps (BPS, CES, etc.) for parallel query execution across nodes.
- [Query Statistics for MariaDB ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/query-statistics-for-mariadb-enterprise-columnstore.md): Query statistics log MariaDB ColumnStore execution metrics (memory, I/O, cache) to infinidb\_querystats; disabled by default and exposed via SHOW WARNINGS and calGetStats().
- [Optimization & Tuning](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/optimization-and-tuning.md)
- [Profiling Memory Usage with Heaptrack](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/optimization-and-tuning/profiling-memory-usage-with-heaptrack.md)
- [Analyzing Queries in ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/optimization-and-tuning/analyzing-queries-in-columnstore.md)
- [Measuring cpimport Performance Baseline with ioping](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/optimization-and-tuning/analyzing-queries-in-columnstore-1.md)
- [Columnstore System Variables: Advanced Performance and Control Flow](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/optimization-and-tuning/columnstore-system-variables-advanced-performance-and-control-flow.md)
- [Cluster Management](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/cluster-management.md)
- [Checking CMAPI Cluster Status](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/cluster-management/checking-cmapi-cluster-status.md)