mysql主動停滯 Plugin FEDERATED is disabled 的完善處理辦法。本站提示廣大學習愛好者：（mysql主動停滯 Plugin FEDERATED is disabled 的完善處理辦法）文章只能為提供參考，不一定能成為您想要的結果。以下是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
處理
