服务器退出没有更新PID文件,无法启动MySQL一直说“服务器退出而不更新PID文件”...

无法启动MYSQL服务器,它一直说“服务器退出而不更新PID文件”。我尝试重新创建PID文件,我在my.cmf文件中添加了PID文件的路径,但似乎没有任何帮助。我尝试重命名PID文件然后启动它似乎启动但它立即死亡。

这是mysql日志:

2015-07-24 15:27:27 1992 [Note] Plugin 'FEDERATED' is disabled.

2015-07-24 15:27:27 1992 [Note] InnoDB: Using atomics to ref count buffer pool pages

2015-07-24 15:27:27 1992 [Note] InnoDB: The InnoDB memory heap is disabled

2015-07-24 15:27:27 1992 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2015-07-24 15:27:27 1992 [Note] InnoDB: Memory barrier is not used

2015-07-24 15:27:27 1992 [Note] InnoDB: Compressed tables use zlib 1.2.3

2015-07-24 15:27:27 1992 [Note] InnoDB: Using Linux native AIO

2015-07-24 15:27:27 1992 [Note] InnoDB: Using CPU crc32 instructions

2015-07-24 15:27:27 1992 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2015-07-24 15:27:27 1992 [Note] InnoDB: Completed initialization of buffer pool

2015-07-24 15:27:27 1992 [Note] InnoDB: Highest supported file format is Barracuda.

2015-07-24 15:27:27 1992 [Note] InnoDB: The log sequence numbers 92864584624 and 92864584624 in ibdata files do not match the l$

2015-07-24 15:27:27 1992 [Note] InnoDB: Database was not shutdown normally!

2015-07-24 15:27:27 1992 [Note] InnoDB: Starting crash recovery.

2015-07-24 15:27:27 1992 [Note] InnoDB: Reading tablespace information from the .ibd files...

2015-07-24 15:27:27 1992 [Note] InnoDB: Restoring possible half-written data pages

2015-07-24 15:27:27 1992 [Note] InnoDB: from the doublewrite buffer...

2015-07-24 15:27:28 1992 [Note] InnoDB: 128 rollback segment(s) are active.

2015-07-24 15:27:28 1992 [Note] InnoDB: Waiting for purge to start

2015-07-24 15:27:28 1992 [Note] InnoDB: 5.6.23 started; log sequence number 92864702613

2015-07-24 15:27:28 1992 [Note] Server hostname (bind-address): '*'; port: 3306

2015-07-24 15:27:28 1992 [Note] IPv6 is not available.

2015-07-24 15:27:28 1992 [Note] - '0.0.0.0' resolves to '0.0.0.0';

2015-07-24 15:27:28 1992 [Note] Server socket created on IP: '0.0.0.0'.

2015-07-24 15:27:28 1992 [Note] Event Scheduler: Loaded 0 events

2015-07-24 15:27:28 1992 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.6.23-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

150724 15:27:28 mysqld_safe Number of processes running now: 0

150724 15:27:28 mysqld_safe mysqld restarted

2015-07-24 15:27:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timesta$

2015-07-24 15:27:28 2035 [Note] Plugin 'FEDERATED' is disabled.

2015-07-24 15:27:28 2035 [Note] InnoDB: Using atomics to ref count buffer pool pages

2015-07-24 15:27:28 2035 [Note] InnoDB: The InnoDB memory heap is disabled

2015-07-24 15:27:28 2035 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2015-07-24 15:27:28 2035 [Note] InnoDB: Memory barrier is not used

2015-07-24 15:27:28 2035 [Note] InnoDB: Compressed tables use zlib 1.2.3

2015-07-24 15:27:28 2035 [Note] InnoDB: Using Linux native AIO

2015-07-24 15:27:28 2035 [Note] InnoDB: Using CPU crc32 instructions

2015-07-24 15:27:28 2035 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2015-07-24 15:27:28 2035 [Note] InnoDB: Completed initialization of buffer pool

150724 15:27:28 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

这是my.cmf文件中的内容。

[mysqld]

max_connections=500

slow_query_log=1

default-storage-engine=MyISAM

innodb_file_per_table=1

max_allowed_packet=268435456

open_files_limit=10000

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

任何想法可能有什么问题?

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值