大网数据广告活动
服务器运维问答

MySQL - high RAM usage

· 52CE 我爱测

I have VPS with 2GB of RAM running Ubuntu. There are three sites using database on this server - two on WordPress and one on custom script. All of them get max few hits per day. MySQL always had pretty high RAM usage - usually so…

问题原文

原帖链接 · sajran · CC BY-SA 3.0

I have VPS with 2GB of RAM running Ubuntu. There are three sites using database on this server - two on WordPress and one on custom script. All of them get max few hits per day.

MySQL always had pretty high RAM usage - usually something around 25%. It's not that much but it looked weird compared to other processes using 1% or 2%.

Today I upgraded OS to Ubuntu 16.04 and now MySQL uses even more RAM - currently it's stuck at 42%.

My question is: is it normal? There are lot of posts about minimizing memory usage by MySQL but I don't know if it's necessary. After all half of RAM is still empty.

Here is a picture of htop

已采纳解答

原帖链接 · colan · CC BY-SA 3.0

No, it is not normal. It is caused by the bug Excessive memory used in memory/innodb/os0file starting 5.7.8.

It is tracked in Ubuntu as Excessive consumption RAM of mysqld daemon in Ubuntu 16.04, and there is also a discussion on Reddit.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2016-05-14)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。