Arek H wrote:
Nuno Pereira wrote:
Post here the result of a ps ajxf, but it seems to me that you didn't
started properly mysql. You should start MySQL with mysqld_safe, not
with mysqld.
Here it is
PPID PID PGID SID TTY TPGID STAT UID TIME COMMAND
0 1 0 0 ? -1 S 0 0:04 init [3]
1 2 1 1 ? -1 S 0 0:00 [keventd]
1 3 1 1 ? -1 SN 0 0:00 [ksoftirqd_CPU0]
1 4 1 1 ? -1 S 0 0:00 [kswapd]
1 5 1 1 ? -1 S 0 0:00 [bdflush]
1 6 1 1 ? -1 S 0 0:00 [kupdated]
1 10 1 1 ? -1 S< 0 0:00 [mdrecoveryd]
1 11 1 1 ? -1 S 0 0:00 [kjournald]
1 44 1 1 ? -1 S 0 0:00 [kjournald]
1 45 1 1 ? -1 S 0 0:00 [kjournald]
1 46 1 1 ? -1 S 0 0:00 [kjournald]
1 47 1 1 ? -1 S 0 0:00 [kjournald]
1 48 1 1 ? -1 S 0 0:00 [kjournald]
1 69 69 69 ? -1 Ss 0 0:02 /usr/sbin/syslogd
1 72 72 72 ? -1 Ss 0 0:00 /usr/sbin/klogd
-c 3 -x
1 132 132 132 ? -1 Ss 0 0:00 udevd
1 233 1 1 ? -1 S 0 0:00 [khubd]
1 696 696 696 ? -1 Ss 0 0:00 /sbin/dhcpcd -d
-t 10 eth0
1 943 943 943 ? -1 Ss 0 0:00 /usr/sbin/inetd
1 947 947 947 ? -1 Ss 0 0:06 /usr/sbin/sshd
947 16144 16144 16144 ? -1 Ss 0 0:00 \_ sshd: arek
[priv]
16144 16147 16144 16144 ? -1 S 1000 0:06 | \_ sshd:
[EMAIL PROTECTED]/0
16147 16148 16148 16148 pts/0 21532 Ss 1000 0:00 | \_ -bash
16148 16881 16881 16148 pts/0 21532 S 0 0:00 | \_
bash
16881 21532 21532 16148 pts/0 21532 R+ 0 0:00
| \_ ps ajxf
947 21108 21108 21108 ? -1 Ss 0 0:00 \_ sshd: arek
[priv]
21108 21111 21108 21108 ? -1 S 1000 0:00 \_ sshd:
[EMAIL PROTECTED]/1
21111 21112 21112 21112 pts/1 21132 Ss 1000 0:00 \_ -bash
21112 21123 21123 21112 pts/1 21132 S 0 0:00 \_
bash
21123 21132 21132 21112 pts/1 21132 S+ 0
0:00 \_ tail -f syslog
1 958 957 957 ? -1 S 0 0:00 /usr/sbin/crond
-l10
1 960 960 960 ? -1 Ss 2 0:00 /usr/sbin/atd -b
15 -l 1
1 963 963 963 ? -1 Ss 0 0:00 sendmail:
accepting connections
1 966 966 966 ? -1 Ss 25 0:00 sendmail: Queue
[EMAIL PROTECTED]:25:00 for /var/spool/clientmqueue
1 972 61 61 ? -1 S 0 0:00 /bin/sh
/usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var
972 999 61 61 ? -1 S 27 0:02 \_
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --use
999 1000 61 61 ? -1 S 27 0:01 \_
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql -
1000 1001 61 61 ? -1 S 27 0:00 \_
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys
1000 1002 61 61 ? -1 S 27 0:00 \_
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys
1000 1003 61 61 ? -1 S 27 0:00 \_
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys
1000 1004 61 61 ? -1 S 27 0:00 \_
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys
1000 1005 61 61 ? -1 S 27 0:00 \_
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys
1000 1006 61 61 ? -1 S 27 0:00 \_
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys
1000 1007 61 61 ? -1 S 27 0:00 \_
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys
1000 1008 61 61 ? -1 S 27 0:02 \_
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys
1 976 976 976 ? -1 Ss 0 0:00 /usr/sbin/gpm -m
/dev/mouse -t ps2
1 1010 1010 1010 tty1 1010 Ss+ 0 0:00 -bash
1 1011 1011 1011 tty2 1011 Ss+ 0 0:00 /sbin/agetty
38400 tty2 linux
1 1012 1012 1012 tty3 1012 Ss+ 0 0:00 /sbin/agetty
38400 tty3 linux
1 1013 1013 1013 tty4 1013 Ss+ 0 0:00 /sbin/agetty
38400 tty4 linux
1 1014 1014 1014 tty5 1014 Ss+ 0 0:00 /sbin/agetty
38400 tty5 linux
1 1015 1015 1015 tty6 1015 Ss+ 0 0:00 /sbin/agetty
38400 tty6 linux
1 17378 17378 17378 ? -1 Ss 0 0:00 /usr/sbin/httpd
17378 17379 17378 17378 ? -1 S 99 0:27 \_
/usr/sbin/httpd
17378 17380 17378 17378 ? -1 S 99 0:25 \_
/usr/sbin/httpd
17378 17381 17378 17378 ? -1 S 99 0:28 \_
/usr/sbin/httpd
17378 17382 17378 17378 ? -1 S 99 0:23 \_
/usr/sbin/httpd
17378 17383 17378 17378 ? -1 S 99 0:26 \_
/usr/sbin/httpd
17378 17384 17378 17378 ? -1 S 99 0:27 \_
/usr/sbin/httpd
17378 17417 17378 17378 ? -1 S 99 0:23 \_
/usr/sbin/httpd
17378 17418 17378 17378 ? -1 S 99 0:25 \_
/usr/sbin/httpd
17378 17458 17378 17378 ? -1 S 99 0:27 \_
/usr/sbin/httpd
17378 17462 17378 17378 ? -1 S 99 0:26 \_
/usr/sbin/httpd
You don't have any <Defunct> MySQL process in this case. Try to
replicate the case when you got the defunct processes, and post the
output like this, in tree, so we can see how lost hist child.
--
Nuno Pereira
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]