Hi all.
Hi spam filter. SQL. Query.
MySQL versions 4.0.3, 4.0.4 and 4.0.5 all have the following problem...
When I use 'mysqladmin shutdown', 2 processes are left running and can
only be killed with a 'kill -9 <processid>'.
At midnight I run a script which backs up each database and then
restarts mysql (to get the '--log-updates' log to move to a new version)
and each morning I type:
root@vortex:/usr/local/mysql/var# ps ax | grep mysql
7859 ? S< 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe
--enable-loc
7895 ? S< 0:01 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
19304 ? S< 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe
--enable-loc
19340 ? S< 0:01 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
19342 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
19343 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
19344 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
19345 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
19346 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
19347 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
19348 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
19349 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
19350 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
20262 ? S< 0:06 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
20264 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
20297 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
20315 ? S< 0:01 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
20325 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
20327 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
20376 ? S< 0:00 /usr/local/mysql-4.0.5/libexec/mysqld
--basedir=/usr/
20417 pts/1 S 0:00 grep mysql
root@vortex:/usr/local/mysql/var# kill -9 7859 7895
root@vortex:/usr/local/mysql/var#
MySQL was compiled with the recommended flags (from the INSTALL-SOURCE
file). It's running on a stock Slackware 8.0 install with a 2.4.19 kernel.
Any clues? Anyone else having this problem?
--
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
