# Percona Server for MySQL 5.6.40-84.0 Is Now Available **URL:** \ **Category:** Percona Server for MySQL 5.6\ **Created:** [May 31, 2018, 4:54am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-6-40-84-0-is-now-available/6391 "2018-05-31T04:54:27Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![hrvojem](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hrvojem/32/6_2.png) [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Post date:** [May 31, 2018, 4:54am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-6-40-84-0-is-now-available/6391/1 "2018-05-31T04:54:27Z")
Percona announces the release of [Percona Server for MySQL](https://www.percona.com/software/percona-server) 5.6.40-84.0 on May 30, 2018 (downloads are available [here](https://www.percona.com/downloads/Percona-Server-5.6/) and from the [Percona Software Repositories](https://www.percona.com/doc/percona-server/5.6/installation.html#installing-from-binaries)). Based on [MySQL 5.6.40](http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-40.html), including all the bug fixes in it, Percona Server for MySQL 5.6.40-84.0 is now the current GA release in the 5.6 series. All of Percona’s software is open-source and free. New Features [LIST] [_]A new string variable version\_suffix allows to change suffix for the Percona Server version string returned by the read-only version variable. This allows to append the version number for the server with a custom suffix to reflect some build or configuration specifics. Also version\_comment (default value of which is taken from the CMake COMPILATION\_COMMENT option) is converted from a global read-only to a global read-write variable and thereby it is now cutomizable. [_]Query response time plugin now can be disabled at session level with use of a new variable query\_response\_time\_session\_stats. [/LIST]Bugs Fixed [LIST] [_]Compilation warning was fixed for -DWITH\_QUERY\_RESPONSE\_TIME=ON CMake compilation option, which makes QRT to be linked statically. Bug fixed [#3841](https://jira.percona.com/browse/PS-3841). [_]A code clean-up was done to fix clang 6 specific compilation warnings and errors (bug fixed [#3893](https://jira.percona.com/browse/PS-3893), upstream [#90111](http://bugs.mysql.com/bug.php?id=90111)). [_]Using -DWITHOUT\_=ON CMake variable to exclude a plugin from the build didn’t work for some plugins, including a number of storage engines. Bug fixed [#3901](https://jira.percona.com/browse/PS-3901). [_]A clean-up in Percona Server binlog-related code was made to avoid uninitialized memory comparison. Bug fixed [#3925](https://jira.percona.com/browse/PS-3925) (upstream [#90238](http://bugs.mysql.com/bug.php?id=90238)). [_]Temporary file I/O was not instrumented for Performance Schema. Bug fixed [#3937](https://jira.percona.com/browse/PS-3937) (upstream [#90264](http://bugs.mysql.com/bug.php?id=90264)). [_]A key\_block\_size value was set automatically by the Improved MEMORY Storage Engine, which resulted in warnings when changing the engine type to InnoDB, and constantly growing key\_block\_size during alter operations. Bugs fixed [#3936](https://jira.percona.com/browse/PS-3936), [#3940](https://jira.percona.com/browse/PS-3940), and [#3943](https://jira.percona.com/browse/PS-3943). [_]Percona Server Debian packages description included reference to /etc/mysql/my.cnf file, which is not actually present in these packages. Bug fixed [#2046](https://jira.percona.com/browse/PS-2046). [_]Fixes were introduced to remove GCC 8 compilation warnings for the Percona Server build, retaining compatibility with old compiler versions, including GCC 4.4. Bugs fixed [#3950](https://jira.percona.com/browse/PS-3950) and [#4471](https://jira.percona.com/browse/PS-4471). [_]A typo in plugin.cmake file prevented to compile plugins statically into the server. Bug fixed [#3871](https://jira.percona.com/browse/PS-3871) (upstream [#89766](http://bugs.mysql.com/bug.php?id=89766)). [_]-DWITH\_NUMA=ON build option was silently ignored by CMake when NUMA development package was not installed, instead of exiting by error. Bug fixed [#4487](https://jira.percona.com/browse/PS-4487). [_]Variables [innodb\_buffer\_pool\_populate](https://www.percona.com/doc/percona-server/5.6/performance/innodb_numa_support.html#innodb_buffer_pool_populate) and [numa\_interleave](https://www.percona.com/doc/percona-server/5.6/performance/innodb_numa_support.html#numa_interleave) mapped to the upstream [innodb\_numa\_interleave](http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_numa_interleave) variable in [5.6.27-75.0](https://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.27-75.0.html) were reverted to their original implementation due to upstream variant being less effective in memory allocation. Now buffer pool is allocated with MAP\_POPULATE, forcing NUMA interleaved allocation at the buffer pool initialization time. Bug fixed [#3967](https://jira.percona.com/browse/PS-3967). [_]audit\_log\_include\_accounts variable did not take effect if placed in my.cnf configuration file, while still working as intended if set dynamically. Bug fixed [#3867](https://jira.percona.com/browse/PS-3867). [_]Synchronization between between [innodb\_kill\_idle\_transaction](https://www.percona.com/doc/percona-server/5.6/management/innodb_kill_idle_trx.html#innodb_kill_idle_transaction) and [kill\_idle\_transaction](https://www.percona.com/doc/percona-server/5.6/management/innodb_kill_idle_trx.html#kill_idle_transaction) system variables was broken because of the regression in Percona Server 5.6.40-83.2. Bug fixed [#3955](https://jira.percona.com/browse/PS-3955). [_]Executing the SHOW GLOBAL STATUS expression could cause “data drift” on global status variables in case of a query rollback: the variable, being by its nature a counter and allowing only an increase, could return to its previous value. Bug fixed [#3951](https://jira.percona.com/browse/PS-3951) (upstream [#90351](http://bugs.mysql.com/bug.php?id=90351)). [_]ALTER TABLE … COMMENT = … statement caused TokuDB to rebuild the whole table, which is not needed, as only FRM metadata should be changed. The fix was provided as a contribution by [Fungo Wang](https://github.com/fungo). Bugs fixed [#4280](https://jira.percona.com/browse/PS-4280) and [#4292](https://jira.percona.com/browse/PS-4292). [_]A number of Percona Server 8.0 TokuDB fixes have been backported to Percona Server 5.6 in preparation for using MySQL 8.0. Bugs fixed [#4379](https://jira.percona.com/browse/PS-4379), [#4380](https://jira.percona.com/browse/PS-4380), [#4387](https://jira.percona.com/browse/PS-4387), [#4378](https://jira.percona.com/browse/PS-4378), [#4383](https://jira.percona.com/browse/PS-4383), [#4384](https://jira.percona.com/browse/PS-4384), [#4386](https://jira.percona.com/browse/PS-4386), [#4382](https://jira.percona.com/browse/PS-4382), [#4391](https://jira.percona.com/browse/PS-4391), [#4390](https://jira.percona.com/browse/PS-4390), [#4392](https://jira.percona.com/browse/PS-4392), and [#4381](https://jira.percona.com/browse/PS-4381). [/LIST]TokuDB Changes and Fixes [LIST] [_]Two new variables, tokudb\_enable\_fast\_update and tokudb\_enable\_fast\_upsert, were introduced to facilitate the TokuDB fast updates feature, which involves queries optimization to avoid random reads during their execution. Bug fixed [#4365](https://jira.percona.com/browse/PS-4365). [_]A data race was fixed in minicron utility of the PerconaFT, as a contribution by Rik Prohaska. Bug fixed [#4281](https://jira.percona.com/browse/PS-4281). [_]Row count and cardinality decrease to zero took place after long-running REPLACE load, ending up with full table scans for any action. [/LIST]Other Bugs Fixed [LIST] [_][#3818](https://jira.percona.com/browse/PS-3818) “Orphaned file mysql-test/suite/innodb/r/percona\_innodb\_kill\_idle\_trx.result” [_][#3926](https://jira.percona.com/browse/PS-3926) “Potentially truncated bitmap file name in log\_online\_open\_bitmap\_file\_read\_only() (storage/innobase/log/log0online.cc)” [_][#2204](https://jira.percona.com/browse/PS-2204) “Test main.audit\_log\_default\_db is unstable” [_][#3767](https://jira.percona.com/browse/PS-3767) “Fix compilation warnings/errors with clang” [_][#3773](https://jira.percona.com/browse/PS-3773) “Incorrect key file for table frequently for tokudb” [_][#3794](https://jira.percona.com/browse/PS-3794) “MTR test main.percona\_show\_temp\_tables\_stress does not wait for events to start” [_][#3798](https://jira.percona.com/browse/PS-3798) “MTR test innodb.percona\_extended\_innodb\_status fails if InnoDB status contains unquoted special characters” [_][#3887](https://jira.percona.com/browse/PS-3887) “TokuDB does not compile with -DWITH\_PERFSCHEMA\_STORAGE\_ENGINE=OFF” [_][#4388](https://jira.percona.com/browse/PS-4388) “5.7 code still has TOKU\_INCLUDE\_OPTION\_STRUCTS which is a MariaDB specific construct” [_][#4265](https://jira.percona.com/browse/PS-4265) “TDB-114 (Change use of MySQL HASH to unordered\_map) introduces memory leak” [_][#4277](https://jira.percona.com/browse/PS-4277) “memory leaks in TDB-2 and TDB-89 tests” [_][#4276](https://jira.percona.com/browse/PS-4276) “Data race on cache table attributes detected by the thread sanitizer” [_][#4451](https://jira.percona.com/browse/PS-4451) “Implement better compression algo testing” [_][#4469](https://jira.percona.com/browse/PS-4469) “variable use out of scope bug in get\_last\_key test detected by ASAN in clang 6” [_][#4470](https://jira.percona.com/browse/PS-4470) “the cachetable-simple-pin-nonblocking-cheap test occasionally fails due to a locking conflict with the cachetable evictor” [_][#1131](https://jira.percona.com/browse/PS-1131) “User\_var\_log\_event::User\_var\_log\_event(const char_, uint, const Format\_description\_log\_event\*): Assertion [`](https://www.percona.com/blog/2018/05/30/percona-server-for-mysql-5-6-40-84-0-is-now-available/#id1)(bytes\_read == (data\_written – ((old\_pre\_checksum\_fd || (description\_event-\>checksum\_alg == BINLOG\_CHECKSUM\_ALG\_OFF)) ? 0 : 4))) || ((“. [/LIST] Find the release notes for Percona Server for MySQL 5.6.40-84.0 in our [online documentation](https://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.6.40-84.0.html). Report bugs in the [Jira bug tracker](https://jira.percona.com/projects/PS).