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 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. Can anyone help? Thanks very much! -Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]