http://www.mysqlkorea.co.kr
Çѱ۸Ŵº¾ó 5.0 , Çѱ۸Ŵº¾ó 5.1 , MySQL 5.1 HA , »ç¿ëÀڸŴº¾ó
Advanced Knowle...  
¿£Áö´Ï¾î ³ëÆ®  
ºí·Î±×Á¸  
±Û·Î¹ú MySQL  
MySQL 5.5 GA  
MySQL 5.6 Developer  
ÃֽűÛ
foreign key ¼³Á¤¡¦
ÀÎÅØ½º Ãß°¡ µî¿¡¡¦
mysql master - s¡¦
´Ù´ë´Ù °ü°è¿¡¼­ ¡¦
mysql myÆÄÀϰú ¡¦
 
¿£Áö´Ï¾î ³ëÆ® > °³¹ßÀÚ Á¸ > ¿£Áö´Ï¾î ³ëÆ®
ºÒÇÊ¿äÇÑ mysql thread ÀϰýÁ¾·á ÇÁ·Î½ÃÁ®
±Û¾´ÀÌ : royster   ³¯Â¥ : 13-09-10 10:58   Á¶È¸¼ö : 7593
-- »ç¿ë¹ý
-- mysql> call sp_killid(300);   300ÃÊ ÃʰúÇÑ thread Àϰý °­Á¦ Á¾·á
-- Çʿ信 µû¶ó À̺¥Æ® ½ºÄÉÁÙ·¯ ¹× CronÀ» ÀÀ¿ëÇÏ¸é µÇ°Ú½À´Ï´Ù.
 
 
DELIMITER $$
USE `test`$$
DROP PROCEDURE IF EXISTS `sp_killid`$$
CREATE  PROCEDURE `sp_killid`(
set_time INT
)
BEGIN
DECLARE is_loop INT DEFAULT 0;
DECLARE thisid INT;
DECLARE thisuser CHAR(20);
DECLARE thistime INT;
DECLARE cur1 CURSOR FOR
SELECT `ID`,`USER`,`TIME` FROM `information_schema`.`PROCESSLIST`;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET is_loop = 1;
 
  OPEN cur1;
    REPEAT
       FETCH cur1 INTO thisid,thisuser,thistime;
         IF NOT is_loop THEN
            IF thisuser<>'system user' AND thistime>set_time THEN
               KILL thisid;
            END IF;
         END IF;
    UNTIL is_loop END REPEAT;   
  CLOSE cur1;
 
END$$
DELIMITER ;
ÀÌÀü±Û MySQL Fabric FAQ 
´ÙÀ½±Û ¼ýÀÚ¸¸ »Ì¾Æ³»´Â MySQL stored function 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.