About Mysql EVENT

About the Mysql EVENT, Mysql EVENT has been tested for a long time by modifying the system EVENT. It is preliminarily estimated that it uses thread sleep and it is invalid to modify the system EVENT. It will not be executed until a certain interval. Test: www.2cto.com uses sleep instead of scanning all the time. After sleep for a period of time, wait for the next execution, re-obtain the new system time, and re-calculate. So he uses this mechanism, and sleep is a variable. To sum up, Mysql records the start time and interval. the system time and three values are used to calculate the next sleep time. Therefore, the system time is changed during sleep, the sleep time is invalid. That is to say, during sleep, it does not implement the monitoring system time