ÓÐÊÖ¶¯ÅäÖùýmysqlµÄmy.iniÎļþÂð - PHP / »ù´¡±à³Ì
ÎÒÉϴΰ²×°·þÎñÆ÷ÉϵÄmysqlµÄʱºò£¬ÓÐÒ»¸öÑ¡ÏîÊÇ¡°Í¬Ê±Á¬½ÓmysqlÊý¾Ý¿âµÄÊýÄ¿¡±£¬ÎÒÑ¡ÁË¡°Online Transaction Processing(OLTP)£¨500¸ö×óÓÒ£©¡±£¬ÆäʵÎÒά»¤µÄ·þÎñÆ÷²Å×î¶àÊ®¼¸¸öÊý¾Ý¿â¶øÒÑ£¬¶øÇÒÔÚʹÓõÄÊý¾Ý¿âÒ²²Å²»µ½10¸ö¡£
ÎÒ·¢ÏÖÎÒÑ¡ÔñÁËOnline Transaction Processing(OLTP)Ñ¡Ïîºó£¬mysqld-nt.exeµÄÄÚ´æÊ¹ÓÃÂÊÇá¶øÒ׾ٵľʹﵽÁË140 000K£¬¶øÒÔǰÎÒÑ¡µÄÊÇ¡°Manual Setting£¨ÊÖ¶¯ÉèÖã¬×Ô¼ºÊäÒ»¸öÊý£©¡±£¬ÄÚ´æÊ¹ÓÃÂʾͺÜСµÄ£¬Ò»¸öÔ²»ÖØÆômysqlÒ²´ï²»µ½70 000K£¬
Àϰ岻ÈÃÎÒ֨װmysql£¬ÒòΪÒÔǰÓйýÒ»´Î֨װ£¬ºóÀ´ÆµÆµ³öÎÊÌ⣬ÈÃËûÅÂÁË£¬ËùÒÔÎÒÏë´ÓÅäÖÃÎļþÀïÐ޸IJÎÊý£¬µ«ÊDz»ÖªµÀ¸ÃÔõôÐ޸ģ¬ÓÐÅóÓÑÖªµÀô
ËÑË÷ Äã·þÎñÆ÷É쵀 my.ini my.cnf
Èç¹ûÄ㲻ȷÈÏÉúЧµÄÊÇÄĸö
Äã¾Í¶¼¸ÄÁË.
Õâ¸öÎļþÊǸöÎı¾Îļþ.ʹÓÃÆÕͨÎı¾±à¼Æ÷´ò¿ª±à¼±£´æ¾ÍÐÐÁË.
È»ºó ÖØÆôÄãµÄ MySQL
35434532312
windows:
ÔËÐгÌÐò²Ëµ¥mysqlÀïMySQL Server Instance Config Wizard¿ÉÒÔÖØÐÂÅäÖá£
£¨»òmysql°²×°Ä¿Â¼Ï£ºbin/MySQLInstanceConfig.exeÒ²¿ÉÒÔ£©
ÅäÖúóÖØÆðÏÂmysql¾Í¿ÉÒÔÁË¡£
linux:
http://club.topsage.com/thread-248297-1-1.html
°²×°µÄʱºò£¬ÔÚÅäÖÃÏòµ¼ÀïÃæ£¬Ò»°ãÑ¡ÔñManualSetting
ÒòΪÏòµ¼ÀïÃæ£¬¿ÉÒÔÅäÖõĶ«Î÷£¬¶¼ÊÇ´ÖÂÔµÄ
ÏêϸµÄ»¹ÊÇÒªÔÚmy.iniÀïÃæ
×î´óÁ¬½ÓÊý£¬¿ÉÒÔÔÚmy.iniµÄ
max_connections=100
°ÑÕâ¸ö¸Ä³ÉÆäËüÊý×Ö
ͬʱ£¬»¹ÓÐÕâЩҲҪ¸Ä
query_cache_size=15M
table_cache=256
myisam_sort_buffer_size=35M
key_buffer_size=23M
read_buffer_size=64K
sort_buffer_size=256K
Èç¹ûÄã²
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ÈçÌ⣬Ôõôд¸öheadÍ·²¿ ÈÃÒ³Ãæ»º´æ1ÐÇÆÚ¡£
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
Äã°ÑÀïÃæµÄʱ¼ä£¬¸Ä³Éµ±Ç°Ê±¼ä¼ÓÉÏÒ»¸öÐÇÆÚ
¼ÇµÃҪת»»³Égmtʱ¼ä
ÎÒÕâÑùдµÄ ²»ÖªµÀÐв»ÐС£
Ò»¸öÐ ......
PHPÖÐ ÉùÃ÷±äÁ¿µÄʱºòÒ»¸ö$¸úÁ½¸ö$µÄÇø±ð
±ÈÈç˵
$var="333"; ±íʾ±äÁ¿ÃûΪ$varµÄ±äÁ¿µÄֵΪ333
$var="myvar";$$var="333";±íʾ±äÁ¿ÃûΪ$myvarµÄ±äÁ¿µÄֵΪ333
ÕâÑù˵Çå³þÁËÂð£¿
......
Çë½Ì¸ßÊÖ°ïæ£¬session_start£¨£©·ÅÔÚÍⲿµÄÎļþÓà require »ò include °üº¬½øÀ´£¬ÇëÎÊÕâÑù×öºÏÀíÂ𣿣¿´úÂëÔËÐÐÊÇÕý³£µÄ£¬ÕâÑù×öºÏÀíÂ𣿣¿Çë¸ßÊÖÖ¸µã¡£¡£¡£¡£ лл····
require »ò include ......