Re: High memory used by MySQL

[Peter Brawley]

> mysaladmin refresh then back
> with memory used to the limit

That flushes all table buffers, closes & reopens log files, so may momentarily reduce the memory load of those buffers too.

Handler_read_rnd_nxt/sec is 294K in this time period, much too high, you need to optimise the queries that are causing this debacle---turn the slow query log on, get after the queries causing that high number.

handler writes/sec 154k, > 20k/sec indicates inefficient code is stressing the system---your Inserts need optimising, see https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html