昨天因为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`后问题得到解决