发布于 2017-07-31 03:20:09 | 146 次阅读 | 评论: 0 | 来源: 网友投递
Percona Server Mysql分支数据库
Percona Server是MySQL的改进版本，使用 XtraDB 存储引擎，在功能和性能上较 MySQL 有着很显著的提升，如提升了在高负载情况下的 InnoDB 的性能，为 DBA 提供了一些非常有用的性能诊断工具，另外有更多的参数和命令来控制服务器行为。
Percona Server for MySQL 5.7.18-16 已发布，该版本基于 MySQL 5.7.18，并包括其中的所有错误修复。
Percona Server for MySQL 5.7.18-16 是 Percona Server for MySQL 5.7 系列中当前的 GA 版本。更新内容：
新特性：
Percona Server for MySQL 现在可在 Debian 9 (stretch) 上使用，不过现在仅支持 amd64 架构的平台
Percona Server for MySQL 现在可以在 OpenSSL 1.1 的支持下构建
MyRocks 存储引擎已合并到 Percona Server
TokuDB 可杀死正在等待 FT locktre 锁的查询
TokuDB enables using the MySQL DEBUG_SYNC facility within Percona FT.
Bug 修复：
Row counts in TokuDB could be lost intermittently after restarts. Bug fixed #2.
In TokuDB, two races in the fractal tree lock manager could significantly affect transactional throughput for some applications that used a small number of concurrent transactions. These races manifested as transactions unnecessarily waiting for an available lock. Bug fixed #3.
Percona FT could assert when opening a dictionary with no useful information to an error log. Bug fixed #23.
Percona FT could assert for various reasons deserializing nodes with no useful error output. Bug fixed #24.
It was not possible to build Percona Server on Debian 9 (stretch) due to issues with OpenSSL 1.1. Bug fixed #1702903 (upstream #83814).
Packaging was using the dpkg --verify command which is not available on wheezy/precise. Bug fixed #1694907.
Enabling and disabling the slow query log rotation spuriously added the version suffix to the next slow query log file name. Bug fixed #1704056.
With two client connections to a server (debug server build), the server could crash after one of the clients set the global option userstat and flushed the client statistics (FLUSH CLIENT_STATISTICS) and then both clients were closed. Bug fixed #1661488.
Percona FT did not pass cmake flags on to snappy cmake. Bug fixed #41. The progress status for partitioned TokuDB table ALTERs was misleading. Bug fixed #42.
When a client application is connecting to the Aurora cluster end point using SSL (--ssl-verify-server-cert or --ssl-mode=VERIFY_IDENTITY option), wildcard and SAN enabled SSL certificates were ignored. Note that the --ssl-verify-server-cert option is deprecated in Percona Server 5.7. Bug fixed #1673656 (upstream #68052).
Killing a stored procedure execution could result in an assert failure on a debug server build. Bug fixed #1689736 (upstream #86260).
The SET STATEMENT .. FOR statement changed the global instead of the session value of a variable if the statement occurred immediately after the SET GLOBAL or SHOW GLOBAL STATUS command. Bug fixed #1385352.
When running SHOW ENGINE INNODB STATUS, the Buffer pool size, bytes entry contained 0. BUg fixed #1586262.
The synchronization between the LRU manager and page cleaner threads was not done at shutdown. Bug fixed #1689552.
Spurious lock_wait_timeout_thread wakeup in lock_wait_suspend_thread() could occur. Bug fixed #1704267 (upstream #72123).
其他 bug 修复：
#1686603, #6, #44, #65, #1160986, #1686934, #1688319, #1689989, #1690012, #1691682, #1697700, #1699788, #1121072, and #1684601 (upstream #86016).