mysql自动重启了

rongjun_cui

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

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

ruochen

检查你的应用程序，是不是打开的mysql连接没有及时关闭啊

另外修改open file和max_conn%看是不是有缓解效果

rongjun_cui

mysql数据库是自动关闭的，Number of processes running now: 1
mysqld process hanging, pid 18415 - killed
以上提示作何解释呢，没有人手动去杀进程啊！

ruochen

mysqld process hanging

Coolriver

可以适当的增大一点:table_cache=4096
open_files_limit =4096 重启一下MySQL

或是限制一下你的最大连接数。