majornickmo (July 26th, 2013)
## Please do not write below this line ##
Ticket #125238: Site is loading SUPER slow (not caching correctly?)
Your request (#125238) has been updated.
To review the status of the request and add additional comments, follow the link below:
http://wpengine.zendesk.com/tickets/125238
You can also add a comment by replying to this email.
Donovan Hernandez, Jul 26 01:11 pm (CDT):
Hello there!
I've been investigating your account for the past hour, and feel I have enough information to present to you, as to why your website is slow. There are actually quite a few things that need to be looked into, so I'll try and break it down for you here. These are the top 10 URL's that are requested for the past 5 days. Take note as to how huge of a difference the first one is, compared to the rest.
93455 POST /wp-admin/admin-ajax.php HTTP/1.1
9324 GET /dashboard/ HTTP/1.1
5008 POST /add-new/ HTTP/1.1
4891 POST /login/ HTTP/1.0
4721 GET /dashboard/ HTTP/1.0
3087 GET /add-new/ HTTP/1.1
2537 POST /login/ HTTP/1.1
1285 GET /dashboard/?deleted=true HTTP/1.1
1014 POST /register/ HTTP/1.0
595 POST /register/ HTTP/1.1
90,000+ POST requests to admin-ajax.php. These are un-cached hits, which is terrible for performance. You most likely have some plugin that's doing this, and I'll need to do some research to try and figure out what those are (not always an easy task). Next, the following PHP warning occurs 7000+ times for the past 5 days:
PHP Warning: Illegal offset type in isset or empty in /nas/wp/www/cluster-1642/utahgunexchang/wp-includes/post.php on line 1094
Here is the corresponding code:
/**
* Retrieve a post type object by name
*
* @package WordPress
* @subpackage Post
* @since 3.0.0
* @uses $wp_post_types
* @see register_post_type
* @see get_post_types
*
* @param string $post_type The name of a registered post type
* @return object A post type object
*/
function get_post_type_object( $post_type ) {
global $wp_post_types;
if ( empty($wp_post_types[$post_type]) )
return null;
return $wp_post_types[$post_type];
}
Now, it's not the WordPress core file that's at fault, it's most likely some custom post type code somewhere that isn't up to par. Moving on, we log all MySQL queries that take longer than 2 seconds to complete. Here are the top 5 files that generate such queries. The number on the left is the number of times the file has been logged, the number on the right is the line number for the code that creates the query:
1908 /nas/wp/www/cluster-1642/utahgunexchang/index.php:17
183 /nas/wp/www/cluster-1642/utahgunexchang/wp-content/themes/classipress/framework/includes/stats.php:168
55 /nas/wp/www/cluster-1642/utahgunexchang/wp-content/themes/classipress/includes/theme-functions.php:1441
15 /nas/wp/www/cluster-1642/utahgunexchang/wp-content/themes/classipress/framework/includes/stats.php:119
4 /nas/wp/www/cluster-1642/utahgunexchang/wp-content/themes/classipress/framework/includes/stats.php:80
2 /nas/wp/www/cluster-1642/utahgunexchang/wp-content/themes/classipress/framework/kernel/functions.php:313
Here is the query being generated by the first one:
# User@Host: utahgunexchang[utahgunexchang] @ localhost [127.0.0.1]
# Thread_id: 11175142 Schema: wp_utahgunexchang Last_errno: 0 Killed: 0
# Query_time: 4.262791 Lock_time: 0.000779 Rows_sent: 15 Rows_examined: 160956 Rows_affected: 0 Rows_read: 160956
use wp_utahgunexchang;
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, IF( wp_posts.ID IN ( 1064,1365,2700,3047,3061,4359,4763,5066,5813,5866,5908,7712,8551,9023,10817,11033,11089,11771,14410,15685,15692,16664,17840,18189,18228,20170,20812,21176,22663,22946,23277,23309,23506,23680,23862,24528,24961,25397,26146,26746,17251,27092,27490,27781,27929,28464,28521,28659,28962,29237,29806,30147,30534,30737,30799,31279,32722,33632,33654,34519,34564,34653,37177,37234,38120,39340,39410,39411,39438,39461,40323,5166,40523,40540,41975,42141,42204,42280,42610,42867,43028,43770,45791,46085,46247,46604,46755,47108,47792,48150,48664,48938,49601,50242,50664,51051,51191,51905,51916,45136,52209,2912,52273,52391,53423,54543,55034,56273,56417,56571,56842,58760,59154,59277,60379,60881,61210,61561,61623,61687,62525,63002,63042,63376,65055,66510,67555,67896,68094,68162,68340,68640,68923,69777,70074,70225,1637,71494,72056,72778,72875,73428,73601,74559,74672,75141,75263,75568,75974,76864,76920,76972,77886,78387,78629,79059,79088,80522,80943,81040,81634,82343,82415,82891,83665,83731,83818,83852,85060,86201,88240,88455,88517,89382,90524,90685,90889,91565,91630,92286,92520,92570,92796,93089,93127,93408,94267,94150,94106,95630,95779,96522,97041,97169,97923,97947,98298,98752,99351,99452,99501,101061,101335,102305,102717,103012,103046,104354,104368,105045,105115,108153,109669,110044,98927,113028,113983,115448,115507,115554,115661,116459,116905,117057,117560,118754,119796,120137,120272,120870,121691,123242,123278,123635,124593,124595,125379,125380,125733,125891,126212,126311,127580,127604,128383,128572,131719,132651,134067,134879,135831,136171,136318,137070,137162,106981,138505,138660,138893,139081,101097,139580,139979,140408,140497,141356,141363,141396,27869,143632,144279,144769,144868,144884,144913,144938,145013,145443,145584,146118,147487,822,147940,148618,149335,150474,150568,150748,151065,152963,152976,154461,155435,155536,156370,156931,157454,158262,158465,159115,63863,160938,161724,161787,161918,162067,162131,162236,162723,162740,162947,163630,124797,164855,165535,166018,166036,166048,166058,166064,166070,166083,166086,166095,166101,166103,166112,166168,168264,168457,168434,168566,168500,168877,168925,168940,169658,170035,170250,170823,170835,170867,170973,171536,172031,123821,173233,173408,173503,174352,87165,175681,175977,176432,176615,176710,176752,177279,177301,177564,177636,177852,77242,178508,178075,178698,178796,180034,180073,181550,182255,5392,182763,182990,183717,183897,184288,184340,184345,184393,184669,92941,3301,185574,185848,185907,185922,185930,61457,186509,186533,186603,186683,186717,186770,163600,186891,186951,186964,187290,187459,187833,187872,82324,189272,189574,189595,189649,189661,189856,189913,190089,190243,190382,190555,190623,190922,191869,192205,193969,193975,194158,194396,194914,194979,195945,195998,196243,197167,197555,197560,197603,197808,151053,199047,199072,199167,199382,199688,199693,125711,200076,200081,200267,200919,201197,201434,201935,202154,202165,202414,202991,203270,203303,52468,204874,206287,206360,134260,206863,207021,207681,210122,9446,210339,210702,201330,211028,139887,211493,211983), 1, 0) AS featured FROM wp_posts INNER JOIN wp_term_relationships AS r ON (wp_posts.ID = r.object_id) INNER JOIN wp_term_taxonomy AS x ON (r.term_taxonomy_id = x.term_taxonomy_id) AND (x.taxonomy = 'ad_tag' OR x.taxonomy = 'ad_cat' OR 1=1) INNER JOIN wp_postmeta AS m ON (wp_posts.ID = m.post_id) INNER JOIN wp_terms AS t ON x.term_id = t.term_id WHERE 1=1 AND (((wp_posts.post_title LIKE '%left%') OR (wp_posts.post_content LIKE '%left%') OR ((t.name LIKE '%left%')) OR ((t.slug LIKE '%left%')) OR ((m.meta_key = 'cp_price') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_street') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_city') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_state') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_country') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_phone_number') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_condition') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_listing_type') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_zipcode') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_region') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_size') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_feedback') AND (m.meta_value LIKE '%left%')) OR ((m.meta_key = 'cp_currency') AND (m.meta_value LIKE '%left%'))) AND ((wp_posts.post_title LIKE '%hand%') OR (wp_posts.post_content LIKE '%hand%') OR ((t.name LIKE '%hand%')) OR ((t.slug LIKE '%hand%')) OR ((m.meta_key = 'cp_price') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_street') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_city') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_state') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_country') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_phone_number') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_condition') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_listing_type') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_zipcode') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_region') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_size') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_feedback') AND (m.meta_value LIKE '%hand%')) OR ((m.meta_key = 'cp_currency') AND (m.meta_value LIKE '%hand%'))) OR (wp_posts.post_title LIKE '%left hand%') OR (wp_posts.post_content LIKE '%left hand%')) AND (wp_posts.post_status = 'publish') AND (wp_posts.post_type IN ('ad_listing','post','page')) GROUP BY wp_posts.ID ORDER BY featured DESC, wp_posts.post_date DESC LIMIT 90, 15 /* From [utahgunexchange.com/page/7/?s=left+hand&sa=search&scat=0] in [/nas/wp/www/cluster-1642/utahgunexchang/index.php:17] */;
There reaches a point where the built-in WordPress search isn't as optimized as it could be, with such a large dataset to look through. The customers I've dealt with who have this problem, have had great success with this plugin: http://wordpress.org/plugins/swiftype-search/ - Lastly, object-caching is NOT enabled for the "utahgunexchang" account. Let me know if this needs to be turned on, or if you contacted support to turn it off in the past. If you have any questions at all, just let me know!
Donovan Hernandez
Twitter: @heydonovan
Senior Engineer & Malware Analyst
Support Hours: M-F 9:00AM-6:00PM CST
Info, Jul 26 12:20 pm (CDT):
That's it^. The site is taking a REALLY long time to load the homepage, I'm wondering if it is caching correctly or if it's something else. I'm pretty sure we've paid our bills with you guys haha. ;-)
This email is a service from WPE Support.
Message-Id:ZJ7NARW4_51f2bbc1b3192_1c0c7d4880298353a_sprut
majornickmo (July 26th, 2013)
There are currently 1 users browsing this thread. (0 members and 1 guests)