执行语句SET GLOBAL event_scheduler = 1; 后mysqld-nt.exe应用程序错误,mysql就终止了,这是怎么回事啊?
解决方案 »
- 求一个SQL语句
- 急。跳过权限查询
- 如何在MySql中编写使用Top来查询的Sql语句
- select t1.a, t1.b, t2.c, t2.d from t1, t2 while (t1.a = t2.a and t2.a = 5)
- 向大哥们紧急求援!!!!!!
- #100 mysql中to_number用什么代替?
- csv 数据导入到mysql 什么工具简单好用,就是比较傻瓜的工具啦
- 请问各位高手们,mysql如何设计出来积分的几个表可以再1千万数据量下,快速查询?,表如何分区?
- 求一句sql
- mysql 搜索查询的问题
- mysql cluster 数据无法同步
- mysql group by 排序问题
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服务。
谢谢各位。