DSM 7.1 MariaDB on Docker is much slower than MariaDB package

sawwee · 19. Nov 2022

There is a DS1621xs+ with NVMe SSD cache, equipped with 24 GB RAM.

There is a MariaDB10 server running on Docker.

I have an identical database running on the MariaDB10 package. (Dumped and copied from the Docker instance.)

Queries on the database of the MariaDB10 package run much faster than on the docker instance. Difference is at least 2.5x, but on some queries it is 20x.

What might be the reason of this huge perfomance difference, why are the queries slower on Docker than on the Synology Package version of MariaDB?

fredbert · 19. Nov 2022

Wondering if it is anything to do with the container's resource settings for CPU Priority and Memory Limit.

one-eyed-king · 19. Nov 2022

Could also be tweaks in an option group in one of the option files.
Before you ask: I have no idea where the files are located on DSM.

sawwee · 19. Nov 2022

fredbert said:
Wondering if it is anything to do with the container's resource settings for CPU Priority and Memory Limit.

That was my first idea, too, but allocating basically all my RAM (24GB to a 200 MB database) and giving highest CPU priority didn't help.

-- post merged: 19. Nov 2022 --

one-eyed-king said:
Could also be tweaks in an option group in one of the option files.
Before you ask: I have no idea where the files are located on DSM.

I tried that, too: I found where it was located for the package and copied all the relevant data to the docker version. No help.

one-eyed-king · 19. Nov 2022

Just to be sure: you mapped a host path to the container path /var/lib/mysql, right? Otherwise, the files would be written into the container's ephemeral file system, which might impact performance.

sawwee · 19. Nov 2022

one-eyed-king said:
Just to be sure: you mapped a host path to the container path /var/lib/mysql, right? Otherwise, the files would be written into the container's ephemeral file system, which might impact performance.

Yes, of course I did.

one-eyed-king · 19. Nov 2022

If the containerized and native mariadb instances use the same configuration, store the same data (and same indexes!) on the same physical volume, and are both fresh started (to avoid interference from cached query results), I would expect the containerized version to be marginally slower, but not by factor 2,5,

I doubt the native mariadb instance actually benefits from the nvme cache. A containerized mariadb will most definitely not benefit from it.

sawwee · 19. Nov 2022

one-eyed-king said:
If the containerized and native mariadb instances use the same configuration, store the same data (and same indexes!) on the same physical volume, and are both fresh started (to avoid interference from cached query results), I would expect the containerized version to be marginally slower, but not by factor 2,5,

I doubt the native mariadb instance actually benefits from the nvme cache. A containerized mariadb will most definitely not benefit from it.

Yes, indexes are the same, too.
Regarding the NVMe SSD Cache: Actually Synology recommends the SSD cache to database usage, so I guess it helps at least the native package. I don't really see why the containerized mariadb would not benefit from it - the data folder is mapped to the host - , but I'm not an expert in this topic, so I might be wrong.

one-eyed-king · 20. Nov 2022

I haven't thought about it as a file system level cache. If it is, it would make sense that both benefit from it. Like you, I am not an export on this topic either. But with Synology there is a strong tendency to modify open source code to support scenarios they need.

DSM 7.1 MariaDB on Docker is much slower than MariaDB package

Currently reading
DSM 7.1 MariaDB on Docker is much slower than MariaDB package

sawwee

one-eyed-king

fredbert

one-eyed-king

sawwee

one-eyed-king

sawwee

one-eyed-king

sawwee

one-eyed-king

Similar threads

Trending threads

Forum statistics

We value your privacy

DSM 7.1 MariaDB on Docker is much slower than MariaDB package

Currently reading DSM 7.1 MariaDB on Docker is much slower than MariaDB package

Similar threads

We value your privacy

Currently reading
DSM 7.1 MariaDB on Docker is much slower than MariaDB package