mysql_upgrade

mysql_upgrade

 

昨天因为innodb大量AUTO-INC LOCK 导致的DeadLOCK，升级mysql到5.1后一切正常，但是今早发现Tencent.err mysql错误文件中有些错误日志

….

/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist

110318 17:50:37 [ERROR] mysql.user has no `Event_priv` column at position 29

….

 

查阅mysql官方文档后发现，如果升级了需要运行下mysql_update

mysql_upgrade -uxx –pxxx  -v

这里-v只是为了多输出一些信息

 

 

实际运行过程中

db_svr_monitor.t_svr_alarm_record                  OK

mysql.columns_priv                                 OK

mysql.db                                           OK

mysql.func                                         OK

mysql.help_category

error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" to fix it!

mysql.help_keyword

error    : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fix it!

mysql.help_relation                                OK

mysql.help_topic

error    : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix it!

mysql.host                                         OK

mysql.proc

error    : Table upgrade required. Please do "REPAIR TABLE `proc`" to fix it!

 

 

出现了一些error，按照提示为进行REPAIR TABLE `xxx`后问题得到解决