ÓÐÊÖ¶¯ÅäÖùý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
Èç¹ûÄã²
Ïà¹ØÎÊ´ð£º
ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,ÔÀ´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ......
¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁ˰ɣ¬¿ÉÒÔ¿´¿´
cookie Æ ......
ÈçÌ⣬Ôõôд¸öheadÍ·²¿ ÈÃÒ³Ãæ»º´æ1ÐÇÆÚ¡£
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
Äã°ÑÀïÃæµÄʱ¼ä£¬¸Ä³Éµ±Ç°Ê±¼ä¼ÓÉÏÒ»¸öÐÇÆÚ
¼ÇµÃҪת»»³Égmtʱ¼ä
ÎÒÕâÑùдµÄ ²»ÖªµÀÐв»ÐС£
Ò»¸öÐ ......
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
»òÕßÔÚjsÎļþÀïµ÷ÓÃphpÎļþдµÄseesion£¿
PHP¸ÕÈëÃÅѧϰ,ÓÑÇé¶¥Ò»¸ö
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
//echo '<script>alert("ok");< ......
sp ³ÌÐò
delimiter //
create procedure ma()
begin
declare i int default 0;
while i<11 do
set i=i+1;
select i;
end while;
end //
delimiter ;
1+2+...+9+10
ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û
/ ......