set global slow_query_log = 1;
set global long_query_time = 1;

set global event_scheduler = 1;

delimiter $$
create or replace EVENT event_flush_slow_log
ON SCHEDULE
EVERY 1 SECOND
on completion preserve ENABLE
do
begin
  SELECT SLEEP(1);
end; $$
delimiter ;

show events where Name like '%event_flush_slow_log%'\G;
或
select * from information_schema.events where event_name='event_flush_slow_log'\G;

ALTER EVENT event_flush_slow_log ENABLE;

# Time: 180126 12:19:57
# User@Host: root[root] @ localhost [localhost]
# Thread_id: 1640  Schema: db1  QC_hit: No
# Query_time: 1.000645  Lock_time: 0.000269  Rows_sent: 1  Rows_examined: 0
# Rows_affected: 0
SET timestamp=1516940397;
SELECT SLEEP(1);
# Time: 180126 12:19:58
# User@Host: root[root] @ localhost [localhost]
# Thread_id: 1641  Schema: db1  QC_hit: No
# Query_time: 1.000575  Lock_time: 0.000203  Rows_sent: 1  Rows_examined: 0
# Rows_affected: 0
SET timestamp=1516940398;
SELECT SLEEP(1);
# Time: 180126 12:19:59
# User@Host: root[root] @ localhost [localhost]
# Thread_id: 1642  Schema: db1  QC_hit: No
# Query_time: 1.000856  Lock_time: 0.000180  Rows_sent: 1  Rows_examined: 0
# Rows_affected: 0
SET timestamp=1516940399;
SELECT SLEEP(1);

ALTER EVENT event_flush_slow_log DISABLE;

DROP EVENT IF EXISTS event_flush_slow_log;