Hi, I run Debian 3.1 with kernel 2.6.8-1-686-smp, I wonder why why I do ps -aux, I only can see 1 MySQL process.
mysql 4227 0.0 64.6 1849456 1341912 pts/1 S Sep16 4:57 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql/ --user=mysql --pid-file=/var/lib/mysql//natuna.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock On my other machine, there are many processes. mysql 13648 0.1 57.7 1858672 1195352 ? S 20:44 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/tidore.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock mysql 13649 0.1 57.7 1858672 1195352 ? S 20:44 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/tidore.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock mysql 13650 0.1 57.7 1858672 1195352 ? S 20:44 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/tidore.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock ... I use the same my.cnf, and "show processlist" show me more than 1 process on both machines. Both of these machines are slave DBs. The one that only has 1 process tends to lag behind a lot. I am not sure that they are somewhat connected. Any idea? Thank you very much. --bk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]