Can you give us the output of `uname -a` from your mysql hosts? There's a difference if you are running a 2.4 kernel vs. 2.6 kernel (Linux).
In 2.4 kernel, try "ps -ef", and in 2.6 kernel, "ps -Lef". You may notice that PPID is the same for all PIDs except one, usually. -Paul On Thu, 2008-08-14 at 13:38 +0530, Krishna Chandra Prajapati wrote: > But some of the mysql server(mysql server on debian) shows only one mysql > process. > > On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David < > [EMAIL PROTECTED]> wrote: > > > I may be talking rubbish here, but is it not threading? > > > > I have seen Linux processes before create more than one PID etc when it > > needs to handle multiple requests. This may be not true for MySQL. > > However when looking at my test server is shows more than one. If you > > use a command called htop, similar to top but a little more visually > > easier, it has an option called tree. Which shows how one process spawns > > many when/where needed. > > > > Dave > > > > -----Original Message----- > > From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] > > Sent: 14 August 2008 05:57 > > To: mysql > > Subject: MYSQL PROCESS > > > > Hi all, > > > > I am running mysql on debian. I didn't understand why there is a lots of > > mysql process running. There should be only one mysql process running. > > Please help me that what should i do. Although there is no problem with > > mysql server. > > > > debian:~# ps axu > > USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND > > root 1 0.0 0.0 1400 472 ? S Jun03 0:03 init [2] > > root 2 0.0 0.0 0 0 ? S Jun03 0:01 [keventd] > > root 3 0.0 0.0 0 0 ? SN Jun03 0:06 > > [ksoftirqd_CPU0] > > root 4 0.0 0.0 0 0 ? S Jun03 2:25 [kswapd] > > root 5 0.0 0.0 0 0 ? S Jun03 0:00 [bdflush] > > root 6 0.0 0.0 0 0 ? S Jun03 1:15 > > [kupdated] > > root 99 0.0 0.0 0 0 ? S Jun03 6:52 > > [kjournald] > > root 250 0.0 0.0 0 0 ? S Jun03 0:00 [kcopyd] > > root 252 0.0 0.0 0 0 ? S Jun03 0:00 > > [kmirrord] > > root 265 0.0 0.0 0 0 ? S Jun03 0:00 > > [kjournald] > > root 431 0.0 0.0 0 0 ? S Jun03 0:00 [khubd] > > root 1247 0.0 0.0 1456 600 ? Ss Jun03 0:04 > > /sbin/syslogd > > root 1250 0.0 0.0 2084 444 ? Ss Jun03 0:00 > > /sbin/klogd > > root 1288 0.0 0.1 2432 1024 ? S Jun03 0:00 /bin/sh > > /usr/bin/mysqld_safe > > mysql 1325 0.0 27.1 324124 262548 ? S Jun03 0:31 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 1336 0.0 27.1 324124 262548 ? S Jun03 0:03 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 1337 0.0 27.1 324124 262548 ? S Jun03 0:00 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 1338 0.0 27.1 324124 262548 ? S Jun03 0:01 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 1339 0.0 27.1 324124 262548 ? S Jun03 16:49 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 1340 0.0 27.1 324124 262548 ? S Jun03 0:30 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 1369 0.0 27.1 324124 262548 ? S Jun03 6:10 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 1370 0.0 27.1 324124 262548 ? S Jun03 3:32 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 1380 0.0 27.1 324124 262548 ? S Jun03 1:16 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 1381 0.0 27.1 324124 262548 ? S Jun03 0:08 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 1384 0.0 27.1 324124 262548 ? S Jun03 5:33 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > root 1431 0.0 0.1 4736 1560 ? Ss Jun03 1:23 > > /usr/sbin/sshd > > > > . > > . > > . > > .. > > . > > > > mysql 3404 0.0 27.1 324124 262548 ? S Jun04 3:22 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 3456 0.0 27.1 324124 262548 ? S Jun04 3:06 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 3607 0.0 27.1 324124 262548 ? S Jun04 3:24 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 3685 0.0 27.1 324124 262548 ? S Jun04 2:25 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 5325 0.0 27.1 324124 262548 ? S Jun05 3:14 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 5352 0.0 27.1 324124 262548 ? S Jun05 3:21 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 5374 0.0 27.1 324124 262548 ? S Jun05 3:16 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 5378 0.0 27.1 324124 262548 ? S Jun05 3:06 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 5397 0.0 27.1 324124 262548 ? S Jun05 2:49 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 5398 0.0 27.1 324124 262548 ? S Jun05 2:51 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > mysql 5400 0.0 27.1 324124 262548 ? S Jun05 3:35 > > /usr/sbin/mysqld --basedir=/usr --datadir=/var/ > > > > > > -- > > Krishna Chandra Prajapati > > MySQL DBA, > > Ed Ventures e-Learning Pvt.Ltd. > > 1-8-303/48/15, Sindhi Colony > > P.G.Road, Secunderabad. > > Pin Code: 500003 > > Office Number: 040-66489771 > > Mob: 9912924044 > > URL: ed-ventures-online.com > > Email-id: [EMAIL PROTECTED] > > > > > > This message has been scanned for viruses by MailControl - (see > > http://bluepages.wsatkins.co.uk/?6875772) > > > > > > This email and any attached files are confidential and copyright protected. > > If you are not the addressee, any dissemination of this communication is > > strictly prohibited. Unless otherwise expressly agreed in writing, nothing > > stated in this communication shall be legally binding. > > > > The ultimate parent company of the Atkins Group is WS Atkins plc. > > Registered in England No. 1885586. Registered Office Woodcote Grove, > > Ashley Road, Epsom, Surrey KT18 5BW. A list of wholly owned Atkins Group > > companies registered in the United Kingdom can be found at > > http://www.atkinsglobal.com/terms_and_conditions/index.aspx > > > > Consider the environment. Please don't print this e-mail unless you really > > need to. > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- Paul Choi <[EMAIL PROTECTED]>
