乱爱性全过程免费视频/午夜毛片视频/中文字幕av三区/一级视频网址

當(dāng)前位置： 維易PHP培訓(xùn)學(xué)院 > MYSQL教程 > 內(nèi)容正文

Mysql入門mysql如何設(shè)置job任務(wù)自動(dòng)啟動(dòng)

作者：VEPHP   時(shí)間 2017-09-27

《Mysql入門mysql如何設(shè)置job任務(wù)自動(dòng)啟動(dòng)》要點(diǎn)：
本文介紹了Mysql入門mysql如何設(shè)置job任務(wù)自動(dòng)啟動(dòng)，希望對(duì)您有用。如果有疑問，可以聯(lián)系我們。

導(dǎo)讀：1,檢查當(dāng)前的job mysql> use dev;Reading table information for completion of table and column namesYou can turn off t...

MYSQL數(shù)據(jù)庫(kù)1,檢查當(dāng)前的job
?

MYSQL數(shù)據(jù)庫(kù)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數(shù)據(jù)庫(kù)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數(shù)據(jù)庫(kù)2,檢查是否開啟了自動(dòng)啟動(dòng)
?

mysql> show global variables like '%event_scheduler%';
+-----------------+-------+
| Variable_name?? | Value |
+-----------------+-------+
| event_scheduler | OFF?? |
+-----------------+-------+
1 row in set (0.00 sec)

MYSQL數(shù)據(jù)庫(kù)3,設(shè)置job自動(dòng)啟動(dòng)
?

mysql> set global event_scheduler = on;
Query OK, 0 rows affected (0.00 sec)

MYSQL數(shù)據(jù)庫(kù)4,設(shè)置mysql重啟后,job能自動(dòng)啟動(dòng)
編輯/etc/my.cnf文件,在[mysqld]下添加event_scheduler=1
?

MYSQL數(shù)據(jù)庫(kù)[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數(shù)據(jù)庫(kù)[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/6174.html


    標(biāo)簽：