MySQL 5.7.15 released with new InnoDB and CMake options

MySQL 5.7.15 was released. Updated as follows:

Security matters:

The Validate_password plugin now supports the capability of rejecting passwords this match the current session user name, Either forward or in reverse. To enable control over this capability, the plugin exposes a validate_password_check_user_name system variable. By default, this variable is disabled; The default would change to an enabled in MySQL 8.0. For more information, see Password Validation Plugin Options and Variables.
To add or change a function:

INNODB:A New dynamic configuration option, Innodb_deadlock_detect, can be used to disable deadlock detection. On high concurrency systems, deadlock detection can cause a slowdown when numerous threads wait for the same lock. At times, it could be a efficient to disable deadlock detection and rely on the Innodb_lock_wait_timeout setting for Tran Saction rollback when a deadlock occurs. (Bug #23477773)
The SYSTEMD support script for the unit file (MYSQLD_PRE_SYSTEMD) now assists in creating the error log file if it L Ocation matches the Pattern/var/log/mysql*.log. In other cases, the error log directory must is writable or the error log must is present and writable for the user Runnin G Themysqld process. Also, Mysqld_pre_systemd now avoids creating insecure temporary files. (Bug #24516262)
The CMake with_lz4 option has a been added to control which LZ4 library is used during compilation. By default With_lz4 are set to bundled, so the library provided with MySQL is used. Setting With_lz4 to system uses the LZ4 library from the operating system. (Bug #23607230)
Bugs Repair:

Innodb:an ALTER TABLE ... Encryption= ' Y ', algorithm=copy operation on a table residing in the system tablespace raised an assertion. (Bug #24381804)
Innodb:creating an encrypted table in a Fusion-io disk with an innodb_flush_method setting of o_direct caused a fatal err Or. (Bug #24329079, bug #82073)
Innodb:an operation that dropped and created a full-text search table raised an assertion. (Bug #24315031)
innodb:accessing Full-text Search Auxiliary tables while dropping the indexed table raised an assertion. (Bug #24009272)
Innodb:an Online DDL operation on a table with indexed BLOBs columns raised an assertion during logging of table Modificat Ions. (Bug #23760086)
Innodb:in some cases, code that locates a buffer pool chunk corresponding to given pointer returned the wrong chunk. Thanks to Alexey Kopytov for the patch. (Bug #23631471, bug #79378)
replication:the addition of the TRANSACTION-WRITE-SET-EXTRACTION=XXH64 option uses Xxhash symbols from LIBLZ4. Although the Xxhash symbols was exported by LIBLZ4, the header file was not a part of the API, so compilation failed when Bui Lding with With_lz4=system. The fix ensures that Xxhash was built separately from LIBLZ4 so that it was available both when using the system and bundled LZ4 libraries. (Bug #82426, bug #24399819) References:see Also:bug #23607230.
Replication:mysqlbinlog--read-from-remote-server log1 log2 is opening a new connection for log2 without freeing the con Nection used Forlog1. Thanks to Laurynas Biveinis for the contribution. (Bug #81675, bug #23540182)
replication:the MTR binary Log test suite failed to clean up copied files. Thanks to Daniel Black for the contribution. (Bug #80881, bug #23016254)
Replication:with Binlog_row_image=full, when updating single tables temporary tables were unnecessarily being used. The Fix ensures single table update follows the same pattern as multi-table update. (Bug #79867, bug #22510353)
Mysqld_safe attempted to read my.cnf in the data directory, although that is no longer a standard option for file location. (Bug #24482156)
For Mysqld_safe, the argument to--malloc-lib now must be one of the Directories/usr/lib,/usr/lib64,/usr/lib/i386-linux -gnu, Or/usr/lib/x86_64-linux-gnu. In addition, the--MYSQLD and--mysqld-version options can is used only on the command line and not in an option file. (Bug #24464380)
It is possible to the write log files ending with. ini or. CNF, later could be parsed as option files. The general query log and slow query log can no longer is written to a file ending with. ini or. cnf. (Bug #24388753)
Privilege escalation was possible by exploiting the "the" to REPAIR TABLE used temporary files. (Bug #24388746)
The client library failed to build on the Solaris using the CSTD library. (Bug #24353920)
If the BASEDIR system variable is set at server startup from the command line or option file, the value is not normalize D (on Windows,/is not replaced with/). (Bug #23747899, bug #82125)
Kevent Statement Timer Subsystem Deinitialization is revised to avoid a mysqld the during shutdown on OS X 10.12. (Bug #23744004, bug #82097)
For accounts for which multiple GRANT statements applied, Mysqlpump could fail-to-dump them all. (Bug #23721446)
The Mysql_add_plugin macro had a spelling error that caused mysql_server is defined. (Bug #23508762, bug #81666)
In-place ALTER table operations which when executed separately caused no TABLE rebuild could when combined to a single s Tatement result in a table rebuild. (Bug #23475211, bug #81587)
For keyring plugins, the data access layer was now created only as necessary, not once per operation, which improves Keyrin G performance. (Bug #23337926)
A blank server name in the CREATE server statements produced a server exit rather than an error. (Bug #23295288)
The optimizer failed to check a function return value for an area calculation, leading to a server exit. (Bug #23280059)
The server could fail to free memory allocated for execution of queries that used generated columns. (Bug #23205454) References:this issue is a regression of:bug #22392268.
Mysqlpump output for triggers, contained multiple statements in the trigger body failed to load correctly. (Bug #23072245)
Queries that satisfied the following conditions could return different results than in MySQL 5.6:1) A subquery appeared I n the select list; 2) The subquery contained a WHERE condition that referenced a value in the outer query; 3) The outer query contained a GROUP by that required creation of a temporary table. (Bug #23049975)
Passwords that were rejected by the Validate_password plugin were written by the server to the error log as cleartext. (Bug #22922023)
A prepared statement that used a parameter in the select list of a derived table that is part of a join could cause a ser Ver exit. (Bug #22392374, bug #24380263)
Mediumint columns used in operations with a long integer values could result in buffer overflow. (Bug #19984392)
A spurious er_no_such_table error could occur when attempting to execute a prepared CREATE TABLE ... SELECT statement, used a temporary table in the FROM clause and called a stored function. The same error could occur for a nonprepared version of the statement if used in a stored procedure when the procedure was re-executed. (Bug #16672723, bug #68972)
EINTR handling in the client library have been fixed so, interrupted read and write calls are retried. Previously, EINTR was ignored. (Bug #82019, bug #23703570)
To see a list of other bug updates and full updates, click mysql/5.7/en/news-5-7-15.html

: http://dev.mysql.com/downloads/mysql/

MySQL 5.7.15 released with new InnoDB and CMake options