AMP plugin causing high database load
-
According to my server host this plugin is using a lot of dbase resources. Like, a LOT.
I am using New Relic and the wp_posts select is by far the most time consuming resource in the dbase, by a factor of 20X above the next highest usage resource.
My host looked into it and said the following:
“It appears that the wp_posts selects that you mentioned are in fact a major contributor to your poor database performance. The main driver behind these queries is the amp plugin.”
It looks like there is an issue with the cache settings, causing it to bypass the cache and execute PHP every time? Here is an example page:
curl -I https://gamerant.com/far-cry-5-it-easter-egg-stephen-king/amp/
HTTP/1.1 200 OK
Date: Fri, 31 Aug 2018 15:06:59 GMT
Content-Type: text/html; charset=UTF-8
Connection: keep-alive
Set-Cookie: __cfduid=d6e130d3b7ec0adb615b02f541ea7233f1535728019; expires=Sat, 31-Aug-19 15:06:59 GMT; path=/; domain=.gamerant.com; HttpOnly
Cache-Control: max-age=0, must-revalidate, no-cache, no-storeI need some help with this, please.
Thanks
-
I don’t understand the use of JS to determine 75% of images don’t have those attributes, but images used in posts do have height/width, and what’s that got to do with the AMP version of the page?
I see two items with no height/width but those are inside javascript, not actual images.
Here is an example from New Relic:
Query
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE ?=? AND wp_posts.ID NOT IN (?) AND (
wp_term_relationships.term_taxonomy_id IN (?,?,?,?,?)
) AND wp_posts.post_type = ? AND (wp_posts.post_status = ?) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT ?, ?
Database instance
vps-gamerant-cluster.cluster-czvuylgsbq58.us-east-1.rds.amazonaws.com:3306
Database name
db_dom9972
Stack trace
in mysqli_query called at /wordpress-4.9.8/wp-includes/wp-db.php (1924)
in wpdb::_do_query called at /wordpress-4.9.8/wp-includes/wp-db.php (1813)
in wpdb::query called at /wordpress-4.9.8/wp-includes/wp-db.php (2454)
in wpdb::get_col called at /wordpress-4.9.8/wp-includes/class-wp-query.php (2821)
… WP_Query::get_posts called at /wordpress-4.9.8/wp-includes/
class-wp-query.php (3230)
in WP_Query::query called at /wordpress-4.9.8/wp-includes/class-wp-query.php (3336)
…WP_Query::__construct called at /dom9972/wp-content/themes/8.9K/amp/
single.php (54)
…/dom9972/wp-content/plugins/amp/includes/templates/
class-amp-post-template.php (441)
…/dom9972/wp-content/plugins/amp/includes/templates/
class-amp-post-template.php (211)
…/dom9972/wp-content/plugins/amp/includes/templates/
class-amp-post-template.php (200)
in AMP_Post_Template::load called at /dom9972/wp-content/plugins/amp/amp.php (328)
in amp_render_post called at /dom9972/wp-content/plugins/amp/amp.php (279)
in amp_render called at /wordpress-4.9.8/wp-includes/class-wp-hook.php (286)
…P_Hook::apply_filters called at /wordpress-4.9.8/wp-includes/
class-wp-hook.php (310)
in WP_Hook::do_action called at /wordpress-4.9.8/wp-includes/plugin.php (453)
in do_action called at /wordpress-4.9.8/wp-includes/template-loader.php (12)
in require_once called at /wordpress-4.9.8/wp-blog-header.php (19)
in require called at /wordpress-4.9.8/index.php (17)I’m not an expert on all this, so I’m not sure. You can see here the relative usage of AMP compared to the next couple of plugins: https://gamerant.com/ampusage.PNG
The topic ‘AMP plugin causing high database load’ is closed to new replies.
