mysqlÊý¾Ý¿â Too many connections
Eb.;^=x ³öÏÖÕâÖÖ´íÎóÃ÷ÏÔ¾ÍÊÇ mysql_connect Ö®ºóÍü¼Ç mysql_close
RFG$X-.e µ±´óÁ¿µÄconnectÖ®ºó£¬¾Í»á³öÏÖToo many connectionsµÄ´íÎó
!g0cC.' mysqlĬÈϵÄÁ¬½ÓΪ100¸ö
iY.eJlfH ¶øʲôÇé¿öÏ»á³öÏÖÕâÖÖ´íÎóÄØ£¿
>v0 :qN7| X_70]^XL Õý³£µÄmysql_connect Ö®ºóµ÷Óà mysql_close()¹Ø±ÕÁ¬½Ó
a%~yol0wO7 µ«ÔÚÁ¬½Ó´íÎóʱ£¬»áÕßmysql_real_query()³öÏÖ´íÎóÍ˳öʱ£¬¿ÉÄÜÍü¼Çmysql_close();
=%h~/, ËùÒÔÔÚ³ÌÐòreturn ֮ǰһ¶¨ÒªÅжÏÊÇ·ñclose(),×îÎÈÍ׵ķ½·¨¾ÍÊÇÔÚдÈκκ¯Êýʱ¶¼Ö»ÓÐÒ»¸ö³ö¿Ú£¡
^&:'NR »¹ÓпÉÒÔͨ¹ýÐÞ¸ÄmysqlÅäÖÃÎļþÀ´¼Ó´óÔÊÐíÁ¬½ÓµÄÊýÁ¿£¡
1| xN%27> ~5t?C<wo ÓÐʱÄãµÄ·þÎñÆ÷ÊǾ³£³öÏÖÕâÑùµÄ´íÎóÄØ£º
A'DVJ9%xB ´íÎóÐÅÏ¢ÈçÏ£º
J#7(]!;F Can not connect to MySQL server
Uh+jt,RB` &] 3:D Error: Too many connections
MCAXt1sL&E Errno.: 1040
q$^<zY ,35Ag#va Similar error report has beed dispatched to administrator before.
D9ywg/Q91 sfC@*Y2XT ´Ó¹Ù·½ÎĵµÖªµÀlinuxÉÏÃæ±àÒë°²×°µÄmysqlĬÈϵÄÁ¬½ÓΪ100¸ö
b]dxlj}
< Îĵµ£º
http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html )_O.{$
to @}G|R\2P mysql¹Ù·½¸æËßÎÒÃÇÐèÒªÐÞ¸Ämax_connectionsµÄÖµ,ÄÇôÎÒÃÇÔõôȥÐÞ¸ÄÄØ£¿ÓÐÁ½ÖÖ·½·¨
hgj0tIi/ 1¡¢ÐÞ¸ÄÅäÖÃÎļþÎļþ
7z>+w ÐÞ¸Ä/etc/my.cnfÕâ¸öÎļþ£¬ÔÚ[mysqld] ÖÐÐÂÔömax_connections=N£¬Èç¹ûÄãûÓÐÕâ¸öÎļþÇë´Ó±àÒëÔ´ÂëÖеÄsupport-filesÎļþ¼ÐÖи´ÖÆÄãËùÐèÒªµÄ*.cnfÎļþΪµ½ /etc/my.cnf¡£ÎÒʹÓõÄÊÇmy-medium.cnf,ÖÐÐÍ·þÎñÆ÷ÅäÖá£ÀýÈçÎÒµÄ[mysqld]µÄÄÚÈÝÈçÏÂ
F`D9Zfd [mysqld]
sWW\bK0B4 port = 3306
g _x\T+= socket = /tmp/mysql.sock
`7>K1slQ}S skip-locking
w}b<D#0XC key_buffer = 160M
Fi k@hu max_allowed_packet = 1M
{"\q(R0 table_cache = 64
:28@J?jjO sort_buffer_size = 512K
zCM^r <Kr net_buffer_length = 8K
@6[x%j/!bt read_buffer_size = 256K
Cd9t{pQD4 read_rnd_buffer_size = 512K
>T(M0Tkt myisam_sort_buffer_size = 8M
=yo=q)W max_connections=1000
0vcET(