Percona Server for MySQL 5.7.17-12 (2017-03-24)¶
Percona is glad to announce the GA (Generally Available) release of Percona Server for MySQL 5.7.17-12 on March 24th, 2017 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.7.17, including all the bug fixes in it, Percona Server for MySQL 5.7.17-12 is the current GA release in the Percona Server for MySQL 5.7 series. All of Percona’s software is open-source and free, all the details of the release can be found in the 5.7.17-12 milestone at Launchpad
New Features¶
Percona Server for MySQL 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 the storage engine is using a 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.
Now mysqldump automatically enables the session variable rocksdb_bulk_load if it is supported by the target server.
Bugs Fixed¶
If the variable thread_handling was set to pool-of-threads in
the MySQL configuration file, the server couldn’t be gracefully shut down by a
SIGTERM signal. 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 the last valid bitmap data correctly. Bug fixed #1658055.
A query using a 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 a 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 index with even if cardinality was good. Bug fixed #1671152.
Row-based replication events were not reflected in Rows_updated fields in
the User Statistics INFORMATION_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).
Other bugs fixed: #1665545, #1650321, #1654501, #1663251, #1659548, #1663452, #1670834, #1672871, #1626545, #1658006, #1658021, #1659218, #1659746, #1660239, #1660243, #1660348, #1662163 (upstream #81467), #1664219, #1664473, #1671076, and #1671123.