丰满人妻一区二区三区无码AV|国产乱色国产精品免费视频|国产精品一区二区不卡的视频|2020精品国产福利在线观看香蕉

    1. <rp id="2o2at"><nav id="2o2at"></nav></rp>
      
      

      <rt id="2o2at"></rt>
      <ruby id="2o2at"><nav id="2o2at"></nav></ruby>

    2. <rp id="2o2at"><meter id="2o2at"></meter></rp>

        <tt id="2o2at"><form id="2o2at"></form></tt>

      1. <source id="2o2at"></source>

          首頁 > 數據庫 > 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
          解決

          發表評論 共有條評論
          用戶名: 密碼:
          驗證碼: 匿名發表
          1. <rp id="2o2at"><nav id="2o2at"></nav></rp>
            
            

            <rt id="2o2at"></rt>
            <ruby id="2o2at"><nav id="2o2at"></nav></ruby>

          2. <rp id="2o2at"><meter id="2o2at"></meter></rp>

              <tt id="2o2at"><form id="2o2at"></form></tt>

            1. <source id="2o2at"></source>