The MariaDB Foundation has announced the availability of MariaDB 11.5.1 release candidate and MariaDB 11.4.2 generally available release.

MariaDB 11.5.1 adds various new features, such as limiting the amount of produced disk temporary files and tables, expanding the TIMESTAMP range of values, improving index conditions, allowing bulk implementation, and observability. The new users table in the Information Schema stores user information, password expiration dates, and maximum password errors. Tables now contain additional fields such as TABLE_STATISTICS, CLIENT_STATISTICS, and USER STATISTICS. The Query Response Time plugin has been extended to work with Percona servers. Sequences now have more features, including the ability to create sequences of any INT type and parse larger and smaller values for MINVALUE and MAXVALUE.

MariaDB 11.4.2, 11.5.1 now available

The MariaDB Foundation is pleased to announce the availability of  MariaDB 11.5.1, a Release Candidate (RC) in the  rolling release, and  MariaDB 11.4.2, the first Generally Available (GA) release in the MariaDB 11.4 series. MariaDB 11.4 is a  long-term series, and will be maintained for five years.

See the release notes and changelogs for details.

New Features in 11.5.1

Temporary files and tables

• Limit size of created disk temporary files and tables ( MDEV-9101)
• There are two system variables used for controlling this feature:
  • max_tmp_space_usage: Limits the the temporary space allowance per user
  • max_total_tmp_space_usage: Limits the temporary space allowance for all users.

Data Types

• The  TIMESTAMP range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms ( MDEV-32188).

Optimizer

• Index condition pushdown is now supported for partitioned tables ( MDEV-12404)
• ANALYZE FORMAT=JSON now  shows selectivity of pushed index condition ( MDEV-18478)

Protocol

• Permit bulk implementation to return ALL individual results ( MDEV-30366)
• Send initial values of system variables in first OK packet ( MDEV-31609)

Observability

• New  USERS table in the Information Schema for storing information about users,  password expiry, and the limits set by  max_password_errors ( MDEV-23729,  MDEV-32218)
• Add more columns to Information Schema  TABLE_STATISTICS,  CLIENT_STATISTICS and  USER STATISTICS tables ( MDEV-33151)
• Add QUERIES column to Information Schema  INDEX_STATISTICS table ( MDEV-33152)
• Add  FLUSH GLOBAL STATUS ( MDEV-33145)
• Provide InnoDB async IO statistics ( MDEV-32841)
• Show variable deprecation for  mariadbd --help output ( MDEV-28671)
• Extend  Query Response Time plugin to be compatible with Percona server ( MDEV-33501)

Sequences

• Additional features for Sequences ( MDEV-28152)
  • CREATE SEQUENCE ... AS permits creating as any  INT type (including  BIGINT UNSIGNED), extending the range
  • Information Schema Sequences table
  • Parser accepts larger and smaller values for  MINVALUE and  MAXVALUE

Other

• REPAIR TABLE ... FORCE ( MDEV-33449)
• Deprecate and ignore the  alter_algorithm system variable ( MDEV-33655)
• Change default Unicode collation to uca1400_ai_ci ( MDEV-25829)
• Parallel dump of multiple databases via  mariadb-dump with the --dir option ( MDEV-33625)
• Deprecate  spider_casual_read ( MDEV-31789)

Changelog

For a complete list of changes made in  MariaDB 11.5.1, with links to detailed information on each push, see the  changelog.

MariaDB 11.4.2, 11.5.1 now available