Re: Unexpected RAM usage on MySQL
Posted by: Peter Brawley
Date: March 18, 2019 11:22AM

MySQL crashed out of mem when RAM use reached ~14GB and swap use reached ~27GB, though calculated max mem use is less than half that.

Main suspects seem to be too many unoptimised queries, 33k open files and too many created tmp tables going to disk. Re the latter, grow tmp_table_size, grow max_heap_size, diminish use of blobs, optimise queries, use db.table syntax to avoid db changes, use Heap tables in queries.

> app services are set to a nightly restart exactly to try to reclaim some memory ...

Okeh but the first sample was just 3h and perhaos wasn't peak time, could you do 12h including the busiest part of the day?

We're still missing something big. Could you run free -m and top say every 30 min from startup to see how and when usage max's out?

And a no-cost experiment, please run ...

wget mysqltuner.pl
perl mysqltuner.pl

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.