Public bug reported:
On a fresh install of Ubuntu 16.04, MySQL eats up way too much RAM due
to poor config settings out of the box. I'm suggesting maybe someone
tune it for a 512MB server.
As an example, I have a 1GB AWS EC2 instance running. I installed MySQL,
and did nothing beyond that. I came back about a couple hours later, and
the RAM consumption (according to htop) is 656/991MB! htop shows several
MySQL processes consuming 60% MEM. Again, this is for a DB process that
doesn't even have any databases, and zero activity.
ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: mysql-server-core-5.7 5.7.12-0ubuntu1.1
ProcVersionSignature: Ubuntu 4.4.0-28.47-generic 4.4.13
Uname: Linux 4.4.0-28-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.1
Architecture: amd64
Date: Thu Jul 14 07:09:40 2016
Ec2AMI: ami-b9ff39d9
Ec2AMIManifest: (unknown)
Ec2AvailabilityZone: us-west-2b
Ec2InstanceType: t2.micro
Ec2Kernel: unavailable
Ec2Ramdisk: unavailable
ExecutablePath: /usr/sbin/mysqld
Logs.var.log.daemon.log:
MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
[mysqld_safe]
syslog
MySQLVarLibDirListing: ['auto.cnf', 'ibdata1', 'performance_schema',
'ib_logfile1', 'ib_logfile0', 'mysql', 'sys', 'debian-5.7.flag', 'ibtmp1',
'ib_buffer_pool']
ProcAttrCurrent: /usr/sbin/mysqld (enforce)
ProcEnviron:
PATH=(custom, no user)
SHELL=/bin/false
SourcePackage: mysql-5.7
UpgradeStatus: No upgrade log present (probably fresh install)
** Affects: mysql-5.7 (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug ec2-images xenial
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1602964
Title:
MySQL consumes mega amounts of RAM
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1602964/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
