Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 11 1 Older Entries

Displaying posts with tag: mysql changelogs (reset)

MySQL 5.6.21 Overview and Highlights
+1 Vote Up -0Vote Down

MySQL 5.6.21 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here.

For this release, there was 1 “InnoDB Notes” and 1 “Functionality Added or Changed” bug fix (and 0 “Security Fix”), so not much there, but of course they should be noted:

  • InnoDB Note: The –skip-innodb option is now deprecated and its use results in a warning. It will be removed in a future MySQL release. This also applies to its synonyms (–innodb=OFF, –disable-innodb, and so forth).
  • Functionality Added: Internally, spatial data types such as Geometry are represented as BLOB values, so when invoked with the –hex-blob option, mysqldump now displays spatial values in hex. (Bug
  •   [Read more...]
    MySQL 5.5.40 Overview and Highlights
    +2 Vote Up -0Vote Down

    MySQL 5.5.40 was recently released (it is the latest MySQL 5.5, is GA), and is available for download here:

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

    This release, similar to the last 5.5 release, is mostly uneventful.

    There were 0 “Functionality Added or Changed” bugs this time, and 18 bugs overall fixed.

    Out of the 18 bugs, most seemed rather minor or obscure, but there are 3 I think are worth noting (all 3 are InnoDB-related, regressions, and serious if you encounter them, so best to be aware of them):

    • InnoDB: An ALTER TABLE … ADD FOREIGN KEY operation could cause a serious error. (Bug #19471516, Bug #73650)
    • InnoDB: With a transaction isolation level
      [Read more...]
    MySQL 5.6.20 Overview and Highlights
    +0 Vote Up -0Vote Down

    MySQL 5.6.20 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here.

    For this release, there is 1 “Security Fix”, 1 “InnoDB Important Change”, and 7 “Functionality Added or Changed” fixes, all of which should be read in case they might affect you (though for this release, these mostly appear to be minor – some [default] changes, build notes/changes, and deprecations):

  • Security Fix: The linked OpenSSL library for the MySQL 5.6 Commercial Server has been updated from version 1.0.1g to version 1.0.1h. Versions of OpenSSL prior to and including 1.0.1g are reported to be vulnerable to CVE-2014-0224. This
  •   [Read more...]
    MySQL 5.5.39 Overview and Highlights
    +1 Vote Up -0Vote Down

    MySQL 5.5.39 was recently released (it is the latest MySQL 5.5, is GA), and is available for download here:

    http://downloads.skysql.com/archive/index/p/mysql/v/5.5.39

    This release, similar to the last 5.5 release, is mostly uneventful.

    There were two “Functionality Added or Changed” and 24 bugs fixed.

    The “Functionality Added or Changed” changes are:

    • CMake support was updated to handle CMake version 3.
    • The timed_mutexes system variable has no effect and is deprecated.

    Out of the 24 bugs, most seemed rather minor or obscure, but here are the ones I think are worth noting (crashing, security, wrong results, deadlock):

    • InnoDB: Opening a parent table that has thousands of child tables could
      [Read more...]
    MySQL 5.5.38 Overview and Highlights
    +0 Vote Up -0Vote Down

    MySQL 5.5.38 was recently released (it is the latest MySQL 5.5, is GA), and is available for download here:

    http://downloads.skysql.com/archive/index/p/mysql/v/5.5.38

    This release, similar to the last 5.5 release, is mostly uneventful.

    Out of the mere 13 bugs, most were benign, but I thought there were two worth mentioning (just because one is a slight performance improvement for InnoDB, and the other relates to slave consistency, so always important to see if it could affect you):

  • InnoDB: For each insert, memset would be called three times to allocate memory for system fields. To reduce CPU usage, the three memset calls are now combined into a single call. (Bug #17858679, Bug #71014)
  •   [Read more...]
    MySQL 5.6.19 Overview and Highlights
    +2 Vote Up -0Vote Down

    MySQL 5.6.19 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here.

    I should actually call this post “5.6.18 and 5.6.19 Overview and Highlights”.

    The 5.6 “Release Notes” Index provides an entry/changelog for 5.6.18 and says it was released 2014-04-11. However, it’s not available in the community download archives. This isn’t mentioned in the 5.6.18 changelogs, but it is in the

      [Read more...]
    MySQL 5.6.17 Overview and Highlights
    +1 Vote Up -0Vote Down

    MySQL 5.6.17 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here:

    For this release, I counted 7 “Functionality Added” and/or “Incompatible Change” fixes:

  • Incompatible Change: The AES_ENCRYPT() and AES_DECRYPT() functions now permit control of the block encryption mode and take an optional initialization vector argument.
  • Incompatible Change: The ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE SQL modes now are deprecated and setting the sql_mode value to include any of them generates a warning. In MySQL 5.7, these modes do nothing. Instead, their effects are included in the effects of
  •   [Read more...]
    MySQL 5.5.37 Overview and Highlights
    +2 Vote Up -0Vote Down

    MySQL 5.5.37 was recently released (it is the latest MySQL 5.5, is GA), and is available for download here:

    http://downloads.skysql.com/archive/index/p/mysql/v/5.5.37

    This release, similar to the last 5.5 release, is mostly uneventful.

    There was one new feature added (Solaris-specific + obscure), and only 21 bugs fixed.

    The new feature is this:

    • On Solaris, mysql_config –libs now includes -R/path/to/library so that libraries can be found at runtime.

    Out of the 21 bugs, most were benign, but there was one definitely worth mentioning (because it is a regression bug with performance degradation):

    • A regression introduced by Bug #14329288 would result in a performance degradation when a compressed table does not fit into memory. (Bug #18124788,
      [Read more...]
    MySQL 5.6.16 Overview and Highlights
    +6 Vote Up -0Vote Down

    MySQL 5.6.16 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here:

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

    As opposed to the latest 5.5 release, this latest 5.6 release has quite a few more bug fixes, but that’s expected since 5.5 has been GA for much longer.

    There were 2 minor functionality changes:

    • Previously, ALTER TABLE in MySQL 5.6 could alter a table such that the result had temporal columns in both 5.5 and 5.6 format. Now ALTER TABLE upgrades old temporal columns to 5.6 format for ADD COLUMN, CHANGE COLUMN, MODIFY COLUMN, ADD INDEX, and FORCE operations. This conversion cannot be done using the INPLACE algorithm, so specifying ALGORITHM=INPLACE in these cases results in an error. (Bug #17246318)
    • CMake now supports a -DTMPDIR=dir_name
      [Read more...]
    MySQL 5.5.36 Overview and Highlights
    +1 Vote Up -0Vote Down

    MySQL 5.5.36 was recently released (it is the latest MySQL 5.5, is GA), and is available for download here:

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

    I was reading through the changelogs to review the changes and fixes, and to summarize, I must say this release is mostly uneventful.

    There was one new feature added (for building, so not really applicable to everyone), and only 17 bugs fixed.

    The new feature is this:

    • CMake now supports a -DTMPDIR=dir_name option to specify the default tmpdir value. If unspecified, the value defaults to P_tmpdir in . Thanks to Honza Horak for the patch. (Bug #68338, Bug #16316074)

    Out of the 17 bugs, there was only 1 I thought worth mentioning (because it is a wrong results bug):

    • COUNT(DISTINCT) sometimes produced an incorrect result
      [Read more...]
    Showing entries 1 to 10 of 11 1 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.