已解决
发布

不知道为什么mysqld经常无缘无故就挂掉了,有没有办法监控网页状态,一旦503就重启mysqld,,,求大大赐教

5 答案

发布
管理员 2016-04-06

重启mysqld没用,找到根本原因吧,分析下/data/mysql/mysql-error.log

#1
发布

2016-04-06 01:57:45 6605 [Note] Plugin ‘FEDERATED’ is disabled.
2016-04-06 01:57:45 6605 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-04-06 01:57:45 6605 [Note] InnoDB: The InnoDB memory heap is disabled
2016-04-06 01:57:45 6605 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-06 01:57:45 6605 [Note] InnoDB: Memory barrier is not used
2016-04-06 01:57:45 6605 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-06 01:57:45 6605 [Note] InnoDB: Using CPU crc32 instructions
2016-04-06 01:57:45 6605 [Note] InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: mmap(137363456 bytes) failed; errno 12
2016-04-06 01:57:45 6605 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2016-04-06 01:57:45 6605 [ERROR] Plugin ‘InnoDB’ init function returned error.
2016-04-06 01:57:45 6605 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2016-04-06 01:57:45 6605 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-04-06 01:57:45 6605 [ERROR] Aborting

#2
发布

大大,这种情况我应该怎么调整呢

#3
发布

[root@localhost ~]# free -ml
total used free shared buffers cached
Mem: 3998 3030 968 23 20 260
Low: 3998 3030 968
High: 0 0 0
-/+ buffers/cache: 2748 1249
Swap: 511 199 312

#4
发布
管理员 2016-04-06

调小。。/etc/my.cnf innodb相关参数

#5

请登录或者 注册 来提交答案