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]

Reply via email to