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

这两天新买的服务器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
解决