[Note] Event Scheduler: Killing the scheduler thread, thread id 1

MySQL SLAVE 启动后有如下提示：
[Note] Event Scheduler: Killing the scheduler thread, thrtestd id 1
[Note] Event Scheduler: Waiting for the scheduler thread to reply
[Note] Event Scheduler: Stopped

 

mysql> select version();
+-------------------------------------------+
| version()                                 |
+-------------------------------------------+
| 5.6.21-enterprise-commercial-advanced-log |
+-------------------------------------------+
1 row in set (0.00 sec)

 

 mysql中的event已经被关闭

mysql>  show variables where Variable_name='event_scheduler';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| event_scheduler | OFF   |
+-----------------+-------+
1 row in set (0.00 sec)

mysql> SELECT EVENT_SCHEMA, EVENT_NAME
    ->     FROM INFORMATION_SCHEMA.EVENTS
    ->     WHERE STATUS = 'SLAVESIDE_DISABLED';
Empty set (0.00 sec)

 

将event的状态改为DISABLE ON SLAVE 

mysql> alter event test.orderReplyQueue DISABLE ON SLAVE  ;

mysql> SELECT EVENT_SCHEMA, EVENT_NAME ,status FROM INFORMATION_SCHEMA.EVENTS   WHERE  EVENT_NAME='orderReplyQueue';
+--------------+-----------------+--------------------+
| EVENT_SCHEMA | EVENT_NAME      | status             |
+--------------+-----------------+--------------------+
| eportal      | orderReplyQueue | SLAVESIDE_DISABLED |
+--------------+-----------------+--------------------+
1 row in set (0.00 sec)

 

重启后，提示消失。