Re: Unexpected RAM usage on MySQL
Posted by: Peter Brawley
Date: March 14, 2019 10:56AM

> I have tried twice again to execute the query you gave me, during the night
> after a fresh database restart, but still both times the database crashed.

Need to see what the mysql error log says about that.

> What I can say about the server being overloaded, is that it currently hosts
> a multitenant application in which each database is copied, under a different
> name, for each different customer.

Still missing something big ...

PID   USER  PR NI VIRT  RES   SHR  S %CPU %MEM TIME+   COMMAND 
21542 mysql 20 0  28.9g 14.5g 1980 S 0.0  93.5 2:20.33 mysqld

MySQL claiming 29G of virtual mem whilst asleep, yikes, and I've not been able to find what is doing that. Just a hunch, did you try turning off performance_schema?

> we do not use the Aria storage engine

Then innodb_buffer_pool_size should be 70-75% of RAM available to MySQL.



Edited 1 time(s). Last edit at 03/14/2019 10:56AM by Peter Brawley.

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.