Change event scheduler status in mysql

Question

I have 5 event planners in my MySql database. I want to stop one event planner from them.

I used the statements below,

SET GLOBAL event_scheduler = OFF;
SET @@global.event_scheduler = OFF;
SET GLOBAL event_scheduler = 0;
SET @@global.event_scheduler = 0;

but he stops all 5 event planners. Please help me with this.

Thanks at Advance.

Regards, Saurabh

Answer 1

I think you mean that you have 5 events on one scheduler. Correctly?

Here's how you disable one event:

    ALTER EVENT myevent
    DISABLE;

Here's how you disable the entire scheduler (all events):

    SET GLOBAL event_scheduler = OFF;

All this can be read at http://dev.mysql.com/doc/refman/5.1/en/events.html How to disable one event here http://dev.mysql.com/doc/refman/5.1/en/alter -event.html

Answer 2

, ;

select @@global.event_scheduler;

Answer 3

, :

. event_scheduler , DISABLED . , , event_scheduler . , , :

• :

  --event- = DISABLED

• (my.cnf my.ini Windows) , (, [mysqld]):

  event_scheduler =

https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html