> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-parallel-read-in-order-multi-part.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Managing ClickStack

> Managing ClickStack

This section describes how to manage ClickStack.

<h2 id="admin-guides">
  Admin guides
</h2>

| Section | Description |
| - | - |
| [Basic administration](/clickstack/managing/admin) | An introduction to performing common administrative tasks in ClickStack. |
| [Configuration options](/clickstack/managing/config) | Configuration options available for each component of ClickStack. |
| [Estimating resources](/clickstack/managing/estimating-resources) | Guidance on sizing compute resources for Managed ClickStack based on ingest volume. |
| [Going to production](/clickstack/managing/production) | Recommended steps and best practices before running ClickStack in production. |
| [Isolating read and write](/clickstack/managing/isolating-read-write) | Separating ClickStack ingestion and query workloads onto dedicated compute with ClickHouse Cloud warehouses. |
| [Materialized views](/clickstack/managing/materialized-views) | A detailed guide to using materialized views in ClickStack to accelerate query performance. |
| [Performance tuning](/clickstack/managing/performance-tuning) | A comprehensive guide to tuning ClickStack for large-scale workloads. |
| [RBAC](/clickstack/managing/rbac) | Configure role-based access control to manage team permissions for dashboards, saved searches, and sources. |
| [Managing TTL](/clickstack/managing/ttl) | Managing data retention with TTL (time-to-live) in ClickStack. |

<h2 id="core-concepts">
  Core ClickHouse concepts
</h2>

Most ClickStack management tasks require familiarity with the underlying ClickHouse database. We recommend reviewing the following core ClickHouse concepts outlined below before performing administrative or performance-related operations.

| Concept | Description |
| - | - |
| **Tables** | How ClickStack data sources map to underlying ClickHouse tables. ClickHouse tables primarily use the [MergeTree](/reference/engines/table-engines/mergetree-family/mergetree) engine. |
| **Parts** | How data is written as immutable parts and merged over time. |
| **Partitions** | Logical groupings of table parts that simplify data management, querying, and optimization. |
| **Merges** | The background process that combines parts to reduce the number of parts queried and maintain performance. |
| **Granules** | The smallest unit of data read and pruned during query execution. |
| **Primary (ordering) keys** | How the `ORDER BY` key defines on-disk data layout, compression, and query pruning behavior. |

These concepts are fundamental to ClickHouse performance and will help you make informed administrative decisions when managing ClickStack.