mysql启动报错cannot allocate memory for the buffer pool处理
来源：互联网 发布：sublime text 2 python 编辑：程序博客网 时间：2024/04/23 15:19
今天启动mysql服务器时失败了。去/var/log/mysql/查看error.log，报错信息如下：
160123 22:29:26 InnoDB: Initializing buffer pool, size = 200.0M
InnoDB: mmap(214630400 bytes) failed; errno 12160123 22:29:26 InnoDB: Completed initialization of buffer pool
160123 22:29:26 InnoDB: Fatal error: cannot allocate memory for the buffer pool
原来是无法给innodb分配足够的内存，
我的阿里云服务器是最低配的，总共就500M内存，于是到/etc/mysql/my.cnf中改了如下选项：
innodb_buffer_pool_size=50M
再重新运行/etc/init.d/mysql start就成功了。
看来需要好好学习一下mysqll
0 0
- mysql启动报错cannot allocate memory for the buffer pool处理
- 解决MySQL : InnoDB: Cannot allocate memory for the buffer pool
- Mysql cannot allocate memory for the buffer pool 解决方法
- mysql无法启动——cannot allocate the memory for the buffer pool
- mysql:failed,启动失败,mmap failed-Cannot allocate memory for the buffer pool
- Fatal error: cannot allocate memory for the buffer pool
- InnoDB: Cannot allocate memory for the buffer pool
- mysql错误日志之cannot allocate the memory for the buffer pool
- 【数据库】InnoDB: Fatal error: cannot allocate memory for the buffer pool
- kafka 启动 报错cannot allocate memory，即内存不足
- RMAN Restore异常终止，报错：Cannot allocate memory
- Android 模拟器启动报错Failed to allocate memory: 8
- 启动PHP报错ERROR: [pool www] cannot get uid for user '@php_fpm_user@'
- 启动PHP报错ERROR: [pool www] cannot get uid for user '@php_fpm_user@'
- Android cannot allocate memory
- win7 下虚拟机资源挂载失败，报错mount: Cannot allocate memory
- 虚拟机编译代码是报 Cannot allocate memory Error
- wasted buffer pool memory
- HDU 5612 Baby Ming and Matrix games（dfs）
- hdoj Baby Ming and Weight lifting 5610 (暴力&转换)
- HDU2093考试排名
- 第2章第3节练习题2 串的模式匹配(KMP)
- 【leetcode】142. Linked List Cycle II My Submissions Question
- mysql启动报错cannot allocate memory for the buffer pool处理
- hdoj Baby Ming and phone number 5611 （简单判断）
- 设计模式：单例模式
- 利用TortoiseGit管理云仓库
- linux 嵌入式环境使用iptables防火墙的一些体验
- nyoj 整理图书 1216 （DP）
- WebUploader asp.net 多文件上传
- 十个值得一试的开源深度学习框架
- 奇异值分解（SVD）线性变换和几何意义
