mysql> SET GLOBAL event_scheduler = 1; Query OK, 0 rows affected (0.00 sec)mysql> show variables like '%event%'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | event_scheduler | ON | +-----------------+-------+ 1 row in set (0.00 sec)mysql> 并没有出现你说的问题。 贴出ERR日志看看。
mysql> set global event_scheduler =1; Query OK, 0 rows affected (0.00 sec) mysql> show variables like '%sche%'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | event_scheduler | ON | +-----------------+-------+ 1 row in set (0.01 sec)
mysql> SHOW VARIABLES LIKE '%sche%';这句话是可以执行的。 +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | event_scheduler | OFF | +-----------------+-------+ 1 row in set mysql> SET GLOBAL event_scheduler = 1; 这句话就执行不了 之后就就会弹出mysqld-nt.exe应用程序错误,不能读,终止按确定,调试按取消之类的。
错误日志是 "You can't write-lock a log table. Only read access is possible.
to:zuoxingyu 弱弱的问一下,错误日志在哪里找。
直接配置在my.ini中能不能启动?
这里是错误日志了 100914 11:28:19 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 100914 11:28:19 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43665. InnoDB: Doing recovery: scanned up to log sequence number 0 43665 100914 11:28:19 InnoDB: Started; log sequence number 0 43665 100914 11:28:19 [Note] F:\mysql-noinstall-5.1.6-alpha-win32\mysql-5.1.6-alpha-win32\bin\mysqld-nt.exe: ready for connections. Version: '5.1.6-alpha-nt-max' socket: '' port: 3306 MySQL Community Edition (GPL)
TO:limohao 这个怎么用?
mysql> set global event_scheduler =0; Query OK, 0 rows affected设置为0 就没错 , 郁闷 不知道怎么办啦。
mysql> SET GLOBAL event_scheduler = 1;
Query OK, 0 rows affected (0.00 sec)mysql> show variables like '%event%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
1 row in set (0.00 sec)mysql>
并没有出现你说的问题。
贴出ERR日志看看。
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%sche%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
1 row in set (0.01 sec)
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set
mysql> SET GLOBAL event_scheduler = 1; 这句话就执行不了
之后就就会弹出mysqld-nt.exe应用程序错误,不能读,终止按确定,调试按取消之类的。
"You can't write-lock a log table. Only read access is possible.
弱弱的问一下,错误日志在哪里找。
100914 11:28:19 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100914 11:28:19 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43665.
InnoDB: Doing recovery: scanned up to log sequence number 0 43665
100914 11:28:19 InnoDB: Started; log sequence number 0 43665
100914 11:28:19 [Note] F:\mysql-noinstall-5.1.6-alpha-win32\mysql-5.1.6-alpha-win32\bin\mysqld-nt.exe: ready for connections.
Version: '5.1.6-alpha-nt-max' socket: '' port: 3306 MySQL Community Edition (GPL)
这个怎么用?
Query OK, 0 rows affected设置为0 就没错 , 郁闷 不知道怎么办啦。
试试
try it
加完这个后 重启服务...
加到MYSQLD下,重新启动MYSQL服务。
谢谢各位。