Mysql server is crashing everying 5-10 min ..
Below is what I noticed a very strange fact that my mysql server crashes every few minutes..
look at these log lines:
040809 18:50:14 Warning: Asked for 196608 thread stack, but got 126976
040809 18:50:14 Can't start server: Bind on TCP/IP port: Address already in use
040809 18:50:14 Do you already have another mysqld server running on port: 3306 ?
040809 18:50:14 Aborting
040809 18:50:14 mysqld: Shutdown Complete
--------------------------------------------
Then after some time:
040809 18:54:03 Warning: Asked for 196608 thread stack, but got 126976
040809 18:54:03 Can't start server: Bind on TCP/IP port: Address already in use
040809 18:54:03 Do you already have another mysqld server running on port: 3306 ?
040809 18:54:03 Aborting
040809 18:54:03 mysqld: Shutdown Complete
-------------------------------------------------------
**IMP :This error of some thread stack is related with OS version I think ..
I have some hint for this error:
Late last year early this year the default thread stack was changed
from 64K to 192K in MySQL. This message is letting you know that the 192K
thread stack was requested and it received about 125K. From my memory RH
8.0 and other kernels needed about 128K to do core dumps properly so the
value was changed. You need to determine wheter this is a problem for
your configuration or not.
The value is to let you know what is happening.
I use mysql 4.0.20 for server ,and my.cnf is already optimized.
But not sure where to look for this error?
