Reference for MariaDB Community Server 10.6

Overview

Reference material is available for MariaDB Community Server 10.6.

MariaDB Community Server 10.6 Reference

Character Sets

Character sets use different character encodings tailored for different languages

Collations

Collations use different sorting and comparison rules tailored for different languages and use cases

Command-Line Interfaces

Command-line utilities for connecting, configuration, data loading, and troubleshooting

Data Types

Data types define the type of data a column can store

Error Codes

Error codes are used to identify each specific type of error

Client Error Codes

Client error codes are used to identify client-side errors

Functions

Built-in functions are provided to simplify common programming tasks

Information Schema

Information schema provides general information about the server and its database objects

Logging

Logs for monitoring, issue diagnosis, and troubleshooting

Operators

Operators are keywords and symbols used to perform common arithmetic, logical, and matching operations

Performance Schema

Performance schema records metrics for troubleshooting performance related issues and events

Plugins

Plugins provide optional features that can be installed

Privileges

Privileges can be granted to users to control who can perform what actions

Reserved Words

Reserved words cannot be used in queries and object names without being quoted

SQL Statements

Structured Query Language (SQL) statements enable the reading and writing of data within the database

Status Variables

Status variables contain information about the current state of the server or session

System Tables

System tables contain general settings, like user accounts, MariaDB Enterprise Audit filters, and plugin configuration

System Variables

Variables that can be queried, set, and filtered for configuration and monitoring

SQL Modes

The supported SQL mode flags

wsrep Provider Options

The wsrep provider options are used to configure Galera Cluster with the wsrep_provider_options system variable

Sys Database Table Schema

System status VIEWs in the SYS database