mysql自动停止 Plugin FEDERATED is disabled 的完美解决方法
这两天新买的服务器mysql总是自动停止，查了日志
9:13:57[Note]MySQL:Normalshutdown
9:13:57[Note]EventScheduler:Purgingthequeue.0events
9:13:57 InnoDB:Startingshutdown...
9:13:58 InnoDB:Shutdowncompleted;logsequencenumber044273
9:13:58[Note]MySQL:Shutdowncomplete
重启发现
9:13:59[Note]Plugin'FEDERATED'isdisabled.
9:13:59 InnoDB:Initializingbufferpool,size=8.0M
9:13:59 InnoDB:Completedinitializationofbufferpool
9:13:59 InnoDB:Started;logsequencenumber044273
9:13:59[Note]EventScheduler:Loaded0events
9:13:59[Note]MySQL:readyforconnections.
Version:'5.1.61-community' socket:'' port:3306 MySQLCommunityServer(GPL)
9:14:24[Note]MySQL:Normalshutdown
网上找到的方法
在MY.INI文件中的[mysqld]中增加一行tmpdir="D:/MySQL/data/tmp"
删除MySQL目录下的ib_logfile0和ib_logfile1
测试后没有用
后来在服务中设置了mysql自动重启
最后
[mysqld]
federated
解决
启动正常
10:28:01 InnoDB:Initializingbufferpool,size=8.0M
10:28:01 InnoDB:Completedinitializationofbufferpool
10:28:01 InnoDB:Started;logsequencenumber044556
10:28:01[Note]EventScheduler:Loaded0events
10:28:01[Note]MySQL:readyforconnections.
Version:'5.1.61-community' socket:'' port:3306 MySQLCommunityServer(GPL)
顺手添加
skip-external-locking
skip-name-resolve
解决