Hi all.
This is a re-post of a problem I originally had under MySQL-4.0.3, which
I thought might be due to me compiling with K6 flags, but I have
recompiled using i686 flags (and using MySQL-4.0.4) and still get stray
processes running:
bash-2.05# ps ax | grep mysql
11565 ? S< 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe
--enable-loc
11601 ? S< 0:01 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25789 ? S< 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe
--enable-loc
25825 ? S< 0:01 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25827 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25828 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25829 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25830 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25831 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25832 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25833 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25834 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25835 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27319 ? S< 0:04 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27334 ? S< 0:06 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27374 ? S< 0:02 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27492 ? S< 0:05 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27524 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27536 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27548 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27554 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27581 pts/15 S 0:00 grep mysql
bash-2.05#
I then do a:
bash-2.05# kill -9 11565 11601
which fixes it:
bash-2.05# ps ax | grep mysql
25789 ? S< 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe
--enable-loc
25825 ? S< 0:01 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25827 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25828 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25829 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25830 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25831 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25832 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25833 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25834 ? S< 0:01 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
25835 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27334 ? S< 0:07 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27374 ? S< 0:02 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27524 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27536 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27554 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27583 ? S< 0:05 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27588 ? S< 0:01 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27592 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27598 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27601 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27618 ? S< 0:04 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27654 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27784 ? S< 0:00 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27787 ? S< 0:01 /usr/local/mysql-4.0.4/libexec/mysqld
--basedir=/usr/
27796 pts/15 S 0:00 grep mysql
bash-2.05#
There is nothing in any of the logs about this (the hostname.err log or
the hostname.xxx log from --log-update). Does anyone know what is
causing this? I haven't noticed any corruption yet, but I still don't
feel very good about it. I have ensured all clients have closed all
connections before shutting MySQL down (this happens at midnight when I
do a mysqldump backup). Also the problem only happens about 50% of the
time - I haven't figured out any conditions which trigger it yet.
Thanks in advance!
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
