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/> References: <bug-235748-227@https.bugs.freebsd.org/bugzilla/>
next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D235748 --- Comment #6 from info@murrawhip.net --- The following is from mysqltuner.pl which collates some of the internals fr= om mysql: [--] Up for: 41d 14h 10m 5s (1B q [366.392 qps], 28M conn, TX: 497G, RX: 15= 5G) [--] 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 me= mory 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 clu= ster has been pretty happy since FreeBSD 8. Thanks for the questions though, it's given me a lot of stuff I can research. --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-235748-227-fAtXbqMbDj>