mysqlÊý¾Ý¿â Too many connections
!;v|' I ³öÏÖÕâÖÖ´íÎóÃ÷ÏÔ¾ÍÊÇ mysql_connect Ö®ºóÍü¼Ç mysql_close
[=q1T3 µ±´óÁ¿µÄconnectÖ®ºó£¬¾Í»á³öÏÖToo many connectionsµÄ´íÎó
!sP{gi#= mysqlĬÈϵÄÁ¬½ÓΪ100¸ö
,AFu C< ¶øʲôÇé¿öÏ»á³öÏÖÕâÖÖ´íÎóÄØ£¿
-zgI_u9=EB Z]Cq3~l Õý³£µÄmysql_connect Ö®ºóµ÷Óà mysql_close()¹Ø±ÕÁ¬½Ó
OX!tsARC@ µ«ÔÚÁ¬½Ó´íÎóʱ£¬»áÕßmysql_real_query()³öÏÖ´íÎóÍ˳öʱ£¬¿ÉÄÜÍü¼Çmysql_close();
g-bK|6?yz ËùÒÔÔÚ³ÌÐòreturn ֮ǰһ¶¨ÒªÅжÏÊÇ·ñclose(),×îÎÈÍ׵ķ½·¨¾ÍÊÇÔÚдÈκκ¯Êýʱ¶¼Ö»ÓÐÒ»¸ö³ö¿Ú£¡
$k%2J9O »¹ÓпÉÒÔͨ¹ýÐÞ¸ÄmysqlÅäÖÃÎļþÀ´¼Ó´óÔÊÐíÁ¬½ÓµÄÊýÁ¿£¡
X`>i&I] n
M*%o- ÓÐʱÄãµÄ·þÎñÆ÷ÊǾ³£³öÏÖÕâÑùµÄ´íÎóÄØ£º
Qn.om=KDs@ ´íÎóÐÅÏ¢ÈçÏ£º
K7:)nv
E Can not connect to MySQL server
l<LI7Z]A 'Aq{UGN Error: Too many connections
NP3y+s Errno.: 1040
}rw8PZ9 kfY}S Similar error report has beed dispatched to administrator before.
9IfmW^0 l4YJ c ´Ó¹Ù·½ÎĵµÖªµÀlinuxÉÏÃæ±àÒë°²×°µÄmysqlĬÈϵÄÁ¬½ÓΪ100¸ö
XJ|
<? Îĵµ£º
http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html G@X% +$I oQVgyj. mysql¹Ù·½¸æËßÎÒÃÇÐèÒªÐÞ¸Ämax_connectionsµÄÖµ,ÄÇôÎÒÃÇÔõôȥÐÞ¸ÄÄØ£¿ÓÐÁ½ÖÖ·½·¨
A[{yCn`tM 1¡¢ÐÞ¸ÄÅäÖÃÎļþÎļþ
ZG8DIV\D7 ÐÞ¸Ä/etc/my.cnfÕâ¸öÎļþ£¬ÔÚ[mysqld] ÖÐÐÂÔömax_connections=N£¬Èç¹ûÄãûÓÐÕâ¸öÎļþÇë´Ó±àÒëÔ´ÂëÖеÄsupport-filesÎļþ¼ÐÖи´ÖÆÄãËùÐèÒªµÄ*.cnfÎļþΪµ½ /etc/my.cnf¡£ÎÒʹÓõÄÊÇmy-medium.cnf,ÖÐÐÍ·þÎñÆ÷ÅäÖá£ÀýÈçÎÒµÄ[mysqld]µÄÄÚÈÝÈçÏÂ
"&?kC2Y| [mysqld]
G}raA% port = 3306
,<P
vovg_ socket = /tmp/mysql.sock
z,p~z*4 skip-locking
={&j07,*a key_buffer = 160M
HBXOjr<,{ max_allowed_packet = 1M
;'@9[N9 table_cache = 64
} (73Syl# sort_buffer_size = 512K
N<VJ(20y net_buffer_length = 8K
d/kv|$XW read_buffer_size = 256K
&n:.k}/P read_rnd_buffer_size = 512K
uHzU-FZ|B myisam_sort_buffer_size = 8M
5Yq@;e max_connections=1000
"@0]G<H