• <menu id="aeakq"></menu>
  • <menu id="aeakq"><strong id="aeakq"></strong></menu>
    首頁 > 數據庫 > 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
    解決

    發表評論 共有條評論
    用戶名: 密碼:
    驗證碼: 匿名發表
    国产成a人亚洲精v品无码樱花|无码人妻久久一区二区三区|国产精品视频全国免费观看|成人国产亚洲日本欧美
  • <menu id="aeakq"></menu>
  • <menu id="aeakq"><strong id="aeakq"></strong></menu>