Percona Server with XtraDB

Percona Server 5.6.13-61.0

GA

Milestone information

Project:
Percona Server
Series:
5.6
Version:
5.6.13-61.0
Released:
2013-10-07  
Registrant:
Hrvoje Matijakovic
Release registered:
2013-10-09
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:
3 George Ormond Lorch III, 2 Hrvoje Matijakovic, 4 Ignacio Nin, 31 Laurynas Biveinis, 9 Sergei Glushchenko, 3 Vlad Lesin
Blueprints:
13 Implemented
Bugs:
39 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features

Percona Server has implemented a number of XtraDB Performance Improvements for high-concurrency scenarios.

Percona Server has implemented a number of performance improvements for Page cleaner thread tuning. This feature fixes the upstream bugs: #69170 (#1231918), #70453 (#1232101) and #68481 (#1232406).

ALL_O_DIRECT method for innodb_flush_method has been ported from Percona Server 5.5.

Statement Timeout feature has been ported from the Twitter branch.

Percona Server has extended the SELECT INTO ... OUTFILE and SELECT INTO DUMPFILE to add the support for UNIX sockets and named pipes.

Bugs Fixed

Due to an incompatible upstream change that went in unnoticed, the page cleaner thread would attempt to replay any file operations it encountered. In most cases this were a no-op, but there were race conditions for certain DDL operations that would have resulted in server crash. Bug fixed #1217002.

apt-get upgrade of Percona Server would fail in post-installation step if server failed to start. Bug fixed #1002500.

Percona Server 5.6 now ships with memcached plugins. Bug fixed #1159621.

Fixed the libssl.so.6 dependency issues in binary tarballs releases. Bug fixed #1172916.

Error in install_layout.cmake could cause that some library files, during the build, end up in different directories on x86_64 environment. Bug fixed #1174300.

Server would crash if empty string was passed to AES_ENCRYPT when older OpenSSL version was used. Upstream bug fixed #70489, bug fixed #1201033.

Kill Idle Transactions feature didn’t work correctly if Thread Pool was enabled. Bug fixed #1201440.

Percona Server 5.6.12-60.4 would crash if server was started with Thread Pool feature enabled. Bugs fixed #1201681, #1194097 and #1201442.

Memory leak was introduced by the fix for bug #1132194. Bug fixed #1204873.

A server could have crashed under a heavy I/O-bound workload involving compressed InnoDB tables. Bug fixed #1224432.

A potential deadlock, involving DDL, SELECT, SHOW ENGINE INNODB STATUS, and KILL, has been fixed. Fixed the upstream bug #60682, bug fixed #1115048.

A memory leak in Utility user feature has been fixed. Bug fixed #1166638.

A server could crash due to a race condition between a INNODB_CHANGED_PAGES query and bitmap file delete by PURGE CHANGED_PAGE_BITMAP or directly on the file system. Bug fixed #1191580.

Percona Server could not be built with Thread Pool feature and -DWITH_PERFSCHEMA_ENGINE=OFF option. Bug fixed #1196383.

Page cleaner should perform LRU flushing regardless of server activity. Fixed the upstream bug #70500, bug fixed #1234562.

Fixed the upstream bug #64556 which could cause an unrelated warning to be raised if a query inside InnoDB was interrupted. Bug fixed #1115158.

Other bugs fixed: bug fixed #1131949, bug fixed #1191589, bug fixed #1229583, upstream bug fixed #70490 bug fixed #1205196,upstream bug fixed #70417 bug fixed #1230220.

13 blueprints and 39 bugs targeted

