¹ØÓÚMYSQLµ¥±í´æ´¢ÎÊÌâ
Êý¾Ý¿âÒýÇæʹÓÃMYISAM
ÀýÈç±íÃû£ºLOG¡¡Ã¿Ìì»á²úÉú400Íò×óÓҵļǼ
ÈÕ»ýÔÂÀÛÊý¾ÝÁ¿»á·Ç³£Ö®³è´ó
ËùÒÔ¿¼Âǵ½Õâµã
ÎÒÏëÁËÁ½¸ö·½°¸
1¡¢Ã¿Ìì²úÉúÒ»¸ö±í£¬ÀàËÆLOG20091010¡¢LOG20091011
2¡¢Ã¿Ì콫×òÌìµÄÊý¾Ý±¸·Ýµ½LOGBACKÏ£¬È»ºóɾ³ýLOG±íÖеÄ×òÌìµÄÊý¾Ý£¬Ò»ÖܶÔLOG±í×öOPTIMIZE
ÓÐÆäËû¸üºÃµÄ·½°¸Âð£¿
Ò»°ã»á²ÉÓÃÄãµÄµÚ¶þÖÖ·½°¸¼´¡£ Á½LOG±í log_1day, log_history £¬µ«Èç¹ûÄãµÄ²éѯÈç¹û´ó¶àÊÇ»ùÓÚʱ¼äÀ´²éµÄ£¬ÔòÓ¦¸Ã½« log_history ÒÔÈÕÆÚÀ´½¨³É·ÖÇø±í¡£
logÈÕÖ¾ÓÈÆäÊÇBIN-LOG ÿ´Î·þÎñÆô¶¯¶¼»á²úÉúÒ»¸öÐеÄlogÈÕÖ¾ Ïñflush logs µÈ²Ù×÷Ò²ÓÐͬÑùµÄЧ¹û
ËùÒÔÈÕ»ýÊý¾ÝÁ¿»áºÝÅÓ´ó
ÎÒÃDzÉÈ¡µÄ´ëÊ©²»ÊÇÍ£Ö¹log ¶øÊǶ¨ÆÚɾ³ýlogÈÕÖ¾
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
Java code:
public static void load(String filename) {
try {
@SuppressWarnings("unused")
Process process = Runtime.getRuntime().exec(
......
ÎÒÔÚ³ÌÐòÀïÃæдÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......
mySql5.1µÄ mysql command line clientÃüÁî´°¿Úÿ´ÎÒ»µãËü,Ëü¾ÍÒ»ÉÁ¶ø¹ý,²»»áÏÔʾÁË.ÕâÊÇʲôÎÊÌâ?
ÔÚÄãµÄWINDOWSÉÏ£¬ÏÈ°´ [¿ªÊ¼], È»ºó [ÔËÐÐ] ,ÊäÈë cmd È»ºó»Ø³µ
È»ºóÔÙÔÚÕâ¸öDOS´°ÌåÖУ¬ cd C:\Program ......