Files
| File Name |
| Name | MariaDB |
| Version | |
| Badge |
|
| Last Updated | 2021-09-23T06:42:03Z |
Table of Contents
- Aggregate Functions
- Aria Clients and Utilities
-
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
- Built-in Functions
- Clients & Utilities
- Columns, Storage Engines, and Plugins
- Control Flow Functions
- 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
- dbForge Studio for MariaDB
- EXPLAIN Analyzer
- EXPLAIN Analyzer API
- 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
- How to match API version for php5_mysql and mariadb client?
- innochecksum
- 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 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-admin
- mariadb-check
- mariadb-conv
- mariadb-convert-table-format
- mariadb-dumpslow
- mariadb-embedded
- mariadb-find-rows
- mariadb-fix-extensions
- mariadb-install-db
- mariadb-plugin
- mariadb-report
- mariadb-secure-installation
- mariadb-setpermission
- mariadb-show
- mariadb-slap
- mariadb-tzinfo-to-sql
- mariadb-upgrade
- mariadb-waitpid
- msql2mysql
- Multi Master in maria db
- Multi master replication and deadlock detection in Galera with Mariadbs
- my_print_defaults
- MyISAM Clients and Utilities
- mysql Client
- MySQL Sandbox
- mysql-stress-test
- mysql-test
- mysql_convert_table_format
- mysql_embedded
- mysql_find_rows
- mysql_fix_extensions
- mysql_install_db
- mysql_plugin
- mysql_secure_installation
- mysql_setpermission
- mysql_tzinfo_to_sql
- mysql_waitpid
- mysql_zap
- mysqlaccess
- mysqladmin
- mysqlbinlog
- mysqldumpslow
- mysqlreport
- mysqlshow
- 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
-
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
-
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
- Pseudo Columns
- replace Utility
- resolve_stack_dump
- resolveip
- 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
-
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
-
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
- Triggers & Events
-
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
- Variables and Modes
- Views
- xtstat