MySQL5.1から5.5へアップデート

GentooからMySQL5.5がStableになったし5.1はmaskするよ、というお知らせが来ていました
epgrecとMediatombで使っているのですが5.5でも問題なさそうなのでアップデートしました

  1. MySQLの停止

    # /etc/init.d/mysql stop

  2. emergeを使用してアップデート

    # emerge -uav mysql
# etc-update

  3. InnoDBが有効になっているとepgrecが遅くなるみたいなので設定を変更する *
    /etc/mysql/my.cnf に以下の二行を追加

    skip-innodb
default-storage-engine=MyISAM

  4. 関連パッケージの更新

    # emerge @preserved-rebuild -a
# revdep-rebuild --library libmysqlclient.so.16
# revdep-rebuild --library libmysqlclient_r.so.16

  5. MySQLを再起動
    再起動すると /var/log/mysql/mysqld.err に以下のようなエラーが出力されて
    mysql_upgrade を実行するように指示されます *

    # /etc/init.d/mysql start
# tail /var/log/mysql/mysqld.err
140830 20:53:41 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
140830 20:53:41 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140830 20:53:41 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140830 20:53:41 [Note] Event Scheduler: Loaded 0 events

  6. DBの更新と再度MySQLを再起動
    再起動後にログを確認してエラーがでていなければ完了

    # mysql_upgrade -u root -p
# /etc/init.d/mysql restart