[Bug 235748] Using swap with free memory available

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=235748

--- Comment #6 from info at 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.