LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 10-03-2004, 03:56 AM   #1
lsimon4180
Member
 
Registered: Oct 2004
Location: Chicago, IL
Distribution: Fedora Core 2
Posts: 101

Rep: Reputation: 15
multiple mysqld processes


Hey all,

I am running Fedora2 with mysql 4.0.21-standard and im noticing strange things with mysql.

I origianlly had mysql 3.23 then tried to get 4.0.21 installed and finally did but mysql 4 isnt acting like it should.

If I type 'service mysqld start' to start it and then i type 'mysql' and im in!

But, i also typed 'ps -A |grep mysqld*' to see how many processes there are and i see about 10!

28515 tty1 00:00:00 mysqld_safe
28547 tty1 00:00:00 mysqld
28548 tty1 00:00:00 mysqld
28549 tty1 00:00:00 mysqld
28550 tty1 00:00:00 mysqld
28551 tty1 00:00:00 mysqld
28552 tty1 00:00:00 mysqld
28553 tty1 00:00:00 mysqld
28554 tty1 00:00:00 mysqld
28555 tty1 00:00:00 mysqld
28556 tty1 00:00:00 mysqld

i run killall mysqld a few times and it finally kils them all but i try to start the service again and the 10 processes appear.

another thing is. I dont see mysqld running when i type 'top' to view the processes?

Is there something different with 4.0.21-standard?

i looked at some threads that are related and I checked perms on most of the mysql files and they are owned my mysql...the only file that is owned by root is mysqld_safe.

any ideas?

Thanks,

lenny
 
Old 10-03-2004, 12:18 PM   #2
lsimon4180
Member
 
Registered: Oct 2004
Location: Chicago, IL
Distribution: Fedora Core 2
Posts: 101

Original Poster
Rep: Reputation: 15
Hey me again,

I actually see the process when i do a top:

28515 root 25 0 5648 1172 3948 S 0.0 0.3 0:00.01 mysqld_safe
28547 mysql 16 0 47684 11m 4516 S 0.0 2.7 0:00.05 mysqld
28548 mysql 16 0 47684 11m 4516 S 0.0 2.7 0:00.00 mysqld
28549 mysql 20 0 47684 11m 4516 S 0.0 2.7 0:00.00 mysqld
28550 mysql 22 0 47684 11m 4516 S 0.0 2.7 0:00.00 mysqld
28551 mysql 23 0 47684 11m 4516 S 0.0 2.7 0:00.00 mysqld
28552 mysql 20 0 47684 11m 4516 S 0.0 2.7 0:00.00 mysqld
28554 mysql 16 0 47684 11m 4516 S 0.0 2.7 0:00.03 mysqld

I would really like to know why there are so maany..are they child processes?

Lenny
 
Old 10-03-2004, 03:42 PM   #3
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
By default in later versions it starts more processes to improve performance. If your familiar with Apache, it does the same thing.
 
  


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 10:22 AM
bind mysqld to multiple IPs demian Linux - Software 0 05-03-2005 07:10 PM
Why are multiple instances of mysqld running? philpq Linux - Newbie 2 02-17-2005 03:01 PM
Multiple Processes Appearing! Riddick Suse/Novell 0 12-06-2004 05:27 PM
multiple instances of processes? ararag Linux - Software 2 07-31-2004 10:27 AM


All times are GMT -5. The time now is 10:52 AM.

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