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]
