qq_28882477 2016-11-04 05:17 采纳率: 0%
浏览 1323

mysql启动失败，求助!!!!!!!

[root@localhost log]# service mysql start
Starting MySQL...The server quit without updating PID file [失败]/mysql/localhost.pid).

  • 写回答

3条回答 默认 最新

  • qq_28882477 2016-11-04 05:23
    关注

    161104 12:13:45 mysqld_safe Starting mysqld daemon with databases from /home/mysql
    2016-11-04 12:13:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2016-11-04 12:13:45 15466 [Note] Plugin 'FEDERATED' is disabled.
    2016-11-04 12:13:45 15466 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2016-11-04 12:13:45 15466 [Note] InnoDB: The InnoDB memory heap is disabled
    2016-11-04 12:13:45 15466 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2016-11-04 12:13:45 15466 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2016-11-04 12:13:45 15466 [Note] InnoDB: Using Linux native AIO
    2016-11-04 12:13:45 15466 [Note] InnoDB: Using CPU crc32 instructions
    2016-11-04 12:13:45 15466 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2016-11-04 12:13:45 15466 [Note] InnoDB: Completed initialization of buffer pool
    2016-11-04 12:13:45 15466 [Note] InnoDB: Highest supported file format is Barracuda.
    2016-11-04 12:13:45 15466 [Note] InnoDB: 128 rollback segment(s) are active.
    2016-11-04 12:13:45 15466 [Note] InnoDB: Waiting for purge to start
    2016-11-04 12:13:45 15466 [Note] InnoDB: 5.6.17 started; log sequence number 1600667
    2016-11-04 12:13:45 15466 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'log-slow-queries=/home/mysql/slowlog/slow_query.log'
    2016-11-04 12:13:45 15466 [ERROR] Aborting

    2016-11-04 12:13:45 15466 [Note] Binlog end
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'partition'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'ARCHIVE'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'BLACKHOLE'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_METRICS'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_CMP'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_LOCKS'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'INNODB_TRX'
    2016-11-04 12:13:45 15466 [Note] Shutting down plugin 'InnoDB'
    2016-11-04 12:13:45 15466 [Note] InnoDB: FTS optimize thread exiting.
    2016-11-04 12:13:45 15466 [Note] InnoDB: Starting shutdown...
    2016-11-04 12:13:47 15466 [Note] InnoDB: Shutdown completed; log sequence number 1600677
    2016-11-04 12:13:47 15466 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2016-11-04 12:13:47 15466 [Note] Shutting down plugin 'CSV'
    2016-11-04 12:13:47 15466 [Note] Shutting down plugin 'MEMORY'
    2016-11-04 12:13:47 15466 [Note] Shutting down plugin 'MRG_MYISAM'
    2016-11-04 12:13:47 15466 [Note] Shutting down plugin 'MyISAM'
    2016-11-04 12:13:47 15466 [Note] Shutting down plugin 'sha256_password'
    2016-11-04 12:13:47 15466 [Note] Shutting down plugin 'mysql_old_password'
    2016-11-04 12:13:47 15466 [Note] Shutting down plugin 'mysql_native_password'
    2016-11-04 12:13:47 15466 [Note] Shutting down plugin 'binlog'
    2016-11-04 12:13:47 15466 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

    大家谁给看看，万分感谢

    评论

报告相同问题？

悬赏问题

  • ¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
  • ¥15 如何在scanpy上做差异基因和通路富集？
  • ¥20 关于#硬件工程#的问题，请各位专家解答！
  • ¥15 关于#matlab#的问题：期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707，使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错，维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯：Person is not mapped，如何解決？