# HA & Performance

- [Optimization and Tuning](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning.md): Complete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.
- [Buffers, Caches and Threads](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads.md): Optimize MariaDB Server performance by tuning buffers, caches, and threads. This section covers essential configurations to maximize throughput and responsiveness for your database workloads.
- [Query Cache](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/query-cache.md): Complete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.
- [Thread Command Values](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-command-values.md)
- [Thread Pool](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool.md): Optimize MariaDB Server with the thread pool. This section explains how to manage connections and improve performance by efficiently handling concurrent client requests, reducing resource overhead.
- [Thread Pool in MariaDB](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb.md)
- [Thread Groups in the Unix Implementation of the Thread Pool](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-groups-in-the-unix-implementation-of-the-thread-pool.md)
- [Thread Pool System and Status Variables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md)
- [Thread Pool in MariaDB 5.1 - 5.3](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb-51-53.md)
- [Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states.md): Understand MariaDB Server thread states. This section explains the different states a thread can be in, helping you monitor and troubleshoot query execution and server performance.
- [Delayed Insert Connection Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/delayed-insert-connection-thread-states.md)
- [Delayed Insert Handler Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/delayed-insert-handler-thread-states.md)
- [Event Scheduler Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/event-scheduler-thread-states.md)
- [Galera Cluster Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/galera-cluster-thread-states.md)
- [General Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/general-thread-states.md)
- [Master Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/master-thread-states.md)
- [Query Cache Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/query-cache-thread-states.md)
- [Replica I/O Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/replica-io-thread-states.md)
- [Replica Connection Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/slave-connection-thread-states.md)
- [Replica SQL Thread States](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/slave-sql-thread-states.md)
- [MariaDB Internal Optimizations](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations.md): Explore MariaDB Server's internal optimizations. This section delves into how the database engine enhances query execution, data storage, and overall performance through its core architecture.
- [Fair Choice Between Range and Index\_merge Optimizations](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations/fair-choice-between-range-and-index_merge-optimizations.md)
- [Multi Range Read Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations/multi-range-read-optimization.md)
- [Operating System Optimizations](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/operating-system-optimizations.md): Optimize MariaDB Server performance with operating system tuning. This section covers configuring your OS for improved I/O, memory management, and network settings to maximize database efficiency.
- [Filesystem Optimizations](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/operating-system-optimizations/filesystem-optimizations.md)
- [Optimization and Indexes](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes.md): Optimize MariaDB Server queries with indexes. This section covers index types, creation, and best practices for leveraging them to significantly improve query performance and data retrieval speed.
- [Building the best INDEX for a given SELECT](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/building-the-best-index-for-a-given-select.md)
- [Compound (Composite) Indexes](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/compound-composite-indexes.md)
- [Foreign Keys](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/foreign-keys.md): Complete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.
- [Ignored Indexes](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/ignored-indexes.md): Ignored indexes allow indexes to be visible and maintained without being used by the optimizer. This feature is comparable to MySQL 8’s "invisible indexes."
- [Index Statistics](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/index-statistics.md): Index statistics provide crucial insights to the MariaDB query optimizer, guiding it in executing queries efficiently. Up-to-date index statistics ensure optimized query performance.
- [Latitude/Longitude Indexing](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/latitudelongitude-indexing.md)
- [Primary Keys with Nullable Columns](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/primary-keys-with-nullable-columns.md)
- [Storage Engine Index Types](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/storage-engine-index-types.md)
- [Full-Text Indexes](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/full-text-indexes.md): Implement full-text indexes in MariaDB Server for efficient text search. This section guides you through creating and utilizing these indexes to optimize queries on large text datasets.
- [Full-Text Index Overview](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/full-text-indexes/full-text-index-overview.md): Definitive full-text index guide: MATCH() AGAINST syntax, FULLTEXT index creation, NATURAL/BOOLEAN/QUERY EXPANSION modes, stopwords, ft\_min\_word\_length.
- [Full-Text Index Stopwords](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/full-text-indexes/full-text-index-stopwords.md)
- [Optimizer Hints](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints.md): This section details special comments you can add to SQL statements to influence the query optimizer, helping you manually select better execution plans for improved performance and query tuning.
- [SELECT Modifier Hints](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/select-modifier-hints.md)
- [Expanded New-Style Optimizer Hints](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/expanded-optimizer-hints.md)
- [Index-Level Hints](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/index-level-hints.md)
- [Query Block Naming](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/query-block-naming.md)
- [Table-Level Hints](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/table-level-hints.md)
- [Compression](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression.md): Optimize MariaDB Server performance and storage with compression. This section details how to apply data compression at various levels to reduce disk space and improve I/O efficiency.
- [Compression Plugins](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression/compression-plugins.md)
- [Storage-Engine Independent Column Compression](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression/storage-engine-independent-column-compression.md)
- [Optimizing Data Structure](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizing-data-structure.md): Optimize MariaDB Server performance by refining your data structure. This section covers schema design, data types, and normalization techniques to improve query efficiency and storage utilization.
- [Numeric vs String Fields](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizing-data-structure/numeric-vs-string-fields.md)
- [Optimizing MEMORY Tables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizing-data-structure/optimizing-memory-tables.md)
- [Optimizing String and Character Fields](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizing-data-structure/optimizing-string-and-character-fields.md)
- [Optimizing Tables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables.md): Optimize tables for enhanced performance. This section covers various techniques, including proper indexing, data types, and storage engine choices, to improve query speed and efficiency.
- [OPTIMIZE TABLE](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/optimize-table.md): Complete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.
- [Defragmenting InnoDB Tablespaces](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/defragmenting-innodb-tablespaces.md)
- [Entity-Attribute-Value Implementation](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/entity-attribute-value-implementation.md)
- [IP Range Table Performance](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/ip-range-table-performance.md)
- [Optimizing Queries](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations.md): Optimize queries for peak performance. This section provides techniques for writing efficient SQL, understanding query execution plans, and leveraging indexes effectively to speed up your queries.
- [Aborting Statements that Exceed a Certain Time to Execute](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/aborting-statements.md)
- [Big DELETEs](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/big-deletes.md)
- [Charset Narrowing Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/charset-narrowing-optimization.md)
- [Data Sampling: Techniques for Efficiently Finding a Random Row](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-sampling-techniques-for-efficiently-finding-a-random-row.md)
- [Data Warehousing High Speed Ingestion](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-warehousing-high-speed-ingestion.md)
- [Data Warehousing Summary Tables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-warehousing-summary-tables.md)
- [Data Warehousing Techniques](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-warehousing-techniques.md)
- [DISTINCT removal in aggregate functions](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/query-optimizations-distinct-removal-in-aggregate-functions.md)
- [Equality propagation optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/equality-propagation-optimization.md)
- [Filesort with Small LIMIT Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/filesort-with-small-limit-optimization.md)
- [FORCE INDEX](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/force-index.md)
- [Groupwise Max in MariaDB](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/groupwise-max-in-mariadb.md)
- [GUID/UUID Performance](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/guiduuid-performance.md)
- [hash\_join\_cardinality optimizer\_switch Flag](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/hash_join_cardinality-optimizer_switch-flag.md)
- [How to Quickly Insert Data Into MariaDB](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/how-to-quickly-insert-data-into-mariadb.md)
- [IGNORE INDEX](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/ignore-index.md)
- [Index Condition Pushdown](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/index-condition-pushdown.md)
- [Index Hints: How to Force Query Plans](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/index-hints-how-to-force-query-plans.md)
- [index\_merge sort\_intersection](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/index_merge-sort_intersection.md)
- [LIMIT ROWS EXAMINED](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/limit-rows-examined.md)
- [MariaDB 5.3 Optimizer Debugging](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/mariadb-53-optimizer-debugging.md)
- [not\_null\_range\_scan Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/not_null_range_scan-optimization.md)
- [optimizer\_switch](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer-switch.md)
- [optimizer\_adjust\_secondary\_key\_costs](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer_adjust_secondary_key_costs.md)
- [optimizer\_join\_limit\_pref\_ratio Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer_join_limit_pref_ratio-optimization.md)
- [Optimizing for "Latest News"-style Queries](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizing-for-latest-news-style-queries.md)
- [Pagination Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/pagination-optimization.md)
- [Pivoting in MariaDB](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/pivoting-in-mariadb.md)
- [Query Limits and Timeouts](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/query-limits-and-timeouts.md)
- [reorder\_outer\_joins](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/reorder_outer_joins.md)
- [Rollup Unique User Counts](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/rollup-unique-user-counts.md)
- [Rowid Filtering Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/rowid-filtering-optimization.md)
- [Sargable DATE and YEAR](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/sargable-date-and-year.md)
- [Sargable UPPER](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/sargable-upper.md)
- [USE INDEX](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/use-index.md)
- [Virtual Column Support in the Optimizer](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/virtual-column-support-in-the-optimizer.md)
- [Optimization Strategies](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies.md): Discover effective optimization strategies for MariaDB Server queries. This section provides a variety of techniques and approaches to enhance query performance and overall database efficiency.
- [Duplicate Weedout Strategy](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/duplicateweedout-strategy.md)
- [FirstMatch Strategy](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/firstmatch-strategy.md): FirstMatch is a semi-join execution strategy that avoids duplicate results by short-cutting subquery execution as soon as the first matching record is found, improving performance.
- [Improvements to ORDER BY Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/improvements-to-order-by.md)
- [LooseScan Strategy](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/loosescan-strategy.md)
- [Semi-join Materialization Strategy](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/semi-join-materialization-strategy.md)
- [Optimizations for Derived Tables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables.md): Optimize derived tables in MariaDB Server queries. This section provides techniques and strategies to improve the performance of subqueries and complex joins, enhancing overall query efficiency.
- [Condition Pushdown into Derived Table Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/condition-pushdown-into-derived-table-optimization.md)
- [Derived Table Merge Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/derived-table-merge-optimization.md)
- [Derived Table with Key Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/derived-table-with-key-optimization.md)
- [Lateral Derived Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/lateral-derived-optimization.md): Documents Lateral Derived Optimization, also referred to as Split Grouping Optimization or Split Materialized Optimization.
- [Split Materialized Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/split-materialized-optimization.md)
- [Statistics for Optimizing Queries](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries.md): Utilize statistics to optimize queries in MariaDB Server. This section explains how the database uses statistical information to generate efficient query execution plans and improve performance.
- [Engine-Independent Table Statistics](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/engine-independent-table-statistics.md)
- [Histogram-Based Statistics](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/histogram-based-statistics.md)
- [InnoDB Persistent Statistics](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/innodb-persistent-statistics.md)
- [Slow Query Log Extended Statistics](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/slow-query-log-extended-statistics.md)
- [User Statistics](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/user-statistics.md)
- [Subquery Optimizations](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations.md): Optimize subqueries in MariaDB Server for improved performance. This section provides techniques and best practices to ensure your nested queries execute efficiently and enhance overall query speed.
- [Condition Pushdown Into IN subqueries](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/condition-pushdown-into-in-subqueries.md)
- [Conversion of Big IN Predicates Into Subqueries](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/conversion-of-big-in-predicates-into-subqueries.md)
- [EXISTS-to-IN Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/exists-to-in-optimization.md)
- [Non-semi-join Subquery Optimizations](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/non-semi-join-subquery-optimizations.md)
- [Optimizing GROUP BY and DISTINCT Clauses in Subqueries](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/optimizing-group-by.md)
- [Semi-join Subquery Optimizations](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/semi-join-subquery-optimizations.md)
- [Subquery Cache](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/subquery-cache.md)
- [Subquery Optimizations Map](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/subquery-optimizations-map.md)
- [Table Pullout Optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/table-pullout-optimization.md)
- [Table Elimination](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination.md): Learn about table elimination for query optimization in MariaDB Server. This section explains how the optimizer removes unnecessary tables from query plans, improving performance.
- [Table Elimination External Resources](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-external-resources.md)
- [Table Elimination in MariaDB](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-in-mariadb.md)
- [Table Elimination in Other Databases](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-in-other-databases.md)
- [Table Elimination User Interface](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-user-interface.md)
- [What is Table Elimination?](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/what-is-table-elimination.md)
- [Query Optimizer](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer.md): Delve into the MariaDB Server query optimizer. This section provides internal documentation on how queries are parsed, optimized, and executed for maximum efficiency and performance.
- [Block-Based Join Algorithms](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/block-based-join-algorithms.md)
- [Condition Selectivity Computation Internals](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/condition-selectivity-computation-internals.md)
- [Extended Keys](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/extended-keys.md)
- [MIN/MAX optimization](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/minmax-optimization.md)
- [Notes When an Index Cannot Be Used](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/notes-when-an-index-cannot-be-used.md)
- [Optimizer Debugging With GDB](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-debugging-with-gdb.md)
- [Optimizer Development](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-development.md)
- [optimizer\_max\_sel\_arg\_weight](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer_max_sel_arg_weight.md)
- [Range Optimizer](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/range-optimizer.md)
- [The Optimizer Cost Model from MariaDB 11.0](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/the-optimizer-cost-model-from-mariadb-11-0.md)
- [Optimizer Trace](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace.md)
- [Basic Optimizer Trace Example](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/basic-optimizer-trace-example.md)
- [How to Collect Large Optimizer Traces](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/how-to-collect-large-optimizer-traces.md)
- [Optimizer Trace for Developers](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/optimizer-trace-for-developers.md)
- [Optimizer Trace Guide](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/optimizer-trace-guide.md)
- [Optimizer Trace Overview](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/optimizer-trace-overview.md)
- [Optimizer Trace Resources](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/optimizer-trace-resources.md)
- [System and Status Variables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables.md): Optimize MariaDB Server with system variables, configuring various parameters to fine-tune performance, manage resources, and adapt the database to your specific workload requirements.
- [Big Query Settings](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/big-query-settings.md)
- [Handling Too Many Connections](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/handling-too-many-connections.md)
- [MariaDB Optimization for MySQL Users](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/mariadb-optimization-for-mysql-users.md)
- [Optimizing key\_buffer\_size](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/optimizing-key_buffer_size.md)
- [Optimizing table\_open\_cache](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/optimizing-table_open_cache.md)
- [OQGRAPH System and Status Variables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/oqgraph-system-and-status-variables.md)
- [Sample my.cnf Files](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/sample-mycnf-files.md)
- [Segmented Key Cache](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/segmented-key-cache.md)
- [Semisynchronous Replication Plugin Status Variables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/semisynchronous-replication-plugin-status-variables.md)
- [InnoDB Server Status Variables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/innodb-status-variables.md)
- [Setting Innodb Buffer Pool Size Dynamically](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/setting-innodb-buffer-pool-size-dynamically.md)
- [Sphinx Status Variables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/sphinx-status-variables.md)
- [Spider Status Variables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/spider-status-variables.md)
- [SQL Error Log System Variables and Options](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/sql-error-log-system-variables-and-options.md)
- [SSL/TLS Status Variables](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/ssltls-status-variables.md)
- [System and Status Variables Added By Major Release](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release.md): Discover system and status variables added by major MariaDB Server releases. This section helps you track new configuration options and monitoring metrics introduced in different versions.
- [System Variables Added in MariaDB 12.1](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-variables-added-in-mariadb-12.1.md)
- [System Variables Added in MariaDB 12.0](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-variables-added-in-mariadb-12.0.md)
- [System Variables Added in MariaDB 11.8](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-variables-added-in-mariadb-11-8.md)
- [System Variables Added in MariaDB 11.4](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-variables-added-in-mariadb-11-4.md)
- [Status Variables Added in MariaDB 11.4](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/status-variables-added-in-mariadb-11-4.md)
- [System Variables Added in MariaDB 10.11](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-variables-added-in-mariadb-10-11.md)
- [System Variables Added in MariaDB 10.6](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-variables-added-in-mariadb-10-6.md)
- [Status Variables Added in MariaDB 10.6](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/status-variables-added-in-mariadb-106.md)
- [System and Status Variables Added By Major Unmaintained Release](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release.md): Discover system and status variables added by major unmaintained MariaDB Server releases. This section provides insights into parameters from older versions, useful for understanding historical config
- [System Variables Added in MariaDB 11.7](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-11-7.md)
- [System Variables Added in MariaDB 11.6](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-11-6.md)
- [System Variables Added in MariaDB 11.5](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-11-5.md)
- [Status Variables Added in MariaDB 11.5](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-11-5.md)
- [System Variables Added in MariaDB 11.3](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-11-3.md)
- [System Variables Added in MariaDB 11.2](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-11-2.md)
- [System Variables Added in MariaDB 11.1](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-11-1.md)
- [System Variables Added in MariaDB 11.0](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-11-0.md)
- [Status Variables Added in MariaDB 11.0](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-11-0.md)
- [System Variables Added in MariaDB 10.10](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-10-10.md)
- [System Variables Added in MariaDB 10.9](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-10-9.md)
- [System Variables Added in MariaDB 10.8](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-10-8.md)
- [System Variables Added in MariaDB 10.5](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-10-5.md)
- [Status Variables Added in MariaDB 10.5](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-105.md)
- [System Variables Added in MariaDB 10.4](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-10-4.md)
- [Status Variables Added in MariaDB 10.4](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-104.md)
- [System Variables Added in MariaDB 10.3](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-10-3.md)
- [Status Variables Added in MariaDB 10.3](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-103.md)
- [System Variables Added in MariaDB 10.2](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-102.md)
- [Status Variables Added in MariaDB 10.2](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-102.md)
- [System Variables Added in MariaDB 10.1](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-101.md)
- [Status Variables Added in MariaDB 10.1](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-101.md)
- [System Variables Added in MariaDB 10.0](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-100.md)
- [Status Variables Added in MariaDB 10.0](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-100.md)
- [System Variables Added in MariaDB 5.5](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-55.md)
- [Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication.md): Complete MariaDB replication guide. Complete reference for data redundancy, failover, read scaling, and multi-source topologies with comprehensive examples and.
- [Replication Overview](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-overview.md): Explore the core concepts of MariaDB standard replication. Learn about the primary-replica architecture, data redundancy strategies, and how to scale read operations effectively.
- [Choosing a Replication Strategy](https://mariadb.com/docs/server/ha-and-performance/standard-replication/choosing-a-replication-strategy.md)
- [Replication Statements](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-statements.md): Access the complete reference of SQL statements used to manage replication. This guide covers commands for controlling primaries, configuring replicas, and monitoring status.
- [Setting Up Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/setting-up-replication.md): Complete guide to MariaDB replication setup. Complete walkthrough for primary-replica topology with binary logging and GTID configuration.
- [Global Transaction ID](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid.md): Complete GTID replication reference: CHANGE MASTER master\_use\_gtid=current\_pos|slave\_pos, gtid\_slave\_pos table (InnoDB), START REPLICA UNTIL master\_gtid\_pos.
- [Read-Only Replicas](https://mariadb.com/docs/server/ha-and-performance/standard-replication/read-only-replicas.md): Learn how to configure replicas as read-only instances. This ensures data integrity by preventing accidental writes on the replica while allowing it to process replication events.
- [Multi-Source Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/multi-source-replication.md): Discover how to replicate data from multiple primaries to a single replica. This guide covers the configuration for aggregating data from different sources into one MariaDB instance.
- [Multi-Master Ring Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/multi-master-ring-replication.md): Explore the ring topology where each server acts as both primary and replica. Learn the configuration steps and caveats for setting up a circular replication environment.
- [Delayed Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/delayed-replication.md): Learn to configure a time lag for your replica. Delayed replication helps recover from human errors on the primary, such as accidental drop commands, by preserving older states.
- [Parallel Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/parallel-replication.md): Boost MariaDB Server replication performance with parallel replication. This section explains how to configure replicas to apply events concurrently, reducing lag and improving throughput.
- [Semisynchronous Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication.md): Enhance data consistency with semisynchronous replication. Ensure that the primary waits for at least one replica to acknowledge receipt of a transaction before committing.
- [Row-based Replication With No Primary Key](https://mariadb.com/docs/server/ha-and-performance/standard-replication/row-based-replication-with-no-primary-key.md): Understand the performance implications and best practices for replicating tables without primary keys when using row-based logging, including how to avoid full table scans.
- [Unsafe Statements for Statement-Based Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/unsafe-statements-for-statement-based-replication.md): Identify SQL statements that are non-deterministic and unsafe for statement-based replication. Learn why these queries cause divergence and how to switch to row-based logging.
- [Replication Filters](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-filters.md): Learn how to filter specific databases or tables from being replicated. This guide covers configuration options to replicate only the data you need on specific replicas.
- [Replication Threads](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-threads.md): Gain insight into the background threads that drive replication. Understand the roles of the I/O thread, SQL thread, and binlog dump thread in moving data between servers.
- [Replication and Foreign Keys](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-foreign-keys.md): Understand how foreign key constraints interact with replication. Learn best practices for managing cascading deletes and updates across primary and replica servers.
- [Replication and Binary Log System Variables](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md): Complete Replication and Binary Log System Variables reference for MariaDB. Complete guide for configuration values, scope settings, and performance impact.
- [Replication and Binary Log Status Variables](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-status-variables.md): View the status variables used to monitor replication health. Learn how to interpret metrics regarding log positions, connection status, and event counts.
- [Binlog Event Checksum Interoperability](https://mariadb.com/docs/server/ha-and-performance/standard-replication/binlog-event-checksum-interoperability.md): Learn about checksum compatibility between different MariaDB versions. Ensure older replicas can correctly verify binary log events generated by newer primaries.
- [Binlog Event Checksums](https://mariadb.com/docs/server/ha-and-performance/standard-replication/binlog-event-checksums.md): Configure checksums to detect data corruption in binary logs. Learn how to enable verification to ensure the integrity of replication events during transmission and storage.
- [Changing a Replica to Become the Primary](https://mariadb.com/docs/server/ha-and-performance/standard-replication/changing-a-replica-to-become-the-primary.md): Follow the procedure to promote a replica to a primary role. This guide details the steps for planned failovers or topology reorganization with minimal downtime.
- [Replication When the Primary and Replica Have Different Table Definitions](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-when-the-primary-and-replica-have-different-table-definitions.md): Understand the rules and limitations when replicating between tables with differing structures. Learn how attribute promotion and column handling work in row-based replication.
- [START TRANSACTION ... WITH CONSISTENT SNAPSHOT](https://mariadb.com/docs/server/ha-and-performance/standard-replication/enhancements-for-start-transaction-with-consistent-snapshot.md): Learn how to start a consistent transaction for backups or replication setup. This command ensures a consistent view of the database without locking tables unnecessarily.
- [Restricting Speed of Reading Binlog from Primary by a Replica](https://mariadb.com/docs/server/ha-and-performance/standard-replication/restricting-speed-of-reading-binlog-from-primary-by-a-replica.md): Configure throughput limits for replication traffic. Learn to throttle the binlog download speed to prevent replication from consuming all available network bandwidth.
- [Running Triggers on the Replica for Row-based Events](https://mariadb.com/docs/server/ha-and-performance/standard-replication/running-triggers-on-the-replica-for-row-based-events.md): Understand how triggers behave under row-based replication. Learn when and why triggers are not executed on the replica and how to manage complex logic in this mode.
- [Obsolete Replication Information](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information.md): Access documentation for deprecated or removed replication features. Review this historical context when upgrading legacy systems or migrating to newer MariaDB versions.
- [LOAD DATA FROM MASTER (removed)](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/load-data-from-master-removed.md)
- [LOAD TABLE FROM MASTER (removed)](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/load-table-from-master-removed.md)
- [MariaDB 5.2 Replication Feature Preview](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/mariadb-52-replication-feature-preview.md)
- [XtraDB option --innodb-release-locks-early](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/xtradb-option-innodb-release-locks-early.md)
- [Benchmarking](https://mariadb.com/docs/server/ha-and-performance/benchmarking.md)
- [MariaDB Memory Allocation](https://mariadb.com/docs/server/ha-and-performance/mariadb-memory-allocation.md): Plan MariaDB memory usage by sizing global caches, per-connection buffers, and engine-specific settings to avoid swapping and out-of-memory conditions.
- [Hardware Optimization](https://mariadb.com/docs/server/ha-and-performance/hardware-optimization.md): Optimize MariaDB Server performance through hardware. This section covers selecting appropriate CPU, memory, and storage configurations to maximize your database's speed and throughput.
- [Connection Redirection Mechanism in the MariaDB Client/Server Protocol](https://mariadb.com/docs/server/ha-and-performance/connection-redirection-mechanism-in-the-mariadb-clientserver-protocol.md): Explore connection redirection. This section details how the client/server protocol handles redirection for high availability and load balancing, ensuring seamless database access and failover.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/ha-and-performance.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.