# HA & Performance

- [Optimization and Tuning](/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](/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](/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](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-command-values.md)
- [Thread Pool](/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](/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](/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](/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](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb-51-53.md)
- [Thread States](/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](/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](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/delayed-insert-handler-thread-states.md)
- [Event Scheduler Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/event-scheduler-thread-states.md)
- [Galera Cluster Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/galera-cluster-thread-states.md)
- [General Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/general-thread-states.md)
- [Master Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/master-thread-states.md)
- [Query Cache Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/query-cache-thread-states.md)
- [Replica I/O Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/replica-io-thread-states.md)
- [Replica Connection Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/slave-connection-thread-states.md)
- [Replica SQL Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/slave-sql-thread-states.md)
- [MariaDB Internal Optimizations](/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](/docs/server/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations/fair-choice-between-range-and-index_merge-optimizations.md)
- [Multi Range Read Optimization](/docs/server/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations/multi-range-read-optimization.md)
- [Operating System Optimizations](/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](/docs/server/ha-and-performance/optimization-and-tuning/operating-system-optimizations/filesystem-optimizations.md)
- [Optimization and Indexes](/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](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/building-the-best-index-for-a-given-select.md)
- [Compound (Composite) Indexes](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/compound-composite-indexes.md)
- [Foreign Keys](/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](/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](/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](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/latitudelongitude-indexing.md)
- [Primary Keys with Nullable Columns](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/primary-keys-with-nullable-columns.md)
- [Storage Engine Index Types](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/storage-engine-index-types.md)
- [Full-Text Indexes](/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](/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](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/full-text-indexes/full-text-index-stopwords.md)
- [Optimizer Hints](/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](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/select-modifier-hints.md)
- [Expanded New-Style Optimizer Hints](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/expanded-optimizer-hints.md)
- [Index-Level Hints](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/index-level-hints.md)
- [Query Block Naming](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/query-block-naming.md)
- [Table-Level Hints](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/table-level-hints.md)
- [Compression](/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](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression/compression-plugins.md)
- [Storage-Engine Independent Column Compression](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression/storage-engine-independent-column-compression.md)
- [Optimizing Data Structure](/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](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-data-structure/numeric-vs-string-fields.md)
- [Optimizing MEMORY Tables](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-data-structure/optimizing-memory-tables.md)
- [Optimizing String and Character Fields](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-data-structure/optimizing-string-and-character-fields.md)
- [Optimizing Tables](/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](/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](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/defragmenting-innodb-tablespaces.md)
- [Entity-Attribute-Value Implementation](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/entity-attribute-value-implementation.md)
- [IP Range Table Performance](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/ip-range-table-performance.md)
- [Optimizing Queries](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/aborting-statements.md)
- [Big DELETEs](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/big-deletes.md)
- [Charset Narrowing Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/charset-narrowing-optimization.md)
- [Data Sampling: Techniques for Efficiently Finding a Random Row](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-warehousing-high-speed-ingestion.md)
- [Data Warehousing Summary Tables](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-warehousing-summary-tables.md)
- [Data Warehousing Techniques](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-warehousing-techniques.md)
- [DISTINCT removal in aggregate functions](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/query-optimizations-distinct-removal-in-aggregate-functions.md)
- [Equality propagation optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/equality-propagation-optimization.md)
- [Filesort with Small LIMIT Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/filesort-with-small-limit-optimization.md)
- [FORCE INDEX](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/force-index.md)
- [Groupwise Max in MariaDB](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/groupwise-max-in-mariadb.md)
- [GUID/UUID Performance](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/guiduuid-performance.md)
- [hash\_join\_cardinality optimizer\_switch Flag](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/hash_join_cardinality-optimizer_switch-flag.md)
- [How to Quickly Insert Data Into MariaDB](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/how-to-quickly-insert-data-into-mariadb.md)
- [IGNORE INDEX](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/ignore-index.md)
- [Index Condition Pushdown](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/index-condition-pushdown.md)
- [Index Hints: How to Force Query Plans](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/index-hints-how-to-force-query-plans.md)
- [index\_merge sort\_intersection](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/index_merge-sort_intersection.md)
- [LIMIT ROWS EXAMINED](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/limit-rows-examined.md)
- [MariaDB 5.3 Optimizer Debugging](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/mariadb-53-optimizer-debugging.md)
- [not\_null\_range\_scan Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/not_null_range_scan-optimization.md)
- [optimizer\_switch](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer-switch.md)
- [optimizer\_adjust\_secondary\_key\_costs](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer_adjust_secondary_key_costs.md)
- [optimizer\_join\_limit\_pref\_ratio Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer_join_limit_pref_ratio-optimization.md)
- [Optimizing for "Latest News"-style Queries](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizing-for-latest-news-style-queries.md)
- [Pagination Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/pagination-optimization.md)
- [Pivoting in MariaDB](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/pivoting-in-mariadb.md)
- [Query Limits and Timeouts](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/query-limits-and-timeouts.md)
- [reorder\_outer\_joins](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/reorder_outer_joins.md)
- [Rollup Unique User Counts](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/rollup-unique-user-counts.md)
- [Rowid Filtering Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/rowid-filtering-optimization.md)
- [Sargable DATE and YEAR](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/sargable-date-and-year.md)
- [Sargable UPPER](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/sargable-upper.md)
- [USE INDEX](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/use-index.md)
- [Virtual Column Support in the Optimizer](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/virtual-column-support-in-the-optimizer.md)
- [Optimization Strategies](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/duplicateweedout-strategy.md)
- [FirstMatch Strategy](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/improvements-to-order-by.md)
- [LooseScan Strategy](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/loosescan-strategy.md)
- [Semi-join Materialization Strategy](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/semi-join-materialization-strategy.md)
- [Optimizations for Derived Tables](/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](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/derived-table-merge-optimization.md)
- [Derived Table with Key Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/derived-table-with-key-optimization.md)
- [Lateral Derived Optimization](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/split-materialized-optimization.md)
- [Statistics for Optimizing Queries](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/engine-independent-table-statistics.md)
- [Histogram-Based Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/histogram-based-statistics.md)
- [InnoDB Persistent Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/innodb-persistent-statistics.md)
- [Slow Query Log Extended Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/slow-query-log-extended-statistics.md)
- [User Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/user-statistics.md)
- [Subquery Optimizations](/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](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/conversion-of-big-in-predicates-into-subqueries.md)
- [EXISTS-to-IN Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/exists-to-in-optimization.md)
- [Non-semi-join Subquery Optimizations](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/optimizing-group-by.md)
- [Semi-join Subquery Optimizations](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/semi-join-subquery-optimizations.md)
- [Subquery Cache](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/subquery-cache.md)
- [Subquery Optimizations Map](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/subquery-optimizations-map.md)
- [Table Pullout Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/table-pullout-optimization.md)
- [Table Elimination](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-external-resources.md)
- [Table Elimination in MariaDB](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-in-mariadb.md)
- [Table Elimination in Other Databases](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-in-other-databases.md)
- [Table Elimination User Interface](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-user-interface.md)
- [What is Table Elimination?](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/what-is-table-elimination.md)
- [Query Optimizer](/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](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/block-based-join-algorithms.md)
- [Condition Selectivity Computation Internals](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/condition-selectivity-computation-internals.md)
- [Extended Keys](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/extended-keys.md)
- [MIN/MAX optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/minmax-optimization.md)
- [Notes When an Index Cannot Be Used](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/notes-when-an-index-cannot-be-used.md)
- [Optimizer Debugging With GDB](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-debugging-with-gdb.md)
- [Optimizer Development](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-development.md)
- [optimizer\_max\_sel\_arg\_weight](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer_max_sel_arg_weight.md)
- [Range Optimizer](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/range-optimizer.md)
- [The Optimizer Cost Model from MariaDB 11.0](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/the-optimizer-cost-model-from-mariadb-11-0.md)
- [Optimizer Trace](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace.md)
- [Basic Optimizer Trace Example](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/basic-optimizer-trace-example.md)
- [How to Collect Large Optimizer Traces](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/how-to-collect-large-optimizer-traces.md)
- [Optimizer Trace for Developers](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/optimizer-trace-for-developers.md)
- [Optimizer Trace Guide](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/optimizer-trace-guide.md)
- [Optimizer Trace Overview](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/optimizer-trace-overview.md)
- [Optimizer Trace Resources](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/optimizer-trace/optimizer-trace-resources.md)
- [System and Status Variables](/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](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/big-query-settings.md)
- [Handling Too Many Connections](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/handling-too-many-connections.md)
- [MariaDB Optimization for MySQL Users](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/mariadb-optimization-for-mysql-users.md)
- [Optimizing key\_buffer\_size](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/optimizing-key_buffer_size.md)
- [Optimizing table\_open\_cache](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/optimizing-table_open_cache.md)
- [OQGRAPH System and Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/oqgraph-system-and-status-variables.md)
- [Sample my.cnf Files](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/sample-mycnf-files.md)
- [Segmented Key Cache](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/segmented-key-cache.md)
- [Semisynchronous Replication Plugin Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/semisynchronous-replication-plugin-status-variables.md)
- [InnoDB Server Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/innodb-status-variables.md)
- [Setting Innodb Buffer Pool Size Dynamically](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/setting-innodb-buffer-pool-size-dynamically.md)
- [Sphinx Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/sphinx-status-variables.md)
- [Spider Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/spider-status-variables.md)
- [SQL Error Log System Variables and Options](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/sql-error-log-system-variables-and-options.md)
- [SSL/TLS Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/ssltls-status-variables.md)
- [System and Status Variables Added By Major Release](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/docs/server/ha-and-performance/standard-replication/choosing-a-replication-strategy.md)
- [Replication Statements](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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)](/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/load-data-from-master-removed.md)
- [LOAD TABLE FROM MASTER (removed)](/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/load-table-from-master-removed.md)
- [MariaDB 5.2 Replication Feature Preview](/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/mariadb-52-replication-feature-preview.md)
- [XtraDB option --innodb-release-locks-early](/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/xtradb-option-innodb-release-locks-early.md)
- [Benchmarking](/docs/server/ha-and-performance/benchmarking.md)
- [MariaDB Memory Allocation](/docs/server/ha-and-performance/mariadb-memory-allocation.md): Complete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.
- [Hardware Optimization](/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](/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.