Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÊÇÕýÈ·µÄ

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


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

jsp±¸·ÝmysqlÖ»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

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

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

mysql Ð޸IJéѯÊý¾ÝµÄÎÊÌâ

select time from table

time
2009-09-12 12
2009-09-12 13
2009-09-12 14
2009-09-12 15

Ôõô½« ²éѯµÄÊý¾Ý±äΪ
time
2009-09-12 12ʱ
2009-09-12 13ʱ
2009-09-12 14ʱ
......

MySql command line clientÎÊÌ⣬¼±£¡

mySql5.1µÄ mysql command line clientÃüÁî´°¿Úÿ´ÎÒ»µãËü,Ëü¾ÍÒ»ÉÁ¶ø¹ý,²»»áÏÔʾÁË.ÕâÊÇʲôÎÊÌâ?
ÔÚÄãµÄWINDOWSÉÏ£¬ÏȰ´ [¿ªÊ¼], È»ºó [ÔËÐÐ] ,ÊäÈë cmd È»ºó»Ø³µ

È»ºóÔÙÔÚÕâ¸öDOS´°ÌåÖУ¬ cd C:\Program ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