MySQL5.1をMySQL5.5にバージョンアップしてみた

NO IMAGE

すでにremiが入っているかつPHP5.3が入っているサーバーでMySQL5.5を入れてみます

mysqlをupdateする時は必ずPHPも同時にやってやらないとあとで後悔するので同時にやります

yum --enablerepo=remi-test update php mysql*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * addons: ftp.nara.wide.ad.jp
 * base: ftp.nara.wide.ad.jp
 * epel: ftp.jaist.ac.jp
 * epel-debuginfo: ftp.jaist.ac.jp
 * epel-source: ftp.jaist.ac.jp
 * extras: ftp.nara.wide.ad.jp
 * updates: ftp.nara.wide.ad.jp
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.5.8-1.el5.remi set to be updated
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: php-mysql
---> Package mysql-libs.x86_64 0:5.5.8-1.el5.remi set to be updated
---> Package mysql-server.x86_64 0:5.5.8-1.el5.remi set to be updated
--> Processing Dependency: php = 5.3.3-1.el5.remi for package: php-devel
---> Package php.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
--> Processing Dependency: php-common = 5.3.4-0.1.201011270530.el5.remi for package: php
--> Processing Dependency: php-cli = 5.3.4-0.1.201011270530.el5.remi for package: php
--> Running transaction check
---> Package compat-mysql51.x86_64 0:5.1.54-1.el5.remi set to be updated
---> Package php-cli.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-enchant
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-xml
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-xmlrpc
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-gd
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-mbstring
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-pspell
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-bcmath
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-recode
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-ldap
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-dba
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-mcrypt
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-zts
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-tidy
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-intl
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-embedded
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-process
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-imap
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-pdo
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-snmp
--> Processing Dependency: php-common = 5.3.3-1.el5.remi for package: php-soap
---> Package php-common.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-devel.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-mysql.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
--> Running transaction check
---> Package php-bcmath.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-dba.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-embedded.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-enchant.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-gd.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-imap.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-intl.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-ldap.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-mbstring.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-mcrypt.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-pdo.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-process.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-pspell.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-recode.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-snmp.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-soap.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-tidy.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-xml.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-xmlrpc.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
---> Package php-zts.x86_64 0:5.3.4-0.1.201011270530.el5.remi set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================
 Package                   Arch              Version                                     Repository            Size
====================================================================================================================
Updating:
 mysql                     x86_64            5.5.8-1.el5.remi                            remi-test            7.7 M
 mysql-libs                x86_64            5.5.8-1.el5.remi                            remi-test            1.2 M
 mysql-server              x86_64            5.5.8-1.el5.remi                            remi-test             12 M
 php                       x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            1.4 M
Installing for dependencies:
 compat-mysql51            x86_64            5.1.54-1.el5.remi                           remi-test            1.8 M
Updating for dependencies:
 php-bcmath                x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             41 k
 php-cli                   x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            2.6 M
 php-common                x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            970 k
 php-dba                   x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             61 k
 php-devel                 x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            626 k
 php-embedded              x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            1.3 M
 php-enchant               x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             32 k
 php-gd                    x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            209 k
 php-imap                  x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             88 k
 php-intl                  x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            136 k
 php-ldap                  x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             57 k
 php-mbstring              x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            2.3 M
 php-mcrypt                x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             48 k
 php-mysql                 x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            159 k
 php-pdo                   x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            118 k
 php-process               x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             60 k
 php-pspell                x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             33 k
 php-recode                x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             26 k
 php-snmp                  x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             40 k
 php-soap                  x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            277 k
 php-tidy                  x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             53 k
 php-xml                   x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            222 k
 php-xmlrpc                x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test             87 k
 php-zts                   x86_64            5.3.4-0.1.201011270530.el5.remi             remi-test            1.5 M

Transaction Summary
====================================================================================================================
Install      1 Package(s)
Update      28 Package(s)
Remove       0 Package(s)

Total download size: 35 M
Is this ok [y/N]:

当然yを入力すると

