mysql如何设置job任务自动启动
1,检查当前的job
mysql> use dev;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show events;
+-----+-------------+------------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
| Db | Name | Definer | Time zone | Type | Execute at | Interval value | Interval field | Starts | Ends | Status | Originator | character_set_client | collation_connection | Database Collation |
+-----+-------------+------------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
| dev | my_job_test | hxl@192.168.56.% | SYSTEM | RECURRING | NULL | 1 | DAY | 2014-03-07 18:10:00 | NULL | ENABLED | 0 | utf8 | utf8_general_ci | latin1_swedish_ci |
+-----+-------------+------------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
1 row in set (0.23 sec)
2,检查是否开启了自动启动
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.00 sec)
3,设置job自动启动
Query OK, 0 rows affected (0.00 sec)
4,设置mysql重启后,job能自动启动
编辑/etc/my.cnf文件,在[mysqld]下添加event_scheduler=1
[root@node1 etc]# more my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
event_scheduler=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
您可能感兴趣的文章:
mysql如何设置job任务自动启动
自动删除mysql死连接 mysql死锁
学习oracle定时执行存储过程的job
python的参数有哪些?怎么用?
mysql中1067错误及其它的解决方法集合
php-resque :基于Redis的后台任务系统
Beanstalkd消息/任务队列的详解
Linux下Mysql配置(rpm安装)
MySQL sleep进程连接过多卡住了问题解决办法
Quartz.NET框架AdoJobStore保存job到数据库