Skip to content

Instantly share code, notes, and snippets.

@bradyswenson
Created February 18, 2015 20:32
Show Gist options
  • Save bradyswenson/002e3407e3b8bd3b2e09 to your computer and use it in GitHub Desktop.
Save bradyswenson/002e3407e3b8bd3b2e09 to your computer and use it in GitHub Desktop.
[Wed Feb 18 20:19:26 2015] [error] [client 207.46.13.63] [WPE Monitoring] Slow mysql_query() call was running query:\nSELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id ) WHERE 1=1 AND ((wp_posts.post_author = 803 OR (wp_term_taxonomy.taxonomy = 'author' AND wp_term_taxonomy.term_id = '15608'))) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID HAVING MAX( IF( wp_term_taxonomy.taxonomy = 'author', IF( wp_term_taxonomy.term_id = '15608',2,1 ),0 ) ) <> 1 ORDER BY wp_posts.post_date DESC LIMIT 0, 10 /* From [rhrealitycheck.org/author/shannon-rush/] in [/nas/wp/www/cluster-1516/rhrealitycheck/index.php:17] */
[Wed Feb 18 20:19:32 2015] [error] [client 207.46.13.73] [WPE Monitoring] Stopwatch php.pod-1516.function.mysql_query.duration exceeded 1000ms. Was: 7220ms.\n#0 wpe\\measure\\LoggingStopwatch->logStackTrace(7220) called at [/nas/wp/www/common/production/measure.php:198]\n#1 wpe\\measure\\LoggingStopwatch->lap_ended(7220) called at [/nas/wp/www/common/production/measure.php:134]\n#2 wpe\\measure\\Stopwatch->lapstart() called at [/nas/wp/www/common/production/measure.php:152]\n#3 wpe\\measure\\Stopwatch->stop() called at [/nas/wp/www/common/production/statsd_monitoring.php(256) : runkit created function:19]\n#4 mysql_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) LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id ) WHERE 1=1 AND ((wp_posts.post_author = 1328 OR (wp_term_taxonomy.taxonomy = 'author' AND wp_term_taxonomy.term_id = '13377'))) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID HAVING MAX( IF( wp_term_taxonomy.taxonomy = 'author', IF( wp_term_taxonomy.term_id = '13377',2,1 ),0 ) ) <> 1 ORDER BY wp_posts.post_date DESC LIMIT 0, 10 /* From [rhrealitycheck.org/author/kim-irish/] in [/nas/wp/www/cluster-1516/rhrealitycheck/index.php:17] */, Resource id #31) called at [/nas/wp/www/cluster-1516/rhrealitycheck/wp-includes/wp-db.php:1655]\n#5 wpdb->_do_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) LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id ) WHERE 1=1 AND ((wp_posts.post_author = 1328 OR (wp_term_taxonomy.taxonomy = 'author' AND wp_term_taxonomy.term_id = '13377'))) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID HAVING MAX( IF( wp_term_taxonomy.taxonomy = 'author', IF( wp_term_taxonomy.term_id = '13377',2,1 ),0 ) ) <> 1 ORDER BY wp_posts.post_date DESC LIMIT 0, 10 /* From [rhrealitycheck.org/author/kim-irish/] in [/nas/wp/www/cluster-1516/rhrealitycheck/index.php:17] */) called at [/nas/wp/www/cluster-1516/rhrealitycheck/wp-includes/wp-db.php:1559]\n#6 wpdb->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) LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id ) WHERE 1=1 AND ((wp_posts.post_author = 1328 OR (wp_term_taxonomy.taxonomy = 'author' AND wp_term_taxonomy.term_id = '13377'))) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID HAVING MAX( IF( wp_term_taxonomy.taxonomy = 'author', IF( wp_term_taxonomy.term_id = '13377',2,1 ),0 ) ) <> 1 ORDER BY wp_posts.post_date DESC LIMIT 0, 10) called at [/nas/wp/www/cluster-1516/rhrealitycheck/wp-includes/wp-db.php:1923]\n#7 wpdb->get_col(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) LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id ) WHERE 1=1 AND ((wp_posts.post_author = 1328 OR (wp_term_taxonomy.taxonomy = 'author' AND wp_term_taxonomy.term_id = '13377'))) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID HAVING MAX( IF( wp_term_taxonomy.taxonomy = 'author', IF( wp_term_taxonomy.term_id = '13377',2,1 ),0 ) ) <> 1 ORDER BY wp_posts.post_date DESC LIMIT 0, 10) called at [/nas/wp/www/cluster-1516/rhrealitycheck/wp-includes/query.php:3444]\n#8 WP_Query->get_posts() called at [/nas/wp/www/cluster-1516/rhrealitycheck/wp-includes/query.php:3826]\n#9 WP_Query->query(Array ([author_name] => kim-irish)) called at [/nas/wp/www/cluster-1516/rhrealitycheck/wp-includes/class-wp.php:541]\n#10 WP->query_posts() called at [/nas/wp/www/cluster-1516/rhrealitycheck/wp-includes/class-wp.php:612]\n#11 WP->main() called at [/nas/wp/www/cluster-1516/rhrealitycheck/wp-includes/functions.php:873]\n#12 wp() called at [/nas/wp/www/cluster-1516/rhrealitycheck/wp-blog-header.php:14]\n#13 require(/nas/wp/www/cluster-1516/rhrealitycheck/wp-blog-header.php) called at [/nas/wp/www/cluster-1516/rhrealitycheck/index.php:17]\n
[Wed Feb 18 20:19:32 2015] [error] [client 207.46.13.73] [WPE Monitoring] Slow mysql_query() call was running query:\nSELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id ) WHERE 1=1 AND ((wp_posts.post_author = 1328 OR (wp_term_taxonomy.taxonomy = 'author' AND wp_term_taxonomy.term_id = '13377'))) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID HAVING MAX( IF( wp_term_taxonomy.taxonomy = 'author', IF( wp_term_taxonomy.term_id = '13377',2,1 ),0 ) ) <> 1 ORDER BY wp_posts.post_date DESC LIMIT 0, 10 /* From [rhrealitycheck.org/author/kim-irish/] in [/nas/wp/www/cluster-1516/rhrealitycheck/index.php:17] */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment