I’m using docker for a development environment which has a mysql image.
On my current computer, running arch linux up to date with the no chagne to the docker setup, everything is working fine but mysql that uses all the memory available.
Each time I start the container, it uses immediately all the memory of my computer.
Even the most basic use of the docker image with no database uses 16GB.
All the other containers runs fine with no issue
I’ve tried the docker library mysql image, version 8 and 5.7, the oracle version, the percona version, they all have the same issue.
I’ve tried mariadb and it works as it’s supposed, using 100 something MB.
I’ve tried the same mysql image with podman and had no issue, it uses around 200 MB.
My version of docker is:
Docker version 18.09.6-ce, build 481bc77156
Here’s the Dockerfile
FROM mysql:5.7 ENV MYSQL_ROOT_PASSWORD rootpassword ENV MYSQL_ALLOW_EMPTY_PASSWORD=yes ENV MYSQL_DATABASE=database
CONTAINER ID NAME CPU % MEM USAGE / LIMIT MEM % NET I/O BLOCK I/O PIDS d66ccdbd03aa boring_haibt 0.20% 14.27GiB / 15.51GiB 92.00% 1.34kB / 0B 439MB / 299MB 27
And top inside the container
top - 16:11:06 up 7:32, 0 users, load average: 0.84, 2.05, 1.42 Tasks: 2 total, 1 running, 1 sleeping, 0 stopped, 0 zombie %Cpu(s): 5.4 us, 3.0 sy, 0.2 ni, 87.1 id, 3.3 wa, 0.9 hi, 0.2 si, 0.0 st KiB Mem: 16262332 total, 16100992 used, 161340 free, 10252 buffers KiB Swap: 8388604 total, 6197880 used, 2190724 free. 443820 cached Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1 mysql 20 0 17.005g 0.013t 0 S 0.0 85.0 0:05.59 mysqld 172 root 20 0 24152 2336 2000 R 0.0 0.0 0:00.15 top
I have no clue where the issue is coming from, does any one have an idea how I can troubleshoot that?
I tried to limit the memory usage of the container using
-m and mysqld refuses to start when it is bellow 10g with the error:
ERROR: mysqld failed while attempting to check config command was: "mysqld --verbose --help"
I found something even weirder.
On the same machine, I run a Windows virtual machine using qemu-kvm.
When this machine is started, the mysql container behave normally. When this machine is not started, it use all the memory of my computer