Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
* HanIRCÀÇ #coffeenix ¹æ
[ Àåºñ ¹× ȸ¼± ÈÄ¿ø ]
HOME > µ¥ÀÌÅͺ£À̽º(database) > MySQL µµ¿ò¸»
°Ë»ö : »çÀÌÆ® WHOIS À¥¼­¹ö Á¾·ù


  MySQL 5.1.x¿¡¼­ Event Scheduler ·Î±× ÀÛ¼ºÀÏ : 2009/03/10 19:22
 
  • ±Û¾´ÀÌ : ÁÁÀºÁøÈ£ ( http://coffeenix.net/ )
  • Á¶È¸¼ö : 10647
          [ ÀÌÀüÈ­¸é / ¼öÁ¤ ]   ºñ¹Ð¹øÈ£ :     Àμâ¿ë È­¸é
      Á¦  ¸ñ : MySQL 5.1.x¿¡¼­ Event Scheduler ·Î±×
    ÀÛ¼ºÀÚ : ÁÁÀºÁøÈ£(truefeel, http://coffeenix.net/ )
    ÀÛ¼ºÀÏ : 2009.3.10(È­)

    MySQL 5.1Àº ¸®´ª½º/À¯´Ð½ºÀÇ cronó·³ ÁÖ±âÀûÀ¸·Î ¸í·ÉÀ» ½ÇÇàÇÏ´Â ÇüÅÂÀÇ Event Scheduler(À̺¥Æ® ½ºÄÉÁì·¯) ±â´ÉÀ» Á¦°øÇÑ´Ù. MySQL ÀÚü ³»ºÎ ±â´É¸¸À¸·Î ƯÁ¤ ½Ã°£´ë, ÀÏÁ¤ÇÑ ÁÖ±â·Î SQL¹®À» ½ÇÇàÇÒ ¼ö ÀÖ´Â °ÍÀÌ´Ù. ÇÏÁö¸¸ 5.1.30 ÀÌÇÏ ¹öÀü¿¡¼­´Â ¼º°øÀûÀ¸·Î ½ÇÇàµÈ À̺¥Æ® ½ºÄÉÁì·¯±îÁö ·Î±×·Î ³²±â´Â ¹®Á¦°¡ ÀÖ´Ù. ¸¸¾à ¸Å 5 ÃÊ°£°ÝÀ¸·Î ½ÇÇàµÇ´Â ½ºÄÉÁì·¯¶ó¸é ÇÏ·ç¸é ¹«·Á 34,560°³(86400ÃÊ/5ÃÊ*2ÁÙ)ÀÇ ·Î±×°¡ 'È£½ºÆ®¸í.err'ÆÄÀÏ¿¡ ³²°Ô µÈ´Ù.

     
    090212 13:57:26 [Note] Event Scheduler: Loaded 0 events
    090212 13:57:26 [Note] Event Scheduler: scheduler thread started with id 1
    090217 15:05:09 [Note] Event Scheduler: [__ID__@192.___.___.__%].[__DB__.__TABLE__] started in thread 12021126.
    090217 15:05:09 [Note] Event Scheduler: [__ID__@192.___.___.__%].[__DB__.__TABLE__] executed successfully in thread 12021126.
    090217 15:05:39 [Note] Event Scheduler: [__ID__@192.___.___.__%].[__DB__.__TABLE__] started in thread 12021735.
    090217 15:05:39 [Note] Event Scheduler: [__ID__@192.___.___.__%].[__DB__.__TABLE__] executed successfully in thread 12021735.
     


    'MySQL 5.1 Reference Manual' Áß¿¡ 'C.1.2. Changes in MySQL 5.1.31 (19 January 2009)' ( http://dev.mysql.com/doc/refman/5.1/en/news-5-1-31.html )À» º¸¸é ´ÙÇàÀÌ 5.1.31 ¹öÀüºÎÅÍ´Â ¼º°øÀûÀ¸·Î ½ÇÇàµÈ °æ¿ì´Â ´õÀÌ»ó ³²±âÁö ¾Ê´Â´Ù.

     
    The Event Scheduler no longer logs ¡°started in thread¡± or ¡°executed¡± successfully messages to the error log. (Bug#38066)
     

      Ä¿ÇǴнº Ä«Æä ÃÖ±Ù ±Û
    [03/24] Youtube òÁ&#2
    [03/20] Re: ¿Â¶óÀΰÔÀÓÀÇ Á¾ÁÖ±¹ ´ëÇѹα¹
    [03/20] ½ÇÁ¦&#4
    [03/18] ±¹°¡&#5
    [10/20] Cross Compiler ±ò
    [07/14] SSL ¬¡¬°
    [04/26] Re: µµ½ºÈ­¸é ¿ø°ÝÁ¶Á¾ ¿©ºÎ
    [04/25] µµ½ºÈ­¸é ¿ø°ÝÁ¶Á¾ ¿©ºÎ
    [10/30] Cshell¿¡¼­ ³­¼ö ¼³Á¤
    [10/23] °øÇ×öµµÁÖ½Äȸ»ç SE ±¸ÀÎ Ëì
    [01/26] Re: wgetÀ¸·Î ´Ù¸¥¼­¹ö¿¡ÀÖ´Â µð·ºÅ丮¸¦ °¡Á®¿À·Á°íÇÕ´Ï´Ù.
    [01/25] wgetÀ¸·Î ´Ù¸¥¼­¹ö¿¡ÀÖ´Â µð·ºÅ丮¸¦ °¡Á®¿À·Á°íÇÕ´Ï´Ù.
    [01/11] ƯÁ¤ ¾Èµå·ÎÀ̵å WebView ¹öÀü¿¡¼­ SSL ¹®Á¦ (WebView ¹ö±×)
    [08/01] DNS forwarder (Àü´ÞÀÚ) ¼­¹ö¸¦ ÅëÇؼ­ Äõ¸®ÇÏ¸é ¿ª¹æÇâÀ» ¹Þ¾Æ¿ÀÁú ¸øÇÕ´Ï´Ù.
    [05/16] (ÁÖ)ÈÄÀÌÁî ½Ã½ºÅÛ¿£Áö´Ï¾î (°æ·ÂÀÚ) ¸ðÁý
      New!   ÃÖ±Ù¿¡ µî·ÏÇÑ ÆäÀÌÁö
      KiCad EDA Suite project (Free/Libre/Open-Source EDA Suite) (CAD)
      ¿ÀÇÂij½ºÄÉÀ̵å ijµå (OpenCASCADE CAD)
      QCad for Windows --- GNU GPL (Free Software)
      The Hello World Collection
      IPMI¸¦ È°¿ëÇÑ ¸®´ª½º ¼­¹ö°ü¸®
      DNS ¼³Á¤ °Ë»ç
      nagiosgraph ¼³Ä¡ ¹æ¹ý
      Slony-I ¼³Ä¡ ¹æ¹ý (postgresql replication tool)
      Qmail±â¹ÝÀÇ Anti spam ½Ã½ºÅÛ ±¸ÃàÇϱâ
      clusterssh

    [ ÇÔ²²ÇÏ´Â »çÀÌÆ® ]




    ¿î¿µÁø : ÁÁÀºÁøÈ£(truefeel), ¾ß¼ö(yasu), ¹ü³ÃÀÌ, sCag
    2003³â 8¿ù 4ÀÏ~