厦门旅游景点图片,苏州美田董事长高琪,宝宝多大不会吐奶
这两天新买的服务器mysql总是自动停止,查了日志
9:13:57 [note] mysql: normal shutdown
9:13:57 [note] event scheduler: purging the queue. 0 events
9:13:57 innodb: starting shutdown...
9:13:58 innodb: shutdown completed; log sequence number 0 44273
9:13:58 [note] mysql: shutdown complete
重启发现
9:13:59 [note] plugin 'federated' is disabled.
9:13:59 innodb: initializing buffer pool, size = 8.0m
9:13:59 innodb: completed initialization of buffer pool
9:13:59 innodb: started; log sequence number 0 44273
9:13:59 [note] event scheduler: loaded 0 events
9:13:59 [note] mysql: ready for connections.
version: '5.1.61-community' socket: '' port: 3306 mysql community server (gpl)
9:14:24 [note] mysql: normal shutdown
网上找到的方法
在my.ini文件中的 [mysqld] 中增加一行tmpdir="d:/mysql/data/tmp"
删除mysql目录下的ib_logfile0和ib_logfile1
测试后没有用
后来在服务中设置了mysql自动重启
最后
[mysqld]
federated
解决
启动正常
10:28:01 innodb: initializing buffer pool, size = 8.0m
10:28:01 innodb: completed initialization of buffer pool
10:28:01 innodb: started; log sequence number 0 44556
10:28:01 [note] event scheduler: loaded 0 events
10:28:01 [note] mysql: ready for connections.
version: '5.1.61-community' socket: '' port: 3306 mysql community server (gpl)
顺手添加
skip-external-locking
skip-name-resolve
解决
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
小白安装登录mysql-8.0.19-winx64的教程图解(新手必看)
Navicat连接MySQL时报10060、1045错误及my.ini位置问题
网友评论