LNMPA mysql服务运行几个小时后总是自动挂掉，系统重做好多次了，总是搞不定，求救！
Ubuntu 14.04.2 LTS (GNU/Linux 3.13.0-32-generic x86_64)512M内存，只装了LNMPAmysql启用innoDB，更改了MySQL的数据库存放目录，innodb_data_home_dir 和innodb_log_group_home_dir地址
同步修改清理并禁用mysql-bin.00001日志文件，
my.cnf文件下增加下面配置innodb_file_per_table=1
一开始一起运行正常，过几个小时后mysql就会自动挂掉，
重启之后正常运行，过几个小时后mysql又自动挂掉
mysql出错日志如下，请高手帮忙指点一下
151215 23:25:06 mysqld_safe mysqld from pid file /mnt/data/AY1404082155398856bcZ.pid ended
151215 23:25:08 mysqld_safe Starting mysqld daemon with databases from /mnt/data
151215 23:25:08 InnoDB: The InnoDB memory heap is disabled
151215 23:25:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151215 23:25:08 InnoDB: Compressed tables use zlib 1.2.8
151215 23:25:08 InnoDB: Initializing buffer pool, size = 16.0M
151215 23:25:08 InnoDB: Completed initialization of buffer pool
151215 23:25:08 InnoDB: highest supported file format is Barracuda.
151215 23:25:08InnoDB: Waiting for the background threads to start
151215 23:25:09 InnoDB: 5.5.42 started; log sequence number 696396357
151215 23:25:09 Server hostname (bind-address): '0.0.0.0'; port: 3306
151215 23:25:09 - '0.0.0.0' resolves to '0.0.0.0';
151215 23:25:09 Server socket created on IP: '0.0.0.0'.
151215 23:25:09 Event Scheduler: Loaded 0 events
151215 23:25:09 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42'socket: '/tmp/mysql.sock'port: 3306Source distribution
Killed
151216 02:31:45 mysqld_safe Number of processes running now: 0
151216 02:31:45 mysqld_safe mysqld restarted
1512162:31:45 InnoDB: The InnoDB memory heap is disabled
1512162:31:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1512162:31:45 InnoDB: Compressed tables use zlib 1.2.8
1512162:31:45 InnoDB: Initializing buffer pool, size = 16.0M
1512162:31:45 InnoDB: Completed initialization of buffer pool
1512162:31:45 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!
1512162:31:45InnoDB: 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...
1512162:31:46InnoDB: Waiting for the background threads to start
1512162:31:47 InnoDB: 5.5.42 started; log sequence number 697241756
1512162:31:47 Server hostname (bind-address): '0.0.0.0'; port: 3306
1512162:31:47 - '0.0.0.0' resolves to '0.0.0.0';
1512162:31:47 Server socket created on IP: '0.0.0.0'.
1512162:31:48 Event Scheduler: Loaded 0 events
1512162:31:48 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42'socket: '/tmp/mysql.sock'port: 3306Source distribution
Killed
151216 02:33:44 mysqld_safe Number of processes running now: 0
151216 02:33:44 mysqld_safe mysqld restarted
1512162:33:44 InnoDB: The InnoDB memory heap is disabled
1512162:33:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1512162:33:44 InnoDB: Compressed tables use zlib 1.2.8
1512162:33:44 InnoDB: Initializing buffer pool, size = 16.0M
1512162:33:44 InnoDB: Completed initialization of buffer pool
1512162:33:44 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!
1512162:33:44InnoDB: 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...
1512162:33:45InnoDB: Waiting for the background threads to start
1512162:33:46 InnoDB: 5.5.42 started; log sequence number 697241766
1512162:33:46 Server hostname (bind-address): '0.0.0.0'; port: 3306
1512162:33:46 - '0.0.0.0' resolves to '0.0.0.0';
1512162:33:48 Server socket created on IP: '0.0.0.0'.
1512162:35:20 Event Scheduler: Loaded 0 events
1512162:35:20 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42'socket: '/tmp/mysql.sock'port: 3306Source distribution
Killed
151216 02:35:40 mysqld_safe Number of processes running now: 0
151216 02:35:40 mysqld_safe mysqld restarted
1512162:35:40 InnoDB: The InnoDB memory heap is disabled
1512162:35:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1512162:35:40 InnoDB: Compressed tables use zlib 1.2.8
1512162:35:40 InnoDB: Initializing buffer pool, size = 16.0M
1512162:35:40 InnoDB: Completed initialization of buffer pool
1512162:35:40 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!
1512162:35:40InnoDB: 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...
1512162:35:43InnoDB: Waiting for the background threads to start
1512162:35:44 InnoDB: 5.5.42 started; log sequence number 697241776
1512162:35:44 Server hostname (bind-address): '0.0.0.0'; port: 3306
1512162:35:44 - '0.0.0.0' resolves to '0.0.0.0';
1512162:35:44 Server socket created on IP: '0.0.0.0'.
1512162:35:44 Event Scheduler: Loaded 0 events
1512162:35:44 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42'socket: '/tmp/mysql.sock'port: 3306Source distribution
Killed
151216 02:59:39 mysqld_safe Number of processes running now: 0
151216 02:59:39 mysqld_safe mysqld restarted
1512162:59:39 InnoDB: The InnoDB memory heap is disabled
1512162:59:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1512162:59:39 InnoDB: Compressed tables use zlib 1.2.8
1512162:59:39 InnoDB: Initializing buffer pool, size = 16.0M
InnoDB: mmap(17170432 bytes) failed; errno 12
1512162:59:39 InnoDB: Completed initialization of buffer pool
1512162:59:39 InnoDB: Fatal error: cannot allocate memory for the buffer pool
1512162:59:39 Plugin 'InnoDB' init function returned error.
1512162:59:39 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
1512162:59:39 Unknown/unsupported storage engine: InnoDB
1512162:59:39 Aborting
1512162:59:39 /usr/local/mysql/bin/mysqld: Shutdown complete
151216 02:59:39 mysqld_safe mysqld from pid file /mnt/data/AY1404082155398856bcZ.pid ended 前面日志里只有Killed，应该是内存不足被系统kill了
InnoDB: mmap(17170432 bytes) failed; errno 12
1512162:59:39 InnoDB: Completed initialization of buffer pool
1512162:59:39 InnoDB: Fatal error: cannot allocate memory for the buffer pool
后面日志也有无法分配内存的提示 为什么会这样？ 难道512M内存不能支持LNMPA吗
回复 3# 的帖子
512MB运行lnmpa确实内存挺紧张最好是1G以上
本身apache就挺能吃内存的 果然是，换成lnmp一切正常，伤心呀！用不了lnmpa 我也有512的，很稳定
页:
[1]