SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;
使用上面任何一句都没有用,在my.ini里面的[mysqld] 标记后加一行内容为 event_scheduler = 1也没有作用,错误日志里面也没有显示,只显示了程序非正常重启。mysql的版本是5.1.6的。谁能指点我啊!
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;
使用上面任何一句都没有用,在my.ini里面的[mysqld] 标记后加一行内容为 event_scheduler = 1也没有作用,错误日志里面也没有显示,只显示了程序非正常重启。mysql的版本是5.1.6的。谁能指点我啊!
SET GLOBAL event_scheduler = 1
提示什么SHOW VARIABLES LIKE 'event_scheduler';
每次一使用上面的命令,mysql服务自己就停止了,得我手动从服务里面开启。开启之后show了一下,还是off的。然后在set,服务又停止了。
mysql-[lym]> delimiter ;
mysql-[lym]> SET GLOBAL event_scheduler = ON;
Query OK, 0 rows affected (0.00 sec)mysql-[lym]> SET @@global.event_scheduler = ON;
Query OK, 0 rows affected (0.00 sec)mysql-[lym]> SET GLOBAL event_scheduler = 1;
Query OK, 0 rows affected (0.00 sec)mysql-[lym]> SET @@global.event_scheduler = 1;
Query OK, 0 rows affected (0.00 sec)
mysql-[lym]> SHOW VARIABLES LIKE '%sche%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
1 row in set (0.00 sec)mysql-[lym]> SET @@global.event_scheduler = 0;
Query OK, 0 rows affected (0.00 sec)mysql-[lym]> SHOW VARIABLES LIKE '%sche%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.00 sec)mysql-[lym]> SET @@global.event_scheduler = 1;
Query OK, 0 rows affected (0.00 sec)mysql-[lym]> SHOW VARIABLES LIKE '%sche%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)