H
H
HeBonpoc2014-08-16 17:31:35
MySQL
HeBonpoc, 2014-08-16 17:31:35

How much memory does one mysql connection eat?

I have a problem with hosting. There are always a bunch of mysqld processes hanging there that gobble up all the RAM. I have 12 of them and in total they eat 75% of the memory. When I kill 1 process, they all disappear, and then they all also appear together, and in 3 seconds. I looked at the server log and see that there were no requests at all during these 3 seconds.
Do you know what 1 mysqld is responsible for and why they breed like rabbits?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Sergey, 2014-08-16
Protko @Fesor

1) the total memory consumption does not depend much on the number of processes. It's a little more difficult there.
2) mysqld - mysql daemon that handles connections. If there was only one, it would be more likely that some connections would be served more slowly, therefore, several such worker processes are launched (the number is configured in the config). That is, if you want to reduce their number - change the settings and restart the service.

P
Puma Thailand, 2014-08-16
@opium

Strange behavior, mysql seems to work with threads, and not with processes, something is just strangely configured for you.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question