更改mysql中的事件计划程序状态 [英] change Event Scheduler status in mysql

问题描述

我的MySql数据库中有5个事件调度程序. 我想从他们那里停止一个事件调度程序.

I have 5 event Scheduler in my MySql data base. I want to stop one event Scheduler from them.

我已经使用了以下语句，

I have used below statements,

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

但是它会停止所有5个事件调度程序.为此，请帮助我.

but it stops all 5 event Scheduler. Please help me for this.

预先感谢.

关于， 索拉比(Suurabh)

Regards, Saurabh

推荐答案

我认为您的意思是您在一个调度程序上有5个事件.对吧?

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

这是您禁用一个事件的方法:

Here is how you disable one event:

    ALTER EVENT myevent
    DISABLE;

这是您禁用整个调度程序(所有事件)的方法:

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

    SET GLOBAL event_scheduler = OFF;

所有这些都可以在 http://dev.mysql上阅读. com/doc/refman/5.1/en/events.html 如何禁用一个事件在此处 http://dev.mysql. com/doc/refman/5.1/en/alter-event.html

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

这篇关于更改mysql中的事件计划程序状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！