1、现在用的是LINODE VPS,自建MYSQL,WORDPRESS有23万文章,尝试做了各种优化,性能不是很好,现在想转到阿里云,外加RDS,请问这么多数据的WP应该选择什么版本的RDS(暂不考虑流量,目前百十个IP),只考虑23万文章(2.3G数据表)的WP对RDS配置的需求。
2、另外发现WP的一些常见的慢查询,请教大神有没有对应WP的优化建议。
# Time: 151025 22:46:05
# User@Host: hsdhwcom_news[hsdhwcom_news] @ localhost []
# Query_time: 5.938003 Lock_time: 0.000066 Rows_sent: 1 Rows_examined: 208056
SET timestamp=1445784365;
SELECT COUNT(*) FROM news_term_relationships, news_posts WHERE news_posts.ID = news_term_relationships.object_id AND post_status = 'publish' AND post_type IN ('post') AND term_taxonomy_id = 3;
# Time: 151025 22:22:46
# User@Host: hsdhwcom_news[hsdhwcom_news] @ localhost []
# Query_time: 5.832869 Lock_time: 0.000080 Rows_sent: 12 Rows_examined: 121952
SET timestamp=1445782966;
SELECT SQL_CALC_FOUND_ROWS news_posts.ID FROM news_posts INNER JOIN news_term_relationships ON (news_posts.ID = news_term_relationships.object_id) WHERE 1=1 AND (
news_term_relationships.term_taxonomy_id IN (7)
) AND news_posts.post_type = 'post' AND (news_posts.post_status = 'publish') GROUP BY news_posts.ID ORDER BY news_posts.post_date DESC LIMIT 0, 12;
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。