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

mysqlÅäÖÃÎļþ£¨my.cnf)

ÏÖÓеķþÎñÆ÷ÊÇ4ºË£¬ÄÚ´æÎª4G£¬Êý¾Ý¿âֻʹÓÃinnodbÊý¾ÝÒýÇæ¡£Á´½ÓÊý¿ÉÄܱȽϸߣ¬ÏÈÉèÖÃΪ500°É£¬¶øÇÒÊý¾Ý¿âÖеÄÊý¾Ý²åÈë¡¢¸üкÍɾ³ý²Ù×÷»á·Ç³£µÄƵ·±¡£
ÓÐûÓиßÈ˰ïæÅäÖÃÒ»ÏÂmy.cnf

Õâ¸öûÓж¨Â۵쬾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¶øÇÒͬһӦÓò»Í¬ÔËÐн׶ÎÒ²¿ÉÄÜ´ó²»Ò»ÑùµÄ
¸ø¸öµØÖ·Äã²Î¿¼Ï°ɣº

http://thomaslee007.javaeye.com/blog/234244

¿´°ïÖúÊÖ²á°É¡£ buffer_size´óЩ£¬log²»ÓõĹصô£¬logÎļþÉèÖôóµã¡£ÆäËû²ÎÊý¿´ÄãÓ¦ÓÃÇé¿ö¶Ô±È×ÅÊֲῴןİɣ¬ÎÒÒ»°ãÐÞ¸ÃΪĬÈÏÖµµÄ2±¶»ò1/3

Á¬½ÓÊýͦ´ó°¡¡£¡£

ÏÖÓеķþÎñÆ÷ÊÇ4ºË£¬ÄÚ´æÎª4G£¬Êý¾Ý¿âֻʹÓÃinnodbÊý¾ÝÒýÇæ¡£
Á´½ÓÊý¿ÉÄܱȽϸߣ¬ÏÈÉèÖÃΪ500°É£¬¶øÇÒÊý¾Ý¿âÖеÄÊý¾Ý²åÈë¡¢¸üкÍɾ³ý²Ù×÷»á·Ç³£µÄƵ·±¡£
-----------------------------
¿É¼ûÄãʹÓÃINNODBÊÇÕýÈ·µÄ

×îºÃ²»Ê¹ÓÃÊÂÎï


Ïà¹ØÎÊ´ð£º

jspÁ¬½ÓmysqlÎÊÌâ

ÎÒµÄtomcat6.0.20 jdbcÇý¶¯ÊÇ5.1µÄ  ǰ´ÎÎÒÕÕ×ÅÍøÉϵÄÅäÖþͿÉÒÔÁË Ò²²»ÓÃŪʲô»·¾³±äÁ¿ Õâ´Î¾Í²»ÐÐÁË ÎÒŪÁË»·¾³±äÁ¿Ò²²»ÐÐ tomcatÏÂÃæÃ»ÓÐcomm ËùÒÔÎÒ°Ñmysql-connector-java-5.1.8-bin.jar·Åµ½D:\Tomcat 6. ......

ÈçºÎÓÃjspʵÏÖmysqlÊý¾Ý¿â±àÂ룿

ÔÚphpÖÐÓÃÕâ¾ä¾Í¿ÉʵÏÖ¶Ô¿Í»§¶Ë×Ö·û¼¯µÄÉèÖÃ....

mysql_query("set names gb2312")

ÇëÎÊÔÚjspÖÐÈçºÎʵÏÖÕâ¾ä¹¦ÄÜ£¿£¿£¿
jspÖУº
<%@page language="java" contentType=&q ......

javaÁ¬½Ómysql±»¾Ü¾ø

ÎÒÔÚ³ÌÐòÀïÃæÐ´ÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

mysqlÁ¬½ÓÎÊÌâ

Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ

ÃÜÂë´íÁ˰ɡ£

¸Õѧmysql,ÕÕ×ÅÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