WordPress Popular Postsが重い! スロークエリーのログを観察してて何度も現れたのはwp_popularpostdataというデータベースに関する処理です。 # Time: 171029 12:09:23 # User@Host: ...[...] @ localhost [] # Thread_id: 32675 Schema: ... QC_hit: No # Query_time: 0.303782 Lock_time: 0.000076 Rows_sent: 0 Rows_examined: 0 # Rows_affected: 2 use ...; SET timestamp=1509246563; INSERT INTO wp_popularpostsdata (postid, day, last_viewed, pageviews) VALUES (194
![WordPress高速化: WordPress Popular PostsからSimple GA Rankingへ移行](https://cdn-ak-scissors.b.st-hatena.com/image/square/d2069061c4fbbfdbb537c72d63c6449b28d6fc9a/height=288;version=1;width=512/https%3A%2F%2Fscratchpad.jp%2Fwp-content%2Fuploads%2F2017%2F10%2F7c8fd0ac5680ee025e7164c9114dca79_s.jpg)