Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 05-02-2007, 12:05 AM   #1
LQ Newbie
Registered: May 2006
Posts: 6

Rep: Reputation: 0
Multiple My Sql processes


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


Old 05-03-2007, 08:58 AM   #2
LQ Guru
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, CoreOS, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 6,818
Blog Entries: 14

Rep: Reputation: 1076Reputation: 1076Reputation: 1076Reputation: 1076Reputation: 1076Reputation: 1076Reputation: 1076Reputation: 1076
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.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple threads vs Multiple processes deveraux83 Programming 1 05-11-2005 10:22 AM
Multiple Processes Appearing! Riddick SUSE / openSUSE 0 12-06-2004 05:27 PM
multiple mysqld processes lsimon4180 Linux - Software 2 10-03-2004 03:42 PM
multiple instances of processes? ararag Linux - Software 2 07-31-2004 10:27 AM
SQL: making queries from multiple tables ganninu Programming 1 01-08-2004 11:17 AM

All times are GMT -5. The time now is 07:00 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration