Dear MySQL users,
MySQL Server 5.5.54 is a new version of the 5.5 production release
of the world's most popular open source database. MySQL 5.5.54 is
recommended for use on production systems.
MySQL 5.5 includes several high-impact enhancements to improve the
performance and scalability of the MySQL Database, taking advantage of
the latest multi-CPU and multi-core hardware and operating systems. In
addition, with release 5.5, InnoDB is now the default storage engine for
the MySQL Database, delivering ACID transactions, referential integrity
and crash recovery by default.
MySQL 5.5 also provides a number of additional enhancements including:
- Significantly improved performance on Windows, with various
Windows specific features and improvements
- Higher availability, with new semi-synchronous replication and
Replication Heartbeat
- Improved usability, with Improved index and table partitioning,
SIGNAL/RESIGNAL support and enhanced diagnostics, including a new
Performance Schema monitoring capability.
For a more complete look at what's new in MySQL 5.5, please see the
following resources:
MySQL 5.5 is GA, Interview with Tomas Ulin:
http://dev.mysql.com/tech-resources/interviews/thomas-ulin-mysql-55.html
Documentation:
http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html
If you are running a MySQL production level system, we would like to
direct your attention to MySQL Enterprise Edition, which includes the
most comprehensive set of MySQL production, backup, monitoring,
modeling, development, and administration tools so businesses can
achieve the highest levels of MySQL performance, security and uptime.
http://mysql.com/products/enterprise/
For information on installing MySQL 5.5.54 on new servers, please see
the MySQL installation documentation at
http://dev.mysql.com/doc/refman/5.5/en/installing.html
For upgrading from previous MySQL releases, please see the important
upgrade considerations at:
http://dev.mysql.com/doc/refman/5.5/en/upgrading.html
MySQL Database 5.5.54 is available in source and binary form for a
number of platforms from our download pages at:
http://dev.mysql.com/downloads/mysql/
The following section lists the changes in the MySQL source code since
the previous released version of MySQL 5.5. It may also be viewed
online at:
http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-54.html
Enjoy!
==============================================================================
Changes in MySQL 5.5.54 (2016-12-12, General availability)
* Security Notes
* Bugs Fixed
Security Notes
* Incompatible Change: These changes were made to
mysqld_safe:
+ Unsafe use of rm and chown in mysqld_safe could
result in privilege escalation. chown now can be
used only when the target directory is /var/log. An
incompatible change is that if the directory for the
Unix socket file is missing, it is no longer
created; instead, an error occurs. Due to these
changes, /bin/bash is required to run mysqld_safe on
Solaris. /bin/sh is still used on other Unix/Linux
platforms.
+ The --ledir option now is accepted only on the
command line, not in option files.
+ mysqld_safe ignores the current working directory.
Other related changes:
+ Initialization scripts that invoke mysqld_safe pass
--basedir explicitly.
+ Initialization scripts create the error log file
only if the base directory is /var/log or /var/lib.
+ Unused systemd files for SLES were removed.
(Bug #24483092, Bug #25088048)
References: See also: Bug #24464380, Bug #24388753.
Bugs Fixed
* Incompatible Change: A change made in MySQL 5.7.8 for
handling of multibyte character sets by LOAD DATA was
reverted due to the replication incompatibility
(Bug #24487120, Bug #82641)
References: See also: Bug #23080148.
* InnoDB: The GCC mach_parse_compressed function should
load one to five bytes depending on the value of the
first byte. Due to a GCC bug, GCC 5 and 6 emit code to
load four bytes before the first byte value is checked
(GCC Bug #77673). A workaround prevents this behavior.
Thanks to Laurynas Biveinis for the patch.
(Bug #24707869, Bug #83073)
* Some Linux startup scripts did not process the datadir
setting correctly. (Bug #25159791)
* CREATE TABLE with a DATA DIRECTORY clause could be used
to gain extra privileges. (Bug #25092566)
* OEL RPM packages now better detect which platforms have
multilib support (for which 32-bit and 64-bit libraries
can be installed). Thanks to Alexey Kopytov for the
patch. (Bug #24925181, Bug #83457)
* If mysqladmin shutdown encountered an error determining
the server process ID file, it displayed an error message
that did not clearly indicate the error was nonfatal. It
now indicates that execution continues. (Bug #24496214)
* The data structure used for ZEROFILL columns could
experience memory corruption, leading eventually to a
server exit. (Bug #24489302)
* Use of very long subpartition names could result in a
server exit. Now partition or subpartition names larger
than 64 characters produce an ER_TOO_LONG_IDENT error.
(Bug #24400628, Bug #82429)
* On Solaris, gettimeofday() could return an invalid value
and cause a server shutdown. (Bug #23499695)
* A union query resulting in tuples larger than
max_join_size could result in a server exit.
(Bug #23303485)
* For some deeply nested expressions, the optimizer failed
to detect stack overflow, resulting in a server exit.
(Bug #23135667)
* The --character-set-server option could set connection
character set system variables to values such as ucs2
that are not permitted. (Bug #15985752, Bug #23303391)
On behalf of Oracle MySQL Release Engineering Team,
Gipson Pulla
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
