Is it possible to shutdown and restart mysql again, if its not in production.
regards anandkl On 8/14/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > 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] >
