Performance issues with mysql docker container

Question

I migrated my mysql database to docker and I restored a dump file. My mysql server was instaled directly on Linux, and I had not issues. On docker container my queries is 30x slower. Someone had a similar problem? I am running docker on Ubuntu 16 and I am using the following docker compose:

version: '3'
services:
  db:
    image: mysql:5.7
    environment:
      - MYSQL_ROOT_PASSWORD=root
    volumes:
      - ~/mysql/:/var/lib/mysql/
    ports:
      - "3306:3306"

  web:
    build: .
    volumes:
       - .:/var/www/html/app/
    ports:
      - "80:80"
    depends_on:
      - db

Can you dump your docker info, also which filesystem do you use and with which flags are they mounted? — Sander Visser, Jan 02 '19 at 13:36
https://github.com/docker/for-linux/issues/247 also there is some worthfull information there — Sander Visser, Jan 02 '19 at 13:37
[Something that worked for me was running mysqlcheck to fix the tables.](https://stackoverflow.com/a/23944159/2867894) — omarjebari, Nov 24 '20 at 02:04

score 8 · Answer 1 · answered Sep 03 '19 at 08:20

8

don't know if it can still help you. Faced the same issue hence I tried to figure it out. Apparentley the volume from your host filesystem to the container slows it down dramatically. Try to use the following setup with your volume:

~/mysql/:/var/lib/mysql:delegated

The only draw back is that it might take some time until the data written inside /var/lib/mysql will be written to your local filesystem.

answered Sep 03 '19 at 08:20

Peter P

491
4
14

Worked for me running Docker on Windows 10 (moby VM) – Reboot_87 Apr 13 '20 at 18:50
1

switched to docker-sync now, its mindblowing fast on mac os – Peter P Apr 15 '21 at 07:46

score -1 · Answer 2 · answered May 01 '21 at 20:29

-1

I did not encounter such a problem on my desktop, but mysql container was running very slowly in a way that I could not understand on my laptop computer. This solution solved my problem.

answered May 01 '21 at 20:29

Suat Keskin

116
5

Performance issues with mysql docker container

2 Answers2