Reference for MariaDB Enterprise Server

Overview

Reference material is available here for MariaDB Enterprise Server on MariaDB SkySQL.

This includes MariaDB Enterprise Server and MariaDB ColumnStore, all on expert-maintained cloud infrastructure from MariaDB Corporation.

Reference material is available for MariaDB Enterprise Server.

Features of MariaDB Enterprise Server include MariaDB Enterprise Backup and MariaDB Enterprise Audit.

MariaDB Enterprise Server 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

Docker Registry

How to use the MariaDB Enterprise Docker Registry

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

MariaDB Enterprise Server Reference for SkySQL

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

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

Sys Database Table Schema

System status VIEWs in the SYS database