mysql参数之innodb_buffer_pool_size大小设置
运行已久的mysql今天突然服务停止了 查看日志
[FATAL] InnoDB: Over 95 percent of the buffer pool is occupied by lock heaps or the adaptive hash index! Check that your transactions do not set too many row locks. Your buffer pool size is 8 MB. Maybe you should make the buffer pool bigger? We intentionally generate a seg fault to print a stack trace on Linux!For more information, see Help and Support Center at http://www.mysql.com.
大概的意思书缓冲区太小了只有 8M
使用如下语句查询参数
show variables like 'innodb_buffer_pool%';
SELECT @@innodb_buffer_pool_size/1024/1024/1024; 换算成G
如下设置 innodb_buffer_pool_size 必须是 innodb_buffer_pool_chunk_size 的倍数
-- set global innodb_buffer_pool_size = 21474836480;
如果想持久化设置 必须修改 my.ini文件
show status like 'Innodb_buffer_pool_resize%'; 查看调整进度
