HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

MySQL 5.7 + Ubuntu 14.04 eating up my RAM

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
ubuntumysqleatingram

Problem

I've recently installed MySQL 5.7.11 in my Ubuntu 14.04.3 system following these instructions: http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/

Being totally empty and not being called by any other program, it always ramps up RAM usage in a couple of hours until I can't start Node apps because of low memory (ENOMEM). I first assumed it to be because I'm running on a 768MB VPS, so I tweaked my.cnf, using some very low parameters, but it kept behaving like that, eating up more than 600MB of RAM after a couple of hours.

Please notice that it's really taking up all that RAM, it's not some buffer/cache voodoo, because it stops other programs from starting. Or am I wrong here?

Just uninstalled everything and reinstalled MySQL 5.6 and this problem isn't happening. Can anyone lend me a hand here? Am I doing something wrong or is this some kind of bug?

Thanks!

Solution

MySQL 5.7.13 is OK

I was suffering from this problem. Same as you described: MySQL 5.7.11 with almost empty database and few requests in hour was eating memory up to 450MB.

So I've recently tried new version and it is totally OK. MySQL 5.7.13 instance is running for a week already and it takes only 73MB.

Also I've turned off performance schema in my.cnf:

[mysqld]
            performance_schema=0

Code Snippets

[mysqld]
            performance_schema=0

Context

StackExchange Database Administrators Q#129411, answer score: 4

Revisions (0)

No revisions yet.