Y-Ken Studio

新しもの好きのデータエンジニアが四方山話をお届けします。

133もの修正が行われた MySQL-5.6.12 が配布開始となりました

133もの不具合及び機能改善が施された MySQL-5.6.12 が配布開始となりました。
5.6.11に続き、今回の更新も盛り沢山ですね。後半では、yumでのアップデート方法も併せて紹介します。

リリースノート

InnoDB関連の修正が39、レプリケーション関連の修正が21と、今回も盛り沢山な更新です。
私が注目したい修正箇所としては、以下の2つです。思わずアップデートしたくなります。。

Replication: Following disconnection from the master, the slave could under certain conditions report erroneously on reconnection that it had received a packet that was larger than slave_max_allowed_packet, causing replication to fail. (Bug #16438800, Bug #68490)

.

If Loose Index Scan was used to evaluate a query that compared an integer column to an integer specified as a quoted string (for example, col_name = '1'), the query could return incorrect results. (Bug #68473, Bug #16394084)

その他の詳細は、以下のリリースノートをご参照ください。
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-12.html

CentOS6向けのrpmパッケージ

本家にて既に配布開始となっており、rpmファイルをダウンロードすることが出来ます。
まだ jaist からはダウンロード出来ませんが、時間の問題だと思います。
2013年6月5日追記:出来るようになりました!

http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.12-2.el6.x86_64.rpm
http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-shared-5.6.12-2.el6.x86_64.rpm
http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.12-2.el6.x86_64.rpm
http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-devel-5.6.12-2.el6.x86_64.rpm
http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.12-2.el6.x86_64.rpm

yum/rpm でのアップデート方法

速攻アップデートを掛けたい方は以下のように実行しましょう。

rpmコマンド

$ sudo rpm -Uvh  \
  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.12-2.el6.x86_64.rpm \
  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-shared-5.6.12-2.el6.x86_64.rpm \
  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.12-2.el6.x86_64.rpm \
  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-devel-5.6.12-2.el6.x86_64.rpm \
  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.12-2.el6.x86_64.rpm

yumコマンド

以下の通り、滞りなくアップデートできました。

$ sudo yum --disableexcludes=all install \
  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.12-2.el6.x86_64.rpm \
  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-shared-5.6.12-2.el6.x86_64.rpm \
  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.12-2.el6.x86_64.rpm \
  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-devel-5.6.12-2.el6.x86_64.rpm \
  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.12-2.el6.x86_64.rpm

Loaded plugins: etckeeper, fastestmirror, security
Loading mirror speeds from cached hostfile
Setting up Install Process
MySQL-shared-compat-5.6.12-2.el6.x | 3.8 MB     00:00
Examining /var/tmp/yum-root-hvq_7g/MySQL-shared-compat-5.6.12-2.el6.x86_64.rpm: MySQL-shared-compat-5.6.12-2.el6.x86_64
Marking /var/tmp/yum-root-hvq_7g/MySQL-shared-compat-5.6.12-2.el6.x86_64.rpm as an update to MySQL-shared-compat-5.6.11-2.el6.x86_64
MySQL-shared-5.6.12-2.el6.x86_64.r | 1.8 MB     00:00
Examining /var/tmp/yum-root-hvq_7g/MySQL-shared-5.6.12-2.el6.x86_64.rpm: MySQL-shared-5.6.12-2.el6.x86_64
Marking /var/tmp/yum-root-hvq_7g/MySQL-shared-5.6.12-2.el6.x86_64.rpm as an update to MySQL-shared-5.6.11-2.el6.x86_64
MySQL-server-5.6.12-2.el6.x86_64.r |  55 MB     00:03
Examining /var/tmp/yum-root-hvq_7g/MySQL-server-5.6.12-2.el6.x86_64.rpm: MySQL-server-5.6.12-2.el6.x86_64
Marking /var/tmp/yum-root-hvq_7g/MySQL-server-5.6.12-2.el6.x86_64.rpm as an update to MySQL-server-5.6.11-2.el6.x86_64
MySQL-devel-5.6.12-2.el6.x86_64.rp | 3.2 MB     00:00
Examining /var/tmp/yum-root-hvq_7g/MySQL-devel-5.6.12-2.el6.x86_64.rpm: MySQL-devel-5.6.12-2.el6.x86_64
Marking /var/tmp/yum-root-hvq_7g/MySQL-devel-5.6.12-2.el6.x86_64.rpm as an update to MySQL-devel-5.6.11-2.el6.x86_64
MySQL-client-5.6.12-2.el6.x86_64.r |  18 MB     00:00
Examining /var/tmp/yum-root-hvq_7g/MySQL-client-5.6.12-2.el6.x86_64.rpm: MySQL-client-5.6.12-2.el6.x86_64
Marking /var/tmp/yum-root-hvq_7g/MySQL-client-5.6.12-2.el6.x86_64.rpm as an update to MySQL-client-5.6.11-2.el6.x86_64
Resolving Dependencies
--> Running transaction check
---> Package MySQL-client.x86_64 0:5.6.11-2.el6 will be updated
---> Package MySQL-client.x86_64 0:5.6.11-2.el6 will be obsoleted
---> Package MySQL-client.x86_64 0:5.6.12-2.el6 will be obsoleting
---> Package MySQL-devel.x86_64 0:5.6.11-2.el6 will be obsoleted
---> Package MySQL-devel.x86_64 0:5.6.11-2.el6 will be updated
---> Package MySQL-devel.x86_64 0:5.6.12-2.el6 will be obsoleting
---> Package MySQL-server.x86_64 0:5.6.11-2.el6 will be obsoleted
---> Package MySQL-server.x86_64 0:5.6.11-2.el6 will be updated
---> Package MySQL-server.x86_64 0:5.6.12-2.el6 will be obsoleting
---> Package MySQL-shared.x86_64 0:5.6.11-2.el6 will be updated
---> Package MySQL-shared.x86_64 0:5.6.11-2.el6 will be obsoleted
---> Package MySQL-shared.x86_64 0:5.6.12-2.el6 will be obsoleting
---> Package MySQL-shared-compat.x86_64 0:5.6.11-2.el6 will be updated
---> Package MySQL-shared-compat.x86_64 0:5.6.11-2.el6 will be obsoleted
---> Package MySQL-shared-compat.x86_64 0:5.6.12-2.el6 will be obsoleting
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================
 Package             Arch   Version      Repository  Size
==========================================================
Installing:
 MySQL-client        x86_64 5.6.12-2.el6 /MySQL-client-5.6.12-2.el6.x86_64
                                                     81 M
     replacing  MySQL-client.x86_64 5.6.11-2.el6
 MySQL-devel         x86_64 5.6.12-2.el6 /MySQL-devel-5.6.12-2.el6.x86_64
                                                     19 M
     replacing  MySQL-devel.x86_64 5.6.11-2.el6
 MySQL-server        x86_64 5.6.12-2.el6 /MySQL-server-5.6.12-2.el6.x86_64
                                                    234 M
     replacing  MySQL-server.x86_64 5.6.11-2.el6
 MySQL-shared        x86_64 5.6.12-2.el6 /MySQL-shared-5.6.12-2.el6.x86_64
                                                    8.4 M
     replacing  MySQL-shared.x86_64 5.6.11-2.el6
 MySQL-shared-compat x86_64 5.6.12-2.el6 /MySQL-shared-compat-5.6.12-2.el6.x86_64
                                                     11 M
     replacing  MySQL-shared-compat.x86_64 5.6.11-2.el6

Transaction Summary
==========================================================
Install       5 Package(s)

Total size: 354 M