Blueprint Priority Assignee Delivery
Add support for UNIX socket and named pipe to SELECT INTO OUTFILE 5.6 4 High Sergei Glushchenko  11 Implemented
Backoff for sync preflushes 4 High Laurynas Biveinis  11 Implemented
Empty free list backoff for XtraDB 4 High Laurynas Biveinis  11 Implemented
LSN age factor tuning for adaptive flushing in 5.6 4 High Laurynas Biveinis  11 Implemented
Page cleaner thread tuning for 5.6 4 High Laurynas Biveinis  11 Implemented
Port innodb_flush_method=ALL_O_DIRECT to 5.6 4 High George Ormond Lorch III  11 Implemented
Priority refill for the buffer pool free list 4 High Laurynas Biveinis  11 Implemented
Relative Thread Scheduling Priorities for XtraDB 4 High Laurynas Biveinis  11 Implemented
Server activity check fixes for page cleaner thread 4 High Laurynas Biveinis  11 Implemented
XtraDB Priority Mutex 4 High Laurynas Biveinis  11 Implemented
XtraDB Priority RW Lock 4 High Laurynas Biveinis  11 Implemented
XtraDB Thread Priority Flag 4 High Laurynas Biveinis  11 Implemented
Port max_statement_time from the Twitter branch 3 Medium Vlad Lesin  11 Implemented
Bug report Importance Assignee Status
1217002 #1217002 RENAME/DROP crashes with innodb_track_changed_pages 2 Critical Laurynas Biveinis  10 Fix Released
1227581 #1227581 InnoDB: Failing assertion: buf_page_in_file(bpage) in file buf0flu.cc line 2674 | abort (sig=6) in buf_pool_get_dirty_pages_count on ALTER TABLE 2 Critical Laurynas Biveinis  10 Fix Released
1235978 #1235978 Purge thread deadlock on shutdown with --innodb_empty_free_list_algorithm=backoff 2 Critical Laurynas Biveinis  10 Fix Released
1002500 #1002500 apt-upgrading percona-server fails in post-installation 3 High Ignacio Nin  10 Fix Released
1131949 #1131949 server won't start when flush_method=ALL_O_DIRECT and track_changed_pages=TRUE 3 High George Ormond Lorch III  10 Fix Released
1159621 #1159621 Missing memcached plugins in 5.6 packages 3 High Ignacio Nin  10 Fix Released
1174300 #1174300 INSTALL_LIBDIR_RPM error in install_layout.cmake 3 High Ignacio Nin  10 Fix Released
1191589 #1191589 mysqld-debug: .../sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed on a INFORMATION_SCHEMA.INNODB_CHANGED_PAGES query. 3 High Laurynas Biveinis  10 Fix Released
1194097 #1194097 Assertion `pfs->m_idle || (state == PSI_SOCKET_STATE_IDLE)' failed when run with thread pool 3 High Sergei Glushchenko  10 Fix Released
1201033 #1201033 Crash when using AES_ENCRYPT on empty string 3 High Sergei Glushchenko  10 Fix Released
1201440 #1201440 percona_innodb_kill_idle_trx failed for Percona Server 5.6 with threadpool 3 High Sergei Glushchenko  10 Fix Released
1201442 #1201442 main.ssl failed on Percona Server 5.6 with threadpool 3 High Sergei Glushchenko  10 Fix Released
1201681 #1201681 Percona server 5.6.12 started with thread_pool hangs on shutdown 3 High Sergei Glushchenko  10 Fix Released
1204873 #1204873 Valgrind: bytes lost in operator new[] | Table_node::Table_node 3 High Sergei Glushchenko  10 Fix Released
1224432 #1224432 Buffer pool watch sentinel page buf_fix_count race condition | InnoDB: Failing assertion: buf_fix_count > 0 in file buf0buf.cc line 3690 | abort (sig=6) in buf_page_init_for_read 3 High Laurynas Biveinis  10 Fix Released
1234513 #1234513 buf_flush_LRU_tail(): incorrect buf_flush_LRU() return value check and srv_cleaner_eviction_factor handling 3 High Laurynas Biveinis  10 Fix Released
1235265 #1235265 Thread scheduling priority and purge heuristics tuning 3 High Laurynas Biveinis  10 Fix Released
1235285 #1235285 Missed wakeup events in priority rw lock 3 High Laurynas Biveinis  10 Fix Released
1115048 #1115048 deadlock from thd_security_context (__lll_mutex_lock_wait) 4 Medium Vlad Lesin  10 Fix Released
1166638 #1166638 Utility user setup leaks memory | Valgrind: still reachable: malloc in acl_init_utility_user & init_dynamic_array2 4 Medium George Ormond Lorch III  10 Fix Released
1191580 #1191580 InnoDB: Failing assertion: bitmap_files->files[0].seq_num == first_file_seq_num in file log0online.cc line 1423 | abort in log_online_setup_bitmap_file_range 4 Medium Laurynas Biveinis  10 Fix Released
1192811 #1192811 Document how to implement periodic buffer pool dumps in 5.6 4 Medium Hrvoje Matijakovic  10 Fix Released
1196383 #1196383 Thread pool breaks -DWITH_PERFSCHEMA_ENGINE=OFF 4 Medium Sergei Glushchenko  10 Fix Released
1225189 #1225189 5.6 installing my.cnf to /usr 4 Medium Ignacio Nin  10 Fix Released
1229583 #1229583 Clarify ALL_O_DIRECT relationship with fsync() 4 Medium Hrvoje Matijakovic  10 Fix Released
1234029 #1234029 buf_flush_LRU_list_batch() accounts flushed pages multiple times 4 Medium Laurynas Biveinis  10 Fix Released
1234562 #1234562 Page cleaner should perform LRU flushing regardless of server activity 4 Medium Laurynas Biveinis  10 Fix Released
1234848 #1234848 sync_array_cell_print() misdirects some output to stderr 4 Medium Laurynas Biveinis  10 Fix Released
1235114 #1235114 LRU flushing timeouts in the cleaner must allow the current pass over buf pool instances to complete 4 Medium Laurynas Biveinis  10 Fix Released
1235379 #1235379 Make use of flush end events in the sync preflush backoff 4 Medium Laurynas Biveinis  10 Fix Released
1235396 #1235396 Convert rseg mutex to priority framework 4 Medium Laurynas Biveinis  10 Fix Released
1115158 #1115158 Interrupting a query inside InnoDB causes an unrelated warning to be raised 5 Low Vlad Lesin  10 Fix Released
1205196 #1205196 Valgrind: 32 bytes in 1 blocks are still reachable in malloc > CRYPTO_malloc > sk_new 5 Low Sergei Glushchenko  10 Fix Released
1235730 #1235730 Sporadic percona_changed_page_bmp testcase warnings 5 Low Laurynas Biveinis  10 Fix Released
1230220 #1230220 rw_lock_x_lock_func_nowait() calls os_thread_get_curr_id() mostly needlessly 6 Wishlist Laurynas Biveinis  10 Fix Released
1231918 #1231918 "buf_flush_LRU is lazy" | buf_flush_common() calls buf_dblwr_flush_buffered_writes() even when no pages flushed 6 Wishlist Laurynas Biveinis  10 Fix Released
1232101 #1232101 Add hard timeouts to page cleaner flushes 6 Wishlist Laurynas Biveinis  10 Fix Released
1232406 #1232406 Implement furious flushing for 5.6 6 Wishlist Laurynas Biveinis  10 Fix Released
1236884 #1236884 thread convoys from log_checkpoint_margin with innodb_buffer_pool_instances > 1 6 Wishlist Laurynas Biveinis  10 Fix Released
This milestone contains Public information
Everyone can see this information.