2019
09-03

[Note] Shutting down plugin 'INNODB_CMPMEM' MYSQL报错故障[Note] Shutting down plugin解决办法

路由器交流群

最近进行日常网站维护查看日志的时候,发现MySQL日志里面出现了大量的“[Note] Shutting down plugin”错误提示

[Note] Shutting down plugin解决办法

2019-09-01T23:36:16.566901Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2019-09-01T23:36:16.566903Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2019-09-01T23:36:16.566905Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2019-09-01T23:36:16.566908Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2019-09-01T23:36:16.566910Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2019-09-01T23:36:16.566912Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2019-09-01T23:36:16.566915Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2019-09-01T23:36:16.566917Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2019-09-01T23:36:16.566920Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2019-09-01T23:36:16.566922Z 0 [Note] Shutting down plugin 'INNODB_METRICS'

2019-09-01T23:36:16.566925Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'

2019-09-01T23:36:16.566927Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2019-09-01T23:36:16.566929Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2019-09-01T23:36:16.566932Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2019-09-01T23:36:16.566934Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2019-09-01T23:36:16.566941Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2019-09-01T23:36:16.566943Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2019-09-01T23:36:16.566946Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'

2019-09-01T23:36:16.566948Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2019-09-01T23:36:16.566950Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2019-09-01T23:36:16.566953Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2019-09-01T23:36:16.566955Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2019-09-01T23:36:16.566957Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2019-09-01T23:36:16.566960Z 0 [Note] Shutting down plugin 'InnoDB'

检查发现mysql的目录下有如下文件:

[root@tserver mysql]# ls

ibdata1 ib_logfile0 ib_logfile1 mysql RPM_UPGRADE_HISTORY RPM_UPGRADE_MARKER-LAST tserver.err

删除了如下三个文件:

[root@tserver mysql]# rm ibdata1 ib_logfile0 ib_logfile1

rm: remove regular file `ibdata1'? yes

rm: remove regular file `ib_logfile0'? yes

rm: remove regular file `ib_logfile1'? yes

重新启动mysql server就可以了:

[root@tserver mysql]# /etc/init.d/mysql start

Starting MySQL.[ OK ]

网上查找发现还有一种方法,这种方法没有尝试,做任何修改时一定要先备份数据,说多了都是泪。

解决方法如下:

删除mysql路径下的data文件夹

执行mysqld --initialize

重新启动mysql

网上的一些其他错误提示

MySQL无法启动的原因有多种,这里是我遇到的一种情况和解决方法。

起因:

最近项目需要使用MySQL,于是想在MAC上安装一个本地的数据库,但是其实忘了已经安装过一个版本了,结果发现新的服务器怎么也无法运行。

现象:

通过命令行启动MySQL:sudo /usr/local/mysql/support-files/mysql.server start

Starting MySQL

一直得到这个错误:

ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.pid).

查看error文件:

sudo tail /usr/local/mysql/data/localhost.err

得到的结果如下:

2014-06-24 13:50:52 37094 [Note] Shutting down plugin 'MyISAM'

2014-06-24 13:50:52 37094 [Note] Shutting down plugin 'MEMORY'

2014-06-24 13:50:52 37094 [Note] Shutting down plugin 'CSV'

2014-06-24 13:50:52 37094 [Note] Shutting down plugin 'sha256_password'

2014-06-24 13:50:52 37094 [Note] Shutting down plugin 'mysql_old_password'

2014-06-24 13:50:52 37094 [Note] Shutting down plugin 'mysql_native_password'

2014-06-24 13:50:52 37094 [Note] Shutting down plugin 'binlog'

2014-06-24 13:50:52 37094 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

13:50:52 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.pid ended

于是怀疑已经有MySQL进程存在。

解决方法:

通过命令查找所有MySQL有关的进程:ps -ef|grep mysql

然后杀死进程:sudo kill -9 PID

------------成功的分割线----------------

最后再运行命令:sudo /usr/local/mysql/support-files/mysql.server start

得到SUCCESS!结果。

您可能感兴趣的文章

免费支持本站

支付宝打赏支付宝打赏微信打赏微信打赏

本文》有 0 条评论

留下一个回复 (您的评论需要经过审核才能显示)