https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=235748
--- Comment #6 from [email protected] --- 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. _______________________________________________ [email protected] mailing list https://lists.freebsd.org/mailman/listinfo/freebsd-bugs To unsubscribe, send any mail to "[email protected]"
