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