MySQL 5.5如何創(chuàng)建和查看數(shù)據(jù)庫(kù)計(jì)劃任務(wù)

142次閱讀

共計(jì) 2466 個(gè)字符，預(yù)計(jì)需要花費(fèi) 7 分鐘才能閱讀完成。

這篇文章將為大家詳細(xì)講解有關(guān) MySQL 5.5 如何創(chuàng)建和查看數(shù)據(jù)庫(kù)計(jì)劃任務(wù)，丸趣 TV 小編覺得挺實(shí)用的，因此分享給大家做個(gè)參考，希望大家閱讀完這篇文章后可以有所收獲。

– 開啟相關(guān)參數(shù)
mysql set global event_scheduler = 1;
Query OK, 0 rows affected (0.00 sec)

– 開啟參數(shù)后，在線程中會(huì)出現(xiàn) event_scheduler 相關(guān)線程
mysql show processlist\G

*************************** 7. row ***************************
Id: 13
User: event_scheduler
Host: localhost
db: NULL
Command: Daemon
Time: 474
State: Waiting for next activation
Info: NULL
7 rows in set (0.00 sec)

– 創(chuàng)建計(jì)劃任務(wù)
mysql CREATE EVENT myevent
– ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
– DO
– UPDATE fire.t12 SET sal = sal + 100;
Query OK, 0 rows affected (0.02 sec)

– 查看數(shù)據(jù)庫(kù)里面的計(jì)劃任務(wù)
mysql show events from fire\G
*************************** 1. row ***************************
Db: fire
Name: myevent
Definer: system@localhost
Time zone: SYSTEM
Type: ONE TIME
Execute at: 2016-05-23 02:48:03
Interval value: NULL
Interval field: NULL
Starts: NULL
Ends: NULL
Status: ENABLED
Originator: 100
character_set_client: gbk
collation_connection: gbk_chinese_ci
Database Collation: utf8_general_ci
1 row in set (0.00 sec)

– 查看計(jì)劃任務(wù)的內(nèi)容
mysql show create event myevent\G
*************************** 1. row ***************************
Event: myevent
sql_mode: STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
time_zone: SYSTEM
Create Event: CREATE DEFINER=`system`@`localhost` EVENT `myevent` ON SCHEDULE AT 2016-05-23 02:48:03 ON COMPLETION NOT PRESERVE ENABLE DO UPDATE fire.t12 SET sal = sal + 100
character_set_client: gbk
collation_connection: gbk_chinese_ci
Database Collation: utf8_general_ci
1 row in set (0.00 sec)

– 禁止計(jì)劃任務(wù)
mysql ALTER EVENT myevent DISABLE;

關(guān)于“MySQL 5.5 如何創(chuàng)建和查看數(shù)據(jù)庫(kù)計(jì)劃任務(wù)”這篇文章就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，使各位可以學(xué)到更多知識(shí)，如果覺得文章不錯(cuò)，請(qǐng)把它分享出去讓更多的人看到。

正文完