Date: Thu, 14 Feb 2019 20:37:30 +0000 From: bugzilla-noreply@freebsd.org To: bugs@FreeBSD.org Subject: [Bug 235748] Using swap with free memory available Message-ID: <bug-235748-227-fAtXbqMbDj@https.bugs.freebsd.org/bugzilla/> In-Reply-To: <bug-235748-227@https.bugs.freebsd.org/bugzilla/>
index | next in thread | previous in thread | raw e-mail
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=235748 --- Comment #6 from info@murrawhip.net --- The following is from mysqltuner.pl which collates some of the internals from mysql: [--] Up for: 41d 14h 10m 5s (1B q [366.392 qps], 28M conn, TX: 497G, RX: 155G) [--] Physical Memory : 32.0G [--] Max MySQL memory : 22.5G [--] Other process memory: 0B [--] Total buffers: 19.1G global + 11.2M per thread (200 max threads) [--] P_S Max memory usage: 1G [OK] Maximum reached memory usage: 21.8G (68.07% of installed RAM) [OK] Maximum possible memory usage: 22.5G (70.51% of installed RAM) [OK] Overall possible memory usage with other process is compatible with memory available [OK] Highest usage of available connections: 64% (129/200) I previously neglected to include the per-connection buffers, but even with those, MySQL doesn't reckon it'll use more than 22.5G. I'm at a loss at what caused this. It's a production server so I can't try out 11.1 to confirm 11.2 isn't the issue, so all I can try is reverting the arc_max change. This cluster has been pretty happy since FreeBSD 8. Thanks for the questions though, it's given me a lot of stuff I can research. -- You are receiving this mail because: You are the assignee for the bug.help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-235748-227-fAtXbqMbDj>