Changes and Improvements in MariaDB 11.5

MariaDB 11.5 is a current short-term development series.

New Features

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).

Other

• REPAIR TABLE ... FORCE (MDEV-33449)
• Deprecate and ignore @@alter_algorithm system variable (MDEV-33655)
• New USERS table in the Information Schema (MDEV-23729)
• Add more columns to TABLE_STATISTICS and USER STATS (MDEV-33151)
• Add QUERIES to INDEX_STATISTICS (MDEV-33152)
• Additional features for Sequences (MDEV-28152)
• Add FLUSH GLOBAL STATUS (MDEV-33145)
• Index condition pushdown on partitioned tables (MDEV-12404)
• ANALYZE for statement should show selectivity of pushed index condition (MDEV-18478)
• Provide InnoDB async IO statistics (MDEV-32841)
• Change default Unicode collation to uca1400_ai_ci (MDEV-25829)
• Show var deprecation for mariadbd --help output (MDEV-28671)
• New --dir option for mariadb-dump (MDEV-33625)
• Permit bulk implementation to return ALL individual results (MDEV-30366)
• Send initial values of system variables in first OK packet (MDEV-31609)
• Extend query_response_time plugin to be compatible with Percona server (MDEV-33501)
• New variable, slow_query_log_always_write_time (MDEV-33144)
• Deprecate spider_casual_read (MDEV-31789)

Variables

• For a list of all new variables, see System Variables Added in MariaDB 11.5.

List of All MariaDB 11.5 Releases