Downloading Packages:
(1/29): php-recode-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                |  26 kB     00:00
(2/29): php-enchant-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                               |  32 kB     00:01
(3/29): php-pspell-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                |  33 kB     00:01
(4/29): php-snmp-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                  |  40 kB     00:01
(5/29): php-bcmath-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                |  41 kB     00:00
(6/29): php-mcrypt-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                |  48 kB     00:01
(7/29): php-tidy-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                  |  53 kB     00:01
(8/29): php-ldap-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                  |  57 kB     00:01
(9/29): php-process-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                               |  60 kB     00:01
(10/29): php-dba-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                  |  61 kB     00:01
(11/29): php-xmlrpc-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                               |  87 kB     00:01
(12/29): php-imap-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                 |  88 kB     00:01
(13/29): php-pdo-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                  | 118 kB     00:01
(14/29): php-intl-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                 | 136 kB     00:02
(15/29): php-mysql-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                | 159 kB     00:02
(16/29): php-gd-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                   | 209 kB     00:02
(17/29): php-xml-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                  | 222 kB     00:02
(18/29): php-soap-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                 | 277 kB     00:02
(19/29): php-devel-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                | 626 kB     00:06
(20/29): php-common-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                               | 970 kB     00:05
(21/29): mysql-libs-5.5.8-1.el5.remi.x86_64.rpm                                              | 1.2 MB     00:05
(22/29): php-embedded-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                             | 1.3 MB     00:05
(23/29): php-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                      | 1.4 MB     00:05
(24/29): php-zts-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                  | 1.5 MB     00:05
(25/29): compat-mysql51-5.1.54-1.el5.remi.x86_64.rpm                                         | 1.8 MB     00:06
(26/29): php-mbstring-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                             | 2.3 MB     00:07
(27/29): php-cli-5.3.4-0.1.201011270530.el5.remi.x86_64.rpm                                  | 2.6 MB     00:39
(28/29): mysql-5.5.8-1.el5.remi.x86_64.rpm                                                   | 7.7 MB     01:04
(29/29): mysql-server-5.5.8-1.el5.remi.x86_64.rpm                                            |  12 MB     01:35
--------------------------------------------------------------------------------------------------------------------
Total                                                                               123 kB/s |  35 MB     04:53
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction

WARNING : This php-* RPM are not official Fedora/Redhat build and
overrides the official ones. Don't file bugs on Fedora Project nor Redhat.

Use dedicated forums http://forums.famillecollet.com/

  Updating       : php-common                                                                                  1/57
  Installing     : compat-mysql51                                                                              2/57
  Updating       : php-cli                                                                                     3/57
  Updating       : php-pdo                                                                                     4/57

