数据库 wifi探针数据量太大了

浅浅的花香味﹌ 2022-12-25 03:54 212阅读 0赞

[https://www.cnblogs.com/showcase/p/11654045.html][https_www.cnblogs.com_showcase_p_11654045.html]

# [橱窗外的小孩][Link 1] #

## 在完成任务的同时，还需要不断“复盘”，不论你多么的忙，都需要留下时间思考，可以思考哪些地方做的好，哪些地方我们可以改进，应该如何改进，注重总结才是王道 ##

*  [博客园][Link 2]
 *  [首页][Link 1]
 *  [新随笔][Link 3]
 *  [联系][Link 4]
 *  订阅
 *  [管理][Link 5]

随笔 - 205  文章 - 1  评论 - 14

# [【数据库-MySql】开启事件 event\_scheduler][https_www.cnblogs.com_showcase_p_11654045.html] #

![70][]

1.  `Navicat Premiu`
2.  `事件计划已关闭。事件只能在服务器启动并开启事件计划时才能处理。`

![70 1][]

1.  `Navicat for MySQL`
2.   
3.  `The event_scheduler is Off. Events can be processed only when server is started with event_scheduler on`

第一步、查看事件是否开启

SHOW VARIABLES LIKE 'event_scheduler';

第二步、开启事件

1.  `SET GLOBAL event_scheduler = ON;`
2.  `-- SET @@global.event_scheduler = ON;`
3.  `-- SET GLOBAL event_scheduler = 1;`
4.  `-- SET @@global.event_scheduler = 1;`

关闭事件相关命令

1.  `SET GLOBAL event_scheduler = OFF;`
2.  `-- SET @@global.event_scheduler = OFF;`
3.  `-- SET GLOBAL event_scheduler = 0;`
4.  `-- SET @@global.event_scheduler = 0;`

第三步、my.ini最后添加并保存

event_scheduler = 1

第四步、重启MySQL服务

原文：[https://blog.csdn.net/chenlu5201314/article/details/80017040][https_blog.csdn.net_chenlu5201314_article_details_80017040]

[https_www.cnblogs.com_showcase_p_11654045.html]: https://www.cnblogs.com/showcase/p/11654045.html
[Link 1]: https://www.cnblogs.com/showcase/
[Link 2]: https://www.cnblogs.com/
[Link 3]: https://i.cnblogs.com/EditPosts.aspx?opt=1
[Link 4]: https://msg.cnblogs.com/send/%E6%A9%B1%E7%AA%97%E5%A4%96%E7%9A%84%E5%B0%8F%E5%AD%A9
[Link 5]: https://i.cnblogs.com/
[70]: /images/20221120/f1476823459748a18a675014f5d1eb03.png
[70 1]: /images/20221120/85acc83cfeb34c088e55484edb9862df.png
[https_blog.csdn.net_chenlu5201314_article_details_80017040]: https://blog.csdn.net/chenlu5201314/article/details/80017040