查看mysql执行事件_查看当前数据库正在执行的事件

通过执行：

SELECT * FROM information_schema.EVENTS;

查看当前选定的数据库在执行了哪些事件。

可以看到相应的库中的作业信息，其中LAST_EXECUTED字段会反映出相应的作业最近一次的执行时间。

也可以通过：

select * from mysql.event\G

查看

root@localhost:mysql-3306.sock  11:22:  [s2b]>select * from mysql.event\G

*************************** 1. row ***************************

db: sss

name: event_wxm_setTimeoutFlagForSyncSapJob

body: UPDATE `trade_tertiary_order` SET sap_timeout = 1 where sap_timeout = 0 AND id in  = 1) a)

definer: dddd@%

execute_at: NULL

interval_value: 20

interval_field: MINUTE

created: 2019-12-17 16:57:41

modified: 2019-12-17 16:57:41

last_executed: 2020-03-02 03:17:41

starts: 2019-12-17 08:57:41

ends: NULL

status: ENABLED

on_completion: DROP

sql_mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUT

comment: 处理超时订单标记

originator: 101

time_zone: SYSTEM

character_set_client: utf8mb4

collation_connection: utf8mb4_general_ci

db_collation: utf8mb4_unicode_ci

body_utf8: UPDATE `trade_tertiary_order` SET sap_timeout = 1 where sap_timeout = 0 AND id in  = 1) a)

1 row in set (0.00 sec)