liunxs 关闭mysql_在Linux中mysql自动关闭,求解,急!!!

在CentOS 7.3 X64系统上使用XAMPP安装的MySQL频繁自动关闭,日志显示错误与数据库崩溃恢复相关。错误包括:非正常关闭、timestamp警告以及日志序列号不匹配。问题发生在每天凌晨23点至7点之间,间隔5-6天。
摘要由CSDN通过智能技术生成

这里有最近两次的数据库发生错误时的日志!!!求解环境是用xampp安装的,系统是centos7.3X642015-04-0122:07:278019[Note]EventScheduler:Loaded0events2015-04-0122:07:278019[Note...

这里有最近两次的数据库发生错误时的日志!!!求解环境是用xampp安装的,系统是centos7.3X64

2015-04-01 22:07:27 8019 [Note] Event Scheduler: Loaded 0 events

2015-04-01 22:07:27 8019 [Note] /opt/lampp/sbin/mysqld: ready for connections.

Version: '5.6.21' socket: '/opt/lampp/var/mysql/mysql.sock' port: 0 Source distribution

2015-04-01 23:07:08 20326 mysqld_safe Number of processes running now: 0

2015-04-01 23:07:08 20326 mysqld_safe mysqld restarted

2015-04-01 23:07:09 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.

2015-04-01 23:07:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2015-04-01 23:07:09 9322 [Note] Plugin 'FEDERATED' is disabled.

2015-04-01 23:07:09 9322 [Note] InnoDB: Using atomics to ref count buffer pool pages

2015-04-01 23:07:09 9322 [Note] InnoDB: The InnoDB memory heap is disabled

2015-04-01 23:07:09 9322 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2015-04-01 23:07:09 9322 [Note] InnoDB: Memory barrier is not used

2015-04-01 23:07:09 9322 [Note] InnoDB: Compressed tables use zlib 1.2.8

2015-04-01 23:07:09 9322 [Note] InnoDB: Using CPU crc32 instructions

2015-04-01 23:07:09 9322 [Note] InnoDB: Initializing buffer pool, size = 16.0M

2015-04-01 23:07:09 9322 [Note] InnoDB: Completed initialization of buffer pool

2015-04-01 23:07:09 9322 [Note] InnoDB: Highest supported file format is Barracuda.

2015-04-01 23:07:09 9322 [Note] InnoDB: The log sequence numbers 136627662 and 136627662 in ibdata files do not match the log sequence number 150824087 in the ib_logfiles!

2015-04-01 23:07:09 9322 [Note] InnoDB: Database was not shutdown normally!

2015-04-01 23:07:09 9322 [Note] InnoDB: Starting crash recovery.

2015-04-01 23:07:09 9322 [Note] InnoDB: Reading tablespace information from the .ibd files...

2015-04-01 23:07:10 9322 [Note] InnoDB: Restoring possible half-written data pages

2015-04-01 23:07:10 9322 [Note] InnoDB: from the doublewrite buffer...

2015-04-01 23:07:10 9322 [Note] InnoDB: 128 rollback segment(s) are active.

2015-04-01 23:07:10 9322 [Note] InnoDB: Waiting for purge to start

2015-04-01 23:07:10 9322 [Note] InnoDB: 5.6.21 started; log sequence number 150824087

由于字数太多删除了一次的,每次都是在23点到7点钟之间发生,现在隔5,6天就自动停一次,特别奇怪

展开

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值