Thanks, Paul. The machines are running RH 9 (one instance) and Fedora Core 1 (multiple instances). It's not really a problem, so much as a curiosity about whether the one with more processes showing was using more resources.
Jim On Friday 30 April 2004 07:36 pm, Paul DuBois wrote: > 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: > > > >[EMAIL PROTECTED] 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]: > > > >[EMAIL PROTECTED] 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/[EMAIL PROTECTED]
