MYSQL服务器经常挂掉--php工作中的一些问题和解决方法（2）

前些日子一个网站搬家了，然后我们第二天发现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的日志，从错误日志里找到解决办法，如果您有什么不懂得可以联系我！