Board logo

标题: [求助] WDCP V3的mysql 会不定期关闭,想查下原因,日志在哪? [打印本页]

作者: fimd    时间: 2016-10-12 21:05     标题: WDCP V3的mysql 会不定期关闭,想查下原因,日志在哪?

WDCP V3的mysql 会不定期关闭,想查下原因,日志在哪?
作者: lanyeit    时间: 2016-10-12 21:11

看看空间是不是满了
作者: fimd    时间: 2016-10-13 10:52

回复 2# lanyeit


   空间没有满。在哪查MYSQL 的出错日志?一直没有找着。
作者: fimd    时间: 2016-10-13 16:12

回复 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    时间: 2016-10-15 11:51

内存是多大?我原来用小内存VPS的时候也出现过,现在2G以上内存都没这问题了
作者: fimd    时间: 2016-10-17 11:38

回复 5# lanyeit


   1G内存。
作者: eastdesign    时间: 2016-10-22 10:09

这个问题官方还是不重视吗?貌似很普遍了,我的阿里云ECS 8G内存,MYSQL服务时不时死掉,目前无法解决。
作者: magentoon    时间: 2016-10-23 01:40

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




欢迎光临 WDlinux官方论坛 (http://wdlinux.cn/bbs/) Powered by Discuz! 7.2