Table of Contents
Aggregate Functions
Aggregate Functions
AVG
BIT_AND
BIT_OR
BIT_XOR
COUNT
COUNT DISTINCT
GROUP_CONCAT
MAX
MIN
STD
STDDEV
STDDEV_POP
STDDEV_SAMP
SUM
VAR_POP
VAR_SAMP
VARIANCE
Aria Clients and Utilities
Aria Clients and Utilities
aria_chk
aria_pack
aria_read_log
Backing Up and Restoring Databases
Backing Up and Restoring Databases
Backup and Restore Overview
Files Backed Up By Mariabackup
Files Created by Mariabackup
Full Backup and Restore with Mariabackup
How Mariabackup Works
Incremental Backup and Restore with Mariabackup
Mariabackup
Mariabackup and BACKUP STAGE Commands
Mariabackup Options
Mariabackup Overview
Partial Backup and Restore with Mariabackup
Percona XtraBackup
Percona XtraBackup Build Instructions
Percona XtraBackup Overview
Replication as a Backup Solution
Restoring Individual Tables and Partitions with Mariabackup
Setting up a Replication Slave with Mariabackup
Using Encryption and Compression Tools With Mariabackup
Backup, Restore and Import Clients
Backup, Restore and Import Clients
mariadb-dump
mariadb-hotcopy
mariadb-import
mysqldump
mysqlhotcopy
mysqlimport
Built-in Functions
Built-in Functions
Clients & Utilities
Clients & Utilities
Columns, Storage Engines, and Plugins
Columns, Storage Engines, and Plugins
Control Flow Functions
CASE OPERATOR
Control Flow Functions
DECODE_ORACLE
IF Function
IFNULL
NULLIF
NVL
NVL2
Copying Tables Between Different MariaDB Databases and MariaDB Servers
Copying Tables Between Different MariaDB Databases and MariaDB Servers
Data Types
AUTO_INCREMENT
AUTO_INCREMENT FAQ
BIGINT
BINARY
BIT
BLOB
BLOB and TEXT Data Types
BOOLEAN
CHAR
CHAR BYTE
Character Set and Collation Overview
Character Sets and Collations
Coordinated Universal Time
Data Type Storage Requirements
Data Types
DATE
Date and Time Data Types
DATETIME
DEC, NUMERIC, FIXED
DECIMAL
DOUBLE
DOUBLE PRECISION
ENUM
FLOAT
Floating-point Accuracy
Future developments for temporal types
How to define a date in order to import an empty date from a CSV file?
INET6
INT
INT1
INT2
INT3
INT4
INT8
INTEGER
Internationalization and Localization
JSON Data Type
Locales Plugin
LONG and LONG VARCHAR
LONGBLOB
LONGTEXT
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
NULL Values
NUMBER
Numeric Data Type Overview
Numeric Data Types
ROW
Server Locale
SET CHARACTER SET
SET Data Type
SET NAMES
Setting Character Sets and Collations
Setting the Language for Error Messages
SMALLINT
String Data Types
Supported Character Sets and Collations
TEXT
TIME
Time Zones
TIMESTAMP
TINYBLOB
TINYINT
TINYTEXT
Unicode
UUID Data Type
VARBINARY
VARCHAR
Which datatypes are supported by MariaDB
YEAR Data Type
Date & Time Functions
ADD_MONTHS
ADDDATE
ADDTIME
CONVERT_TZ
CURDATE
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURTIME
Date & Time Functions
Date and Time Units
DATE FUNCTION
DATE_ADD
DATE_FORMAT
DATE_SUB
DATEDIFF
DAY
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
EXTRACT
FROM_DAYS
FROM_UNIXTIME
GET_FORMAT
HOUR
LAST_DAY
LOCALTIME
LOCALTIMESTAMP
MAKEDATE
MAKETIME
MICROSECOND
Microseconds in MariaDB
MINUTE
MONTH
MONTHNAME
NOW
PERIOD_ADD
PERIOD_DIFF
QUARTER
SEC_TO_TIME
SECOND
STR_TO_DATE
SUBDATE
SUBTIME
SYSDATE
TIME Function
TIME_FORMAT
TIME_TO_SEC
TIMEDIFF
TIMESTAMP FUNCTION
TIMESTAMPADD
TIMESTAMPDIFF
TO_DAYS
TO_SECONDS
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
dbdeployer
dbdeployer
dbForge Studio for MariaDB
dbForge Studio for MariaDB
EXPLAIN Analyzer
EXPLAIN Analyzer
EXPLAIN Analyzer API
EXPLAIN Analyzer API
Function and Operator Reference
Function and Operator Reference
Geographic & Geometric Features
AREA
AsBinary
AsText
AsWKB
AsWKT
BOUNDARY
BUFFER
CENTROID
CONTAINS
CONVEXHULL
CROSSES
DIMENSION
DISJOINT
ENDPOINT
ENVELOPE
EQUALS
ExteriorRing
Geographic & Geometric Features
GeoJSON
GeomCollFromText
GeomCollFromWKB
Geometry Constructors
Geometry Hierarchy
Geometry Properties
Geometry Relations
Geometry Types
GEOMETRYCOLLECTION
GeometryCollectionFromText
GeometryCollectionFromWKB
GeometryFromText
GeometryFromWKB
GeometryN
GeometryType
GeomFromText
GeomFromWKB
GIS features in 5.3.3
GIS Resources
GLENGTH
InteriorRingN
INTERSECTS
IsClosed
IsEmpty
IsRing
IsSimple
LineFromText
LineFromWKB
LINESTRING
LineString Properties
LineStringFromText
LineStringFromWKB
MariaDB Plans - GIS
MBR (Minimum Bounding Rectangle)
MBR Definition
MBRContains
MBRDisjoint
MBREqual
MBRIntersects
MBROverlaps
MBRTouches
MBRWithin
MLineFromText
MLineFromWKB
MPointFromText
MPointFromWKB
MPolyFromText
MPolyFromWKB
MULTILINESTRING
MultiLineStringFromText
MultiLineStringFromWKB
MULTIPOINT
MultiPointFromText
MultiPointFromWKB
MULTIPOLYGON
MultiPolygonFromText
MultiPolygonFromWKB
MySQL/MariaDB Spatial Support Matrix
NumGeometries
NumInteriorRings
NumPoints
OVERLAPS
POINT
Point Properties
PointFromText
PointFromWKB
PointN
PointOnSurface
PolyFromText
PolyFromWKB
POLYGON
Polygon Properties
PolygonFromText
PolygonFromWKB
SPATIAL INDEX
SRID
ST_AREA
ST_AsBinary
ST_AsGeoJSON
ST_AsText
ST_AsWKB
ST_ASWKT
ST_BOUNDARY
ST_BUFFER
ST_CENTROID
ST_CONTAINS
ST_CONVEXHULL
ST_CROSSES
ST_DIFFERENCE
ST_DIMENSION
ST_DISJOINT
ST_DISTANCE
ST_DISTANCE_SPHERE
ST_ENDPOINT
ST_ENVELOPE
ST_EQUALS
ST_ExteriorRing
ST_GeomCollFromText
ST_GeomCollFromWKB
ST_GeometryCollectionFromText
ST_GeometryCollectionFromWKB
ST_GeometryFromText
ST_GeometryFromWKB
ST_GEOMETRYN
ST_GEOMETRYTYPE
ST_GeomFromGeoJSON
ST_GeomFromText
ST_GeomFromWKB
ST_InteriorRingN
ST_INTERSECTION
ST_INTERSECTS
ST_ISCLOSED
ST_ISEMPTY
ST_IsRing
ST_IsSimple
ST_LENGTH
ST_LineFromText
ST_LineFromWKB
ST_LineStringFromText
ST_LineStringFromWKB
ST_NUMGEOMETRIES
ST_NumInteriorRings
ST_NUMPOINTS
ST_OVERLAPS
ST_PointFromText
ST_PointFromWKB
ST_POINTN
ST_POINTONSURFACE
ST_PolyFromText
ST_PolyFromWKB
ST_PolygonFromText
ST_PolygonFromWKB
ST_RELATE
ST_SRID
ST_STARTPOINT
ST_SYMDIFFERENCE
ST_TOUCHES
ST_UNION
ST_WITHIN
ST_X
ST_Y
STARTPOINT
The maria/5.3-gis tree on Launchpad.
TOUCHES
Well-Known Binary (WKB) Format
WITHIN
WKB
WKT
WKT Definition
X
Y
Getting, Installing, and Upgrading MariaDB
A Comparison Between Automation Systems
About the MariaDB RPM Files
Ansible and MariaDB
Ansible Overview for MariaDB Users
apt-upgrade Fails, But the Database is Running
Atomic Write Support
Automated MariaDB Deployment and Administration
Benefits of Managing Docker Containers with Orchestration Software
Bolt Examples
Build Environment Setup for Linux
Build Environment Setup for Mac
Building MariaDB from a Source RPM
Building MariaDB From Source Using musl-based GNU/Linux
Building MariaDB on CentOS
Building MariaDB on Debian
Building MariaDB on Fedora
Building MariaDB on FreeBSD
Building MariaDB on Gentoo
Building MariaDB on Solaris and OpenSolaris
Building MariaDB on Ubuntu
Building MariaDB on Windows
Building RPM Packages From Source
Checking MariaDB RPM Package Signatures
Compiling MariaDB From Source
Compiling MariaDB with Extra Modules/Options
Compiling MariaDB with TCMalloc
Compiling MariaDB with Vanilla XtraDB
Compiling with the InnoDB Plugin from Oracle
Configuring Linux for MariaDB
Configuring MariaDB for Optimal Performance
Configuring MariaDB with Option Files
Configuring Swappiness
Creating a Custom Docker Image
Creating a Debian Repository
Creating a Vagrantfile
Creating the MariaDB Binary Tarball
Creating the MariaDB Source Tarball
Cross-compiling MariaDB
Deploying Docker Containers with Ansible
Deploying Docker Containers with Puppet
Deploying to Remote Servers with Ansible
Differences in MariaDB in Debian (and Ubuntu)
Distributions Which Include MariaDB
Docker and MariaDB
Docker Security Concerns
Downgrading between Major Versions of MariaDB
Error: symbol mysql_get_server_name, version libmysqlclient_16 not defined
Existing Ansible Modules and Roles for MariaDB
Existing Puppet Modules for MariaDB
Fusion-io
Fusion-io Introduction
Generic Build Instructions
Get, Build and Test Latest MariaDB the Lazy Way
Getting, Installing, and Upgrading MariaDB
GPG
HashiCorp Vault and MariaDB
Installation issues on Debian and Ubuntu
Installation issues on Windows
Installation Issues with PHP5
Installing and Using MariaDB via Docker
Installing MariaDB .deb Files
Installing MariaDB .deb Files with Ansible
Installing MariaDB Alongside MySQL
Installing MariaDB Binary Tarballs
Installing MariaDB MSI Packages on Windows
Installing MariaDB on IBM Cloud
Installing MariaDB RPM Files
Installing MariaDB Server on macOS Using Homebrew
Installing MariaDB Server PKG packages on macOS
Installing MariaDB Windows ZIP Packages
Installing MariaDB With the rpm Tool
Installing MariaDB with yum/dnf
Installing MariaDB with zypper
Installing on an Old Linux Version
Installing System Tables (mysql_install_db)
Kubernetes and MariaDB
Kubernetes Operators for MariaDB
Kubernetes Overview for MariaDB Users
launchd
Managing Secrets in Ansible
MariaDB 5.5.33 Debian and Ubuntu Installation Issues
MariaDB Authorization and Permissions for SQL Server Users
MariaDB Backups Overview for SQL Server Users
MariaDB Binary Packages
MariaDB Debian Live Images
MariaDB Environment Variables
MariaDB Features Not Available in SQL Server
MariaDB for DirectAdmin Using RPMs
MariaDB Installation (Version 10.1.21) via RPMs on CentOS 7
MariaDB on Amazon AWS
MariaDB Package Repository Setup and Usage
MariaDB Performance & Advanced Configurations
MariaDB Replication Overview for SQL Server Users
MariaDB Source Configuration Options
MariaDB Transactions and Isolation Levels for SQL Server Users
mariadbd
mariadbd-multi
mariadbd-safe
Migrating to MariaDB
Migrating to MariaDB from MySQL
Migrating to MariaDB from Oracle
Migrating to MariaDB from PostgreSQL
Migrating to MariaDB from SQL Server
Moving Data Between SQL Server and MariaDB
Moving from MySQL to MariaDB in Debian 9
mysql.server
mysql_install_db.exe
mysqld Configuration Files and Groups
mysqld Options
mysqld_multi
mysqld_safe
Obsolete Installation Information
Oracle XE 11.2. and MariaDB 10.1 integration on Ubuntu 14.04 and Debian systems
Orchestrator Overview
Puppet and MariaDB
Puppet and MariaDB
Puppet Overview for MariaDB Users
Repairing MariaDB Tables for SQL Server Users
Running MariaDB from the Build Directory
Running mariadb-tzinfo-to-sql with Ansible
Running Multiple MariaDB Server Processes
Screencast for Upgrading MySQL to MariaDB
Setting Up a LAMP Stack with Docker Compose
Setting Up MariaDB for Testing for SQL Server Users
Specifying Permissions for Schema (Data) Directories and Tables
Specifying Which Plugins to Build
SQL Server and MariaDB Types Comparison
SQL Server Features Implemented Differently in MariaDB
SQL Server Features Not Available in MariaDB
Starting and Stopping MariaDB
Starting and Stopping MariaDB
Switching Between Different Installed MariaDB Versions
Syntax Differences between MariaDB and SQL Server
systemd
sysVinit
Troubleshooting Installation Issues
Troubleshooting MariaDB Installs on Red Hat/CentOS
Understanding MariaDB Architecture
Upgrading Between Major MariaDB Versions
Upgrading Between Minor Versions on Linux
Upgrading from MariaDB 10.0 to MariaDB 10.1
Upgrading from MariaDB 10.1 to MariaDB 10.2
Upgrading from MariaDB 10.2 to MariaDB 10.3
Upgrading from MariaDB 10.3 to MariaDB 10.4
Upgrading from MariaDB 10.4 to MariaDB 10.5
Upgrading from MariaDB 10.5 to MariaDB 10.6
Upgrading from MariaDB 10.6 to MariaDB 10.7
Upgrading from MariaDB 5.3 to MariaDB 5.5
Upgrading from MariaDB 5.5 to MariaDB 10.0
Upgrading from MySQL 5.7 to MariaDB 10.2
Upgrading from MySQL to MariaDB
Upgrading from MySQL to MariaDB
Upgrading MariaDB
Upgrading MariaDB on Windows
Upgrading to MariaDB From MySQL 5.0 or Older
Vagrant and MariaDB
Vagrant Overview for MariaDB Users
Vagrant Security Concerns
What to Do if MariaDB Doesn't Start
Why Source RPMs (SRPMs) Aren't Packaged For Some Platforms
Why to Automate MariaDB Deployments and Management
Graphical and Enhanced Clients
Beekeeper Studio
Database Workbench
DBeaver
dbForge Data Compare
dbForge Data Generator
dbForge Documenter for MariaDB and MySQL
dbForge Fusion: MySQL & MariaDB Plugin for VS
dbForge Query Builder for MySQL & MariaDB
dbForge Schema Compare for MariaDB & MySQL
dbForge Studio for MariaDB
DbSchema
DbVisualizer
ERBuilder Data Modeler
Graphical and Enhanced Clients
HeidiSQL
Improved SQL Document Parser Performance in Updated dbForge Tools for MySQL and MariaDB
LibreOffice Base
Moon Modeler
mycli
Navicat
ocelotgui
OmniDB
phpMyAdmin
Querious
SB Data Generator
Sequel Pro
SQL Diagnostic Manager & SQLyog
SQLPro Studio
SQLTool Pro Database Editor
SQLyog: Community Edition
TablePlus
TOAD Edge
TOAD for MySQL
Valentina Studio
High Availability & Performance Tuning
High Availability & Performance Tuning
How to match API version for php5_mysql and mariadb client?
How to match API version for php5_mysql and mariadb client?
innochecksum
innochecksum
MariaDB Administration
MariaDB Administration
MariaDB Galera Cluster
About Galera Replication
Building the Galera wsrep Package on Fedora
Building the Galera wsrep Package on Ubuntu and Debian
Configuring MariaDB Galera Cluster
Configuring MariaDB Replication between MariaDB Galera Cluster and MariaDB Server
Configuring MariaDB Replication between Two MariaDB Galera Clusters
Galera Cluster Address
Galera Cluster Status Variables
Galera Cluster System Variables
Galera Load Balancer
Galera Test Repositories
Galera Use Cases
Getting Started with MariaDB Galera Cluster
Installing Galera from Source
Installing MariaDB Galera on IBM Cloud
Introduction to State Snapshot Transfers (SSTs)
Manual SST of Galera Cluster Node With Mariabackup
Manual SST of Galera Cluster Node With Percona XtraBackup
mariabackup SST Method
MariaDB Galera 10.0 Changelogs
MariaDB Galera 5.5 Changelogs
MariaDB Galera Cluster
MariaDB Galera Cluster - Known Limitations
MariaDB Galera Cluster Releases
State Snapshot Transfers (SSTs) in Galera Cluster
Tips on Converting to Galera
Upgrading Between Minor Versions with Galera Cluster
Upgrading from MariaDB 10.1 to MariaDB 10.2 with Galera Cluster
Upgrading from MariaDB 10.2 to MariaDB 10.3 with Galera Cluster
Upgrading from MariaDB 10.3 to MariaDB 10.4 with Galera Cluster
Upgrading from MariaDB Galera Cluster 10.0 to MariaDB 10.1 with Galera Cluster
Upgrading from MariaDB Galera Cluster 5.5 to MariaDB Galera Cluster 10.0
Upgrading Galera Cluster
Using MariaDB GTIDs with MariaDB Galera Cluster
Using MariaDB Replication with MariaDB Galera Cluster
Using MariaDB Replication with MariaDB Galera Cluster
What is MariaDB Galera Cluster?
wsrep_provider_options
xtrabackup-v2 SST Method
MariaDB Platform X3
MariaDB Platform X3
MariaDB Replication
Binlog Event Checksum Interoperability
Binlog Event Checksums
Changing a Slave to Become the Master
Compressing Events to Reduce Size of the Binary Log
Delayed Replication
Enhancements for START TRANSACTION WITH CONSISTENT SNAPSHOT
Global Transaction ID
LOAD DATA FROM MASTER (removed)
LOAD TABLE FROM MASTER (removed)
MariaDB 5.2 Replication Feature Preview
MariaDB Replication
Multi-Source Replication
Obsolete Replication Information
Parallel Replication
Read-Only Replicas
Replication and Binary Log Status Variables
Replication and Binary Log System Variables
Replication and Foreign Keys
Replication Filters
Replication Overview
Replication Threads
Replication When the Master and Slave Have Different Table Definitions
Restricting speed of reading binlog from master by a slave
Row-based Replication With No Primary Key
Running Triggers on the Slave for Row-based Events
Selectively Skipping Replication of Binlog Events
Semisynchronous Replication
Setting Up Replication
Unsafe Statements for Statement-based Replication
XtraDB option --innodb-release-locks-early
mariadb-access
mariadb-access
mariadb-admin
mariadb-admin
mariadb-check
mariadb-check
mariadb-conv
mariadb-conv
mariadb-convert-table-format
mariadb-convert-table-format
mariadb-dumpslow
mariadb-dumpslow
mariadb-embedded
mariadb-embedded
mariadb-find-rows
mariadb-find-rows
mariadb-fix-extensions
mariadb-fix-extensions
mariadb-install-db
mariadb-install-db
mariadb-plugin
mariadb-plugin
mariadb-report
mariadb-report
mariadb-secure-installation
mariadb-secure-installation
mariadb-setpermission
mariadb-setpermission
mariadb-show
mariadb-show
mariadb-slap
mariadb-slap
mariadb-tzinfo-to-sql
mariadb-tzinfo-to-sql
mariadb-upgrade
mariadb-upgrade
mariadb-waitpid
mariadb-waitpid
msql2mysql
msql2mysql
Multi Master in maria db
Multi Master in maria db
Multi master replication and deadlock detection in Galera with Mariadbs
Multi master replication and deadlock detection in Galera with Mariadbs
my_print_defaults
my_print_defaults
MyISAM Clients and Utilities
Memory and Disk Use With myisamchk
MyISAM Clients and Utilities
myisam_ftdump
myisamchk
myisamchk Table Information
myisamlog
myisampack
mysql Client
Delimiters
mariadb Command-Line Client
mysql Client
mysql Command-line Client
MySQL Sandbox
MySQL Sandbox
mysql-stress-test
mysql-stress-test
mysql-test
Installing MinIO for Usage With mysql-test-run
mysql-test
mysql-test Auxiliary Files
mysql-test Overview
mysql-test-run.pl Options
New Features for mysqltest in MariaDB
Pausing mysql-test-run.pl
The Debug Sync Facility
mysql_convert_table_format
mysql_convert_table_format
mysql_embedded
mysql_embedded
mysql_find_rows
mysql_find_rows
mysql_fix_extensions
mysql_fix_extensions
mysql_install_db
mysql_install_db
mysql_plugin
mysql_plugin
mysql_secure_installation
mysql_secure_installation
mysql_setpermission
mysql_setpermission
mysql_tzinfo_to_sql
mysql_tzinfo_to_sql
mysql_waitpid
mysql_waitpid
mysql_zap
mysql_zap
mysqlaccess
mysqlaccess
mysqladmin
mysqladmin
mysqlbinlog
Annotate_rows_log_event
mariadb-binlog
mysqlbinlog
mysqlbinlog Options
Using mysqlbinlog
mysqldumpslow
mysqldumpslow
mysqlreport
mysqlreport
mysqlshow
mysqlshow
mysqlslap
mysqlslap
NoSQL
Dynamic Column API
Dynamic Columns
Dynamic Columns API
Dynamic Columns from MariaDB 10
HANDLER
HANDLER Commands
HANDLER for MEMORY Tables
HandlerSocket
HandlerSocket Client Libraries
HandlerSocket Configuration Options
HandlerSocket External Resources
HandlerSocket Installation
NoSQL
Testing HandlerSocket in a Source Distribution
Numeric Functions
ABS
ACOS
Addition Operator (+)
ASIN
ATAN
ATAN2
CEIL
CEILING
CONV
COS
COT
CRC32
DEGREES
DIV
Division Operator (/)
EXP
FLOOR
LN
LOG
LOG10
LOG2
MOD
Modulo Operator (%)
Multiplication Operator (*)
Numeric Functions
OCT
PI
POW
POWER
RADIANS
RAND
ROUND
SIGN
SIN
SQRT
TAN
TRUNCATE
Operators
!
&&
<
<=
<=>
=
>
>=
Arithmetic Operators
Assignment Operator (:=)
Assignment Operator (=)
Assignment Operators
BETWEEN AND
COALESCE
Comparison Operators
GREATEST
IN
INTERVAL
IS
IS NOT
IS NOT NULL
IS NULL
ISNULL
LEAST
Logical Operators
NOT BETWEEN
Not Equal Operator: !=
NOT IN
Operator Precedence
Operators
Subtraction Operator (-)
XOR
||
Optimization and Tuning
Aborting Statements that Exceed a Certain Time to Execute
Benchmarking
Big DELETEs
Big Query Settings
Block-Based Join Algorithms
Buffers, Caches and Threads
Building the best INDEX for a given SELECT
Compound (Composite) Indexes
Compression
Compression Plugins
Condition Pushdown into Derived Table Optimization
Condition Pushdown Into IN subqueries
Conversion of Big IN Predicates Into Subqueries
Data Sampling: Techniques for Efficiently Finding a Random Row
Data Warehousing High Speed Ingestion
Data Warehousing Summary Tables
Data Warehousing Techniques
Defragmenting InnoDB Tablespaces
Delayed Insert Connection Thread States
Delayed Insert Handler Thread States
Derived Table Merge Optimization
Derived Table with Key Optimization
DuplicateWeedout Strategy
Engine-Independent Table Statistics
Entity-Attribute-Value Implementation
Equality propagation optimization
Event Scheduler Thread States
EXISTS-to-IN Optimization
Extended Keys
Fair Choice Between Range and Index_merge Optimizations
Filesort with Small LIMIT Optimization
Filesystem Optimizations
FirstMatch Strategy
FORCE INDEX
Foreign Keys
Full-Text Index Overview
Full-Text Index Stopwords
Full-Text Indexes
General Thread States
Getting Started with Indexes
GROUP BY trick has been optimized away
Groupwise Max in MariaDB
GUID/UUID Performance
Handling Too Many Connections
Hardware Optimization
Histogram-Based Statistics
How to Quickly Insert Data Into MariaDB
IGNORE INDEX
Ignored Indexes
Improvements to ORDER BY Optimization
Index Condition Pushdown
Index Hints: How to Force Query Plans
Index Statistics
index_merge sort_intersection
InnoDB Persistent Statistics
InnoDB Server Status Variables
IP Range Table Performance
Lateral Derived Optimization
Latitude/Longitude Indexing
LIMIT ROWS EXAMINED
LooseScan Strategy
MariaDB 5.3 Optimizer Debugging
MariaDB Internal Optimizations
MariaDB Memory Allocation
MariaDB Optimization for MySQL Users
Master Thread States
MIN/MAX optimization
Multi Range Read Optimization
Non-semi-join Subquery Optimizations
not_null_range_scan Optimization
Numeric vs String Fields
Operating System Optimizations
Optimization and Indexes
Optimization and Tuning
Optimization Strategies
Optimizations for Derived Tables
OPTIMIZE TABLE
optimizer_switch
Optimizing Data Structure
Optimizing for "Latest News"-style Queries
Optimizing GROUP BY and DISTINCT Clauses in Subqueries
Optimizing key_buffer_size
Optimizing MEMORY Tables
Optimizing String and Character Fields
Optimizing table_open_cache
Optimizing Tables
OQGRAPH System and Status Variables
Pagination Optimization
Pivoting in MariaDB
Primary Keys with Nullable Columns
Query Cache
Query Cache Thread States
Query Limits and Timeouts
Query Optimizations
Rollup Unique User Counts
Rowid Filtering Optimization
Sample my.cnf Files
Segmented Key Cache
Semi-join Materialization Strategy
Semi-join Subquery Optimizations
Semisynchronous Replication Plugin Status Variables
Server Status Variables
Server System Variables
Setting Innodb Buffer Pool Size Dynamically
Slave Connection Thread States
Slave I/O Thread States
Slave SQL Thread States
Slow Query Log Extended Statistics
Sphinx Status Variables
Spider Status Variables
SQL_ERROR_LOG Plugin System Variables
SSL/TLS Status Variables
Statistics for Optimizing Queries
Status Variables Added in MariaDB 10.0
Status Variables Added in MariaDB 10.1
Status Variables Added in MariaDB 10.2
Status Variables Added in MariaDB 10.3
Status Variables Added in MariaDB 10.4
Status Variables Added in MariaDB 10.5
Status Variables Added in MariaDB 10.6
Storage Engine Index Types
Storage-Engine Independent Column Compression
Subquery Cache
Subquery Optimizations
Subquery Optimizations Map
System and Status Variables Added By Major Release
System Variables
System Variables Added in MariaDB 10.0
System Variables Added in MariaDB 10.1
System Variables Added in MariaDB 10.2
System Variables Added in MariaDB 10.3
System Variables Added in MariaDB 10.4
System Variables Added in MariaDB 10.5
System Variables Added in MariaDB 10.6
System Variables Added in MariaDB 5.5
Table Elimination
Table Elimination External Resources
Table Elimination in MariaDB
Table Elimination in Other Databases
Table Elimination User Interface
Table Pullout Optimization
Thread Command Values
Thread Groups in the Unix Implementation of the Thread Pool
Thread Pool
Thread Pool in MariaDB
Thread Pool in MariaDB 5.1 - 5.3
Thread Pool System and Status Variables
Thread States
USE INDEX
User Statistics
What is Table Elimination?
Partitioning Tables
HASH Partitioning Type
LIST Partitioning Type
Partition Maintenance
Partition Pruning and Selection
Partitioning Limitations with MariaDB
Partitioning Overview
Partitioning Tables
Partitioning Types
Partitioning Types Overview
Partitions Files
Partitions Metadata
RANGE COLUMNS and LIST COLUMNS Partitioning Types
RANGE Partitioning Type
perror
perror
Plugins
Authentication Plugin - ed25519
Authentication Plugin - GSSAPI
Authentication Plugin - mysql_native_password
Authentication Plugin - mysql_old_password
Authentication Plugin - Named Pipe
Authentication Plugin - PAM
Authentication Plugin - SHA-256
Authentication Plugin - Unix Socket
Authentication Plugins
Authentication with Pluggable Authentication Modules (PAM)
Configuring PAM Authentication and User Mapping with LDAP Authentication
Configuring PAM Authentication and User Mapping with Unix Authentication
Cracklib Password Check Plugin
Disks Plugin
Feedback Plugin
Information on Plugins
Installing, Using, and Creating Plugins
List of Plugins
MariaDB Audit Plugin
MariaDB Audit Plugin - Configuration
MariaDB Audit Plugin - Installation
MariaDB Audit Plugin - Location and Rotation of Logs
MariaDB Audit Plugin - Log Format
MariaDB Audit Plugin - Log Settings
MariaDB Audit Plugin - Status Variables
MariaDB Audit Plugin - Versions
MariaDB Audit Plugin Options and System Variables
MariaDB Replication & Cluster Plugins
METADATA_LOCK_INFO Plugin
Other Plugins
Password Validation Plugins
Pluggable Authentication Overview
Plugin Overview
Plugins
Query Cache Information Plugin
Query Response Time Plugin
Release Notes - MariaDB Audit Plugin
Simple Password Check Plugin
User and Group Mapping with PAM
User Variables Plugin
WSREP_INFO Plugin
Programmatic & Compound Statements
BEGIN END
CASE Statement
CLOSE
Cursor Overview
Cursors
DECLARE CONDITION
DECLARE CURSOR
DECLARE HANDLER
DECLARE Variable
Diagnostics
Diagnostics Area
FETCH
FOR
GET DIAGNOSTICS
GOTO
IF
ITERATE
Labels
LEAVE
LOOP
OPEN
Programmatic & Compound Statements
REPEAT LOOP
RESIGNAL
RETURN
SELECT INTO
SET Variable
SIGNAL
SQLSTATE
Using Compound Statements Outside of Stored Programs
WHILE
Programming & Customizing MariaDB
Programming & Customizing MariaDB
Pseudo Columns
_rowid
Pseudo Columns
replace Utility
replace Utility
resolve_stack_dump
resolve_stack_dump
resolveip
resolveip
Sample Platform X3 implementation for Transactional and Analytical Workloads
Sample Platform X3 implementation for Transactional and Analytical Workloads
Secondary Functions
&
<<
>>
^
AES_DECRYPT
AES_ENCRYPT
BENCHMARK
BINLOG_GTID_POS
Bit Functions and Operators
BIT_COUNT
CHARSET
COERCIBILITY
COLLATION
COMPRESS
CONNECTION_ID
CURRENT_ROLE
CURRENT_USER
DATABASE
DECODE
DECODE_HISTOGRAM
DEFAULT
DES_DECRYPT
DES_ENCRYPT
ENCODE
ENCRYPT
Encryption, Hashing and Compression Functions
FOUND_ROWS
GET_LOCK
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
Information Functions
IS_FREE_LOCK
IS_IPV4
IS_IPV4_COMPAT
IS_IPV4_MAPPED
IS_IPV6
IS_USED_LOCK
LAST_INSERT_ID
LAST_VALUE
MASTER_GTID_WAIT
MASTER_POS_WAIT
MD5
Miscellaneous Functions
NAME_CONST
OLD_PASSWORD
Parentheses
PASSWORD
PROCEDURE ANALYSE
RELEASE_ALL_LOCKS
RELEASE_LOCK
ROW_COUNT
ROWNUM
SCHEMA
Secondary Functions
SESSION_USER
SHA1
SHA2
SLEEP
SYS_GUID
SYSTEM_USER
TRUE FALSE
UNCOMPRESS
UNCOMPRESSED_LENGTH
USER
UUID
UUID_SHORT
VALUES / VALUE
VERSION
|
~
Sequences
ALTER SEQUENCE
CREATE SEQUENCE
DROP SEQUENCE
LASTVAL
NEXT VALUE for sequence_name
NEXTVAL
PREVIOUS VALUE FOR sequence_name
SEQUENCE Functions
Sequence Overview
Sequences
SETVAL()
Server Monitoring & Logs
Activating the Binary Log
Binary Log
Binary Log Formats
Error Log
EXPLAIN in the Slow Query Log
Flashback
General Query Log
Group Commit for the Binary Log
Heuristic Recovery with the Transaction Coordinator Log
MyISAM Log
Overview of MariaDB Logs
Overview of the Binary Log
Relay Log
Rotating Logs on Unix and Linux
Server Monitoring & Logs
Slow Query Log
Slow Query Log Overview
SQL Error Log Plugin
Transaction Coordinator Log
Transaction Coordinator Log Overview
Using and Maintaining the Binary Log
Writing Logs Into Tables
Special Functions
Aggregate Functions as Window Functions
COLUMN_ADD
COLUMN_CHECK
COLUMN_CREATE
COLUMN_DELETE
COLUMN_EXISTS
COLUMN_GET
COLUMN_JSON
COLUMN_LIST
ColumnStore Window Functions
CUME_DIST
DENSE_RANK
Differences between JSON_QUERY and JSON_VALUE
Dynamic Columns Functions
FIRST_VALUE
Galera Functions
Geographic Functions
JSON Functions
JSON_ARRAY
JSON_ARRAY_APPEND
JSON_ARRAY_INSERT
JSON_ARRAYAGG
JSON_COMPACT
JSON_CONTAINS
JSON_CONTAINS_PATH
JSON_DEPTH
JSON_DETAILED
JSON_EQUALS
JSON_EXISTS
JSON_EXTRACT
JSON_INSERT
JSON_KEYS
JSON_LENGTH
JSON_LOOSE
JSON_MERGE
JSON_MERGE_PATCH
JSON_MERGE_PRESERVE
JSON_NORMALIZE
JSON_OBJECT
JSON_OBJECTAGG
JSON_QUERY
JSON_QUOTE
JSON_REMOVE
JSON_REPLACE
JSON_SEARCH
JSON_SET
JSON_TABLE
JSON_TYPE
JSON_UNQUOTE
JSON_VALID
JSON_VALUE
JSONPath Expressions
LAG
LEAD
MEDIAN
NTH_VALUE
NTILE
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
RANK
ROW_NUMBER
Special Functions
Window Frames
Window Functions
Window Functions Overview
WSREP_LAST_SEEN_GTID
WSREP_LAST_WRITTEN_GTID
WSREP_SYNC_WAIT_UPTO_GTID
SQL Language Structure
Binary Literals
Boolean Literals
Date and Time Literals
Hexadecimal Literals
Identifier Case-sensitivity
Identifier Names
Identifier Qualifiers
Identifier to File Name Mapping
MariaDB Error Codes
Numeric Literals
Reserved Words
SQL Language Structure
String Literals
Table Value Constructors
User-Defined Variables
SQL Statements
About SHOW
Account Management SQL Commands
Administrative SQL Statements
ALTER
ALTER DATABASE
ALTER FUNCTION
ALTER LOGFILE GROUP
ALTER SERVER
ALTER TABLE
ALTER TABLESPACE
ALTER USER
ANALYZE and EXPLAIN Statements
ANALYZE FORMAT=JSON
ANALYZE FORMAT=JSON Examples
ANALYZE Statement
ANALYZE TABLE
Atomic DDL
BACKUP commands
BACKUP LOCK
BACKUP STAGE
BACKUP TABLE (removed)
BINLOG
CACHE INDEX
CALL
CHANGE MASTER TO
Changing & Deleting Data
CHECK TABLE
CHECK VIEW
CHECKSUM TABLE
Comma vs JOIN
Comment Syntax
COMMIT
Common Table Expressions
Concurrent Inserts
CONSTRAINT
CREATE
CREATE DATABASE
CREATE EVENT
CREATE FUNCTION
CREATE INDEX
CREATE LOGFILE GROUP
CREATE PACKAGE
CREATE PACKAGE BODY
CREATE ROLE
CREATE SERVER
CREATE TABLE
CREATE TABLESPACE
CREATE USER
Data Definition
Data Manipulation
DEALLOCATE / DROP PREPARE
DELETE
DESCRIBE
DO
DROP
DROP DATABASE
DROP EVENT
DROP INDEX
DROP LOGFILE GROUP
DROP PACKAGE
DROP PACKAGE BODY
DROP ROLE
DROP SERVER
DROP TABLE
DROP TABLESPACE
DROP TRIGGER
DROP USER
DUAL
EXCEPT
EXECUTE IMMEDIATE
EXECUTE Statement
EXPLAIN
EXPLAIN ANALYZE
EXPLAIN FORMAT=JSON
Extended Show
FLUSH
FLUSH Commands
FLUSH QUERY CACHE
FLUSH TABLES FOR EXPORT
FOR UPDATE
Generated (Virtual and Persistent/Stored) Columns
GRANT
GROUP BY
HELP Command
HIGH_PRIORITY and LOW_PRIORITY
IGNORE
Information Schema
Information Schema ALL_PLUGINS Table
Information Schema APPLICABLE_ROLES Table
Information Schema CHANGED_PAGE_BITMAPS Table
Information Schema CHARACTER_SETS Table
Information Schema CHECK_CONSTRAINTS Table
Information Schema CLIENT_STATISTICS Table
Information Schema COLLATION_CHARACTER_SET_APPLICABILITY Table
Information Schema COLLATIONS Table
Information Schema COLUMN_PRIVILEGES Table
Information Schema COLUMNS Table
Information Schema DISKS Table
Information Schema ENABLED_ROLES Table
Information Schema ENGINES Table
Information Schema EVENTS Table
Information Schema FEEDBACK Table
Information Schema FILES Table
Information Schema GEOMETRY_COLUMNS Table
Information Schema GLOBAL_STATUS and SESSION_STATUS Tables
Information Schema GLOBAL_VARIABLES and SESSION_VARIABLES Tables
Information Schema INDEX_STATISTICS Table
Information Schema InnoDB Tables
Information Schema INNODB_BUFFER_PAGE Table
Information Schema INNODB_BUFFER_PAGE_LRU Table
Information Schema INNODB_BUFFER_POOL_PAGES Table
Information Schema INNODB_BUFFER_POOL_PAGES_BLOB Table
Information Schema INNODB_BUFFER_POOL_PAGES_INDEX Table
Information Schema INNODB_BUFFER_POOL_STATS Table
Information Schema INNODB_CHANGED_PAGES Table
Information Schema INNODB_CMP and INNODB_CMP_RESET Tables
Information Schema INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
Information Schema INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
Information Schema INNODB_FT_BEING_DELETED Table
Information Schema INNODB_FT_CONFIG Table
Information Schema INNODB_FT_DEFAULT_STOPWORD Table
Information Schema INNODB_FT_DELETED Table
Information Schema INNODB_FT_INDEX_CACHE Table
Information Schema INNODB_FT_INDEX_TABLE Table
Information Schema INNODB_LOCK_WAITS Table
Information Schema INNODB_LOCKS Table
Information Schema INNODB_METRICS Table
Information Schema INNODB_MUTEXES Table
Information Schema INNODB_SYS_COLUMNS Table
Information Schema INNODB_SYS_DATAFILES Table
Information Schema INNODB_SYS_FIELDS Table
Information Schema INNODB_SYS_FOREIGN Table
Information Schema INNODB_SYS_FOREIGN_COLS Table
Information Schema INNODB_SYS_INDEXES Table
Information Schema INNODB_SYS_SEMAPHORE_WAITS Table
Information Schema INNODB_SYS_TABLES Table
Information Schema INNODB_SYS_TABLESPACES Table
Information Schema INNODB_SYS_TABLESTATS Table
Information Schema INNODB_TABLESPACES_ENCRYPTION Table
Information Schema INNODB_TABLESPACES_SCRUBBING Table
Information Schema INNODB_TRX Table
Information Schema INNODB_UNDO_LOGS Table
Information Schema KEY_CACHES Table
Information Schema KEY_COLUMN_USAGE Table
Information Schema KEYWORDS Table
Information Schema LOCALES Table
Information Schema METADATA_LOCK_INFO Table
Information Schema MROONGA_STATS Table
Information Schema MyRocks Tables
Information Schema OPTIMIZER_TRACE Table
Information Schema PARAMETERS Table
Information Schema PARTITIONS Table
Information Schema PLUGINS Table
Information Schema PROCESSLIST Table
Information Schema PROFILING Table
Information Schema QUERY_CACHE_INFO Table
Information Schema QUERY_RESPONSE_TIME Table
Information Schema REFERENTIAL_CONSTRAINTS Table
Information Schema ROCKSDB_CF_OPTIONS Table
Information Schema ROCKSDB_CFSTATS Table
Information Schema ROCKSDB_COMPACTION_STATS Table
Information Schema ROCKSDB_DBSTATS Table
Information Schema ROCKSDB_DDL Table
Information Schema ROCKSDB_DEADLOCK Table
Information Schema ROCKSDB_GLOBAL_INFO Table
Information Schema ROCKSDB_INDEX_FILE_MAP Table
Information Schema ROCKSDB_LOCKS Table
Information Schema ROCKSDB_PERF_CONTEXT Table
Information Schema ROCKSDB_PERF_CONTEXT_GLOBAL Table
Information Schema ROCKSDB_SST_PROPS Table
Information Schema ROCKSDB_TRX Table
Information Schema ROUTINES Table
Information Schema SCHEMA_PRIVILEGES Table
Information Schema SCHEMATA Table
Information Schema SPATIAL_REF_SYS Table
Information Schema SPIDER_ALLOC_MEM Table
Information Schema SQL_FUNCTIONS Table
Information Schema STATISTICS Table
Information Schema SYSTEM_VARIABLES Table
Information Schema TABLE_CONSTRAINTS Table
Information Schema TABLE_PRIVILEGES Table
Information Schema TABLE_STATISTICS Table
Information Schema Tables
Information Schema TABLES Table
Information Schema TABLESPACES Table
Information Schema TEMP_TABLES_INFO Table
Information Schema THREAD_POOL_GROUPS Table
Information Schema THREAD_POOL_QUEUES Table
Information Schema THREAD_POOL_STATS Table
Information Schema THREAD_POOL_WAITS Table
Information Schema TRIGGERS Table
Information Schema USER_PRIVILEGES Table
Information Schema USER_STATISTICS Table
Information Schema USER_VARIABLES Table
Information Schema WSREP_MEMBERSHIP Table
Information Schema WSREP_STATUS Table
Information Schema XtraDB Tables
Information Schema XTRADB_INTERNAL_HASH_TABLES Table
Information Schema XTRADB_READ_VIEW Table
Information Schema XTRADB_RSEG Table
INSERT
INSERT - Default & Duplicate Values
INSERT DELAYED
INSERT IGNORE
INSERT ON DUPLICATE KEY UPDATE
INSERT SELECT
INSERT...RETURNING
Inserting & Loading Data
INSTALL PLUGIN
INSTALL SONAME
INTERSECT
Invisible Columns
JOIN Syntax
Joins
Joins & Subqueries
KILL [CONNECTION | QUERY]
LIMIT
List of Performance Schema Tables
LOAD DATA INFILE
LOAD Data into Tables or Index
LOAD INDEX
LOAD XML
LOCK IN SHARE MODE
LOCK TABLES
mariadb_schema
Metadata Locking
MINUS
More Advanced Joins
mysql.column_stats Table
mysql.columns_priv Table
mysql.db Table
mysql.event Table
mysql.func Table
mysql.general_log Table
mysql.global_priv Table
mysql.gtid_slave_pos Table
mysql.help_category Table
mysql.help_keyword Table
mysql.help_relation Table
mysql.help_topic Table
mysql.host Table
mysql.index_stats Table
mysql.innodb_index_stats
mysql.innodb_table_stats
mysql.ndb_binlog_index Table
mysql.plugin Table
mysql.proc Table
mysql.procs_priv Table
mysql.proxies_priv Table
mysql.roles_mapping Table
mysql.servers Table
mysql.slow_log Table
mysql.spider_link_failed_log Table
mysql.spider_link_mon_servers Table
mysql.spider_table_crd Table
mysql.spider_table_position_for_recovery Table
mysql.spider_table_sts Table
mysql.spider_tables Table
mysql.spider_xa Table
mysql.spider_xa_failed_log Table
mysql.spider_xa_member Table
mysql.table_stats Table
mysql.tables_priv Table
mysql.time_zone Table
mysql.time_zone_leap_second Table
mysql.time_zone_name Table
mysql.time_zone_transition Table
mysql.time_zone_transition_type Table
mysql.transaction_registry Table
mysql.user Table
mysql_upgrade
mysqlcheck
Non-Recursive Common Table Expressions Overview
Obsolete mysql Database Tables
Obsolete Table Commands
Optimizer Hints
ORDER BY
Out Parameters in PREPARE
Performance Schema
Performance Schema accounts Table
Performance Schema cond_instances Table
Performance Schema Digests
Performance Schema events_stages_current Table
Performance Schema events_stages_history Table
Performance Schema events_stages_history_long Table
Performance Schema events_stages_summary_by_account_by_event_name Table
Performance Schema events_stages_summary_by_host_by_event_name Table
Performance Schema events_stages_summary_by_thread_by_event_name Table
Performance Schema events_stages_summary_by_user_by_event_name Table
Performance Schema events_stages_summary_global_by_event_name Table
Performance Schema events_statements_current Table
Performance Schema events_statements_history Table
Performance Schema events_statements_history_long Table
Performance Schema events_statements_summary_by_account_by_event_name Table
Performance Schema events_statements_summary_by_digest Table
Performance Schema events_statements_summary_by_host_by_event_name Table
Performance Schema events_statements_summary_by_program Table
Performance Schema events_statements_summary_by_thread_by_event_name Table
Performance Schema events_statements_summary_by_user_by_event_name Table
Performance Schema events_statements_summary_global_by_event_name Table
Performance Schema events_transactions_current Table
Performance Schema events_transactions_history Table
Performance Schema events_transactions_history_long Table
Performance Schema events_transactions_summary_by_account_by_event_name Table
Performance Schema events_transactions_summary_by_host_by_event_name Table
Performance Schema events_transactions_summary_by_thread_by_event_name Table
Performance Schema events_transactions_summary_by_user_by_event_name Table
Performance Schema events_transactions_summary_global_by_event_name Table
Performance Schema events_waits_current Table
Performance Schema events_waits_history Table
Performance Schema events_waits_history_long Table
Performance Schema events_waits_summary_by_account_by_event_name Table
Performance Schema events_waits_summary_by_host_by_event_name Table
Performance Schema events_waits_summary_by_instance Table
Performance Schema events_waits_summary_by_thread_by_event_name Table
Performance Schema events_waits_summary_by_user_by_event_name Table
Performance Schema events_waits_summary_global_by_event_name Table
Performance Schema file_instances Table
Performance Schema file_summary_by_event_name Table
Performance Schema file_summary_by_instance Table
Performance Schema host_cache Table
Performance Schema hosts Table
Performance Schema memory_global_by_event_name Table
Performance Schema memory_summary_by_account_by_event_name Table
Performance Schema memory_summary_by_host_by_event_name Table
Performance Schema memory_summary_by_thread_by_event_name Table
Performance Schema memory_summary_by_user_by_event_name Table
Performance Schema metadata_locks Table
Performance Schema mutex_instances Table
Performance Schema objects_summary_global_by_type Table
Performance Schema Overview
Performance Schema performance_timers Table
Performance Schema prepared_statements_instances Table
Performance Schema replication_applier_configuration Table
Performance Schema replication_applier_status Table
Performance Schema replication_applier_status_by_worker Table
Performance Schema rwlock_instances Table
Performance Schema session_account_connect_attrs Table
Performance Schema session_connect_attrs Table
Performance Schema setup_actors Table
Performance Schema setup_consumers Table
Performance Schema setup_instruments Table
Performance Schema setup_objects Table
Performance Schema setup_timers Table
Performance Schema socket_instances Table
Performance Schema socket_summary_by_event_name Table
Performance Schema socket_summary_by_instance Table
Performance Schema Status Variables
Performance Schema System Variables
Performance Schema table_io_waits_summary_by_index_usage Table
Performance Schema table_io_waits_summary_by_table Table
Performance Schema table_lock_waits_summary_by_table Table
Performance Schema Tables
Performance Schema threads Table
Performance Schema users Table
Plugin SQL Statements
Precedence Control in Table Operations
PREPARE Statement
Prepared Statements
PROCEDURE
PURGE BINARY LOGS
Recursive Common Table Expressions Overview
RENAME TABLE
RENAME USER
REPAIR TABLE
REPAIR VIEW
REPLACE
REPLACE...RETURNING
Replication Commands
RESET
RESET MASTER
RESET SLAVE
RESTORE TABLE (removed)
REVOKE
ROLLBACK
Row Subqueries
SAVEPOINT
Scalar Subqueries
SELECT
SELECT ... OFFSET ... FETCH
SELECT INTO DUMPFILE
SELECT INTO OUTFILE
SELECT WITH ROLLUP
Selecting Data
SET
SET Commands
SET DEFAULT ROLE
SET GLOBAL SQL_SLAVE_SKIP_COUNTER
SET PASSWORD
SET ROLE
SET SQL_LOG_BIN
SET STATEMENT
SET TRANSACTION
SHOW
SHOW AUTHORS
SHOW BINARY LOGS
SHOW BINLOG EVENTS
SHOW CHARACTER SET
SHOW CLIENT_STATISTICS
SHOW COLLATION
SHOW COLUMNS
SHOW CONTRIBUTORS
SHOW CREATE DATABASE
SHOW CREATE EVENT
SHOW CREATE FUNCTION
SHOW CREATE PACKAGE
SHOW CREATE PACKAGE BODY
SHOW CREATE PROCEDURE
SHOW CREATE SEQUENCE
SHOW CREATE TABLE
SHOW CREATE TRIGGER
SHOW CREATE USER
SHOW CREATE VIEW
SHOW DATABASES
SHOW ENGINE
SHOW ENGINE INNODB STATUS
SHOW ENGINES
SHOW ERRORS
SHOW EVENTS
SHOW EXPLAIN
SHOW FUNCTION CODE
SHOW FUNCTION STATUS
SHOW GRANTS
SHOW INDEX
SHOW INDEX_STATISTICS
SHOW INNODB STATUS (removed)
SHOW LOCALES
SHOW MASTER STATUS
SHOW OPEN TABLES
SHOW PACKAGE BODY STATUS
SHOW PACKAGE STATUS
SHOW PLUGINS
SHOW PLUGINS SONAME
SHOW PRIVILEGES
SHOW PROCEDURE CODE
SHOW PROCEDURE STATUS
SHOW PROCESSLIST
SHOW PROFILE
SHOW PROFILES
SHOW QUERY_RESPONSE_TIME
SHOW RELAYLOG EVENTS
SHOW SLAVE HOSTS
SHOW SLAVE STATUS
SHOW STATUS
SHOW TABLE STATUS
SHOW TABLE_STATISTICS
SHOW TABLES
SHOW TRIGGERS
SHOW USER_STATISTICS
SHOW VARIABLES
SHOW WARNINGS
SHOW WSREP_MEMBERSHIP
SHOW WSREP_STATUS
SHUTDOWN
Silent Column Changes
Spider mysql Database Tables
SQL Statements
SQL statements That Cause an Implicit Commit
START SLAVE
START TRANSACTION
STOP SLAVE
Storage Snapshots and BACKUP STAGE Commands
Stored Routine Statements
Subqueries
Subqueries and ALL
Subqueries and ANY
Subqueries and EXISTS
Subqueries and JOINs
Subqueries in a FROM Clause
Subquery Limitations
Sys Schema
Sys Schema sys_config Table
System Tables
Table Statements
The mysql Database Tables
TIME_MS column in INFORMATION_SCHEMA.PROCESSLIST
Transaction Timeouts
Transactions
TRUNCATE TABLE
UNINSTALL PLUGIN
UNINSTALL SONAME
UNION
UNLOCK TABLES
UPDATE
USE
Using Buffer UPDATE Algorithm
WAIT and NOWAIT
WITH
XA Transactions
SQL Statements & Structure
SQL Statements & Structure
Storage Engines
About FederatedX
About MariaDB ColumnStore
About Mroonga
About MyRocks for MariaDB
About PBXT
About SphinxSE
About XtraDB
Adding DataFlex 3.1c .dat Files As An External Table Type With CONNECT
Analyzing Queries in ColumnStore
Archive
Aria
Aria FAQ
Aria Group Commit
Aria Status Variables
Aria Storage Engine
Aria Storage Formats
Aria System Variables
Aria Two-step Deadlock Detection
aria_s3_copy
AUTO_INCREMENT Handling in InnoDB
Backup and Restore for MariaDB ColumnStore 1.0.x
Backup and Restore for MariaDB ColumnStore 1.1.0 onwards
BDB
Binary Log Group Commit and InnoDB Flushing Performance
BLACKHOLE
Building Cassandra Storage Engine
Building Cassandra Storage Engine for Packaging
Building ColumnStore in MariaDB
Building MyRocks in MariaDB
Building OQGRAPH Under Windows
Building PBXT
Can't create a table starting with a capital letter. All tables are lower case-
Cassandra Status Variables
Cassandra Storage Engine
Cassandra Storage Engine Future Plans
Cassandra Storage Engine Issues
Cassandra Storage Engine Overview
Cassandra Storage Engine Use Example
Cassandra System Variables
Certified S3 Object Storage Providers
Checking and Repairing CSV Tables
Choosing the Right Storage Engine
ColumnStore Administrative Console
ColumnStore Alter Table
ColumnStore Alter View
ColumnStore Architectural Overview
ColumnStore Architecture
ColumnStore Audit Plugin
ColumnStore Batch Insert Mode
ColumnStore Bulk Data Loading
ColumnStore Bulk Write SDK
ColumnStore Commit
ColumnStore Compression Mode
ColumnStore Conditions
ColumnStore Configuration File Update and Distribution
ColumnStore Create Procedure
ColumnStore Create Table
ColumnStore Create View
ColumnStore Data Definition Statements
ColumnStore Data Ingestion
ColumnStore Data Manipulation Statements
ColumnStore Data Types
ColumnStore Database User Management
ColumnStore Decimal Math and Scale
ColumnStore Delete
ColumnStore Disk-Based Joins
ColumnStore Distributed Aggregate Functions
ColumnStore Distributed Functions
ColumnStore Drop Procedure
ColumnStore Drop Table
ColumnStore Getting Started
ColumnStore Information Functions
ColumnStore Information Schema Tables
ColumnStore Insert
ColumnStore LOAD DATA INFILE
ColumnStore Minimum Hardware Specification
ColumnStore Multiple User Module Guide
ColumnStore Naming Conventions
ColumnStore Non-Distributed Post-Processed Functions
ColumnStore Operating Mode
ColumnStore Partition Management
ColumnStore Performance Module
ColumnStore Performance Tuning
ColumnStore Query Processing
ColumnStore Redistribute Data
ColumnStore remote bulk data import: mcsimport
ColumnStore Rename Table
ColumnStore Rollback
ColumnStore Security Vulnerabilities
ColumnStore Select
ColumnStore SQL Structure and Commands
ColumnStore Storage Architecture
ColumnStore Streaming Data Adapters
ColumnStore System Databases
ColumnStore System Monitoring Configuration
ColumnStore System Operations
ColumnStore System Variables
ColumnStore Troubleshooting
ColumnStore Update
ColumnStore Upgrade Guides
ColumnStore User Defined Aggregate and Window Functions
ColumnStore User Defined Functions
ColumnStore User Module
ColumnStore Utility Functions
ColumnStore Window Functions
Compiling OQGRAPH
Configuring ColumnStore Cross-Engine Joins
Configuring ColumnStore Local PM Query Mode
Configuring Sphinx
CONNECT
CONNECT - Adding the REST Feature as a Library Called by an OEM Table
CONNECT - Compiling JSON UDFs in a Separate Library
CONNECT - External Table Types
CONNECT - Files Retrieved Using Rest Queries
CONNECT - Making the GetRest Library
CONNECT - NoSQL Table Types
CONNECT - OEM Table Example
CONNECT - Security
CONNECT - Using the TBL and MYSQL Table Types Together
CONNECT BIN Table Type
CONNECT CSV and FMT Table Types
CONNECT Data Types
CONNECT DBF Table Type
CONNECT DOS and FIX Table Types
CONNECT engine windows
CONNECT INI Table Type
CONNECT JDBC Table Type: Accessing Tables from Another DBMS
CONNECT JSON Table Type
CONNECT MONGO Table Type: Accessing Collections from MongoDB
CONNECT MYSQL Table Type: Accessing MySQL/MariaDB Tables
CONNECT OCCUR Table Type
CONNECT ODBC Table Type: Accessing Tables From Another DBMS
CONNECT PIVOT Table Type
CONNECT PROXY Table Type
CONNECT System Variables
CONNECT Table Types
CONNECT Table Types - Catalog Tables
CONNECT Table Types - Data Files
CONNECT Table Types - OEM: Implemented in an External LIB
CONNECT Table Types - Special "Virtual" Tables
CONNECT Table Types - VIR
CONNECT Table Types Overview
CONNECT TBL Table Type: Table List
CONNECT VEC Table Type
CONNECT XCOL Table Type
CONNECT XML Table Type
CONNECT Zipped File Tables
Converting Tables from MyISAM to InnoDB
Creating and Dropping CONNECT Tables
Creating Mroonga User-Defined Functions
creating pivot table fails
CSV
CSV Overview
Current Status of the CONNECT Handler
Custom Installation of Multi-Server ColumnStore Cluster
DDL statements that differ for ColumnStore
Differences Between FederatedX and Federated
Differences Between MyRocks Variants
Engine-defined New Table/Field/Index Attributes
EXAMPLE Storage Engine
FEDERATED Storage Engine
FederatedX
File Organization in PBXT
Getting Started with MyRocks
Handling Joins With Cassandra
IBMDB2I Storage Engine
InfiniDB Migration to ColumnStore
Information Schema SPIDER_WRAPPER_PROTOCOLS Table
InnoDB
InnoDB Buffer Pool
InnoDB Change Buffering
InnoDB COMPACT Row Format
InnoDB COMPRESSED Row Format
InnoDB Data Dictionary Troubleshooting
InnoDB Data Scrubbing
InnoDB Doublewrite Buffer
InnoDB DYNAMIC Row Format
InnoDB File Format
InnoDB File-Per-Table Tablespaces
InnoDB Limitations
InnoDB Lock Modes
InnoDB Monitors
InnoDB Online DDL
InnoDB Online DDL Operations with the INPLACE Alter Algorithm
InnoDB Online DDL Operations with the INSTANT Alter Algorithm
InnoDB Online DDL Operations with the NOCOPY Alter Algorithm
InnoDB Online DDL Overview
InnoDB Page Compression
InnoDB Page Flushing
InnoDB Purge
InnoDB Recovery Modes
InnoDB Redo Log
InnoDB REDUNDANT Row Format
InnoDB Row Formats
InnoDB Row Formats Overview
InnoDB Strict Mode
InnoDB System Tablespaces
InnoDB System Variables
InnoDB Tablespaces
InnoDB Temporary Tablespaces
InnoDB Troubleshooting
InnoDB Troubleshooting Overview
InnoDB Undo Log
InnoDB Versions
Installing and Configuring a ColumnStore System using the Amazon AMI
Installing and Configuring a ColumnStore System using the Google Cloud
Installing and Configuring a Multi Server ColumnStore System - 1.0.X
Installing and Configuring a Multi Server ColumnStore System - 1.1.X
Installing and Configuring a Multi Server ColumnStore System - 1.2.X
Installing and Configuring a Single Server ColumnStore System
Installing and Configuring a Single Server ColumnStore System - 1.2.x
Installing and Testing SphinxSE with MariaDB
Installing MariaDB AX / MariaDB ColumnStore from the Package Repositories - 1.1.X
Installing MariaDB AX / MariaDB ColumnStore from the Package Repositories - 1.2.X
Installing MariaDB ColumnStore 1.4
Installing MariaDB ColumnStore 1.5
Installing MariaDB ColumnStore from the Development Buildbot Package Repositories
Installing MariaDB ColumnStore from the MariaDB Download
Installing OQGRAPH
Installing Sphinx
Installing the CONNECT Storage Engine
Installing TokuDB
Instant ADD COLUMN for InnoDB
Introduction to the CONNECT Engine
Inward and Outward Tables
JSON Sample Files
last_insert_grn_id
Legacy Storage Engines
limit of number of columns
Loading Data Into MyRocks
Machine Learning with MindsDB
Managing ColumnStore
Managing ColumnStore Database Environment
Managing ColumnStore Module Configurations
Managing ColumnStore System
MariaDB ColumnStore
MariaDB ColumnStore 1.0 Upgrades
MariaDB ColumnStore 1.1 Upgrades
MariaDB ColumnStore 1.2 Upgrades
MariaDB ColumnStore 1.4 Upgrades
MariaDB ColumnStore 1.5 Upgrades
MariaDB ColumnStore Backup and Restore
MariaDB ColumnStore Cluster Test Tool
MariaDB ColumnStore Performance Concepts
MariaDB ColumnStore Performance Related Configuration Settings
MariaDB ColumnStore software upgrade 1.0.10 to 1.0.11
MariaDB ColumnStore software upgrade 1.0.11 to 1.0.12
MariaDB ColumnStore software upgrade 1.0.11 to 1.1.0 Beta
MariaDB ColumnStore software upgrade 1.0.12 to 1.0.13
MariaDB ColumnStore software upgrade 1.0.13 to 1.0.14
MariaDB ColumnStore software upgrade 1.0.14 to 1.0.15
MariaDB ColumnStore software upgrade 1.0.15 to 1.0.16
MariaDB ColumnStore software upgrade 1.0.4 to 1.0.6
MariaDB ColumnStore software upgrade 1.0.5 to 1.0.6
MariaDB ColumnStore software upgrade 1.0.6 to 1.0.7
MariaDB ColumnStore software upgrade 1.0.7 to 1.0.8
MariaDB ColumnStore software upgrade 1.0.8 to 1.0.9
MariaDB ColumnStore software upgrade 1.0.9 to 1.0.10
MariaDB ColumnStore software upgrade 1.1.0 Beta to 1.1.1 RC
MariaDB ColumnStore software upgrade 1.1.1 RC to 1.1.2 GA
MariaDB ColumnStore software upgrade 1.1.2 GA to 1.1.3 GA
MariaDB ColumnStore software upgrade 1.1.3 GA to 1.1.4 GA
MariaDB ColumnStore software upgrade 1.1.4 GA to 1.1.5 GA
MariaDB ColumnStore software upgrade 1.1.5 GA to 1.1.6 GA
MariaDB ColumnStore software upgrade 1.1.6 GA to 1.1.7 GA
MariaDB ColumnStore software upgrade 1.1.6 GA to 1.2.0 Alpha
MariaDB ColumnStore software upgrade 1.1.6 GA to 1.2.1 Beta
MariaDB ColumnStore software upgrade 1.1.6 GA to 1.2.2 GA
MariaDB ColumnStore software upgrade 1.1.7 GA to 1.2.3 GA
MariaDB ColumnStore software upgrade 1.1.7 GA to 1.2.4 GA
MariaDB ColumnStore software upgrade 1.1.7 GA to 1.2.5 GA
MariaDB ColumnStore software upgrade 1.2.x GA to 1.2.4 GA
MariaDB ColumnStore software upgrade 1.2.x GA to 1.2.5 GA
MariaDB ColumnStore System Usage
MariaDB ColumnStore with Spark
MEMORY Storage Engine
MERGE
Migrating from InfiniDB 4.x to MariaDB ColumnStore
Mroonga
Mroonga Overview
Mroonga Status Variables
Mroonga System Variables
Mroonga User-Defined Functions
mroonga_command
mroonga_escape
mroonga_highlight_html
mroonga_normalize
mroonga_snippet
mroonga_snippet_html
MyISAM
MyISAM Index Storage Space
MyISAM Overview
MyISAM Storage Formats
MyISAM System Variables
MyRocks
MyRocks and Bloom Filters
MyRocks and CHECK TABLE
MyRocks and Data Compression
MyRocks and Group Commit with Binary log
MyRocks and Index-Only Scans
MyRocks and Replication
MyRocks and START TRANSACTION WITH CONSISTENT SNAPSHOT
MyRocks Column Families
MyRocks in MariaDB 10.2 vs MariaDB 10.3
MyRocks Performance Troubleshooting
MyRocks Status Variables
MyRocks System Variables
MyRocks Transactional Isolation
NDB in MariaDB
Optimizer Statistics in MyRocks
OQGRAPH
OQGRAPH Examples
OQGRAPH Overview
PBXT
PBXT System Variables
PERFORMANCE_SCHEMA Storage Engine
Preparing and Installing MariaDB ColumnStore 1.0.X
Preparing and Installing MariaDB ColumnStore 1.1.x
Preparing and Installing MariaDB ColumnStore 1.2.X
Preparing for ColumnStore Installation - 1.0.X
Preparing for ColumnStore Installation - 1.1.X
Preparing for ColumnStore Installation - 1.2.0
Preparing for ColumnStore Installation - 1.2.1
Preparing for ColumnStore Installation - 1.2.2
Preparing for ColumnStore Installation - 1.2.5
R Statistical Programming Using MariaDB as the Background Database
Running MariaDB ColumnStore Docker containers on Linux, Windows and MacOS
S3 Storage Engine
S3 Storage Engine Internals
S3 Storage Engine Status Variables
S3 Storage Engine System Variables
Sample storagemanager.cnf
Sequence Storage Engine
SphinxSE
Spider
Spider Benchmarks
Spider Case Studies
Spider Cluster Management
Spider Differences Between SpiderForMySQL and MariaDB
Spider FAQ
Spider Feature Matrix
Spider Functions
Spider Installation
Spider Server System Variables
Spider Storage Engine Core Concepts
Spider Storage Engine Overview
Spider Table System Variables
Spider Use Cases
SPIDER_BG_DIRECT_SQL
SPIDER_COPY_TABLES
SPIDER_DIRECT_SQL
SPIDER_FLUSH_TABLE_MON_CACHE
Storage Engine Development
Storage Engine FAQ
Storage Engines
StorageManager
System Troubleshooting MariaDB ColumnStore
Table Discovery
Table Discovery (before 10.0.2)
Testing the Connections to S3
The Aria Name
TokuDB
TokuDB Differences
TokuDB Resources
TokuDB Status Variables
TokuDB System Variables
Troubleshooting Row Size Too Large Errors with InnoDB
Upgrade from InfiniDB 4.x to MariaDB ColumnStore
Upgrading MariaDB ColumnStore from 1.0.1 to 1.0.2
Upgrading MariaDB ColumnStore from 1.0.2 to 1.0.3
Upgrading MariaDB ColumnStore from 1.0.3 to 1.0.4
Upgrading MariaDB ColumnStore from 1.0.4 to 1.0.5
Using CONNECT
Using CONNECT - Condition Pushdown
Using CONNECT - Exporting Data From MariaDB
Using CONNECT - General Information
Using CONNECT - Importing File Data Into MariaDB Tables
Using CONNECT - Indexing
USING CONNECT - Offline Documentation
Using CONNECT - Partitioning and Sharding
Using CONNECT - Virtual and Special Columns
Using InnoDB Instead of XtraDB
Using MariaDB ColumnStore
Using StorageManager With IAM Role
Using the S3 Storage Engine
Virtual Machine to Test the Cassandra Storage Engine
Stored Routines
ALTER PROCEDURE
Binary Logging of Stored Routines
CREATE PROCEDURE
DROP FUNCTION
DROP PROCEDURE
Stored Aggregate Functions
Stored Function Limitations
Stored Function Overview
Stored Functions
Stored Procedure Overview
Stored Procedures
Stored Routine Limitations
Stored Routine Privileges
Stored Routines
String Functions
ASCII
BIN
BINARY Operator
BIT_LENGTH
CAST
CHAR Function
CHAR_LENGTH
CHARACTER_LENGTH
CHR
CONCAT
CONCAT_WS
CONVERT
ELT
EXPORT_SET
EXTRACTVALUE
FIELD
FIND_IN_SET
FORMAT
FROM_BASE64
HEX
INSERT Function
INSTR
LCASE
LEFT
LENGTH
LENGTHB
LIKE
LOAD_FILE
LOCATE
LOWER
LPAD
LTRIM
MAKE_SET
MATCH AGAINST
MID
NATURAL_SORT_KEY
NOT LIKE
NOT REGEXP
OCTET_LENGTH
ORD
Perl Compatible Regular Expressions (PCRE) Documentation
POSITION
QUOTE
REGEXP
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
Regular Expressions Functions
Regular Expressions Overview
REPEAT Function
REPLACE Function
REVERSE
RIGHT
RLIKE
RPAD
RTRIM
SFORMAT
SOUNDEX
SOUNDS LIKE
SPACE
STRCMP
String Functions
SUBSTR
SUBSTRING
SUBSTRING_INDEX
TO_BASE64
TO_CHAR
TRIM
TRIM_ORACLE
Type Conversion
UCASE
UNHEX
UPDATEXML
UPPER
WEIGHT_STRING
Temporal Tables
Application-Time Periods
Bitemporal Tables
System-Versioned Tables
Temporal Tables
Triggers & Events
ALTER EVENT
CREATE TRIGGER
Event Limitations
Event Scheduler
Events Overview
Trigger Limitations
Trigger Overview
Triggers
Triggers & Events
Triggers and Implicit Locks
User & Server Security
Account Locking
Amazon Web Services (AWS) Key Management Service (KMS) Encryption Plugin Advanced Usage
Amazon Web Services (AWS) Key Management Service (KMS) Encryption Plugin Setup Guide
Aria Disabling Encryption
Aria Enabling Encryption
Aria Encryption
Aria Encryption Keys
Aria Encryption Overview
Authentication from MariaDB 10.4
AWS Key Management Encryption Plugin
Certificate Creation with OpenSSL
Data-at-Rest Encryption
Data-at-Rest Encryption Overview
Data-in-Transit Encryption
Disabling InnoDB Encryption
Enabling InnoDB Encryption
Encrypting Binary Logs
Encryption
Encryption Key Management
Eperi Key Management Encryption Plugin
File Key Management Encryption Plugin
InnoDB Background Encryption Threads
InnoDB Encryption
InnoDB Encryption Keys
InnoDB Encryption Overview
InnoDB Encryption Troubleshooting
Key Management and Encryption Plugins
Replication with Secure Connections
Roles
Roles Overview
Running mysqld as root
Secure Connections Overview
SecuRich
Securing Communications in Galera Cluster
Securing Connections for Client and Server
Securing MariaDB
Security-Enhanced Linux with MariaDB
SSL/TLS System Variables
TLS and Cryptography Libraries Used by MariaDB
User & Server Security
User Account Management
User Password Expiry
Using TLSv1.3
Why Encrypt MariaDB Data?
User-Defined Functions
CREATE FUNCTION UDF
Creating User-Defined Functions
DROP FUNCTION UDF
User-Defined Functions
User-Defined Functions Calling Sequences
User-Defined Functions Security
Variables and Modes
Full List of MariaDB Options, System and Status Variables
OLD_MODE
SQL_MODE
Variables and Modes
Views
ALTER VIEW
CREATE VIEW
DROP VIEW
Information Schema VIEWS Table
Inserting and Updating with Views
View Algorithms
Views
xtstat
xtstat
中文
English
A
A
Serif
Sans
White
Sepia
Night
首页
API Docs
工具
首页
API Docs
工具
mariadb
/
10.6.4
/
library
/
Files
File Name
backup-and-restore-for-mariadb-columnstore-110-onwards/
installing-and-configuring-a-multi-server-columnstore-system-11x/
preparing-for-columnstore-installation/
using-mariadb-replication-with-mariadb-galera-cluster-using-mariadb-replica/
Name
MariaDB
Version
10.6.4
Badge
Last Updated
2021-09-23T06:42:03Z