What is MySQL event?

What is MySQL event?

MySQL event is the MySQL event scheduler and can be periodically executed. It is a bit like crontab in Linux, but MySQL event can be accurate to seconds. After using the event, you can partially replace the scheduled execution of crontab. However, you do not know if the event is stable or unstable.

1. Check whether MySQL event is enabled.

View copy print?

1. Mysql> show variables like"Event %";
2. + ----------------- + ------- +
3. | Variable_name | value |
4. + ----------------- + ------- +
5. | Event_scheduler | off |
6. + ----------------- + ------- +
7. 1 row in Set

If not, set global event_schedld = 1; or add event_schedld = 1 to [mysqld] In my. CNF to save and restart MySQL.

II. A simple example

View copy print?

2. Create Table: Create Table 'test '(// Test table
4. 'Time' varchar (20) default null
6. ) Engine = MyISAM default charset = Latin1
8. 1 row in SET (0.00 Sec)
12. // Create an event
14. Mysql> Create event if not exists test_event on schedule every 5 secondDoInsert into test (time) values (now ());
16. Query OK, 0 rows affected
20. Mysql> select * from test;// View data
22. + --------------------- +
24. | Time |
26. + --------------------- +
28. | 09:14:52 |
30. + --------------------- +
32. | 09:14:57 |
34. + --------------------- +
36. 2 row in Set