MySQL Server Error:Can't connect to MySQL server on 'localhost' (10048)

Question

我频繁刷新网页时会出现这个错误，是怎么回事，各位解救啊
max_connections，max_used_connections都是默认的1910和14，
另外，网页开始connect了mysql,最后没有在结束的地方mysql_close，这样有关系吗？关掉网页会自动关掉刚才的连接吗？

Answer 1

mysql在php中是执行完语句自动关闭连接，所以你不比关心

Answer 2

进数据库  show processlist 看看

Answer 3

Id User Host db Command Time State Info
10770778 root localhost:4223 szs_jihuadan Sleep 1757 \N
10775029 root localhost:4588 szs_jihuadan Sleep 47 \N
10775386 root localhost:1030 szs_jihuadan Sleep 104 \N
10775483 root localhost:1154 szs_jihuadan Sleep 1025 \N
10777102 root localhost:4572 szs_jihuadan Sleep 12 \N
10797776 root localhost:3962 szs_jihuadan Sleep 181 \N
10797860 root localhost:4048 szs_jihuadan Sleep 1213 \N
10806003 root localhost:4329 szs_jihuadan Sleep 56 \N
10806558 root localhost:4896 szs_jihuadan Sleep 82 \N
10863774 root localhost:3225 szs_jihuadan Sleep 12 \N
10980224 root localhost:2148 szs_jihuadan Sleep 8 \N
11073421 root localhost:1304 szs_jihuadan Sleep 181 \N
11074029 root localhost:1920 szs_gongjucailiaocangku Sleep 166 \N
11074573 root localhost:2470 szs_jihuadan Sleep 1258 \N
11075826 root localhost:3738 szs_jihuadan Sleep 119 \N
11075860 root localhost:3772 szs_jihuadan Sleep 390 \N
11076216 root localhost:4135 szs_jihuadan Sleep 163 \N
11077390 root localhost:1357 szs_gongjucailiaocangku Sleep 341 \N
11077611 root localhost:1580 szs_gongjucailiaocangku Sleep 243 \N
11078307 root localhost:2283 szs_jihuadan Sleep 33 \N
11078655 root localhost:2638 szs_jihuadan Sleep 1640 \N
11078836 root localhost:2820 szs_jihuadan Sleep 39 \N
11078846 root localhost:2830 szs_jihuadan Sleep 3036 \N
11080362 root localhost:4371 szs_gongjucailiaocangku Sleep 1658 \N
11086495 root localhost:2643 szs_jihuadan Sleep 84 \N
11087082 root localhost:3237 szs_jihuadan Sleep 11 \N
11087087 root localhost:3242 szs_gongjucailiaocangku Sleep 407 \N
11087207 root localhost:3364 szs_jihuadan Sleep 39 \N
11087326 root localhost:3484 szs_jihuadan Sleep 2692 \N
11087333 root localhost:3491 szs_jihuadan Sleep 53 \N
11092445 root localhost:4708 szs_jihuadan Sleep 27 \N
11093464 root localhost:1762 szs_jihuadan Sleep 54 \N
11093583 root localhost:1883 szs_gongjucailiaocangku Sleep 534 \N
11095716 root localhost:4050 szs_gongjucailiaocangku Sleep 1815 \N
11116050 root localhost:4813 szs_gongjucailiaocangku Sleep 533 \N
11116231 root localhost:4995 szs_jihuadan Sleep 103 \N
11128632 root localhost:1677 szs_jihuadan Sleep 794 \N
11135286 root localhost:4457 szs_jihuadan Sleep 51 \N
11135606 root localhost:4782 szs_jihuadan Sleep 50 \N
11143295 root localhost:4635 szs_jihuadan Sleep 113 \N
11145348 root localhost:2740 szs_jihuadan Sleep 53 \N
11146954 root localhost:4370 szs_jihuadan Sleep 1093 \N
11147120 root localhost:4540 szs_jihuadan Sleep 1620 \N
11147368 root localhost:4793 szs_jihuadan Sleep 874 \N
11148124 root localhost:1583 szs_jihuadan Sleep 350 \N
11150407 root localhost:3897 szs_gongjucailiaocangku Sleep 172 \N
11151223 root localhost:4729 szs_jihuadan Sleep 477 \N
11152419 root localhost:1968 szs_jihuadan Sleep 592 \N
11154623 root localhost:4200 szs_jihuadan Sleep 1303 \N
11159275 root localhost:4951 szs_jihuadan Sleep 35 \N
11180092 root localhost:2225 szs_jihuadan Sleep 127 \N
11189010 root MICHAEL:3536 \N Query 0 \N show processlist
11189014 root MICHAEL:3537 \N Sleep 4 \N

Answer 4

你的max_used_connections显然不是14啊。重新检查一下这个变量。

Answer 5

检查一下你的MYSQL的错误日志，看看有什么信息可以分析。