Showing the first 18000 characters. Load the complete file to read the remainder.
# MariaDB Documentation
## Home
- [MariaDB Documentation](https://mariadb.com/docs/readme.md): Comprehensive documentation, release notes and learning resources for all MariaDB products.
- [MariaDB Server Ecosystem Hub](https://mariadb.com/docs/mariadb-server-ecosystem-hub.md): A curated discovery platform for the tools, services, platforms, and partners that work with MariaDB Server.
## MariaDB Platform
- [MariaDB Enterprise Platform](https://mariadb.com/docs/platform/readme.md)
- [Install a MariaDB Enterprise License](https://mariadb.com/docs/platform/enterprise-license-install.md): Where to get a MariaDB license and how to install it, for every MariaDB product that requires one. Start here, then follow the link for your product.
- [MariaDB Platform Use Cases](https://mariadb.com/docs/platform/mariadb-platform-use-cases.md)
- [MariaDB Platform Quickstart Guides](https://mariadb.com/docs/platform/mariadb-platform-quickstart-guides.md)
- [MariaDB Overview](https://mariadb.com/docs/platform/mariadb-platform-quickstart-guides/mariadb-overview-guide.md)
- [Best Practices](https://mariadb.com/docs/platform/mariadb-platform-quickstart-guides/mariadb-best-practices-guide.md)
- [Security](https://mariadb.com/docs/platform/mariadb-platform-quickstart-guides/security.md)
- [Style](https://mariadb.com/docs/platform/style.md)
- [MariaDB FAQs](https://mariadb.com/docs/platform/mariadb-faqs.md): MariaDB Frequently Asked Questions
- [Database Servers](https://mariadb.com/docs/platform/mariadb-faqs/database-servers.md)
- [MariaDB Enterprise Server](https://mariadb.com/docs/platform/mariadb-faqs/database-servers/mariadb-enterprise-server.md)
- [High Availability & Clustering Solutions](https://mariadb.com/docs/platform/mariadb-faqs/high-availability-and-clustering-solutions.md)
- [MariaDB Enterprise Cluster (powered by Galera Cluster)](https://mariadb.com/docs/platform/mariadb-faqs/high-availability-and-clustering-solutions/mariadb-enterprise-cluster-powered-by-galera-cluster.md)
- [Analytical Solutions](https://mariadb.com/docs/platform/mariadb-faqs/analytical-solutions.md)
- [MariaDB ColumnStore](https://mariadb.com/docs/platform/mariadb-faqs/analytical-solutions/mariadb-columnstore.md)
- [Database Proxies & Routers](https://mariadb.com/docs/platform/mariadb-faqs/database-proxies-and-routers.md)
- [MariaDB MaxScale](https://mariadb.com/docs/platform/mariadb-faqs/database-proxies-and-routers/mariadb-maxscale.md)
- [Management & Operations Tools](https://mariadb.com/docs/platform/mariadb-faqs/management-and-operations-tools.md)
- [MariaDB Connectors](https://mariadb.com/docs/platform/mariadb-faqs/management-and-operations-tools/mariadb-connectors.md)
- [MariaDB Kubernetes Operator](https://mariadb.com/docs/platform/mariadb-faqs/management-and-operations-tools/mariadb-kubernetes-operator.md)
- [MariaDB Enterprise Backup](https://mariadb.com/docs/platform/mariadb-faqs/management-and-operations-tools/mariadb-enterprise-backup.md)
- [Storage Engines](https://mariadb.com/docs/platform/mariadb-faqs/storage-engines.md)
- [InnoDB Storage Engine](https://mariadb.com/docs/platform/mariadb-faqs/storage-engines/innodb-storage-engine.md)
- [Aria Storage Engine](https://mariadb.com/docs/platform/mariadb-faqs/storage-engines/aria-storage-engine.md)
- [MyRocks Storage Engine](https://mariadb.com/docs/platform/mariadb-faqs/storage-engines/myrocks-storage-engine.md)
- [Spider Storage Engine](https://mariadb.com/docs/platform/mariadb-faqs/storage-engines/spider-storage-engine.md)
- [Plugins](https://mariadb.com/docs/platform/mariadb-faqs/plugins.md)
- [MariaDB Enterprise Audit Plugin](https://mariadb.com/docs/platform/mariadb-faqs/plugins/mariadb-enterprise-audit-plugin.md)
- [MariaDB HashiCorp Vault Plugin](https://mariadb.com/docs/platform/mariadb-faqs/plugins/mariadb-hashicorp-vault-plugin.md)
- [MariaDB Enterprise Platform](https://mariadb.com/docs/platform/mariadb-faqs/mariadb-enterprise-platform.md)
## Server
- [MariaDB Server Documentation](https://mariadb.com/docs/server/readme.md): Explore MariaDB Server, the powerful open-source relational database. This comprehensive documentation covers installation, deployment, usage, security, and advanced topics to help you master MariaDB.
- [Quickstart Guides](https://mariadb.com/docs/server/mariadb-quickstart-guides.md): Get started quickly with MariaDB Server using these quickstart guides. Follow step-by-step instructions to install, configure, and begin using MariaDB for your projects.
- [Installing MariaDB Server Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/installing-mariadb-server-guide.md): Official MariaDB Server install guide: Linux apt/dnf/yum commands, mariadb-secure-installation setup, systemctl status/start checks, Windows .msi installer.
- [Adding & Changing Data Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-adding-and-changing-data-guide-1.md): This guide provides a walkthrough of the INSERT, UPDATE, and DELETE statements, demonstrating how to add, modify, and remove data in tables.
- [Essential Queries Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-advanced-sql-guide.md): Learn how to perform essential SQL operations such as creating tables, inserting data, and using aggregate functions like MAX, MIN, and AVG.
- [Basics Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/basics-guide.md): Complete MariaDB basics guide: connect with mariadb -u/-p/-h, CREATE DATABASE/USE, CREATE TABLE with AUTO\_INCREMENT, INSERT/SELECT/UPDATE/DELETE commands.
- [Altering Tables Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-alter-table-guide-1.md): Learn how to modify existing table structures using the ALTER TABLE statement, including adding columns, changing types, and managing indexes.
- [Connecting to MariaDB Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-connecting-guide.md): This guide details how to connect to a MariaDB server using the command-line client, covering options for host, user, password, and protocol.
- [Troubleshooting Connection Issues Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-connection-troubleshooting-guide.md): Diagnose and fix common MariaDB Server connection problems, such as "Can't connect to local server" and access-denied errors, with step-by-step troubleshooting.
- [Doing Time Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-datetime-guide.md): Understand how to work with date and time values in MariaDB, including data types like DATETIME and TIMESTAMP, and useful temporal functions.
- [Importing Data Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-importing-data-guide.md): Learn how to efficiently import data into MariaDB tables from external files using the LOAD DATA INFILE statement.
- [Essentials of an Index Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/essentials-of-an-index-guide.md): This guide provides a conceptual overview of database indexes, explaining their purpose, different types, and when to use them for optimization.
- [Getting Started with Indexes Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-indexes-guide.md): Definitive MariaDB indexes guide: PRIMARY KEY, UNIQUE INDEX, INDEX, FULLTEXT types, CREATE/ALTER TABLE syntax, CREATE INDEX, SHOW INDEX, and EXPLAIN.
- [Joining Tables with JOIN Clauses](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-join-guide.md): This guide introduces the different types of JOINs (INNER, LEFT, RIGHT, CROSS) and demonstrates how to combine data from multiple tables.
- [Advanced Joins](https://mariadb.com/docs/server/mariadb-quickstart-guides/more-advanced-joins.md): Explore complex join scenarios. This guide covers filtering joined data with WHERE clauses, handling dates, and aggregating results from multiple tables for deeper analysis.
- [Configuring MariaDB for Remote Client Access Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-remote-connection-guide.md): Configure MariaDB Server to accept remote connections by setting bind-address, granting privileges for remote users, and opening the right firewall rules.
- [Getting Data Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-selecting-data-guide.md): This guide explains the SELECT statement in detail, covering how to retrieve, filter, limit, and sort data from your MariaDB database.
- [Basic SQL Statements Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-sql-cheat-cheat-guide.md): A quick reference for core SQL statements including DDL (CREATE, DROP), DML (INSERT, UPDATE, DELETE), and TCL (COMMIT, ROLLBACK) commands.
- [Basic SQL Debugging Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-sql-debugging-guide.md): This guide offers conventions and practical tips for designing SQL queries that are easier to read, understand, and debug.
- [MariaDB String Functions Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-string-functions-guide.md): This guide goes through several built-in string functions in MariaDB, grouping them by similar features, and providing examples of how they might be used.
- [Restoring Data from Dump Files Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-restore-guide.md): Restore MariaDB data from mariadb-dump backup files using the mariadb client, including how to selectively restore a single table.
- [Changing Times in MariaDB](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-time-guide.md): This guide explores MariaDB functions for performing calculations and modifications on date and time values, like DATE\_ADD and DATE\_SUB.
- [System & Status Variables Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/system-and-status-variables-guide.md): This guide indicates where the various system and status variables of MariaDB Server are found.
- [Making Backups with mariadb-dump Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-backup-guide.md): Create logical backups of MariaDB databases with the mariadb-dump utility, covering how to back up all databases, specific databases, or individual tables.
- [A MariaDB Primer Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-usage-guide.md): A beginner-friendly primer on using the mariadb command-line client to log in, create databases, and execute basic SQL commands.
- [Creating & Using Views Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-views-guide.md): Discover how to create and use views to simplify complex queries, restrict data access, and present a specific perspective of your data.
- [Database Applications](https://mariadb.com/docs/server/mariadb-quickstart-guides/database-applications.md): This section offers advice on writing and maintaining applications that use databases, covering schema design, code practices, and testing.
- [Introduction & Background](https://mariadb.com/docs/server/mariadb-quickstart-guides/database-applications/introduction-and-background.md): This section provides an introduction to developing database-backed applications with MariaDB, discussing maintenance, upgrades, and separation of concerns.
- [Database Design](https://mariadb.com/docs/server/mariadb-quickstart-guides/database-applications/database-design.md): Learn about best practices for database schema design, including naming conventions, choosing appropriate data types, and using views to abstract complexity.
- [Application Code](https://mariadb.com/docs/server/mariadb-quickstart-guides/database-applications/application-code.md): This guide covers application-side considerations, such as using ORMs, stored procedures, and writing robust SQL that handles schema changes gracefully.
- [Canary Testing](https://mariadb.com/docs/server/mariadb-quickstart-guides/database-applications/canary-testing.md): Explore strategies for safely testing schema and application changes using canary deployments, replication, and features like invisible columns.
- [Server Usage](https://mariadb.com/docs/server/server-usage.md): Learn how to effectively use MariaDB Server. This section covers SQL statements, built-in functions, client utilities, and best practices for daily database operations.
- [Basics](https://mariadb.com/docs/server/server-usage/basics.md): Grasp the basics of using MariaDB Server. This section introduces fundamental concepts, common SQL commands, and essential operations to get you started with your database.
- [Basic Queries](https://mariadb.com/docs/server/server-usage/basics/mariadb-advanced-usage-guide-1.md): This guide covers the fundamentals of creating database structures, inserting data, and retrieving information using the default MariaDB client.
- [Backup & Restore](https://mariadb.com/docs/server/server-usage/backup-and-restore.md): Learn to back up and restore MariaDB Server databases. This section covers essential strategies and tools to ensure data safety and quick recovery from potential data loss.
- [Backup and Restore Overview](https://mariadb.com/docs/server/server-usage/backup-and-restore/backup-and-restore-overview.md): Complete MariaDB backup and recovery guide. Complete resource for backup methods, mariabackup usage, scheduling, and restoration for production use.
- [Forming a Backup Strategy](https://mariadb.com/docs/server/server-usage/backup-and-restore/forming-a-backup-strategy.md): Learn how to design a robust backup strategy tailored to your business needs, balancing recovery time objectives and data retention policies.
- [Backup Optimization](https://mariadb.com/docs/server/server-usage/backup-and-restore/backup-optimization.md): Discover techniques to optimize your backup processes, including multithreading, incremental backups, and leveraging storage snapshots.
- [MariaDB Enterprise Backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md): This page details MariaDB Enterprise Backup, an enhanced version of mariadb-backup with enterprise-specific optimizations and support.
- [mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup.md): Get an overview of MariaDB Backup. This section introduces the hot physical backup tool, explaining its capabilities for efficient and consistent backups of your MariaDB Server.
- [mariadb-backup Overview](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-overview.md): Complete MariaDB backup and recovery guide. Complete resource for backup methods, mariadb-backup usage, scheduling, and restoration for production use.
- [mariadb-backup Options](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-options.md): Reference for mariadb-backup (mariabackup) command-line options. Covers --backup, --prepare, --copy-back, --move-back, streaming, and incremental backups.
- [Full Backup and Restore (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/full-backup-and-restore-with-mariadb-backup.md): Complete MariaDB backup and recovery guide. Complete resource for backup methods, mariabackup usage, scheduling, and restoration for production use.
- [Incremental Backup and Restore (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/incremental-backup-and-restore-with-mariadb-backup.md): Complete mariadb-backup incremental guide: --backup/--prepare syntax, LSN mariadb\_backup\_checkpoints, --incremental-basedir, and --copy-back/--move-back restore.
- [Partial Backup and Restore (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/partial-backup-and-restore-with-mariadb-backup.md): Back up specific databases or tables. This guide explains how to filter your backup to include only the data you need.
- [Point-In-Time Recovery (PITR, mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/point-in-time-recovery-pitr-mariadb-backup.md): Explains how to restore (recover) to a specific point in time. Point-in-time recovery is often referred to as PITR.
- [Restoring Individual Databases From a Full Backup (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/individual-database-restores-with-mariadb-backup-from-full-backup.md): Restore a single database from a full backup. Learn the procedure to extract and recover a specific database schema from a larger backup set.
- [Restoring Individual Tables and Partitions (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/restoring-individual-tables-and-partitions-with-mariadb-backup.md): Restore specific tables from a backup. Learn the process of importing individual .ibd files to recover specific tables without restoring the whole database.
- [Setting up a Replica (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/setting-up-a-replica-with-mariadb-backup.md): Initialize a replication slave using a backup. This guide shows how to use mariadb-backup to provision a new replica from a master server.
- [Files Backed Up by mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/files-backed-up-by-mariadb-backup.md): List of file types included in a backup. Understand which data files, logs, and configuration files are preserved during the backup process.
- [Files Created by mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/files-created-by-mariadb-backup.md): Reference of files generated during backup. This page explains the purpose of metadata files like xtrabackup\_checkpoints created by the tool.
- [Using Encryption
Measured from the saved file
Linked document
UTF-8 text size
1.9 MB2040925 bytes
Token count
537233o200k_base encoding
Markdown links
91629162 distinct URLs
Fenced code blocks
09200 lines in the file
Size measures the captured UTF-8 text, not compressed transfer size. Tokens are counted with a named tokenizer; other models can count differently. Neither measure establishes context compatibility or answer quality.
Project H1
MariaDB Documentation
Context architecture
How the content is divided
11 H2 sections organize 9162 parsed Markdown links. 9162 links point to .md or .markdown paths; 0 link occurrences use another hostname. Linked destinations have not been recursively validated.
H2 section
Links
UTF-8 bytes
Tokens
HomeLine 3
2
358
80
MariaDB PlatformLine 8
30
3538
925
ServerLine 41
4192
994954
234478
MaxScaleLine 4240
515
119894
32394
AnalyticsLine 4758
171
52197
11741
Galera ClusterLine 4932
100
31637
7517
ConnectorsLine 5035
347
95605
22748
ToolsLine 5385
351
88209
19199
MariaDB CloudLine 5739
134
34908
7756
Release NotesLine 5876
3200
601505
196189
General ResourcesLine 9079
120
17936
4169
Link counts exclude parsed fenced and inline code and resolve relative destinations against the final endpoint. Section sizes cover the text below each H2 until the next H2.
Embedded material
Code, installation and API examples
Fenced blocks
0 closed
Declared languages
No fenced blocks detected
Package-install commands
0 detected in fenced or inline code
Authentication examples
0 fenced lines match API-key, Authorization, Bearer, OAuth or access-token patterns
HTTP request examples
0 fenced lines match request-method patterns
Authentication links
7 links have authentication-related labels
Embedded example text and links to further documentation are counted separately. A code block does not establish that a sample runs or that an authentication flow succeeds.
Publisher prioritization
The Optional section
No H2 section named “Optional” was detected in this file.
The community proposal uses Optional by convention for secondary links that can be skipped for a shorter context. This label does not establish that everything outside it is critical, or that the material inside it is deprecated.
Machine-readable routes
MCP references and configuration text
MCP-related text was detected in the captured file. 34 links have MCP-related labels or paths. 0 fenced lines match mcpServers, mcp_servers or an mcp add command.
A verified text response establishes a companion at the checked URL. It does not prove the bundle contains all product documentation, that generation is automated, or that it fits an assistant’s context window.
Change evidence
What can be said about freshness
This capture establishes a baseline. Update frequency cannot be determined from one observation.
Linked release and migration material
3313 links have release, changelog, deprecation or migration terms in their labels or paths. These provide places to investigate product changes separately.
File changes can reveal documentation edits or navigation changes. They do not by themselves measure product release velocity, accuracy, agent adoption or AI visibility.
Counts use a deterministic parser, not a spec-compliance grade. Unusual Markdown and indented code can fall outside its recognized patterns. See the llms.txt proposal and tokenizer implementation.