ÈçºÎÑ¡ÔñºÏÊʵÄmysql´æ´¢ÒýÇæ
ÔÚÑ¡Ôñ´æ´¢ÒýÇæÊ±£¬Ó¦¸ù¾ÝÓ¦ÓÃÌØµãÑ¡ÔñºÏÊʵĴ洢ÒýÇæ£¬¶ÔÓÚ¸´ÔÓµÄÓ¦ÓÃϵͳ¿ÉÒÔ¸ù¾Ýʵ¼ÊÇé¿öÑ¡Ôñ¶àÖÖ´æ´¢ÒýÇæ½øÐÐ×éºÏ¡£
ÏÂÃæÊdz£Óô洢ÒýÇæµÄÊÊÓû·¾³¡£
¡ñMyISAM:ĬÈϵÄMysql²å¼þʽ´æ´¢ÒýÇæ¡£Èç¹ûÓ¦ÓÃÊÇÒÔ¶ÁдºÍ²åÈë²Ù×÷ΪÖ÷£¬Ö»ÓкÜÉÙ¸üкÍɾ³ý²Ù×÷£¬²¢ÇÒ¶ÔÊÂÎñÍêÕûÐÔ£¬²¢·¢ÐÔÒªÇó²»ÊǺܸߣ¬ÄÇôѡÔñÕâ¸ö´æ´¢ÒýÇæ·Ç³£Êʺϵġ£MyISAMÊÇÔÚWeb£¬Êý¾Ý²Ö´¢ºÍÆäËûÓ¦Óû·¾³ÏÂ×î¾³£Ê¹ÓõĴ洢ÒýÇæÖ®Ò»
¡ñInnoDB:ÓÃÓÚÊÂÎñ´¦ÀíÓ¦ÓóÌÐò£¬Ö§³ÖÍâ¼ü¡£Èç¹ûÓ¦ÓöÔÊÂÎñµÄÍêÕûÐÔÓбȽϸߵÄÒªÇó£¬ÔÚ²¢·¢Ìõ¼þÏÂÒªÇóÊý¾ÝµÄÒ»ÖÂÐÔ£¬Êý¾Ý²Ù×÷³ýÁ˲åÈëºÍ²éѯÒÔÍ⣬»¹°üÀ¨ºÜ¶àµÄ¸üкÍɾ³ý²Ù×÷£¬ÄÇôinnoDB´æ´¢ÒýÇæÓ¦¸ÃÊDZȽϺÏÊʵÄÑ¡Ôñ¡£InnoDB´æ´¢ÒýÇæ³ýÁËÓÐЧµÄ½µµÍÓÉÓÚɾ³ýºÍ¸üе¼ÖµÄËø¶¨£¬»¹¿ÉÒÔÈ·±£ÊÂÎñµÄÍêÕûÌá½»£¨commit£©ºÍ»Ø¹ö£¨rollback£©£¬¶ÔÓÚÀàËÆ¼Æ·Ñϵͳ»òÕß²ÆÎñϵͳµÈ¶ÔÊý¾Ý׼ȷÐÔÒªÇó¸ßµÄϵͳ£¬InnoDBÊDZȽϺÏÊʵÄÑ¡Ôñ¡£
¡ñMEMORY£º½«ËùÓÐÊý¾Ý±£´æÔÚÄÚ´æÖУ¬ÔÚÐèÒª¿ìµÝ¶¨Î»¼Ç¼ºÍÆäËûÀàËÆÊý¾ÝµÄ»·¾³Ï£¬¿ÉÌṩ¼«¿ìµÄ·ÃÎÊ¡£MEMORY µÄȱÏÝÊǶԱíµÄ´óСÓÐÏÞÖÆ£¬Ì«´óµÄ±íÎÞ·¨cacheÔÚÄÚ´æÖУ¬Æä´ÎÊÇҪȷ±£±íµÄÊý¾Ý¿ÉÒÔ»Ö¸´£¬Êý¾Ý¿âÒì³£ÖÕÖ¹ºǫ́±íµÄÊý¾Ý¿ÉÒÔ»Ö¸´µÄ£¬MEMORYÖÐͨ³£ÓÃÓÚ¸üв»Ì«Æµ·±µÄС±í£¬ÓÃÓÚ¿ìËٵõ½·ÃÎʽá¹û¡£
¡ñMERGE£ºÓÃÓÚ½«Ò»ÏµÁеÈͬµÄMyISAM±íÒÔÂß¼·½Ê½×éºÏÔÚÒ»Æð£¬²¢×÷Ϊ¶ÔÏóÒýÓÃËûÃÇ£¬MERGE±íµÄÓеãÔÚÓÚ¿ÉÒÔÍ»ÆÆ¶Ôµ¥¸öMyISAM±í´óСµÄÏÞÖÆ£¬²¢Í¨¹ý½«²»Í¬µÄ±í·Ö²¼ÔÚ¶à¸ö´ÅÅÌÉÏ£¬¿ÉÒÔÓÐЧµÄ¸ÄÉÆMERGE±íµÄ·ÃÎÊЧÂÊ¡£Õâ¶ÔÓëÖîÈçÊý¾Ý²Ö´¢µÈVLDB»·¾³Ê®·ÖÊʺϡ£
Ïà¹ØÎĵµ£º
1¡¢Ð½¨¶¯Ì¬webÏîÄ¿¡£
2¡¢Ìí¼Ójar°ü
½«mysql jdbcÇý¶¯Ìí¼Óµ½tomcat°²×°Ä¿Â¼ÏµÄlibĿ¼¡£
3¡¢ÔÚMETA-INFÏÂÌí¼Ócontent.xmlÎļþ¡£ÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="true" crossContext="true">
<!-- Default set of monitored resources - ......
cmdÏÂÇл»µ½ mysql °²×°Ä¿Â¼
Àý
d:/mysql/bin
(Èç¹ûÓÃWAMP°²×°ÔòÊÇD:\wamp\bin\mysql\mysql5.1.30\bin)
ǰÌ᣺mysqlÓû§rootÃÜÂëΪ¿Õ.
Êä
Èë mysql -u root mysql
mysql> ״̬ÏÂÊäÈë
update user set password=password('ÐÂÃÜÂë') where user='root';
ȯ
ÏÔ
Quer ......
×î½üÊÕµ½·´À¡£¬ºÜ¶à¿Í»§Á¬MySql¶¼ÎÞ·¨ÕýÈ·°²×°¡£ÊÕµ½ÈÎÎñ£¬Òª½«MySql´òµ½²úÆ·ÖУ¬ºÍ²úÆ·Ò»Æð°²×°ºÍÐ¶ÔØ£¬À¿ª¼Ü
ʽ¸É°É£¬Ã»·¨×Ó¡£
Ñо¿Ò»Õ󣬷¢ÏÖ½«°²×°ºÃµÄMySqlÎļþ¼ÐCopyµ½ÆäËüµçÄÔÉÏ£¬ÔÙ½â¾öºÃÁ½¸öÎÊÌâÓ¦¸Ã¾Í¿ÉÒԺͰ²×°°æÒ»ÑùÕý³£Ê¹Óá£
1.Copyµ½ÁËÆäËüµçÄÔÉϵIJ»Í¬Ä¿Â¼£¬Ó¦¸ ......
Ê×ÏȽ¨Ò»¸ö¹¤³Ì£¬×¼±¸ºÃÒ»¸ölog4jµÄjar°üºÍÁ¬½ÓMySqLµÄÇý¶¯°ü¡£ÅäÖÃÈçÏ£º
ÐÞ¸Älog4j.propertiesÎļþ£º
######## #´Ë¾äΪ¶¨ÒåÃûΪstdoutµÄÊä³ö¶ËÊÇÄÄÖÖÀàÐÍ£¬¿ÉÒÔÊÇ
#org.apache.log4j.ConsoleAppender£¨¿ØÖÆÌ¨£©£¬
#org.apache.log4j.FileAppender£¨Îļþ£©£¬
#org.apache.log4j.DailyRollingFileAppender£¨Ã¿Ìì²úÉúÒ» ......
Ð¶ÔØMySQLÊý¾Ý¿â£º
ÏÈÍ£µôWINDOWSÀïµÄMySQL·þÎñ£»
ÓÃ360°²È«ÎÀʿǿÐÐɾ³ýMySQLÊý¾Ý¿â
½Ó×ÅÔÚ×¢²á±íÀïÇå³ýMySQL·þÎñ£º
1¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL Ŀ¼ɾ³ý
2¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL Ŀ¼ɾ³ý
3¡¢HKEY_ ......