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
