# StarRocks Documentation — Administration

> Section index of the StarRocks documentation. For the complete documentation index, see [llms.txt](https://docs.starrocks.io/llms.txt). Pages are available as Markdown at their `.md` URLs.

## Administration

- [Configuration](https://docs.starrocks.io/docs/administration/configuration.md): Configuration parameters for FE and BE nodes.
- [BE Configuration](https://docs.starrocks.io/docs/administration/configuration/BE_parameters.md): StarRocks BE configuration reference: complete list of BE parameters configurable in be.conf or via SQL.
- [BE Configuration - Logging, Server, and Metadata](https://docs.starrocks.io/docs/administration/configuration/BE_parameters/log_server_meta.md): BE configuration parameters for logging, server settings, and metadata management.
- [BE Configuration - Query and Loading](https://docs.starrocks.io/docs/administration/configuration/BE_parameters/query_loading.md): BE configuration parameters for query execution and data loading.
- [BE Configuration - Shared-data, Data Lake, and Others](https://docs.starrocks.io/docs/administration/configuration/BE_parameters/shared_lake_other.md): BE configuration parameters for shared-data clusters, data lake integration, and miscellaneous settings.
- [BE Configuration - Statistics and Storage](https://docs.starrocks.io/docs/administration/configuration/BE_parameters/stats_storage.md): BE configuration parameters for statistics collection and storage engine settings.
- [FE Configuration](https://docs.starrocks.io/docs/administration/configuration/FE_parameters.md): StarRocks FE configuration reference: complete list of FE parameters configurable in fe.conf or via ADMIN SET FRONTEND CONFIG.
- [FE Configuration - Logging, Server, and Metadata](https://docs.starrocks.io/docs/administration/configuration/FE_parameters/log_server_meta.md): FE configuration parameters for logging, server settings, and metadata management.
- [FE Configuration - Shared-data, Data Lake, and Others](https://docs.starrocks.io/docs/administration/configuration/FE_parameters/shared_lake_other.md): FE configuration parameters for shared-data clusters, data lake integration, and miscellaneous settings.
- [FE Configuration - Statistics and Storage](https://docs.starrocks.io/docs/administration/configuration/FE_parameters/stats_storage.md): FE configuration parameters for statistics collection and storage settings.
- [FE Configuration - Authentication, Query, and Loading](https://docs.starrocks.io/docs/administration/configuration/FE_parameters/user_query_loading.md): FE configuration parameters for authentication, query execution, and data loading.
- [Cross-cluster Data Migration Tool](https://docs.starrocks.io/docs/administration/data_migration_tool.md): The StarRocks Cross-cluster Data Migration Tool is provided by StarRocks Community.
- [Data Recovery](https://docs.starrocks.io/docs/administration/Data_recovery.md): Recover mistakenly deleted databases/tables/partitions.
- [HTTP Interface](https://docs.starrocks.io/docs/administration/http_interface.md): To facilitate the maintenance of StarRocks clusters, StarRocks provides various types of operation and query interfaces.
- [Query detail API](https://docs.starrocks.io/docs/administration/http_interface/query_detail.md): The query detail API returns recent query execution details that are cached in FE memory.
- [Manage audit logs within StarRocks via AuditLoader](https://docs.starrocks.io/docs/administration/management/audit_loader.md): StarRocks stores its audit logs in the local file fe/log/fe.audit.log rather than an internal database.
- [Back up and restore data](https://docs.starrocks.io/docs/administration/management/Backup_and_restore.md): StarRocks supports backing up data as snapshots into a remote storage system and restoring the data to any StarRocks clusters.
- [Manage BE and CN Blacklist](https://docs.starrocks.io/docs/administration/management/BE_blacklist.md): How to configure the BE and CN Blacklist in StarRocks to exclude problematic nodes from query execution.
- [Cluster Snapshot](https://docs.starrocks.io/docs/administration/management/cluster_snapshot.md): How to create, restore, and manage cluster snapshots for backup and disaster recovery in StarRocks shared-data clusters.
- [Compaction for Shared-data Clusters](https://docs.starrocks.io/docs/administration/management/compaction.md): How to manage and monitor compaction for shared-data clusters in StarRocks.
- [Enable FQDN access](https://docs.starrocks.io/docs/administration/management/enable_fqdn.md): Before 2.4, StarRocks supports access to FEs and BEs via IP address only.
- [Develop Static Extensions](https://docs.starrocks.io/docs/administration/management/extensions.md): Static Extensions are StarRocks FE’s extension modules that allow you to add new features or optimize existing functionality without modifying the core code.
- [Graceful Exit](https://docs.starrocks.io/docs/administration/management/graceful_exit.md): From v3.3 onwards, StarRocks supports Graceful Exit.
- [logs](https://docs.starrocks.io/docs/administration/management/logs.md): Overview of StarRocks logging: FE and BE log file types, content, configuration, log rolling and retention strategies for troubleshooting and performance...
- [Monitor and manage big queries](https://docs.starrocks.io/docs/administration/management/monitor_manage_big_queries.md): Big queries include queries that scan too many rows or occupy too many CPU and memory resources.
- [Monitor and Alert with Prometheus and Grafana](https://docs.starrocks.io/docs/administration/management/monitoring.md): StarRocks provides a monitor and alert solution by using Prometheus and Grafana.
- [Manage Alerts](https://docs.starrocks.io/docs/administration/management/monitoring/alert.md): In the following examples, all variables are prefixed with $.
- [Metric details](https://docs.starrocks.io/docs/administration/management/monitoring/metric_details.md)
- [Metrics a through c](https://docs.starrocks.io/docs/administration/management/monitoring/metric_details/a-c.md): Alphabetical a - c
- [Metrics d through h](https://docs.starrocks.io/docs/administration/management/monitoring/metric_details/d-h.md): Alphabetical d - h
- [Metrics i through p](https://docs.starrocks.io/docs/administration/management/monitoring/metric_details/i-p.md): Alphabetical i - p
- [Metrics q through r](https://docs.starrocks.io/docs/administration/management/monitoring/metric_details/q-r.md): Alphabetical q - r
- [Metrics s](https://docs.starrocks.io/docs/administration/management/monitoring/metric_details/s.md): Alphabetical s
- [Metrics t through z](https://docs.starrocks.io/docs/administration/management/monitoring/metric_details/t-z.md): Alphabetical t - z
- [General Monitoring Metrics](https://docs.starrocks.io/docs/administration/management/monitoring/metrics.md): StarRocks metrics for monitoring
- [Monitoring Metrics for Asynchronous Materialized Views](https://docs.starrocks.io/docs/administration/management/monitoring/metrics-materialized_view.md): From v3.1 onwards, StarRocks supports metrics for asynchronous materialized views.
- [Monitoring Metrics for Shared-data Clusters](https://docs.starrocks.io/docs/administration/management/monitoring/metrics-shared-data.md): Monitoring metrics for StarRocks shared-data clusters, covering the Shared-data Dashboard and Starlet Dashboard templates.
- [Process Profile (Proc Profile)](https://docs.starrocks.io/docs/administration/management/proc_profile.md): Collects and visualizes CPU and memory flame graph profiles for StarRocks FE and BE processes to diagnose performance bottlenecks.
- [Resource management](https://docs.starrocks.io/docs/administration/management/resource_management.md)
- [Add labels on BEs](https://docs.starrocks.io/docs/administration/management/resource_management/be_label.md): Since v3.2.8, StarRocks supports adding labels on BEs. When creating a table or an asynchronous materialized view, you can specify the label of a certain...
- [Blacklist Management](https://docs.starrocks.io/docs/administration/management/resource_management/Blacklist.md): In some cases, administrators need to disable certain patterns of SQL to avoid SQL from triggering cluster crashes or unexpected high concurrent queries.
- [File manager](https://docs.starrocks.io/docs/administration/management/resource_management/filemanager.md): With file manager, you can create, view, and delete files, such as the files that are used to access external data sources: public key files, private key...
- [Load Balancing](https://docs.starrocks.io/docs/administration/management/resource_management/Load_balance.md): When deploying multiple FE nodes, users can deploy a load balancing layer on top of the FEs to achieve high availability.
- [Memory Management](https://docs.starrocks.io/docs/administration/management/resource_management/Memory_management.md): Overview of memory classification and memory management strategies in StarRocks.
- [Query Management](https://docs.starrocks.io/docs/administration/management/resource_management/Query_management.md): Configure per-user query properties in StarRocks: connection limits, query timeouts, and resource allocation using ALTER USER SET PROPERTIES.
- [Query queues](https://docs.starrocks.io/docs/administration/management/resource_management/query_queues.md): From v2.5, StarRocks supports query queues.
- [Manage replica](https://docs.starrocks.io/docs/administration/management/resource_management/Replica.md): Manage data replicas in your StarRocks cluster.
- [Resource group](https://docs.starrocks.io/docs/administration/management/resource_management/resource_group.md): How to use resource groups in StarRocks to isolate resources and run multiple workloads concurrently in a single cluster.
- [Spill to disk](https://docs.starrocks.io/docs/administration/management/resource_management/spill_to_disk.md): How to configure StarRocks to spill intermediate query results to disk or object storage to prevent out-of-memory errors.
- [Scale in and out](https://docs.starrocks.io/docs/administration/management/Scale_up_down.md): How to add or remove nodes to scale a StarRocks cluster up or down.
- [Configure a time zone](https://docs.starrocks.io/docs/administration/management/timezone.md): How to configure time zone settings in StarRocks and understand their effects on data storage and queries.
- [Metadata Recovery](https://docs.starrocks.io/docs/administration/Meta_recovery.md): Recover StarRocks cluster metadata when FE nodes fail to restart, fail to serve requests, or need metadata restored from backup.
- [SQL Digest](https://docs.starrocks.io/docs/administration/sql_digest.md): How to use SQL Digest in StarRocks to fingerprint and group SQL queries with the same structure for analysis.
- [Deploy and Manage StarRocks with StarGo](https://docs.starrocks.io/docs/administration/stargo.md): StarGo is a command line tool for multiple StarRocks clusters management.
- [User Privileges and Authentication](https://docs.starrocks.io/docs/administration/user_privs.md)
- [Authentication](https://docs.starrocks.io/docs/administration/user_privs/authentication.md)
- [JSON Web Token Authentication](https://docs.starrocks.io/docs/administration/user_privs/authentication/jwt_authentication.md): From v3.5.0 onwards, StarRocks supports authenticating client access using JSON Web Tokens.
- [LDAP Authentication](https://docs.starrocks.io/docs/administration/user_privs/authentication/ldap_authentication.md): In addition to native password-based authentication, StarRocks also supports the LDAP authentication.
- [Native Authentication](https://docs.starrocks.io/docs/administration/user_privs/authentication/native_authentication.md): Create and manage users using the native authentication within StarRocks through SQL commands.
- [OAuth 2.0 Authentication](https://docs.starrocks.io/docs/administration/user_privs/authentication/oauth2_authentication.md): From v3.5.0 onwards, StarRocks supports authenticating client access using OAuth 2.0.
- [Authenticate with Security Integration](https://docs.starrocks.io/docs/administration/user_privs/authentication/security_integration.md): Integrate StarRocks with external authentication systems using security integration.
- [Authorization](https://docs.starrocks.io/docs/administration/user_privs/authorization.md)
- [Built-in Roles supported by StarRocks](https://docs.starrocks.io/docs/administration/user_privs/authorization/built_in_roles.md): Reference for the five built-in StarRocks roles: db_admin, cluster_admin, user_admin, security_admin, and public.
- [Privilege FAQ](https://docs.starrocks.io/docs/administration/user_privs/authorization/privilege_faq.md): FAQ for common StarRocks privilege and authorization questions, including role activation issues.
- [Privileges supported by StarRocks](https://docs.starrocks.io/docs/administration/user_privs/authorization/privilege_item.md): Privileges granted to a user or role determine which operations the user or role can perform on certain objects.
- [Manage permissions with Apache Ranger](https://docs.starrocks.io/docs/administration/user_privs/authorization/ranger_plugin.md): How to manage StarRocks access permissions with Apache Ranger for centralized, fine-grained access control.
- [Manage user privileges](https://docs.starrocks.io/docs/administration/user_privs/authorization/User_privilege.md): How to manage user privileges in StarRocks using role-based access control (RBAC) and identity-based access control (IBAC).
- [Overview of privileges](https://docs.starrocks.io/docs/administration/user_privs/authorization/user_privs.md): Overview of StarRocks privilege system, covering role-based access control (RBAC) and identity-based access control (IBAC) models.
- [Authenticate User Groups](https://docs.starrocks.io/docs/administration/user_privs/group_provider.md): Enable Group Provider in StarRocks to authenticate, and authorize user groups from external authentication systems.
- [SSL Authentication](https://docs.starrocks.io/docs/administration/user_privs/ssl_authentication.md): From v3.4.1 onwards, StarRocks supports secure connections encrypted by SSL.