WARNING : This MySQL RPM is not an official Fedora/Redhat build and it
overrides the official one. Don't file bugs on Fedora Project nor Redhat.
Use dedicated forums http://forums.famillecollet.com/

  Updating       : mysql-libs                                                                                  5/57
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
  Updating       : mysql                                                                                       6/57
  Updating       : php                                                                                         7/57
  Updating       : php-snmp                                                                                    8/57
  Updating       : php-mysql                                                                                   9/57
  Updating       : php-gd                                                                                     10/57
  Updating       : php-process                                                                                11/57
  Updating       : php-intl                                                                                   12/57
  Updating       : php-tidy                                                                                   13/57
  Updating       : php-devel                                                                                  14/57
  Updating       : php-mcrypt                                                                                 15/57
  Updating       : php-dba                                                                                    16/57
  Updating       : php-xmlrpc                                                                                 17/57
  Updating       : php-soap                                                                                   18/57
  Updating       : php-enchant                                                                                19/57
  Updating       : php-xml                                                                                    20/57
  Updating       : php-ldap                                                                                   21/57
  Updating       : php-imap                                                                                   22/57
  Updating       : php-pspell                                                                                 23/57
  Updating       : mysql-server                                                                               24/57
  Updating       : php-zts                                                                                    25/57
  Updating       : php-recode                                                                                 26/57
  Updating       : php-embedded                                                                               27/57
  Updating       : php-mbstring                                                                               28/57
  Updating       : php-bcmath                                                                                 29/57
  Cleanup        : php-cli                                                                                    30/57
  Cleanup        : php                                                                                        31/57
  Cleanup        : php-snmp                                                                                   32/57
  Cleanup        : php-mysql                                                                                  33/57
  Cleanup        : php-gd                                                                                     34/57
  Cleanup        : php-process                                                                                35/57
  Cleanup        : php-intl                                                                                   36/57
  Cleanup        : php-tidy                                                                                   37/57
  Cleanup        : php-devel                                                                                  38/57
  Cleanup        : php-mcrypt                                                                                 39/57
  Cleanup        : mysql-libs                                                                                 40/57
  Cleanup        : php-dba                                                                                    41/57
  Cleanup        : php-xmlrpc                                                                                 42/57
  Cleanup        : php-soap                                                                                   43/57
  Cleanup        : php-enchant                                                                                44/57
  Cleanup        : php-xml                                                                                    45/57
  Cleanup        : php-ldap                                                                                   46/57
  Cleanup        : php-imap                                                                                   47/57
  Cleanup        : php-pspell                                                                                 48/57
  Cleanup        : mysql-server                                                                               49/57
  Cleanup        : php-zts                                                                                    50/57
  Cleanup        : php-common                                                                                 51/57
  Cleanup        : mysql                                                                                      52/57
  Cleanup        : php-recode                                                                                 53/57
  Cleanup        : php-pdo                                                                                    54/57
  Cleanup        : php-embedded                                                                               55/57
  Cleanup        : php-mbstring                                                                               56/57
  Cleanup        : php-bcmath                                                                                 57/57

Dependency Installed:
  compat-mysql51.x86_64 0:5.1.54-1.el5.remi

Updated:
  mysql.x86_64 0:5.5.8-1.el5.remi                       mysql-libs.x86_64 0:5.5.8-1.el5.remi
  mysql-server.x86_64 0:5.5.8-1.el5.remi                php.x86_64 0:5.3.4-0.1.201011270530.el5.remi

Dependency Updated:
  php-bcmath.x86_64 0:5.3.4-0.1.201011270530.el5.remi      php-cli.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-common.x86_64 0:5.3.4-0.1.201011270530.el5.remi      php-dba.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-devel.x86_64 0:5.3.4-0.1.201011270530.el5.remi       php-embedded.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-enchant.x86_64 0:5.3.4-0.1.201011270530.el5.remi     php-gd.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-imap.x86_64 0:5.3.4-0.1.201011270530.el5.remi        php-intl.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-ldap.x86_64 0:5.3.4-0.1.201011270530.el5.remi        php-mbstring.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-mcrypt.x86_64 0:5.3.4-0.1.201011270530.el5.remi      php-mysql.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-pdo.x86_64 0:5.3.4-0.1.201011270530.el5.remi         php-process.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-pspell.x86_64 0:5.3.4-0.1.201011270530.el5.remi      php-recode.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-snmp.x86_64 0:5.3.4-0.1.201011270530.el5.remi        php-soap.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-tidy.x86_64 0:5.3.4-0.1.201011270530.el5.remi        php-xml.x86_64 0:5.3.4-0.1.201011270530.el5.remi
  php-xmlrpc.x86_64 0:5.3.4-0.1.201011270530.el5.remi      php-zts.x86_64 0:5.3.4-0.1.201011270530.el5.remi

Complete!

なんだかwarningが出てる気がしますがきっと大丈夫!

mysqlを再起動!

[[email protected] ~]# service mysqld restart
mysqld を停止中:                                           [  OK  ]
MySQL Daemon failed to start.
mysqld を起動中:                                           [失敗]

おおう、失敗した!
ログを見ると

