I have a droplet with 4 GB of memory and MySQL running on it, Apache and PHP.
I don’t understand why MySQL not releasing the memory and don’t stop to take more and more memory until reached the 4 GB and making the server crashed. I noticed when the server crash the disk was reading some data very fast (~150 Mb/s).
I have already tried to set innodb_buffer_pool_size to 64M but seems not to work.
Finnaly, I have add some swap space of 4 GB to avoid crashing for the moment.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.