《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學院為您提供精彩教程。