php PDO Á´½Ó mysql ×î¼òµ¥ ʵÀý
define("DB_SERVER","127.0.0.1");
define("DB_PORT",3306);
define("DB_CATALOG","uab");
define("DB_USERID","root");
define("DB_PASSWORD","");
$dsn="mysql:host=".DB_SERVER.";port=".DB_PORT.";dbname=".DB_CATALOG;
self::$__PDO=new PDO($dsn, DB_USERID, DB_PASSWORD);
//support long connection
self::$__PDO=new PDO($dsn, DB_USERID, DB_PASSWORD, array(PDO::ATTR_PERSISTENT => true));
Ïà¹ØÎĵµ£º
½ñÌìÓöµ½ÁËÒ»¸ö¹ÖÎÊÌ⣬ÎÒÓÃ$fp=fopen("access_log.txt","ab")´ò¿ªÒ»¸öÎļþºó¿ªÊ¼ÍùÀïÃæÐ´Êý¾Ý£¬Ð´µÄÄÚÈÝÊÇ 'XXX\nXXX\n'£»
µ«ÊÇÆæ¹ÖµÄÊÇ ²»¹ÜÎÒÔõôÍùÀïÃæÐ´ ËûÊDz»»»ÐÐ,¼Çʱ¾Àï¼Ç¼µÄÊý¾Ý ¾ÍÊÇ 'xxx\nxxx\n'£¬
ºÜÊÇÄÕ»ð£¬È¥ÍøÉÏËѼ¯×ÊÁÏ£¬ÓеÄ˵¸Ä³É'\r\n'ʲôµÄ£¬½á¹ûÊÇд½øÈ¥ºó»¹ÊÇ 'xxx\r\nxx ......
×ªÔØÇë×¢Ã÷×÷Õߺͳö´¦
http://www.cnlinux.net
Ò»¡¢½éÉÜ
========
²âÊÔ»·¾³£º
Server1:ndbd 192.168.0.11
Server2:ndbd 192.168.0.12
Server3:mysqld --ndb-cluster 192.168.0.13 (ndbd_mgm ndbd_mgmdÒ²ÔÚ±¾»ú)
²Ù×÷ϵͳ¾ùΪ
RH ES3
kernel-2.4.21-9.EL
glibc-2.3.2-95.6
ËùÐèÈí¼þ°ü£º
mysql-max-5.0.22-lin ......
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Li ......
½ñÌ쿪¶àÒ»¸öÓ¦ÓÃÔÚ APP SERVER ÉÏ£¬±¨¸æÒ»¸ö´íÎó:
ERROR 1040 (00000): Too many connections
Õâµ¹ÊÇ´ÓÀ´Ã»Åöµ½¹ý£¬²»¹ýÔÚ console Ï¿ÉÒÔÓà root µÇ¼ £¨console ÏÂÓÃÆäËûÓû§Ò²²»¿ÉµÇ¼£¬Too many connections£©
mysql -uroot -p
mysql > show processlist;
...
ÕâÀïÁÐÁË100¸öÁ´½Ó£¡£¡ÆäÖÐÖ»ÓÐ2¸öÁ´½ÓÊÇQ ......
ÔÚphpÖз¢ËÍÓʼþ¿ÉÒÔÓÃ×Ô´øµÄmail()º¯Êý£¬µ«ÊÇÕâ¸öº¯Êý²»×ãµãºÜÃ÷ÏÔ£¬×îÖ÷ÒªÊÇÔÛ±¾»úÉÏûÓа²×°smtp·þÎñ¾Íû·¨Ê¹ÓÃmail()¡£
µ±È»ÏÖÔÚ»¹ÓÐphpÆäËûµÄ²å¼þ¡¢ÀàʲôµÄ£¬ÄÇЩҲÐí¹¦ÄÜÆëÈ«£¬¿ÉÊÇÍâ¼Ó¾Í¸Ð¾õ²»Ë¬¡£
ÄÇÆäËû°ì·¨µÄ»°£¬Ò»°ã»áÏ뵽ͨ¹ýSMTP·þÎñÆ÷À´·¢ËÍÓʼþ£¬µ«ÊÇÒ²»á²úÉúһϵÁÐÎÊÌ⣨¾ßÌåÓÐÄÄЩÎÊÌâ¿É¼û²Î¿¼×ÊÁÏ"ÎÞÐ ......