MySQL 查看所有事件详细情况

Tom Ma.

已于 2025-04-27 11:43:56 修改

阅读量5.9k

点赞数

分类专栏： MySQL 文章标签： mysql android 数据库

于 2020-06-18 11:40:13 首次发布

本文链接：https://blog.csdn.net/mshxuyi/article/details/106827056

版权

MySQL 专栏收录该内容

31 篇文章

订阅专栏

1、查看所有事件

mysql> show events;

2、查看事件是否开启

mysql> show variables like 'event_scheduler';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| event_scheduler | ON    |
+-----------------+-------+

3、查看事件执行情况

mysql> SELECT * FROM information_schema.EVENTS;

4、查看可用的事件执行情况

mysql> select event_name,created,starts,ends,interval_value,interval_field,last_executed \
from information_schema.events where status='enabled' order by last_executed desc;

+-------------------------------------+---------------------+---------------------+------+----------------+----------------+---------------------+
| event_name                          | created             | starts              | ends | interval_value | interval_field | last_executed       |
+-------------------------------------+---------------------+---------------------+------+----------------+----------------+---------------------+
| auto calculate overdue member point | 2020-08-10 10:00:34 | 2019-11-01 00:00:00 | NULL | 1              | WEEK           | NULL                |
| auto calculate pessenger flow       | 2020-08-10 10:00:34 | 2020-04-04 00:00:00 | NULL | 1              | DAY            | NULL                |
| auto update flow 1                  | 2020-08-10 10:00:34 | 2020-04-24 17:50:43 | NULL | 1200           | SECOND         | 2020-08-10 10:30:43 |
| calcMemberCardAccountDate           | 2020-08-10 10:00:34 | 2020-06-01 23:00:00 | NULL | 1              | DAY            | NULL                |
| ExclusiveConsultant                 | 2020-08-10 10:00:34 | NULL                | NULL | NULL           | NULL           | NULL                |
| MemberLevel                         | 2020-08-10 10:00:35 | NULL                | NULL | NULL           | NULL           | NULL                |
| saveExclusiveConsultantHistory      | 2020-08-10 10:00:35 | 2020-08-01 01:00:00 | NULL | 1              | MONTH          | NULL                |
+-------------------------------------+---------------------+---------------------+------+----------------+----------------+---------------------+