LNMP1.3: MySQL 5.6 日常崩溃
附其中一次的错误日志：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 /usr/local/mysql/bin/mysqld (mysqld 5.6.33-log) starting as process 26083 ...
2016-09-11 21:49:22 26083 Plugin 'FEDERATED' is disabled.
2016-09-11 21:49:22 26083 InnoDB: Using atomics to ref count buffer pool pages
2016-09-11 21:49:22 26083 InnoDB: The InnoDB memory heap is disabled
2016-09-11 21:49:22 26083 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-11 21:49:22 26083 InnoDB: Memory barrier is not used
2016-09-11 21:49:22 26083 InnoDB: Compressed tables use zlib 1.2.3
2016-09-11 21:49:22 26083 InnoDB: Using CPU crc32 instructions
2016-09-11 21:49:22 26083 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
2016-09-11 21:49:22 26083 InnoDB: Cannot allocate memory for the buffer pool
2016-09-11 21:49:22 26083 Plugin 'InnoDB' init function returned error.
2016-09-11 21:49:22 26083 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-11 21:49:22 26083 Unknown/unsupported storage engine: InnoDB
2016-09-11 21:49:22 26083 Aborting 内存不够用了，你机器什么配置？
/etc/my.cnf 里 段里加上
performance_schema_max_table_instances=400
后应该会降低部分内存消耗
页:
[1]