Previous Thread
Next Thread
Print Thread
Rate Thread
#232053 01/06/2003 12:27 PM
Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
I have three instances of the MySQL daemon (mysqld) running on my server. Is that normal?

Sponsored Links
Joined: May 1999
Posts: 1,715
Addict
Addict
Joined: May 1999
Posts: 1,715
If you are running linux the top command shows each thread as a process, it's a quirk of top. It's really just one instance of the program running several threads.

Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
I see.

I also tried "ps". Here's partial output from "ps -fA", which shows the PIDs and PPIDs for the mysql stuff. So this all looks normal?

root 1 0 0 Jan05 ? 00:00:05 init

root 802 1 0 Jan05 ? 00:00:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/p

mysql 848 802 0 Jan05 ? 00:00:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-fil

mysql 875 848 0 Jan05 ? 00:00:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-fil

mysql 876 875 0 Jan05 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-fil

Joined: May 1999
Posts: 1,715
Addict
Addict
Joined: May 1999
Posts: 1,715
Yup, all seems fine. If anything, I would worry about the low number of processes. =]

The process owned by root is the real process, if you ever have to kill it by hand, that's the one to kill. Hopefully you should never have to do that though.

Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
Thanks

Sponsored Links
Joined: Oct 2000
Posts: 2,223
Veteran
Veteran
Offline
Joined: Oct 2000
Posts: 2,223
Dave, run ps -auxf

You'll see something like:

Code
<br />root      8739  0.0  0.0  2140  832 ?        S     2002   0:00 /bin/sh /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf<br />mysql     8754  0.0 10.3 204264 160680 ?     S     2002   2:30  \_ /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadi<br />mysql     8756  0.0 10.3 204264 160680 ?     S     2002   5:09      \_ /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --da<br />mysql     8757  0.0 10.3 204264 160680 ?     S     2002   1:47          \_ /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ <br />mysql    29439  0.0 10.3 204264 160680 ?     S    Jan03   0:00          \_ /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ <br />mysql    29440  0.0 10.3 204264 160680 ?     S    Jan03   0:00          \_ /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ <br />mysql    29441  0.0 10.3 204264 160680 ?     S    Jan03   0:00          \_ /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ <br />mysql    29442  0.0 10.3 204264 160680 ?     S    Jan03   0:00          \_ /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ <br />mysql    29443  0.0 10.3 204264 160680 ?     S    Jan03   0:00          \_ /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ <br />mysql    29444  0.0 10.3 204264 160680 ?     S    Jan03   0:00          \_ /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ <br />


safe_mysqld is the parent with a whole lotta children



Picture perfect penmanship here.
Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
Thanks, that's kewl.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Bill B
Bill B
Issaquah, WA
Posts: 87
Joined: December 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)