Percona Server for MySQL 5.7.20-18 发布

发布于 2017-12-15 03:57:06 | 210 次阅读 | 评论: 0 | 来源: 网友投递

Percona Server是MySQL的改进版本，使用 XtraDB 存储引擎，在功能和性能上较 MySQL 有着很显著的提升，如提升了在高负载情况下的 InnoDB 的性能，为 DBA 提供了一些非常有用的性能诊断工具，另外有更多的参数和命令来控制服务器行为。

Percona Server for MySQL 5.7.20-18 已发布。

Percona Server for MySQL 5.7.20-18 基于 MySQL 5.7.20，包含其中所有的错误修复。Percona Server for MySQL 5.7.20-18 是 Percona Server for MySQL 5.7 系列中的最新版本。更新如下：

新特性

Percona Server packages are now available for Ubuntu 17.10 (Artful).
As part of InnoDB Full-Text Search improvements, a new innodb_ft_ignore_stopwords variable has been implemented which controls whether InnoDB Full-Text Search should ignore stopword list when building/updating an FTS index. This feature is also fixing bug #1679135 (upstream #84420).
Percona Server has implemented InnoDB Page Fragmentation Counters.
Percona Server has implemented support for Multiple page asynchronous I/O requests. This feature was ported from a Facebook MySQL patch.
Percona Server has implemented TokuDB integration with PERFORMANCE_SCHEMA.

Bug 修复

Percona Server 5.7 Docker images did not include TokuDB. Bugs fixed #1682419 and #1699241.
If an I/O syscall returned an error during the server shutdown with Thread Pool enabled, a mutex could be left locked. Bug fixed #1702330 (Daniel Black).
Dynamic row format feature to support BLOB/VARCHAR in MEMORY tables requires all the key columns to come before any BLOB columns. This requirement, however, was not enforced, allowing creating MEMORYtables in unsupported column configurations, which then crashed or lose data in usage. Bug fixed #1731483.
After fixing bug #1668602, bug #1539504, and bug #1313901, CREATE/DROP TEMPORARY TABLE statements were forbidden incorrectly in transactional contexts, including function and trigger calls, even when they required no binary logging at all. Bug fixed #1711781.
Running ANALYZE TABLE while a long-running query is accessing the same table in parallel could lead to a situation where new queries on the same table are blocked in a Waiting for table flush state. Fixed by stopping ANALYZE TABLE flushing affected InnoDB and TokuDB tables from the table definition cache. Bug fixed #1704195 (upstream #87065).
CREATE TABLE ... LIKE ... did not use the source row_format on target TokuDB table. Bug fixed #76.
TokuDB would encode already encoded database name for a directory name. Bug fixed #74.

其他 bug 修复：#1720810, #83, #80 和 #75