ECS内存占用高，wordpress数据库经常挂掉求大神指点
mysql经常挂掉，网站是用wordpress建设的，已经在wp-config.php写入 以下代码/* PHP Memory */define( 'WP_MEMORY_LIMIT', '32' );define( 'WP_MAX_MEMORY_LIMIT', '64' );php-fpm.conf也修改了pm.start_servers、pm.min_spare_servers、pm.max_spare_servers等项，然后好过一段时间。修改后从每天挂一次变为一周挂一次，但最近又成了每天必挂，重启服务器又全部恢复 。
服务器的配置：CPU： 1核 内存： 1024 MB 带宽：1Mbps
mysql日志：
2015-12-28 19:59:59 8218 [Note] Binlog end
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'partition'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'BLACKHOLE'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_METRICS'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_CMP'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'INNODB_TRX'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'ARCHIVE'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'MyISAM'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'CSV'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'MRG_MYISAM'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'MEMORY'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'sha256_password'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'mysql_old_password'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'mysql_native_password'
2015-12-28 19:59:59 8218 [Note] Shutting down plugin 'binlog'
2015-12-28 19:59:59 8218 [Note] /alidata/server/mysql/bin/mysqld: Shutdown complete
151228 19:59:59 mysqld_safe mysqld from pid file /alidata/server/mysql/data/iZ94vpkfebdZ.pid ended
2015-12-29 12:52:49
售后客服说是第三方软件问题超出服务范围，求哪位大神给个解决方案，万分感激！
写回答
-
-
ReECS内存占用高，wordpress数据库经常挂掉求大神指点最好还是增加到2G内存，我原来1G时也经常这样。
折衷的方案是，添加Swap交换文件，防止内存不足时MYSQL崩溃。
方法可参考：http://www.dzbfsj.com/thread-1677-1-1.html2015-12-29 17:18:53赞同 展开评论 打赏 -
ReECS内存占用高，wordpress数据库经常挂掉求大神指点我也在用WP，总感觉慢的很。你安装了 wp-super-cache 么？能管点用的。还有把 mysql 的日志关闭了吧。 那个太浪费空间了。
方便私信给一个地址么，我去看看。
2015-12-29 15:26:52赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
