Yes, mysql 12940 0.0 27.3 324124 264672 ? S Aug06 0:12 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock mysql 12941 0.0 27.3 324124 264672 ? S Aug06 0:19 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock mysql 12942 0.0 27.3 324124 264672 ? S Aug06 1:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock mysql 13021 0.0 27.3 324124 264672 ? S Aug06 0:09 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
It's few of them. On Thu, Aug 14, 2008 at 2:38 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > r they all runing on the same port > > On 8/14/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> 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] >> > >> > >> >> >> -- >> Krishna Chandra Prajapati >> > > -- Krishna Chandra Prajapati
