《Mysql入門mysql如何設置job任務自動啟動》要點:
本文介紹了Mysql入門mysql如何設置job任務自動啟動,希望對您有用。如果有疑問,可以聯系我們。
MYSQL數據庫1,檢查當前的job
?
MYSQL數據庫mysql> use dev;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
MYSQL數據庫Database changed
mysql> show events;
+-----+-------------+------------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
| Db? | Name??????? | Definer????????? | Time zone | Type????? | Execute at | Interval value | Interval field | Starts????????????? | Ends | Status? | Originator | character_set_client | collation_connection | Database Collation |
+-----+-------------+------------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
| dev | my_job_test | hxl@192.168.56.% | SYSTEM??? | RECURRING | NULL?????? | 1????????????? | DAY??????????? | 2014-03-07 18:10:00 | NULL | ENABLED |????????? 0 | utf8???????????????? | utf8_general_ci????? | latin1_swedish_ci? |
+-----+-------------+------------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
1 row in set (0.23 sec)
MYSQL數據庫2,檢查是否開啟了自動啟動
?
MYSQL數據庫3,設置job自動啟動
?
MYSQL數據庫4,設置mysql重啟后,job能自動啟動
編輯/etc/my.cnf文件,在[mysqld]下添加event_scheduler=1
?
MYSQL數據庫[root@node1 etc]# more my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
event_scheduler=1
MYSQL數據庫[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
轉載請注明本頁網址:
http://www.snjht.com/jiaocheng/6174.html