LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices

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

Rep: Reputation: 0
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
 
Old 05-03-2007, 09:58 AM   #2
MensaWater
Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 6,028
Blog Entries: 5

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


Reply


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 11:22 AM
Multiple Processes Appearing! Riddick Suse/Novell 0 12-06-2004 06:27 PM
multiple mysqld processes lsimon4180 Linux - Software 2 10-03-2004 04:42 PM
multiple instances of processes? ararag Linux - Software 2 07-31-2004 11:27 AM
SQL: making queries from multiple tables ganninu Programming 1 01-08-2004 12:17 PM


All times are GMT -5. The time now is 07:40 PM.

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