mysql disabled_mysql自动停止 Plugin FEDERATED is disabled 的完美解决方法

短命女 2022-11-08 11:55 430阅读 0赞

这两天新买的服务器mysql总是自动停止，查了日志

9:13:57 [Note] MySQL: Normal shutdown

9:13:57 [Note] Event Scheduler: Purging the queue. 0 events

9:13:57 InnoDB: Starting shutdown…

9:13:58 InnoDB: Shutdown completed; log sequence number 0 44273

9:13:58 [Note] MySQL: Shutdown complete

重启发现

9:13:59 [Note] Plugin ‘FEDERATED’ is disabled.

9:13:59 InnoDB: Initializing buffer pool, size = 8.0M

9:13:59 InnoDB: Completed initialization of buffer pool

9:13:59 InnoDB: Started; log sequence number 0 44273

9:13:59 [Note] Event Scheduler: Loaded 0 events

9:13:59 [Note] MySQL: ready for connections.

Version: ‘5.1.61-community’ socket: ‘’ port: 3306 MySQL Community Server (GPL)

9:14:24 [Note] MySQL: Normal shutdown

网上找到的方法

在MY.INI文件中的 [mysqld] 中增加一行tmpdir=”D:/MySQL/data/tmp”

删除MySQL目录下的ib_logfile0和ib_logfile1

测试后没有用

后来在服务中设置了mysql自动重启

最后

[mysqld]

federated

解决

启动正常

10:28:01 InnoDB: Initializing buffer pool, size = 8.0M

10:28:01 InnoDB: Completed initialization of buffer pool

10:28:01 InnoDB: Started; log sequence number 0 44556

10:28:01 [Note] Event Scheduler: Loaded 0 events

10:28:01 [Note] MySQL: ready for connections.

Version: ‘5.1.61-community’ socket: ‘’ port: 3306 MySQL Community Server (GPL)

顺手添加

skip-external-locking

skip-name-resolve

解决

您可能感兴趣的文章:MySql报错Table mysql.plugin doesn’t exist的解决方法MySQL部署时提示Table mysql.plugin doesn’t exist的解决方法MySQL中报错：Can’t find file: ‘./mysql/plugin.frm’的解决方法

发表评论

表情：
评论列表 （有 0 条评论，430人围观）

还没有评论，来说两句吧...

相关阅读