Percona Server 5.6.15-63.0

Milestone information

Project:
Percona Server
Series:
5.6
Version:
5.6.15-63.0
Released:
2013-12-19  
Registrant:
Hrvoje Matijakovic
Release registered:
2013-12-19
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:
8 Alexey Kopytov, 3 Hrvoje Matijakovic, 10 Laurynas Biveinis, 1 Patryk Pomykalski, 8 Sergei Glushchenko, 2 Vlad Lesin
Blueprints:
7 Implemented
Bugs:
28 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features

Thread Pool high priority scheduling is now enabled by default by changing the default thread_pool_high_prio_tickets value from 0 to 4294967295.

Percona Server now supports Low priority queue throttling. This feature should improve Thread Pool performance under high concurrency in a situation when thread groups are oversubscribed.

Introduced new thread_pool_high_prio_mode to provide more fine-grained control over high priority scheduling either globally or per connection in Thread Pool.

Percona Server has extended mysqlbinlog to provide SSL and compression support.

Percona Server has reduced the performance overhead of the User Statistics feature.

Bugs Fixed

INSTALL PLUGIN statement would crash server if User Statistics were enabled. Bug fixed #1011047.

innodb_log_checksum_algorithm did not have any effect when set from my.cnf or mysqld command line, it would have effect only if set dynamically. Bug fixed #1248505.

Server would crash on shutdown if Atomic write support for Fusion-io devices feature is enabled. Bug fixed #1255628 (Jan Lindström).

Percona Server would crash when data was select from XTRADB_RSEG table when InnoDB system table space was initialized with lower then default number of rollback segments. Bug fixed #1260259.

Certain types of workloads (large result sets, blobs, slow clients) can have longer waits on network I/O (socket reads and writes). Whenever server waits, this should be communicated to the Thread Pool, so it can start new query by either waking a waiting thread or sometimes creating a new one. Ported MariaDB patch MDEV-156, bug fixed #1159743.

mysqldump --innodb-optimize-keys was generating incorrect CREATE TABLE statements for partitioned tables. Bug fixed #1233841.

Fixed errors when server was compiled with -DWITH_LIBWRAP=ON option. Bug fixed #1240442.

If innobase_atomic_writes was used on separate undo files that do not exists would lead to operating system error. Bug fixed #1255638 (Jan Lindström).

Default value for thread_pool_max_threads has been changed from 500 to 100 000 (the maximum supported number of connections), because limiting the total number of threads in the Thread Pool can result in deadlocks and uneven distribution of worker threads between thread groups in case of stalled connections. Bug fixed #1258097.

PURGE CHANGED_PAGE_BITMAPS BEFORE statement would delete the changed page data after the specified LSN and up to the start of the next bitmap file. If this data were to be used for fast incremental backups, its absence would cause Percona XtraBackup to fall back to the full-scan incremental backup mode. Bug fixed #1260035 (Andrew Gaul).

Server performance could degrade under heavy load or it could deadlock on shutdown while performing purge. Bug fixed #1236696.

Server could crash under heavy load if InnoDB compression was used. Bug fixed #1240371.

Redo log checksum mismatches would be diagnosed using the data page checksum algorithm setting instead of redo log checksum algorithm one. Bug fixed #1250148.

Other bugs fixed: bug #1082333, bug #1260945, bug #1248046, bug #1243067, bug #1238563, bug #1258154 (upstream bug #71092), bug #1242748, bug #1239062, bug #1200788, bug #1193319, bug #1240044.

7 blueprints and 28 bugs targeted

