Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.28, 10.11.7, 11.4.4
-
None
-
CentOS Stream 9
Description
Hello all,
we keep having problems with one of our MariaDB instances consuming more and more swap since October 2023. You can see a cutout of the swap usage in the attached image.
As a result it crashed several times.
We already tried these things:
- increase of swap (server)
- increase of memory (server) + memory settings (MariaDB instance)
- patch to MariaDB version 10.4.28
- migration to new server (old server CentOS 5)
- major upgrade of MariaDB instance from version 10.4.28 to 10.11.7
- reduce of swappiness (server)
- several restarts (server + MariaDB instance)
- major upgrade of customer application (Pimcore 6.2.3 to 11.4.1)
- major upgrade of MariaDB instance from version 10.11.7 to 11.4.4
We are running out of ideas as the performance_schema does not help either and would be very thankful for support.
Kind regards
Sandra Attermeyer
What exactly did you get from the performance schema? Specifically, on 10.11 or 11.4, as performance schema in 10.4 it is indeed not very useful for investigating memory issues? I assume, you enabled memory-related instruments and set up a monitor which was reading from performance_schema.memory_xxx tables periodically, so where was the largest consumption?
Also, there have been cases when switching to a different memory allocator helped (see for example MDEV-35700). You didn't mention it among the things you tried, so maybe it's something to experimented with.