mysql job启动时间设置,mysql怎么设置job自动启动

忘是亡心i 2023-01-13 13:55 122阅读 0赞

当前位置:我的异常网» MySQL » mysql怎么设置job自动启动

mysql怎么设置job自动启动

www.myexceptions.net  网友分享于：2014-09-01  浏览：0次

mysql如何设置job自动启动

1.检查当前的job

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

Database changed

mysql> show events;

\+-----+-------------+------------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+

| 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)

2.检查是否开启了自动启动

mysql> show global variables like '%event\_scheduler%';

\+-----------------+-------+

| Variable\_name   | Value |

\+-----------------+-------+

| event\_scheduler | OFF   |

\+-----------------+-------+

1 row in set (0.00 sec)

3.设置job自动启动

mysql> set global event\_scheduler = on;

Query OK, 0 rows affected (0.00 sec)