Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
*
HanIRCÀÇ #coffeenix ¹æ
[
Àåºñ ¹× ȸ¼± ÈÄ¿ø
]
> Forum <
IT ÀÏÁ¤
N
e
w
!
ÀÚµ¿È ÇÁ·ÎÁ§Æ®
HOME
>
µ¥ÀÌÅͺ£À̽º(database)
>
MySQL
µµ¿ò¸»
°Ë»ö :
»çÀÌÆ®
WHOIS
À¥¼¹ö Á¾·ù
MySQL 5.1.x¿¡¼ Event Scheduler ·Î±×
ÀÛ¼ºÀÏ : 2009/03/10 19:22
±Û¾´ÀÌ : ÁÁÀºÁøÈ£ (
http://coffeenix.net/
)
Á¶È¸¼ö : 11289
[
ÀÌÀüȸé
/
¼öÁ¤
] ºñ¹Ð¹øÈ£ :
Á¦ ¸ñ : 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)
Ä¿ÇǴнº Ä«Æä ÃÖ±Ù ±Û
[10/16]
¾ß©
[10/16]
Ä¡¾Æ
[10/15]
¼ºÀÎ
[10/14]
Àνº
[10/13]
¬®¬¦¬¤¬¡ ¬°¬¯¬ª¬°¬¯ ¬£ ¬³¬¦¬¤¬°¬¥¬¯
[10/13]
¬®¬¦¬¤¬¡ ¬°¬¯¬ª¬°¬¯ ¬£ ¬±¬°¬³¬¬¦¬¥
[10/13]
¼ºÀÎ
[10/12]
¬®¬¦¬¤¬¡ ¬³¬¡¬«¬´ ¬¥¬¡¬²¬¬¬¯¬¦¬´ ¬£
[10/12]
cctv¼³Ä¡
[10/11]
cctv¼³Ä¡
[10/10]
¬°¬æ¬Ú¬è¬Ú¬Ñ¬Ý¬î¬ß¬Ñ¬ñ ¬Ü¬â¬Ñ¬Ü¬Ö¬ß
[10/10]
¬°¬æ¬Ú¬è¬Ú¬Ñ¬Ý¬î¬ß¬Ñ¬ñ ¬Ü¬â¬Ñ¬Ü¬Ö¬ß
[10/10]
¬°¬æ¬Ú¬è¬Ú¬Ñ¬Ý¬î¬ß¬Ñ¬ñ ¬Ü¬â¬Ñ¬Ü¬Ö¬ß
[10/10]
¬°¬æ¬Ú¬è¬Ú¬Ñ¬Ý¬î¬ß¬Ñ¬ñ ¬Ü¬â¬Ñ¬Ü¬Ö¬ß
[10/10]
¬°¬æ¬Ú¬è¬Ú¬Ñ¬Ý¬î¬ß¬Ñ¬ñ ¬Ü¬â¬Ñ¬Ü¬Ö¬ß
N
e
w
! ÃÖ±Ù¿¡ µî·ÏÇÑ ÆäÀÌÁö
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ÀÏ~