Hello guys,
After updating MariaDB to version 10.11.13 we started getting alerts from the server that the memory utilization is high, the MariaDB process takes almost all the memory on the server.
By MySQL Calculator, the database should take a maximum of 11GB, but in reality, it takes 15GB.
Also in the logs I found the note InnoDB: Memory pressure event disregarded; innodb_buffer_pool_size=9216m, innodb_buffer_pool_size_min=9216m
Has somebody had this issue? Know how to fix it?
Hello @Sergej_Reginevic,
Memory calculators are notoriously semi-accurate. They don’t take in to account what type of queries you will run. Some of the buffers are allocated many times during a single query execution. There’s no way for calculators to know this.
You can 1) lower max_connections, 2) lower innodb_buffer_pool_size, or 3) swap memory managers, and use jemalloc or tcmalloc (google is your friend)
Thank you for the answer.
But the question is, why didn’t we get this issue before?
What version were you before?
Reasons for increased memory usage:
- Newer MySQL/MariaDB will have (more) and larger internal structures to support all functionalities and memory management
- New default value changes that might have increased certain buffers/structures
- An increase in workload or change in query patterns that might trigger more frequent temporal memory structures (join buffer, sort buffer, temp tables)
- All of the above
Regards
The current version is 10.11.13. Before the update, we had version 10.11.11, and we didn’t have any issues with memory
@Sergej_Reginevic If the only thing truly changed is the version, then I would then suggest you open a bug report with MariaDB. Be sure to provide them before, and after evidence of the increase in memory. They might ask for things like flamegraphs, or other info to support the case.