mysqld process hanging

[Csongor Fagyal]

Hi,

I am having a problem wiht MySQL 3.23.53
The logs tell all:

"
021211 18:40:42 mysqld started
/usr/libexec/mysqld: ready for connections

Number of processes running now: 1
mysqld process hanging, pid 6066 - killed
021211 19:14:43 mysqld restarted
/usr/libexec/mysqld: ready for connections

Number of processes running now: 1
mysqld process hanging, pid 18762 - killed
021211 19:28:55 mysqld restarted
/usr/libexec/mysqld: ready for connections

[repeated many times...]
"


This I do not like but I can live with.
What worries me is this:

"
/usr/local/libexec/mysqld: ready for connections

Number of processes running now: 2
mysqld process hanging, pid 22134 - killed
mysqld process hanging, pid 22134 - killed
021211 19:23:59 mysqld restarted
021211 19:23:59 Can't start server: Bind on TCP/IP port: Address already in use
021211 19:23:59 Do you already have another mysqld server running on port: 3307 ?
021211 19:23:59 Aborting
"

So sometimes my mysqld process hangs, and it is not (cannot be?) killed. If I du a fuser, I can see one mysqld process which I can kill -9 manually and then start the server.
Could you point me to the right direction?
- Why are my processes getting into a hanging state?
- Why aren't they killed and the server restarted then?

I am using RedHat 8 on a P3 without InnoDB. (I can give more info on the config if needed.)

- Csongor
ps: Yes, I know the port is 3307 and not 3306, but that is OK.


---------------------------------------------------------------------
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