Score:0

Why do I have a plethora of mysqld instances running?

au flag

I am running Ubuntu 22.04, which I recently installed from scratch. I use eclipse, apache2 primarily, browser. For the past few days, eclipse runs out of memory and halts. enter image description here When investigating, I discovered 30+ instances of mysqld running. I cannot filter a mysqld instance using ps aux but I can observe them using htop (see image).

30 instances seems out of order to me. Why should there be so many instances?

Artur Meinild avatar
vn flag
Please provide some output from `top`, `htop` or similar. Is it child processes/threads? This wouldn't surprise me.
Artur Meinild avatar
vn flag
FYI, I have a MariaDB instance that hardly does anything, and it has 10 userland child processes in `htop` (green colored).
pl flag
They're threads, it's fine, working as designed. `htop` breaks threads out in the list, `ps` doesn't.
Artur Meinild avatar
vn flag
I always hide "Userland" processes in `htop`, since they mostly distract more than they inform.
TheGeeko61 avatar
au flag
Thanks for all the insight. After following the link that @popey shared, I discovered that, indeed, all but 1 (we'll call it process) is a thread and htop shows them as children of the process.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.