mysqlÊý¾Ý¿â Too many connections
DAwqo.m ³öÏÖÕâÖÖ´íÎóÃ÷ÏÔ¾ÍÊÇ mysql_connect Ö®ºóÍü¼Ç mysql_close
A<\JQ µ±´óÁ¿µÄconnectÖ®ºó£¬¾Í»á³öÏÖToo many connectionsµÄ´íÎó
H"Klj_<dH0 mysqlĬÈϵÄÁ¬½ÓΪ100¸ö
hoT/KWD, ¶øʲôÇé¿öÏ»á³öÏÖÕâÖÖ´íÎóÄØ£¿
G&;j6<h l % aUsOB-RV Õý³£µÄmysql_connect Ö®ºóµ÷Óà mysql_close()¹Ø±ÕÁ¬½Ó
OEPa|rb µ«ÔÚÁ¬½Ó´íÎóʱ£¬»áÕßmysql_real_query()³öÏÖ´íÎóÍ˳öʱ£¬¿ÉÄÜÍü¼Çmysql_close();
^'p|!`: ËùÒÔÔÚ³ÌÐòreturn ֮ǰһ¶¨ÒªÅжÏÊÇ·ñclose(),×îÎÈÍ׵ķ½·¨¾ÍÊÇÔÚдÈκκ¯Êýʱ¶¼Ö»ÓÐÒ»¸ö³ö¿Ú£¡
|v[ Rp=?] »¹ÓпÉÒÔͨ¹ýÐÞ¸ÄmysqlÅäÖÃÎļþÀ´¼Ó´óÔÊÐíÁ¬½ÓµÄÊýÁ¿£¡
~Ph\Sbp v|ox!0:# ÓÐʱÄãµÄ·þÎñÆ÷ÊǾ³£³öÏÖÕâÑùµÄ´íÎóÄØ£º
l{VSb92f ´íÎóÐÅÏ¢ÈçÏ£º
kAM1TWbaVQ Can not connect to MySQL server
LkLN7| [TF8'jI0 Error: Too many connections
W$qd/'% Errno.: 1040
'cNKjL; T@%m7 |P Similar error report has beed dispatched to administrator before.
y<XlRTy[} L:M0pk{T ´Ó¹Ù·½ÎĵµÖªµÀlinuxÉÏÃæ±àÒë°²×°µÄmysqlĬÈϵÄÁ¬½ÓΪ100¸ö
k>E`s<3 Îĵµ£º
http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html x'Pi5NRE XT,#g-oi mysql¹Ù·½¸æËßÎÒÃÇÐèÒªÐÞ¸Ämax_connectionsµÄÖµ,ÄÇôÎÒÃÇÔõôȥÐÞ¸ÄÄØ£¿ÓÐÁ½ÖÖ·½·¨
4$,,Ppn 1¡¢ÐÞ¸ÄÅäÖÃÎļþÎļþ
.[DthEF ÐÞ¸Ä/etc/my.cnfÕâ¸öÎļþ£¬ÔÚ[mysqld] ÖÐÐÂÔömax_connections=N£¬Èç¹ûÄãûÓÐÕâ¸öÎļþÇë´Ó±àÒëÔ´ÂëÖеÄsupport-filesÎļþ¼ÐÖи´ÖÆÄãËùÐèÒªµÄ*.cnfÎļþΪµ½ /etc/my.cnf¡£ÎÒʹÓõÄÊÇmy-medium.cnf,ÖÐÐÍ·þÎñÆ÷ÅäÖá£ÀýÈçÎÒµÄ[mysqld]µÄÄÚÈÝÈçÏÂ
*QM~O'WhD [mysqld]
iRG?# " port = 3306
rOD1_X- socket = /tmp/mysql.sock
oUx[+Gnv skip-locking
nzX@:7g key_buffer = 160M
Fk^3a'/4KJ max_allowed_packet = 1M
3Dm8[o$Z table_cache = 64
K:yr-#(P/ sort_buffer_size = 512K
'ul\Q`N3 net_buffer_length = 8K
oJ*1>7[ J read_buffer_size = 256K
7Tf]:4Y" read_rnd_buffer_size = 512K
K&A;Z>l,v5 myisam_sort_buffer_size = 8M
}0=<6\+:` max_connections=1000
`GQ{*_-