《Mysql必读mysql自动停止 Plugin FEDERATED is disabled 的完美解决方法》要点:
本文介绍了Mysql必读mysql自动停止 Plugin FEDERATED is disabled 的完美解决方法,希望对您有用。如果有疑问,可以联系我们。
MYSQL必读这两天新买的服务器mysql总是自动停止,查了日志
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
MYSQL必读重启发现
MYSQL必读 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
MYSQL必读网上找到的办法
MYSQL必读在MY.INI文件中的 [mysqld] 中增加一行tmpdir="D:/MySQL/data/tmp"
删除MySQL目录下的ib_logfile0和ib_logfile1
MYSQL必读测试后没有用
MYSQL必读后来在服务中设置了mysql自动重启
MYSQL必读最后
[mysqld]
federated
MYSQL必读办理
启动正常
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)
MYSQL必读
顺手添加
skip-external-locking
skip-name-resolve
办理
《Mysql必读mysql自动停止 Plugin FEDERATED is disabled 的完美解决方法》是否对您有启发,欢迎查看更多与《Mysql必读mysql自动停止 Plugin FEDERATED is disabled 的完美解决方法》相关教程,学精学透。维易PHP学院为您提供精彩教程。