101227 11:48:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101227 11:48:55 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
101227 11:48:56 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
101227 11:48:56  InnoDB: Using Linux native AIO
101227 11:48:56  InnoDB: Initializing buffer pool, size = 128.0M
101227 11:48:56  InnoDB: Completed initialization of buffer pool
101227 11:48:56  InnoDB: highest supported file format is Barracuda.
InnoDB: 127 rollback segment(s) active.
101227 11:48:56  InnoDB: 1.1.4 started; log sequence number 278430606
101227 11:48:56 [ERROR] /usr/libexec/mysqld: unknown variable 'default-character-set=utf8'
101227 11:48:56 [ERROR] Aborting

101227 11:48:56  InnoDB: Starting shutdown...
101227 11:48:58  InnoDB: Shutdown completed; log sequence number 279996546
101227 11:48:58 [Note] /usr/libexec/mysqld: Shutdown complete

101227 11:48:58 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

とりあえず、/usr/libexec/mysqld: unknown variable ‘default-character-set=utf8’って書いてあるしmy.confをいじってみる

色々コメントアウトしてみた

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# To enable the InnoDB Plugin, uncomment the 2 next lines
#ignore-builtin-innodb
#plugin-load=innodb=ha_innodb_plugin.so

#default-character-set=utf8
skip-character-set-client-handshake

# slow queries
#log-slow-queries = /var/log/mysql/mysql-slow.log
#long_query_time=3
#log-queries-not-using-indexes

# To enable InnoDB-related INFORMATION_SCHEMA tables
# Join the following options to above directive
#ignore-builtin-innodb
#plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so
innodb_file_format=Barracuda

  ;innodb_trx=ha_innodb_plugin.so
  ;innodb_locks=ha_innodb_plugin.so
  ;innodb_cmp=ha_innodb_plugin.so
  ;innodb_cmp_reset=ha_innodb_plugin.so
  ;innodb_cmpmem=ha_innodb_plugin.so
  ;innodb_cmpmem_reset=ha_innodb_plugin.so

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

再度起動

[[email protected] ~]# service mysqld start
mysqld を起動中:                                           [  OK  ]

起動した、logはどうなってるかな・・・

101227 11:53:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
101227 11:54:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101227 11:54:47 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
101227 11:54:47  InnoDB: Using Linux native AIO
101227 11:54:47  InnoDB: Initializing buffer pool, size = 128.0M
101227 11:54:47  InnoDB: Completed initialization of buffer pool
101227 11:54:47  InnoDB: highest supported file format is Barracuda.
101227 11:54:47  InnoDB: 1.1.4 started; log sequence number 279996546
101227 11:54:47 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
101227 11:54:47 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
101227 11:54:47 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
101227 11:54:47 [Note] Event Scheduler: Loaded 0 events
101227 11:54:47 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.8'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi

エラーがすごい出てる!なんぞこれ・・・
とりあえずこの時点でちゃんと起動はしてるけど・・・

試しにmysql_upgradeしてみる

ものすごいログが流れた!なにしてるのかはわからん!
再起動してログを見てみると

101227 12:00:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
101227 12:00:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101227 12:00:09 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
101227 12:00:09  InnoDB: Using Linux native AIO
101227 12:00:09  InnoDB: Initializing buffer pool, size = 128.0M
101227 12:00:09  InnoDB: Completed initialization of buffer pool
101227 12:00:09  InnoDB: highest supported file format is Barracuda.
101227 12:00:09  InnoDB: 1.1.4 started; log sequence number 280000791
101227 12:00:09 [Note] Event Scheduler: Loaded 0 events
101227 12:00:09 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.8'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi

お、エラーがなくなりましたね。だいぶこの辺の作業にも慣れた気がするわ・・・
というわけで起動するまでで時間がなくなってしまったのでベンチマーク的なものとか新機能を調べるのは来年になりそうな予感です

追記

default-character-set=utf8をコメントアウトしてしまった為一部環境で文字化けが発生しました。。
そんな時はmy.cnfに

character-set-server=utf8

を書いておくと、今までどおりの挙動になるっぽいです。
参考:MySQL 5.5.3-m3 で廃止になった変数やオプションなどを整理しました – sakaikの日々雑感〜(T)編