Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

phpÁ¬½Ómysql²âÊÔºÍÅäÖÃ


phpÁ¬½Ómysql²âÊÔ´úÂ룺
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
ÔËÐдúÂë³öÏÖ£ºCall   to   undefined   function   'mysql_connect()'… ʧ°Ü
°Ù¶ÈÕÒµ½½á¹ûÊÇPHP+MYSQL »·¾³Ã»ÅäÖúÃ, php5 µÄĬÈÏ mysql ÊǹرյÄ
½«php_mysql.dllºÍlibmysql.dllÎļþ¿½±´ÖÁc:\winnt\system32ÖУ¨ÎÒ©ÁËlibmysql.dll£©
ÕÒµ½php.iniÖеÄ;extension=php_mysql,È¥µôÇ°ÃæµÄ";"   ÖØÆô·þÎñÆ÷.


Ïà¹ØÎĵµ£º

php¿ª·¢web³ÌÐòµÄ¼¸µã¾­Ñé¼Ç¼

ÒÔǰ°Ñphpµ±×÷Ò»¸ö´¿´âµÄϵͳ±à³Ì½Å±¾£¬´Ó3Ô·ݿªÊ¼µÚÒ»´ÎʹÓÃphpдwebÍøÕ¾£¬Ò»µã¾­ÑéÔÚÕâÀï×ܽáһϡ£
Ò»£º´ò¿ª´íÎóÏÔʾºÍ´íÎóÈÕÖ¾¡£ÔÚphp.iniÖаÑdispaly_errorsÉèÖÃΪOn£¬»òÕßÔڽű¾¿ªÍ·ÓÃini_set('display_errors', 'On')¡£
¶þ£º
µ÷ÊÔ¹¤¾ß±Ø±¸¡£ÐèÒªÁ½ÖÖµ÷ÊÔ¹¤¾ß£ºµÚÒ»ÖÖÊǵ÷ÊÔphp½Å±¾µÄ£¬¾ÍÏñCµ÷ÊÔÆ÷ÄÇÑù¿ÉÒÔÔڽű¾ ......

ÔÚCENT OS ÉϱàÒë°²×°NGINX+PHP+MYSQL

NGINX°²×°ÊÖ¼Ç
 
Ò»¡¢»·¾³ÐèÒªºÍÏÂÔØ
1.       ÀûÓÃYUM°²×°±ØÐëµÄ³ÌÐò¿â
# yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-dev ......

mysqlÊý¾Ý¿âlimit²éѯÓÅ»¯

mysqlÊý¾Ý¿âlimit²éѯÓÅ»¯
 
MYSQLµÄÓÅ»¯ÊǷdz£ÖØÒªµÄ¡£ÆäËû×î³£ÓÃÒ²×îÐèÒªÓÅ»¯µÄ¾ÍÊÇlimit¡£mysqlµÄlimit¸ø·ÖÒ³´øÀ´Á˼«´óµÄ·½±ã£¬µ«Êý¾ÝÁ¿Ò»´óµÄʱºò£¬limitµÄÐÔÄܾͼ±¾çϽµ¡£
ͬÑùÊÇÈ¡10ÌõÊý¾Ý
select * from yanxue8_visit limit 10000,10 ºÍ
select * from yanxue8_visit limit 0,10
¾Í²»ÊÇÒ»¸öÊýÁ¿¼¶±ðµ ......

MySQLÊý¾Ý¿âÈÕÖ¾

MySQLÊý¾Ý¿âÈÕÖ¾
selectÈÕÖ¾
slow selectÈÕÖ¾
±ä¸üÈÕÖ¾
¶þ½øÖƱä¸üÈÕÖ¾(binlog)
¸æ¾¯ÈÕÖ¾
´íÎóÈÕÖ¾¡£
¿ÉÒÔÔÚmy.cnfÖÐÅäÖÃ
²ÎÊý
˵Ã÷
log
Îı¾selectÈÕÖ¾£¬¼ÇÏÂËùÓеÄMySQLµÄÃüÁî²Ù×÷£¬
log-update
Îı¾±ä¸üÈÕÖ¾
log-bin
Õâ¸ö¶¼ÖªµÀÁË£¬Êý¾Ý¿â¸´ÖƵÄʱºò±Ø±¸
binlog_cache_size
ÁÙʱ´æ·Åij´ÎÊÂÎñµÄSQL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