LNMP1.3: MySQL 5.6 日常崩溃

zhong9942

附其中一次的错误日志：
160911 21:46:44 mysqld_safe mysqld from pid file /usr/local/mysql/var/heiwajima.pid ended
160911 21:49:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
2016-09-11 21:49:22 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.33-log) starting as process 26083 ...
2016-09-11 21:49:22 26083 [Note] Plugin 'FEDERATED' is disabled.
2016-09-11 21:49:22 26083 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-09-11 21:49:22 26083 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-11 21:49:22 26083 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-11 21:49:22 26083 [Note] InnoDB: Memory barrier is not used
2016-09-11 21:49:22 26083 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-11 21:49:22 26083 [Note] InnoDB: Using CPU crc32 instructions
2016-09-11 21:49:22 26083 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
2016-09-11 21:49:22 26083 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2016-09-11 21:49:22 26083 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-11 21:49:22 26083 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-11 21:49:22 26083 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-11 21:49:22 26083 [ERROR] Aborting

licess

内存不够用了，你机器什么配置？

/etc/my.cnf 里 [mysqld]段里加上
performance_schema_max_table_instances=400
后应该会降低部分内存消耗