MySQL swaps on system with more than enough RAM
Description
Environment
Dual AMD EPYC 7401 24-Core (128G RAM)
Ubuntu 16.04
Percona server 5.7
Smart Checklist
Activity
Julia Vural March 4, 2025 at 9:09 PM
It appears that this issue is no longer being worked on, so we are closing it for housekeeping purposes. If you believe the issue still exists, please open a new ticket after confirming it's present in the latest release.
Mischa ter Smitten September 12, 2019 at 7:47 AM
Using jemmalloc does not fix the problem for us
Lalit Choudhary September 10, 2019 at 9:06 AM
Hi Mischa,
Thank you for the update.
In this case, this bug is similar to upstream bug https://bugs.mysql.com/bug.php?id=83047
As a workaround to this issue, one of the users commented on upstream bug they managed to solve this issue by enabling a different memory allocation library called jemmalloc.
https://www.percona.com/blog/2017/01/03/enabling-and-disabling-jemalloc-on-percona-server/
You can try this as a workaround.
Mischa ter Smitten September 10, 2019 at 8:56 AM
Also I set innodb_buffer_pool_size to 75% of half of my RAM. Performance increased, but there is still swapping (but a little bit less)
Mischa ter Smitten September 10, 2019 at 8:54 AM
Also I'm already using flush_caches = 1 and innodb_numa_interleave = 1
Details
Details
Assignee
Reporter
Mischa ter SmittenUpstream Bug URL
Affects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Om my new dual AMD EPYC 7401 24-Core (128G RAM) MySQL starts swapping even after a restart with no data in memory.
Some more details in [this thread|https://dba.stackexchange.com/questions/246934/mysql-swaps-on-system-with-more-than-enough-ram]