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

すでに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を再起動!

~~~
[root@ ~]# 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
~~~

再度起動

~~~
[root@ ~]# 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)編

コメント

タイトルとURLをコピーしました