mysql数据库突然停了

rongjun_cui

Number of processes running now: 1
mysqld process hanging, pid 17363 - killed
091223 21:26:13  mysqld restarted
091223 21:26:13  Warning: Asked for 196608 thread stack, but got 126976
091223 21:26:13  Warning: setrlimit couldn't increase number of open files to more than 1024 (request: 1049586)
091223 21:26:13  Warning: Changed limits: max_connections: 1000  table_cache: 64
091223 21:26:13  Can't start server: Bind on TCP/IP port: Address already in use
091223 21:26:13  Do you already have another mysqld server running on port: 3306 ?
091223 21:26:13  Aborting

091223 21:26:13  /usr/sbin/mysqld: Shutdown Complete

091223 21:26:13  mysqld ended

justlooks

Do you already have another mysqld server running on port: 3306 ?

rongjun_cui

不是的，我想问的是为什么会mysqld process hanging, pid 17363 - killed
导致数据库restart,是因为一个pid被killed，所以导致数据库重启，但是数据库进程还没有完全释放
，所以才会出现Do you already have another mysqld server running on port: 3306 ，我的理解是这样的

justin033

应该是mysqld process hanging挂住，mysqld就尝试重启。但原来挂的mysqld还没把系统资源放开，如进程，端口等。所以尝试的mysqld就出错。

直接kill mysql pid吗？为什么不kill mysql connection呢？

cenalulu

netstat -anp  |grep 3306看下是哪个进程占用了。
可能是重启之前的清理工作没有清干净