- 论坛徽章:
- 0
|
这是一台mysql服务器,用ps -ef命令看到如下显示,不太清楚为什么这样显示:
root 3263 1 0 17:01 ? 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --user=mysql
mysql 6193 3263 0 19:20 ? 00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6194 6193 0 19:20 ? 00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6195 6194 0 19:20 ? 00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6196 6194 4 19:20 ? 00:00:10 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6197 6194 5 19:20 ? 00:00:11 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6198 6194 2 19:20 ? 00:00:05 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6199 6194 3 19:20 ? 00:00:06 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6200 6194 4 19:20 ? 00:00:10 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6205 6194 2 19:20 ? 00:00:05 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6206 6194 4 19:20 ? 00:00:08 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6207 6194 3 19:20 ? 00:00:08 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
mysql 6208 6194 0 19:20 ? 00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysq
init进程开了3263,3263开了6193,6193开了6194,6194开了一系列6195,6196,6197,6198,6199,6200进程。不太清楚为什么会这样显示。
感觉比较正常的情况,另一台mysql服务器看到的ps -ef的结果:
root 10985 1 0 Sep10 ? 00:00:00 /bin/sh /usr/local/workspace/mysql/bin/mysqld_safe --user=mysql
mysql 11014 10985 1 Sep10 ? 1-02:35:32 /usr/local/workspace/mysql/libexec/mysqld --basedir=/usr/local/workspace/mysql --datadir=/data/mysql/var --user=mysql --pid-file=/data/mysql/var/svr210i.rakoo.jp.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
这台的init开了10985(启动mysql服务时的进程),10985开了11014(用来处理连接请求)。
请问为什么会产生第一种现象?
一些共识:mysql是单进程多线程模式。虽然用ps命令看到的很多个进程pid,而其实mysql内部是使用线程模式处理。 |
|