MariaDB 10.4.1 发布，流行的 MySQL 分支版本

MariaDB 10.4.1 已发布，更新内容如下：

Syntax

• New FLUSH SSL command to reload SSL certificates without server restart ( MDEV-16266 )

• New CAST target —  CAST(x AS INTERVAL DAY_SECOND(N)) ( MDEV-17776 )

Variables

• New sql-mode setting,  TIME_ROUND_FRACTIONAL ( MDEV-16991 )

• Two new values for the variable use_stat_tables :  COMPLEMENTARY_FOR_QUERIES and  PREFERABLY_FOR_QUERIES ( MDEV-17255 )

• Engine Independent Table Statistics is now enabled by default; new default values are  use_stat_tables=PREFERABLY_FOR_QUERIES and  optimizer_use_condition_selectivity=4 ( MDEV-15253 )

• New variable gtid_cleanup_batch_size for determining how many old rows must accumulate in the  mysql.gtid_slave_pos table before a background job will be run to delete them.

Other Features

• Support for window UDF functions via the new method  x_remove ( MDEV-15073 )

• Json service for plugins ( MDEV-5313 )

• Much faster privilege checks for MariaDB setups with many user accounts or many database grants ( MDEV-15649 )

• mysql.user table is retired. User accounts and global privileges are now stored in the  mysql.global_priv table ( MDEV-17658 )

• Change in behavior for FLUSH TABLES ( MDEV-5336 ).

Bug Fixes

Lots of miscellaneous fixes, including:

• Bug fixes for MDEV-15562 instant  DROP COLUMN

MariaDB 主要由开源社区在维护，采用 GPL 授权许可。MariaDB 的目的是完全兼容 MySQL，包括 API 和命令行。

下载地址：

• https://mariadb.com/downloads