Blueprint Priority Assignee Delivery
Merge MySQL 5.6.15 5 Essential Laurynas Biveinis  11 Implemented
Optimize userstat code 4 High Sergei Glushchenko  11 Implemented
ThreadPool: high priority queue mode in PS 5.6 4 High Alexey Kopytov  11 Implemented
ThreadPool: low priority queue throttling in 5.6 4 High Alexey Kopytov  11 Implemented
ThreadPool: make high priority tickets enabled by default in PS 5.6 4 High Alexey Kopytov  11 Implemented
add --compress option to mysqlbinlog for 5.6 3 Medium Vlad Lesin  11 Implemented
Document per-query variables 1 Undefined Hrvoje Matijakovic  11 Implemented
Bug report Importance Assignee Status
1011047 #1011047 mysqld can't startup when a plugin was installed 3 High Sergei Glushchenko  10 Fix Released
1186748 #1186748 Oracle fix for CVE-2012-5611 is incomplete 3 High   10 Fix Released
1193319 #1193319 Failing assertion: ++count < 50 in file log0log.cc line 308 | abort in log_open from mtr_log_reserve_and_write 3 High Sergei Glushchenko  10 Fix Released
1200788 #1200788 InnoDB: Failing assertion: trx_sys->descr_n_used <= (trx_sys->rw_trx_list).count in file trx0trx.cc line 1492 3 High Alexey Kopytov  10 Fix Released
1236696 #1236696 InnoDB: Error: semaphore wait has lasted > 600 seconds. InnoDB: We intentionally crash the server, because it appears to be hung. 2013-10-07 16:29:16 7fc3ebfff700 InnoDB: Assertion failure in thread <nr> in file srv0srv.cc line 2124 (II) 3 High Laurynas Biveinis  10 Fix Released
1239062 #1239062 InnoDB: Error: semaphore wait has lasted > 600 seconds. InnoDB: We intentionally crash the server, because it appears to be hung. InnoDB: Assertion failure in thread <nr> in file srv0srv.cc line 2124. Abort (sig=6) in srv_error_monitor_thread (III) 3 High Laurynas Biveinis  10 Fix Released
1240371 #1240371 Double zip_mutex exit in buf_page_get_gen() 3 High Laurynas Biveinis  10 Fix Released
1242748 #1242748 LOCK_thd_data and MYSQL_CALLBACK 3 High Sergei Glushchenko  10 Fix Released
1248505 #1248505 innodb_log_checksum_algorithm has effect only when set dynamically 3 High Alexey Kopytov  10 Fix Released
1255628 #1255628 XtraDB assertion at shutdown if posix_fallocate is used in ut_a(node->n_pending == 0 || node->space->stop_new_ops); 3 High Laurynas Biveinis  10 Fix Released
1258154 #1258154 InnoDB FTS introduced new mutex sync level in 5.6.15, broke UNIV_SYNC_DEBUG 3 High Laurynas Biveinis  10 Fix Released
1260259 #1260259 Crash on querying I_S.xtradb_rseg when innodb_rollback_segments/innodb_undo_logs lower then default 3 High Laurynas Biveinis  10 Fix Released
1159743 #1159743 Port MDEV-156. Threadpool - add thd_wait_begin/thd_wait_end to the network IO functions 4 Medium Sergei Glushchenko  10 Fix Released
1197524 #1197524 Support for SSL options not included in mysqlbinlog 4 Medium Vlad Lesin  10 Fix Released
1233841 #1233841 mysqldump --innodb-optimize-keys produces incorrect CREATE TABLE statement for partitioned tables 4 Medium Patryk Pomykalski  10 Fix Released
1238563 #1238563 Describe furious flushing for the page cleaner tuning 4 Medium Hrvoje Matijakovic  10 Fix Released
1240044 #1240044 Redundant wakeups in priority rw_lock_s_unlock_func() 4 Medium Laurynas Biveinis  10 Fix Released
1240442 #1240442 Compilation error with -DWITH_LIBWRAP=ON 4 Medium Sergei Glushchenko  10 Fix Released
1243067 #1243067 [DOC] Misleading title for write-intensive optimizations page in the manual 4 Medium Hrvoje Matijakovic  10 Fix Released
1248046 #1248046 SSL certificate revocation list-related MTR tests fail on some platforms with -DWITH_SSL=system 4 Medium Sergei Glushchenko  10 Fix Released
1250148 #1250148 log_block_checksum_is_ok_or_old_format() uses page not log block checksum algorithm 4 Medium Alexey Kopytov  10 Fix Released
1255638 #1255638 Operating system errors if innobase_atomic_writes are used on separate undo files that do not exists 4 Medium Laurynas Biveinis  10 Fix Released
1258097 #1258097 Inadequate default for thread_pool_max_threads 4 Medium Alexey Kopytov  10 Fix Released
1260035 #1260035 PURGE CHANGED_PAGE_BITMAPS BEFORE purges too many bitmap files 4 Medium Laurynas Biveinis  10 Fix Released
1260945 #1260945 Inconsistency in scripts file in the tree 4 Medium   10 Fix Released
1082333 #1082333 Dead code in extended user statistics 5 Low Sergei Glushchenko  10 Fix Released
1203050 #1203050 Sort aborted with no proper information 5 Low   10 Fix Released
1166271 #1166271 Make thread_pool_high_prio_tickets a session variable 6 Wishlist Alexey Kopytov  10 Fix Released
This milestone contains Public information
Everyone can see this information.