aix服务重启mysql_mysqld进程几分钟重启一次,如何解决?

我的mysqld服务是用

cd /usr/local/mysql

./bin/mysqld_safe --defaults-file=/home/user/mysql/my.cnf &

来启动的,但是之前启动都没有问题,今天发现mysql进程启动后,查看/home/repay/mysql/data/.err日志发现有以下信息几分钟会就出现一次。查看mysqld_safe没有丢失,但是mysqld进程一直隔几分钟重启一次,并且对应的mysql.sock文件也是几分钟前刚产生。就是每次重启都会再生成这个文件一次。请问能从日志中判断什么原因引起重启吗?以及如何解决。我看了另一台服务器也是同样的启动方法,它的mysqld进程就没有不停的重启。

170830 18:20:02 mysqld_safe Number of processes running now: 0

170830 18:20:02 mysqld_safe mysqld restarted

170830 18:20:02 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.47) starting as process 1414 ...

170830 18:20:02 [Note] Plugin 'FEDERATED' is disabled.

170830 18:20:02 InnoDB: The InnoDB memory heap is disabled

170830 18:20:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins

170830 18:20:02 InnoDB: Compressed tables use zlib 1.2.3

170830 18:20:02 InnoDB: Using Linux native AIO

170830 18:20:02 InnoDB: Initializing buffer pool, size = 128.0M

170830 18:20:02 InnoDB: Completed initialization of buffer pool

170830 18:20:02 InnoDB: highest supported file format is Barracuda.

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

170830 18:20:02 InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Restoring possible half-written data pages from the doublewrite

InnoDB: buffer...

170830 18:20:02 InnoDB: Waiting for the background threads to start

170830 18:20:03 InnoDB: 5.5.47 started; log sequence number 83660787

170830 18:20:03 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

170830 18:20:03 [Note] - '0.0.0.0' resolves to '0.0.0.0';

170830 18:20:03 [Note] Server socket created on IP: '0.0.0.0'.

170830 18:20:03 [Note] Event Scheduler: Loaded 0 events

170830 18:20:03 [Note] /usr/local/mysql/bin/mysqld: ready for connections.

Version: '5.5.47' socket: '/tmp/mysql.sock3306' port: 3306 MySQL Community Server (GPL)

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

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值