[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: [MYSQL] Multiple instances of server starting
From:       Paul DuBois <paul () mysql ! com>
Date:       2004-04-30 23:36:23
Message-ID: p0602046dbcb892da39ac () [192 ! 168 ! 1 ! 34]
[Download RAW message or body]

At 18:02 -0400 4/30/04, jim wrote:
>Hi,
>
>I've just set up a mySQL server and, upon starting it, and running
>ps ax | grep mysql , it appears that there are multiple instances running:
>
>[root@db02 var]# ps ax | grep mysql
>  7808 pts/0    S      0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe
>--datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/db02.pid
>  7840 pts/0    S      0:00 /usr/local/mysql/bin/mysqld
>--defaults-extra-file=/usr/local/mysql/data/my.cnf
>--basedir=/usr/local/mysql
>--datadir=/usr/local/mysql/var --user=mysql
>--pid-file=/usr/local/mysql/var/db02.pid --skip-locking --port=3306
>--socket=/tmp/mysql.sock
>
>..and so on.  Ten instances.
>
>This should be the same config file (my.cnf) and same mysql.server start
>script (not that it should matter (??)) as a second machine, which does
>the right thing, and runs a single instance of [mysqld]:
>
>[root@emma root]# ps ax | grep mysql
>  1519 ?        S      0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe
>--datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/emma.pid
>  1552 ?        S    778:21 [mysqld]
>26985 pts/0    S      0:00 grep mysql

Very likely you're seeing threads being reported as processes on one
machine and not the other.  What operating system does each machine
run?

>
>Looking at this post to this list: http://lists.mysql.com/mysql/154832
>it seems that others have had this problem, but the answer there does
>not really explain why these two servers are behaving differently.

No, but it does explain that this is not really a "problem".

Well, I suppose it's possible to consider it a problem.  But if
so, it's an operating system problem, not a MySQL problem. :-)


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]