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]
