我的MYSQL隔一天就会连接不上啊,我刚查了一下 NETSTAT -A 发现有N多的3306被链接了!
我该怎么处理啊! TCP dcan-89f74e1dfd:2676 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2677 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2683 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2686 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2696 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2700 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:sms-remctrl dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2706 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2707 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2715 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2717 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2721 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2722 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2723 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2724 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:msolap-ptp2 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2727 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2728 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2793 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2794 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2890 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2891 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2897 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2905 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2909 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2910 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2911 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2912 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2916 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2920 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2922 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2924 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2927 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2930 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3010 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3014 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3018 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3019 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:cifs dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3021 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3025 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3026 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3028 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3029 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3041 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3047 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3052 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3055 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3056 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3057 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3058 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3064 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3067 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3068 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3122 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3123 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3128 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:ms-rule-engine dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3134 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3176 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3177 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3178 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3183 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3185 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3236 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3239 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3241 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3253 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3255 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3258 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3259 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3260 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3263 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:1948 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2009 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2027 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2037 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2091 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2135 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2141 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2170 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2233 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2789 LAST_ACK
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:cifs ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3454 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3455 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3458 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3465 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3612 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3745 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:4400 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:4403 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:4549 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:4554 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:4825 LAST_ACK
TCP dcan-89f74e1dfd:3307 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3452 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3454 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3455 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3458 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3465 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3612 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3745 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:4400 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:4403 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:4549 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:4554 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:43958 dcan-89f74e1dfd:0 LISTENING
TCP dcan-89f74e1dfd:http 60.210.114.78:3466 TIME_WAIT
TCP dcan-89f74e1dfd:http 60.210.114.78:3467 ESTABLISHED
TCP dcan-89f74e1dfd:http 60.210.114.78:3469 TIME_WAIT
我该怎么处理啊! TCP dcan-89f74e1dfd:2676 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2677 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2683 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2686 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2696 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2700 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:sms-remctrl dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2706 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2707 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2715 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2717 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2721 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2722 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2723 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2724 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:msolap-ptp2 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2727 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2728 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2793 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2794 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2890 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2891 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2897 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2905 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2909 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2910 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2911 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2912 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2916 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2920 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2922 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2924 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2927 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:2930 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3010 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3014 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3018 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3019 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:cifs dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3021 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3025 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3026 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3028 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3029 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3041 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3047 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3052 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3055 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3056 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3057 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3058 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3064 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3067 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3068 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3122 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3123 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3128 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:ms-rule-engine dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3134 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3176 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3177 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3178 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3183 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3185 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3236 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3239 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3241 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3253 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3255 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3258 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3259 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3260 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3263 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:1948 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2009 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2027 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2037 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2091 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2135 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2141 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2170 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2233 TIME_WAIT
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:2789 LAST_ACK
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:cifs ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3454 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3455 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3458 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3465 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3612 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:3745 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:4400 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:4403 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:4549 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:4554 ESTABLISHED
TCP dcan-89f74e1dfd:3306 dcan-89f74e1dfd:4825 LAST_ACK
TCP dcan-89f74e1dfd:3307 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3452 dcan-89f74e1dfd:3306 TIME_WAIT
TCP dcan-89f74e1dfd:3454 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3455 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3458 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3465 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3612 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:3745 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:4400 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:4403 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:4549 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:4554 dcan-89f74e1dfd:3306 ESTABLISHED
TCP dcan-89f74e1dfd:43958 dcan-89f74e1dfd:0 LISTENING
TCP dcan-89f74e1dfd:http 60.210.114.78:3466 TIME_WAIT
TCP dcan-89f74e1dfd:http 60.210.114.78:3467 ESTABLISHED
TCP dcan-89f74e1dfd:http 60.210.114.78:3469 TIME_WAIT
你的程序里可能最后没有正常mysql_close()
如果是php代码,可以使用批处理脚本或者php脚本,定期杀死相应连接。
wait-timeout = 10