<track id="pdikh"><span id="pdikh"><em id="pdikh"></em></span></track>
<track id="pdikh"></track>

<bdo id="pdikh"></bdo><tbody id="pdikh"><nobr id="pdikh"><address id="pdikh"></address></nobr></tbody>
  • <bdo id="pdikh"></bdo>

    <menuitem id="pdikh"><dfn id="pdikh"></dfn></menuitem>

    <tbody id="pdikh"></tbody>
    1. 首頁 > 數據庫 > 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
      解決

      發表評論 共有條評論
      用戶名: 密碼:
      驗證碼: 匿名發表
      www con.co.三级免费视频不卡丨秋霞中文不卡无码午夜av影院丨丨吉沢明步高清无码电影免费一区二区丨japanese色国产在线观看
      <track id="pdikh"><span id="pdikh"><em id="pdikh"></em></span></track>
      <track id="pdikh"></track>

      <bdo id="pdikh"></bdo><tbody id="pdikh"><nobr id="pdikh"><address id="pdikh"></address></nobr></tbody>
    2. <bdo id="pdikh"></bdo>

      <menuitem id="pdikh"><dfn id="pdikh"></dfn></menuitem>

      <tbody id="pdikh"></tbody>