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

最近进行日常网站维护查看日志的时候，发现MySQL日志里面出现了大量的“[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!结果。

官方QQ群号码：922069959
点击链接加入群聊【路由器交流】：https://jq.qq.com/?_wv=1027&k=5AKdmZP

您可能感兴趣的文章

• 宝塔面板MySQL没有使用索引的量过高，没有使用索引的量过高有什么影响？
• [N1盒子] 使用N1命令安装linux+nginx+mysql+php7.3建网站（不用面板，手动安装LNMP）
• Openwrt上LAMP(Php、Mysql、Apache)的安装配置

赏 支付宝打赏 微信打赏