[SOLVED] MySQL too many processes and Consuming RAM

Issue

I am suddenly having this problem of too many mysqld processes. When my PC starts the occupied RAM is around 2GB and then when I start XAMPP, slowly and gradually the RAM is occupied at around 14 GB. I currently am running on a 16 GB Memory and using Linux Mint. Can anyone help?

Solution

In the config file for MySQL, lower max_connections to, say, 20. That setting is what controls the list you are seeing.

Meanwhile, how much RAM can you give to MySQL? That is, how much RAM do you need to give to other processes? What is the value of innodb_buffer_pool_size? The buffer_pool grows until it reaches that value. It is very important for performance, so it is a tradeoff between performance and running out of RAM. Lowering the buffer_pool setting is the primary way to shrink MySQL.

(Questions on configuring MySQL belong in dba.stackexchange.com)

Answered By - Rick James

Answer Checked By - Katrina (WPSolving Volunteer)