Why do mysql processes take up a lot of RAM in idle time in my case?

E

Ernest Faizullin2016-06-18 23:41:41

linux

Ernest Faizullin, 2016-06-18 23:41:41

Only 2G of RAM and almost everything is always busy. Even when no one is online

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Saboteur, 2016-06-19
@erniesto77

View Mysql server settings, options *size=, for example myisam_sort_buffer_size
Mysql reserves space in memory during use, and if the space has been allocated, this memory is not returned back (so as not to waste CPU time on clearing and then re-allocation).
Memory can hang in idle time.
You can compare the used memory immediately after restarting mysql, and after performing any operations