[求助] WDCP V3的mysql 会不定期关闭，想查下原因，日志在哪？

fimd

WDCP V3的mysql 会不定期关闭，想查下原因，日志在哪？

lanyeit

看看空间是不是满了

fimd

回复 2# lanyeit


   空间没有满。在哪查MYSQL 的出错日志？一直没有找着。

fimd

回复 2# lanyeit


   161013 10:46:12 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.49/data/iZbp10vmnn5rfl12msv6ciZ.pid ended161013 10:46:13 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.5.49/data
161013 10:46:13 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
161013 10:46:13 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
161013 10:46:13 [Note] /www/wdlinux/mysql-5.5.49/bin/mysqld (mysqld 5.5.49) starting as process 7512 ...
161013 10:46:13 [Note] Plugin 'FEDERATED' is disabled.
161013 10:46:13 InnoDB: The InnoDB memory heap is disabled
161013 10:46:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161013 10:46:13 InnoDB: Compressed tables use zlib 1.2.3
161013 10:46:13 InnoDB: Initializing buffer pool, size = 128.0M
161013 10:46:13 InnoDB: Completed initialization of buffer pool
161013 10:46:13 InnoDB: highest supported file format is Barracuda.
161013 10:46:13  InnoDB: Waiting for the background threads to start
161013 10:46:14 InnoDB: 5.5.49 started; log sequence number 47848664
161013 10:46:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
161013 10:46:14 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
161013 10:46:14 [Note] Server socket created on IP: '0.0.0.0'.
161013 10:46:14 [Note] Event Scheduler: Loaded 0 events
161013 10:46:14 [Note] /www/wdlinux/mysql-5.5.49/bin/mysqld: ready for connections.
Version: '5.5.49'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
161013 14:17:01 mysqld_safe Number of processes running now: 0
161013 14:17:01 mysqld_safe mysqld restarted
161013 14:17:01 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
161013 14:17:01 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
161013 14:17:01 [Note] /www/wdlinux/mysql-5.5.49/bin/mysqld (mysqld 5.5.49) starting as process 7845 ...
161013 14:17:01 [Note] Plugin 'FEDERATED' is disabled.
161013 14:17:01 InnoDB: The InnoDB memory heap is disabled
161013 14:17:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161013 14:17:01 InnoDB: Compressed tables use zlib 1.2.3
161013 14:17:01 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
161013 14:17:01 InnoDB: Completed initialization of buffer pool
161013 14:17:01 InnoDB: Fatal error: cannot allocate memory for the buffer pool
161013 14:17:01 [ERROR] Plugin 'InnoDB' init function returned error.
161013 14:17:01 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
161013 14:17:01 [ERROR] Unknown/unsupported storage engine: InnoDB
161013 14:17:01 [ERROR] Aborting

161013 14:17:01 [Note] /www/wdlinux/mysql-5.5.49/bin/mysqld: Shutdown complete

161013 14:17:01 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.49/data/iZbp10vmnn5rfl12msv6ciZ.pid ended

lanyeit

内存是多大？我原来用小内存VPS的时候也出现过，现在2G以上内存都没这问题了

fimd

回复 5# lanyeit


   1G内存。

eastdesign

这个问题官方还是不重视吗？貌似很普遍了，我的阿里云ECS 8G内存，MYSQL服务时不时死掉，目前无法解决。

magentoon

跟内存关系不大，我搬瓦工的内存才512M，运行半个月没挂过。linode内存2G，每天挂掉一次，前天还一天挂三次。
前两天把linode的虚拟内存也就是交换分区增加到2.5G，貌似两天没挂了，破历史记录。