Ä¿ÇÇÇâÀÌ ³ª´Â *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/
)
Á¶È¸¼ö : 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 òÁ
[03/20]
Re: ¿Â¶óÀΰÔÀÓÀÇ Á¾ÁÖ±¹ ´ëÇѹα¹
[03/20]
½ÇÁ¦
[03/18]
±¹°¡
[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]
(ÁÖ)ÈÄÀÌÁî ½Ã½ºÅÛ¿£Áö´Ï¾î (°æ·ÂÀÚ) ¸ðÁý
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ÀÏ~