Pomelo Lee workspace

mysql5.6启动占用内存过大调整参数

星期三, 2014-04-02 | Author: LeecloseAuthor: Lee Name: lee
Email: [email protected]
Site: https://www.pomelolee.com/
About: webgame网页,手机游戏服务端架构和开发者See Authors Posts (492) | linux | 8,706 views

vps的内存为512M,安装好nginx,php等启动起来,mysql死活启动不起来看了日志只看到对应pid被结束了,后跟踪看发现是内存不足被killed;

调整my.cnf 参数,重新配置（系统默认配置太高直接占用400M内存,小玩家玩不起呢）即可

performance_schema_max_table_instances=200
table_definition_cache=200
table_open_cache=128

~谢谢打赏~

赏

Tags: mysql, mysql5.6

No comments yet.

Leave a comment