Percona Server 5.7.20-18

Milestone information

Project:
Percona Server
Series:
5.7
Version:
5.7.20-18
Released:
2017-12-14  
Registrant:
Hrvoje Matijakovic
Release registered:
2017-12-14
Active:
No. Drivers cannot target bugs and blueprints to this milestone.  

Download RDF metadata

Activities

Assigned to you:
No blueprints or bugs assigned to you.
Assignees:
2 EvgeniyPatlan, 1 George Ormond Lorch III, 3 Laurynas Biveinis, 2 Robert Golebiowski, 1 Sergei Glushchenko, 5 Yura Sorokin, 1 Zsolt Parragi
Blueprints:
7 Implemented
Bugs:
10 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features
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.
Bugs Fixed
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 MEMORY tables 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 source row_format on target TokuDB table. Bug fixed #76.
TokuDB would encode already encoded database name for a directory name. Bug fixed #74.
Other bugs fixed: #1720810, #83, #80, and #75.
MyRocks Changes
RocksDB has implemented a FlushWAL API which improves upon the performance of MySQL 2-phase-commit during binary log group commit flush stage. This feature adds support for using the FlushWAL API in MyRocks and also matches rocksdb_flush_log_at_trx_commit variable with innodb_flush_log_at_trx_commit behavior. Two implement this feature rocksdb_manual_wal_flush and rocksdb_concurrent_prepare variables have been implemented.
New rocksdb_force_compute_memtable_stats_cachetime variable has been implemented that cane be used to specify how long the cached value of memtable statistics should be used instead of computing it every time during the query plan analysis.
New rocksdb_large_prefix variable has been implemented which, when enabled, allows index key prefixes longer than 767 bytes (up to 3072 bytes). This option mirrors the innodb_large_prefix The values for this variable should be the same between master and slave.
New rocksdb_max_background_jobs variable has been implemented to replace rocksdb_base_background_compactions, rocksdb_max_background_compactions, and rocksdb_max_background_flushes variables. This variable specifies the maximum number of background jobs. It automatically decides how many threads to allocate towards flush/compaction. It was implemented to reduce the number of (confusing) options users and can tweak and push the responsibility down to RocksDB level.
New rocksdb_sim_cache_size variable has been implemented to enable the simulated cache. This can be used to figure out the hit/miss rate with a specific cache size without changing the real block cache.
Input can be now sorted by the Primary Key during the bulkload by enababling the rocksdb_bulk_load_allow_unsorted variable.
New rocksdb_ignore_unknown_options variable has been implemented, which when enabled (default) allows RocksDB to receive unknown options and not exit.

7 blueprints and 10 bugs targeted

Blueprint Priority Assignee Delivery
Merge MySQL 5.7.20 Merge MySQL 5.7.20 5 Essential Yura Sorokin  11 Implemented
A new InnoDB variable to control whether InnoDB FTS should ignore stopword list A new InnoDB variable to control whether InnoDB FTS should ignore stopword list 4 High Yura Sorokin  11 Implemented
Encrypted general tablespaces Encrypted general tablespaces 4 High Sergei Glushchenko  11 Implemented
InnoDB page fragmentation counters (5.7) InnoDB page fragmentation counters (5.7) 4 High Yura Sorokin  11 Implemented
Make 5.7 RelWithDebInfo build type define NDEBUG Make 5.7 RelWithDebInfo build type define NDEBUG 4 High George Ormond Lorch III  11 Implemented
Merge AIO page read requests (5.7) Merge AIO page read requests (5.7) 4 High Yura Sorokin  11 Implemented
keyring_vault keyring_vault 4 High Robert Golebiowski  11 Implemented
Bug report Importance Assignee Status
1524948 #1524948 If client killed after ROLLBACK TO SAVEPOINT previous stmts committed 3 High   10 Fix Released
1670902 #1670902 Replication regression with RBR and partitioned tables 3 High   10 Fix Released
1699241 #1699241 percona server 5.7 docker images do not include tokudb 3 High EvgeniyPatlan  10 Fix Released
1702330 #1702330 thread_group_close does not unlock mutex in error branches 3 High Zsolt Parragi  10 Fix Released
1720810 #1720810 after installation PS fails to run keyring_vault test suite 3 High Robert Golebiowski  10 Fix Released
1731483 #1731483 MEMORY storage engine incorrectly allows BLOB columns before indexed columns 3 High Laurynas Biveinis  10 Fix Released
1679135 #1679135 Ignore INNODB_FT_DEFAULT_STOPWORD for ngram indexes 4 Medium Yura Sorokin  10 Fix Released
1711781 #1711781 Redundant GTID unsafe mark for CREATE/DROP TEMPORARY TABLE in RBR/MBR 4 Medium Laurynas Biveinis  10 Fix Released
1704195 #1704195 Release lock on table statistics after query plan created | Stop ANALYZE TABLE from flushing table definition cache 6 Wishlist Laurynas Biveinis  10 Fix Released
1682419 #1682419 ps_tokudb_admin emits "This script must be run as root" 1 Undecided EvgeniyPatlan  10 Fix Released
This milestone contains Public information
Everyone can see this information.