Multiple My Sql processes
 

Hello,

I am running MySql 5.0.22 on Linux machine. When I try to see memory usage of y Sql I get to see number of processes running as follows. Memory usage for all these processes is same.

So are these processes sharing the memory or they take seperate memory.e.g. If 10 processes are running with 20 MB each then total memory usage is still 20MB or it will be 10*20MB=200 MB?
What is the logic behind number of processes or they are threads?

Snapshot of my server
mysqld_safe 1236
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072
mysqld 24072

Thanks.

Regards,
Veena

Likely most of them are threads. In Linux all threads are shown as processes which is rather annoying IMO.

You can verify they're using the SAME memory by checking comparing /proc/<pid>/maps. If they are threads they'll have exactly the same memory maps.