PHPʹÓÃÊý¾Ý¿âÓÀ¾ÃÁ¬½Ó·½Ê½²Ù×÷MySQLµÄÊÇÓë·Ç
PHP³ÌÐòÔ±Ó¦¸Ã¶¼ÖªµÀÁ¬½ÓMySQLÊý¾Ý¿â¿ÉÒÔʹÓÃmysql_pconnect£¨ÓÀ¾ÃÁ¬½Ó£©º¯Êý£¬Ê¹ÓÃÊý¾Ý¿âÓÀ¾ÃÁ¬½Ó¿ÉÒÔÌá¸ßЧÂÊ£¬µ«ÊÇʵ¼ÊÓ¦ÓÃÖÐÊý¾Ý¿âÓÀ¾ÃÁ¬½ÓÍùÍù»áµ¼Ö³öÏÖһЩÎÊÌ⣬ͨ³£µÄ±íÏÖ¾ÍÊÇÔÚ´ó·ÃÎÊÁ¿µÄÍøÕ¾ÉÏʱ³£·¢Éú¶Ï¶ÏÐøÐøµÄÎÞ·¨Á¬½ÓÊý¾Ý¿âµÄÇé¿ö£¬³öÏÖÀàËÆ£¢Too many connections in ...£¢µÄ´íÎóÌáʾÐÅÏ¢£¬ÖØÐÂÆô¶¯·þÎñÆ÷ÓÖÕý³£ÁË£¬µ«¹ý²»ÁËÒ»»á¶ùÓÖ³öÏÖͬÑùµÄ¹ÊÕÏ¡£¶ÔÓÚÕâЩÎÊÌâµÄ³ÉÒò£¬¿ÖžͲ»ÊÇÿ¸öÈ˶¼ÄÜ˵Çå³þµÄÁË£¬ËäÈ»PHPÎĵµÀïÓÐһЩÏà¹Ø×ÊÁÏ£¬µ«ÊǽâÊ͵IJ¢²»Ç³ÏÔÒ×¶®£¬ÕâÀïÎÒºñ×ÅÁ³Æ¤ÊÔͼ×öÒ»¸ö¼òµ¥µÄÌÖÂÛ£¬ËùÊö¹Ûµã²»¼ûµÃÈ«¶¼ÕýÈ·£¬»¶Ó´ó¼Ò·´À¡Òâ¼û¡£
Ê×ÏÈ¿´¿´Êý¾Ý¿âÓÀ¾ÃÁ¬½ÓµÄ¶¨Ò壺
ÓÀ¾ÃµÄÊý¾Ý¿âÁ¬½ÓÊÇÖ¸Ôڽű¾½áÊøÔËÐÐʱ²»¹Ø±ÕµÄÁ¬½Ó¡£µ±ÊÕµ½Ò»¸öÓÀ¾ÃÁ¬½ÓµÄÇëÇóʱ¡£PHP ½«¼ì²éÊÇ·ñÒѾ´æÔÚÒ»¸ö£¨Ç°ÃæÒѾ¿ªÆôµÄ£©ÏàͬµÄÓÀ¾ÃÁ¬½Ó¡£Èç¹û´æÔÚ£¬½«Ö±½ÓʹÓÃÕâ¸öÁ¬½Ó£»Èç¹û²»´æÔÚ£¬Ôò½¨Á¢Ò»¸öеÄÁ¬½Ó¡£Ëùν“Ïàͬ”µÄÁ¬½ÓÊÇÖ¸ÓÃÏàͬµÄÓû§ÃûºÍÃÜÂëµ½ÏàͬÖ÷»úµÄÁ¬½Ó¡£
PHPʹÓÃÓÀ¾ÃÁ¬½Ó·½Ê½²Ù×÷MySQLÊÇÓÐǰÌáµÄ£º¾ÍÊÇPHP±ØÐ밲װΪ¶àÏ̻߳ò¶à½ø³ÌWeb·þÎñÆ÷µÄ²å¼þ»òÄ£¿é¡£×î³£¼ûµÄÐÎʽÊǰÑPHPÓÃ×÷¶à½ø³ÌApache·þÎñÆ÷µÄÒ»¸öÄ£¿é¡£¶ÔÓÚÒ»¸ö¶à½ø³ÌµÄ·þÎñÆ÷£¬ÆäµäÐÍÌØÕ÷ÊÇÓÐÒ»¸ö¸¸½ø³ÌºÍÒ»×é×Ó½ø³Ìе÷ÔËÐУ¬ÆäÖÐʵ¼ÊÉú³ÉWebÒ³ÃæµÄÊÇ×Ó½ø³Ì¡£Ã¿µ±¿Í»§¶ËÏò¸¸½ø³ÌÌá³öÇëÇóʱ£¬¸ÃÇëÇó»á±»´«µÝ¸ø»¹Ã»Óб»ÆäËüµÄ¿Í»§¶ËÇëÇóÕ¼ÓõÄ×Ó½ø³Ì¡£ÕâÒ²¾ÍÊÇ˵µ±ÏàͬµÄ¿Í»§¶ËµÚ¶þ´ÎÏò·þÎñ¶ËÌá³öÇëÇóʱ£¬Ëü½«ÓпÉÄܱ»Ò»¸ö²»Í¬µÄ×Ó½ø³ÌÀ´´¦Àí¡£ÔÚ¿ªÆôÁËÒ»¸öÓÀ¾ÃÁ¬½Óºó£¬ËùÓв»Í¬×Ó½ø³ÌÇëÇóSQL·þÎñµÄºó¼ÌÒ³Ãæ¶¼Äܹ»ÖØÐÂʹÓÃÕâ¸öÒѾ½¨Á¢µÄ SQL·þÎñÆ÷Á¬½Ó¡£ËüʹµÃÿ¸ö×Ó½ø³ÌÔÚÆäÉúÃüÖÜÆÚÖÐÖ»×öÒ»´ÎÁ¬½Ó²Ù×÷£¬¶ø·Çÿ´ÎÔÚ´¦ÀíÒ»¸öÒ³ÃæÊ±¶¼ÒªÏò SQL ·þÎñÆ÷Ìá³öÁ¬½ÓÇëÇó¡£Ã¿¸ö×Ó½ø³Ì½«¶Ô·þÎñÆ÷½¨Á¢¸÷×Ô¶ÀÁ¢µÄÓÀ¾ÃÁ¬½Ó¡£PHP±¾Éí²¢Ã»ÓÐÊý¾Ý¿âÁ¬½Ó³ØµÄ¸ÅÄµ«ÊÇApacheÓнø³Ì³ØµÄ¸ÅÄî, Ò»¸öApache×Ó½ø³Ì½áÊøºó»á±»·Å»Ø½ø³Ì³Ø, ÕâÒ²¾ÍʹµÃÓÃmysql_pconnect´ò¿ªµÄµÄÄǸömysqlÁ¬½Ó×ÊÔ´¿ÉÒÔ²»±»ÊÍ·Å£¬¶øÊÇÒÀ¸½ÔÚÏàÓ¦µÄApache×Ó½ø³ÌÉϱ£´æµ½Á˽ø³Ì³ØÖС£ÓÚÊÇÔÚÏÂÒ»¸öÁ¬½ÓÇëÇóʱËü¾Í¿ÉÒÔ±»¸´Óá£Ò»Çп´ÆðÀ´Ëƺõ¶¼ºÜÕý³££¬µ«ÊÇÔÚApache²¢·¢·ÃÎÊÁ¿´óµÄʱºò£¬Èç¹ûʹÓÃmysql_pconnect£¬»áÓÉÓÚ֮ǰµÄ Apache×Ó½ø³ÌÕ¼ÓõÄMySQLÁ¬½ÓûÓÐclose, ºÜ¿ìʹMySQL´ïµ½×î´óÁ¬½ÓÊý£¬Ê¹µÃÖ®ºóµÄÇëÇó¿ÉÄܵò»µ½ÏìÓ¦¡£
ÉÏÃæµÄ²¿·ÖÎÄ×ÖÊÇÕª³×ÔPHPÎĵµ£¬¿´ÆðÀ´¿ÉÄÜ»¹ÊÇÓÐЩÎÄç§ç§µÄ²»ºÃÀí½
Ïà¹ØÎĵµ£º
Ò»¡¢MySQL5.1°²×°
´ò¿ªÏÂÔØµÄ°²×°Îļþ£¬³öÏÖÈçϽçÃæ£º
mysql°²×°Ïòµ¼Æô¶¯£¬µã»÷“next”¼ÌÐø
Ñ¡Ôñ°²×°ÀàÐÍ£¬ÓГTypical£¨Ä¬ÈÏ£©”¡¢“Complete£¨ÍêÈ«£©”¡¢“Custom£¨Óû§×Ô¶ ......
×î½üÒµÎñ·ÃÎÊÁ¿±È½Ï´ó£¬Êý¾Ýͳ¼ÆÀàµÄ²Ù×÷¶¼Çл»µ½mysqlµÄ±¸»úÉÏÈ¥ÁË£¬±¸»úµÄ¶Á²Ù×÷²»»áÓ°ÏìÖ÷¡¢±¸Ö®¼äµÄÈȱ¸µÄ
ÏÂÃæÁÐһϾßÌåµÄÔÀí£º
ÒªÏëÓúÃÒ»¸öϵͳ£¬Àí½âÆäʵÏÖÔÀíÊǷdz£ÖØÒªµÄÊÂÇ飬ֻÓÐÀí½âÁËÆäʵÏÖÔÀí£¬ÎÒÃDzÅÄܹ»Ñﳤ±Ü¶Ì£¬ºÏÀíµÄÀûÓ㬲ÅÄܹ»´î½¨³ö×îÊʺÏÎÒÃÇ×Ô¼ºÓ¦Óû·¾³µÄϵͳ£¬²ÅÄܹ»ÔÚϵͳʵʩ֮ºó¸üºÃµ ......
PDOÊÇÒ»¸ö“Êý¾Ý¿â·ÃÎʳéÏó²ã”£¬×÷ÓÃÊÇͳһ¸÷ÖÖÊý¾Ý¿âµÄ·ÃÎʽӿڣ¬ÓëmysqlºÍmysqliµÄº¯Êý¿âÏà±È£¬PDOÈÿçÊý¾Ý¿âµÄʹÓøü¾ßÓÐÇ׺ÍÁ¦£»ÓëADODBºÍMDB2Ïà±È£¬PDO¸ü¸ßЧ¡£Ä¿Ç°¶øÑÔ£¬ÊµÏÖ“Êý¾Ý¿â³éÏó²ã”ÈÎÖØ¶øµÀÔ¶£¬Ê¹ÓÃPDOÕâÑùµÄ“Êý¾Ý¿â·ÃÎʳéÏó²ã”ÊÇÒ»¸ö²»´íµÄÑ¡Ôñ¡£
PDO->beginTransa ......
<?php
$url="ÕâÀïдÇëÇóµØÖ·";//http://pmtest.webgame.com.cn/d.php
$data="ÕâÀïдpostÊý¾Ý";//Èç:a=123&b=456 ±íʾ´«Á½¸ö²ÎÊýaºÍb
$rfr="·¢³öÊý¾ÝµÄÒ³ÃæµÄµØÖ·";
$cookie="ÕâÀïдcookie";//Èç:PHPSESSIDs=123456; b=11212
/*
Àý×Ó:
$rfr="http://*.c ......
ǰһÕóÊÔÓà tokyo tyrant Åöµ½Ò»¸öÂé·³£¬
ÔÚphpÉÏÓÃmemcache½Ó¿Ú£¬È¡³öÊý¾ÝµÄʱºò£¬²»»á×Ô¶¯·´ÐòÁл¯¡£±ÈÈçÁËÒ»¸ö array(1,2,3,4,5)£¬³öÀ´¾ÍÊÇ 'a:5:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;}' ÁË¡£
ÓÃ
Wireshark ¸ú×ÙÁËһϣ¬·¢Ïֺͱê×¼memcached·µ»ØµÄÊý¾ÝÀï²îÒ»¸ö×Ö½Ú¡£È¥¿´ÁËÏ memcached
ÐÒ飬·¢ÏÖÕâ¸ö×Ö½ÚÊǸ ......