发布于 2017-03-26 00:51:46 | 133 次阅读 | 评论: 0 | 来源: 网友投递
Percona Server Mysql分支数据库
Percona Server是MySQL的改进版本，使用 XtraDB 存储引擎，在功能和性能上较 MySQL 有着很显著的提升，如提升了在高负载情况下的 InnoDB 的性能，为 DBA 提供了一些非常有用的性能诊断工具，另外有更多的参数和命令来控制服务器行为。
Percona Server for MySQL 5.7.17-12 发布了，Percona Server for MySQL 5.7.17-12 基于MySQL 5.7.17，包括其中的所有错误修复，该版本现在是 5.7系列中的稳定版本。更新内容如下：
新特性：
Percona Server has implemented new mysqldump --order-by-primary-desc option. This feature tells mysqldump to take the backup by descending primary key order (PRIMARY KEY DESC) which can be useful if storage engine is using reverse order column family for a primary key.
mysqldump will now detect when MyRocks is installed and available by seeing if there is a session variable named rocksdb_skip_fill_cache and setting it to 1 if it exists.
mysqldump will now automatically enable session variable rocksdb_bulk_load if it is supported by the target server.
Bugs 修复：
If the variable thread_handling was set to pool-of-threads in the MySQL configuration file, the server couldn’t be gracefully shut down. Bug fixed #1537554.
When innodb_ft_result_cache_limit was exceeded by internal memory allocated by InnoDB during the FT scan not all memory was released which could lead to server assertion. Bug fixed #1634932 (upstream #83648).
Executing the FLUSH LOGS on a read-only slave with a user that doesn’t have the SUPER privilege would result in Error 1290. Bug fixed #1652852 (upstream #84350).
FLUSH LOGS was disabled with read_only and super_read_only variables. Bug fixed #1654682(upstream #84437).
If SHOW BINLOGS or PERFORMANCE_SCHEMA.GLOBAL_STATUS query, and a transaction commit would run in parallel, they could deadlock. Bug fixed #1657128.
A long-running binary log commit would block SHOW STATUS, which in turn could block a number of other operations such as client connects and disconnects. Bug fixed #1646100.
Log tracking initialization did not find last valid bitmap data correctly. Bug fixed #1658055.
A query using range scan with a complex range condition could lead to a server crash. Bug fixed #1660591(upstream #84736).
Race condition between buffer pool page optimistic access and eviction could lead to a server crash. Bug fixed #1664280.
If Audit Log Plugin was unable to create file pointed by audit_log_file, the server would crash during the startup. Bug fixed #1666496.
A DROP TEMPORARY TABLE ... for a table created by a CREATE TEMPORARY TABLE ... SELECT ... would get logged in the binary log on a disconnect with mixed mode replication. Bug fixed #1671013.
TokuDB did not use an index with even if cardinality was good. Bug fixed #1671152.
Row-based replication events were not reflected in Rows_updated fields in the User StatisticsINFORMATION_SCHEMA tables. Bug fixed #995624.
When DuplicateWeedout strategy was used for joins, use was not reported in the query plan info output extension for the slow query log. Bug fixed #1592694.
It was impossible to use column compression dictionaries with partitioned InnoDB tables. Bug fixed #1653104.
Diagnostics for OpenSSL errors have been improved. Bug fixed #1660339 (upstream #75311).
其他 bug 修复： #1665545, #1650321, #1654501, #1663251, #1659548, #1663452, #1670834, #1672871, #1626545, #1658006, #1658021, #1659218, #1659746, #1660239, #1660243, #1660348, #1662163 (upstream #81467), #1664219, #1664473, #1671076, 和 #1671123.