MySQL碰到UTC - mysqld got signal 11宕机一例

闲来无事，开了台MySQL数据库5.6.19进行升级操作，打算升级到5.6.26。目的是验证下这个说法，据说这个升级可以直接将MySQL安装包替换掉即可，不需要进行mysql_upgrade。

blog地址：http://blog.youkuaiyun.com/hw_libo/article/details/48298613

我这里使用的是二进制预编译包安装的，解压完成5.6.26版本包后，将数据库停止，然后做一下调整：

/usr/local/mysql -> /opt/mysql/mysql-5.5
变更成：
/usr/local/mysql -> /opt/mysql/mysql-5.6

重启了数据库，发现数据库正常启动，error log中也并无错误或warnning，一切正常，数据均能正常访问。

但是我还是想试试运行一下mysql_upgrade，于是在my.cnf中添加了skip-grant-table，然后重启了MySQL，接着：

[root@MySQL5 mysql3306]# /usr/local/mysql/bin/mysql_upgrade -S /tmp/mysql3306.sock 
Looking for 'mysql' as: /usr/local/mysql/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/mysql/bin/mysqlcheck
Running 'mysqlcheck' with connection arguments: '--socket=/tmp/mysql3306.sock' 
Running 'mysqlcheck' with connection arguments: '--socket=/tmp/mysql3306.sock' 
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slave_master_info                            OK
mysql.slave_relay_log_info                         OK
mysql.slave_worker_info                            OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone