1. <th id="osa2k"><track id="osa2k"></track></th>
        <rp id="osa2k"><strike id="osa2k"><u id="osa2k"></u></strike></rp>
        首頁 > 數據庫 > MySQL > 正文

        mysql自動停止 Plugin FEDERATED is disabled 的完美解決方法

        2020-01-18 22:30:48
        字體:
        來源:轉載
        供稿:網友

        這兩天新買的服務器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
        解決

        發表評論 共有條評論
        用戶名: 密碼:
        驗證碼: 匿名發表
        亚洲性爱高潮视频_夜夜爽一区二区三区精品_亚洲国产第一福利一区二区_久久精品亚洲国产av

            1. <th id="osa2k"><track id="osa2k"></track></th>
              <rp id="osa2k"><strike id="osa2k"><u id="osa2k"></u></strike></rp>