MySQL/MariaDB 11.4 Hosting Available Now!
-
Saturday, 11th October, 2025
-
00:00am
MariaDB 11.4 is a long-term support (LTS) release that introduces a new cost-based optimizer for improved query performance, along with enhanced security features like default SSL encryption and a more fine-grained privilege system. Other key additions include improved JSON function support, streamlined InnoDB tablespace management, and online schema change capabilities.
Performance and optimization
- New cost-based optimizer: A new cost model is implemented to better calculate the most efficient way to execute queries, taking into account factors like SSDs and storage engine characteristics.
- Online Schema Change: Supports online schema changes for replication topologies.
- Optimistic ALTER TABLE: Includes support for optimistic ALTER TABLE for replication topologies.
Security
- Default SSL/TLS encryption: All client-server connections are encrypted by default, removing the need for complex certificate setup.
- Fine-grained privileges: Moves away from the overly broad SUPER privilege to a more granular system.
- READ ONLY ADMIN privilege: A new READ ONLY ADMIN privilege is added, which is required to write to read-only replicas.
- Password reuse check: A new plugin enforces a check to prevent the reuse of old passwords.
Other improvements
- InnoDB: Features more streamlined tablespace management.
- JSON functions: Has expanded support for JSON functions.
- Partitioning: The ALTER TABLE ... EXCHANGE PARTITION and ALTER TABLE ... CONVERT TABLE ... TO statements now support WITH VALIDATION and WITHOUT VALIDATION clauses.
- Sys Schema: Includes improvements related to the sys schema, providing more metadata about the database.
