前些日子一个网站搬家了,然后我们第二天发现mysql服务器挂掉了,重启之后 没多长时间又挂掉了! 这是为什么呢? 查看mysql的错误日志 [sql] 130115 21:01:03 [Note] Plugin 'FEDERATED' is disabled. 130115 21:01:03 InnoDB: Initializing buffer pool, size = 107.0M 130115 21:01:03 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 130115 21:01:03 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 130115 21:01:03 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 54 MB InnoDB: Database physically writes the file full: wait... 130115 21:01:03 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 54 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 130115 21:01:04 InnoDB: Started; log sequence number 0 0 130115 21:01:04 [Note] Event Scheduler: Loaded 0 events 130115 21:01:04 [Note] D:\Mysql\bin\mysqld: ready for connections. Version: '5.1.60-community' socket: '' port: 3306 MySQL Community Server (GPL) 130115 21:05:54 [Note] D:\Mysql\bin\mysqld: Normal shutdown [/sql] 原因网上找了好多,调整者或者那都不管事,最好才发现,mysql默认的是INNODB引擎,然后还禁用了INNODB的 一些功能然后就挂掉了,网站需要的MYSIAM引擎,然后切换回去,默认MYSIAM引擎,开启相关服务就OK了! 当然还有别的可能解决办法 最大连接数不够 max_connections=800 也有可能是32位mysql占内存满了,32位mysql占1.6G左右内存时就会死, 解决方法是64位系统,64位mysql。 其实最主要的我们还是分析一下mysql的日志,从错误日志里找到解决办法,如果您有什么不懂得可以联系我!

点赞(0) 打赏

评论列表 共有 0 条评论

暂无评论

微信小程序

微信扫一扫体验

立即
投稿

微信公众账号

微信扫一扫加关注

发表
评论
返回
顶部