The following article mainly introduces the MySQL event scheduler (eventsched). The event scheduler we tested this time was executed in the MySQL environment, and it adds another related function, it can be used as a new scheduled task scheduler.
Objective
The event Scheduler is equivalent to timed tasks in the operating system (such as Cron in Linux, scheduled Tasks in Windows), but the MySQL event Scheduler can be accurate to seconds and is useful for some real-time data processing
MySQL event scheduler bitsCN.com
The event scheduler is added to MySQL 5.1. Similar to the Job function of SQL Server.
1.Syntax:
CREATE EVENT [IF NOT EXISTS] event_nameON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE][ENABLE | DISABLE][COMMENT
Detailed Description: MySQL uses Event Scheduler to create a scheduled task, mysqlscheduler
Preface
The event scheduler is equivalent to scheduled tasks in the operating system (for example, scheduled tasks in cron and Window in Linux), but the
Translator: ye Jinrong (Email :), source: imysql.cn I. Overview The Event scheduler is another feature added in MySQL5.1 and can be used as a scheduled task scheduler, this replaces some timer functions that can only be completed by the operating
I. OverviewThe event Scheduler is another feature added in MySQL 5.1 that can be used as a timer Task Scheduler to replace some of the timed work > energy that can only be done with the operating system Task Scheduler. For example, the Crontabe in
Q: Suppose that there is a requirement that the system invoke a begin end at a certain point, and execute the begin end in 10 minutes. There is also a requirement for how often each time a recurring begin end is executed. So what should we do at
The event scheduler is another feature added in MySQL 5.1. It can be used as a scheduled task scheduler to replace some timer functions that can only be completed by the operating system task scheduler.
I. Overview
The event scheduler is another
First, prefaceSince MySQL5.1.6, a feature has been added – Event Scheduler (Scheduler), which can be used to perform certain tasks on a timed basis (for example, deleting records, summarizing data, and so on) to replace work that was previously only
I. OverviewThe event scheduler is another feature added in MySQL 5.1. It can be used as a scheduled task scheduler to replace some timer tasks that can only be completed by the operating system task scheduler>. For example, crontabe in Linux can be
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.