We help IT Professionals succeed at work.

For single instance, many mysqld running, is it nornal?

geermu
geermu asked
on
seeing many mysqld running for single instance, something wrong?
Comment
Watch Question

yes. mysqld will start a number of processes in order to increase efficiency. Apache does the same thing.

Expert of the Quarter 2010
Expert of the Year 2010
Commented:
I assume you are using using Linux because Windows will only show one process.
Older linux kernels may show multiple processes when you use "ps" because of the way the kernel (mis)reports threads as processes.

mysqld is multiple threaded, which means it will perform multiple operations (e.g. multi-user queries) at the same time using multiple threads.
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.