MySQL运行一段时间后自动停止解决办法

327 阅读1分钟

MySql日志:

2021-03-08 09:06:19 77992 [Note] Plugin 'FEDERATED' is disabled.
2021-03-08 09:06:19 77992 [Note] InnoDB: Using atomics to ref count buffer pool pages
2021-03-08 09:06:19 77992 [Note] InnoDB: The InnoDB memory heap is disabled
2021-03-08 09:06:19 77992 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-08 09:06:19 77992 [Note] InnoDB: Memory barrier is not used

解决方法:
1、在服务中设置mysql自动重启;
2、在my.ini中[mysqld]下添加:federated即可;

[mysqld]
federated

3、重启mysql后日志“Plugin ‘FEDERATED’ is disabled”消失。

2021-03-08 09:23:48 77992 [Note] MySQL: Shutdown complete

2021-03-08 09:23:54 48132 [Note] InnoDB: Using atomics to ref count buffer pool pages
2021-03-08 09:23:54 48132 [Note] InnoDB: The InnoDB memory heap is disabled
2021-03-08 09:23:54 48132 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-08 09:23:54 48132 [Note] InnoDB: Memory barrier is not used

参考资料:
MySQL自动停止的解决办法