在服务器重新启动上启用mysql事件调度程序 [英] Enabling mysql Event scheduler on server restarts
问题描述
我正在运行phpmyadmin并在个人计算机上安装了apache服务器.我的问题是我试图将MySQL event_scheduler
设置为始终启用,即使服务器重新启动也是如此.我正在通过在服务器配置文件(my.cnf
或my.ini
)中设置以下命令行来阅读,它应该可以工作:event_scheduler=DISABLED
.但是,在哪里找到该my.cnf
或my.ini
文件,并且在看到我希望始终启用它的同时,命令行也应该是event_scheduler=DISABLED
或event_scheduler=ENABLED
吗?
I am running phpmyadmin and installed apache server on my personal computer. My problem is that I am trying to set MySQL event_scheduler
to always be enabled even when the server restarts. I was reading that by setting the following command line in the server configuration file (my.cnf
or my.ini
) it should work: event_scheduler=DISABLED
. However, where do I locate this my.cnf
or my.ini
file, and also should the command line be event_scheduler=DISABLED
or event_scheduler=ENABLED
seeing that I want it to always be enabled?
推荐答案
您应设置"ON"值(未启用).
You should set 'ON' value (not ENABLED).
在[mysqld]部分的配置文件中,指定'event-scheduler'选项(而不是event_scheduler).
In the configuration file in [mysqld] section specify 'event-scheduler' option (not event_scheduler).
此外,您还可以使用'--event-scheduler'选项启动MySQL服务器,例如-
Also, you can start your MySQL server with '--event-scheduler' option, e.g. -
shell> mysqld --event-scheduler = ON
shell> mysqld --event-scheduler=ON
更多信息- event_scheduler系统变量.
这篇关于在服务器重新启动上启用mysql事件调度程序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!