Help and advice greatly appreciated. - mylemonhead - 11-16-2011 03:55 AM
Hi to everyone here, really hope for some advice here as ive been literally teraing my hair apart for the past few days searching for a solution. 
I've a wordpress site and recently changed webhost with litespeed servers shared-hosting, that i thought will certainly speed up my website.
What really puzzled me and frustrate me is everytime i test my inner webpages, it really takes more than 30 seconds to load and sometimes even time-out.
However when i retest it, the loading time becomes much shorter.
Ex http://www.webpagetest.org/result/111115_YF_26GC6/
(test taken with quick cache and wp-minify)
Ive tried the following wordpress cache plugins, like w3 total cache and quick cache, wp-minify.
w3 total cache gave me a very good yslow and pagespeed ranking, after i implemented it but the server load is horrendous, hitting from 50% upwards when i start to load my inner page. I enabled only page-cache and browser cache. The 1st time taken to load my inner webpage is >15 seconds.
Quick cache is simple enough for a non-techie like myself, and while it gave me a similar pagespeed rating as w3 total cache, i noticed the loading time is terribly long.
Any advice on how i should optimize my webpages, when loading for the first time?
P.s- im planning to implement cloudflare soon, but thought i would solve this first.
Thanks in advance for your time and help
RE: Help and advice greatly appreciated. - pmeenan - 11-16-2011 11:50 PM
You have a serious back-end performance problem. The first visit is painfully slow because nothing is cached and that is showing the actual native performance of the application. The retests are a lot faster because the queries are going to be in the database memory cache (since they were just run recently).
If you go to the page and view the source, W3TC will display some debug information at the bottom of the page that can help:
Code:
<!-- W3 Total Cache: Minify debug info:
Engine: disk: basic
Theme: da177
Template: single
Replaced CSS files:
1. wp-content/themes/topblog/style.css
2. http://www.wide-angle-macro-lens.com/wp-content/plugins/slickr-flickr/lightbox-slideshow/lightbox.css?ver=3.2.1
3. http://www.wide-angle-macro-lens.com/wp-content/plugins/slickr-flickr/slickr-flickr.css?ver=3.2.1
4. http://www.wide-angle-macro-lens.com/wp-content/plugins/wp-single-post-navigation/css/single-post-navigation.css?ver=1.1
5. wp-content/plugins/kk-star-ratings/css/kk-ratings.css
6. wp-content/plugins/jquery-vertical-accordion-menu/skins/black.css
-->
<!-- Performance optimized by W3 Total Cache. Learn more: http://www.w3-edge.com/wordpress-plugins/
Page Caching using disk: enhanced
Database Caching 41/172 queries in 1.384 seconds using disk: basic
Object Caching 1913/1991 objects using disk: basic
Served from: www.wide-angle-macro-lens.com @ 2011-11-16 21:45:31 -->
You can enable a lot more debug information in the plugin settings which can give you better timings and tell you what the database queries are that are taking a long time.
Ultimately, it's probably going to be an issue with the performance of the shared hosting provider (both on the web side and, more likely, their database performance). Shared hosting is notorious for exceptionally slow MySQL.
RE: Help and advice greatly appreciated. - mylemonhead - 11-17-2011 04:02 PM
Hi Preenam, thanks for your time. Ive added more debug info and the numbers are confusing me big time Where do i look for info to find which db queries are the culprits.
Code:
<!-- W3 Total Cache: Db cache debug info:
Engine: disk: basic
Total queries: 139
Cached queries: 112
Total query time: 0.9348
SQL info:
# | Time (s) | Caching (Reject reason) | Status | Data size (b) | Query
1 | 0.0006 | disabled (Query is rejected) | not cached | 0 | SHOW TABLES LIKE 'wp_dynamic_widgets'
2 | 0.0008 | enabled | not cached | 10498 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = 'nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC
3 | 0.0001 | enabled | cached | 503 | SELECT `post_parent` FROM wp_posts WHERE ID = 12807 LIMIT 1
4 | 0.0009 | enabled | not cached | 789 | SELECT url FROM wp_cloakPig_cloaks WHERE cloak='nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews' OR cloak='/nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews' OR cloak='nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews/' OR cloak='/nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews/'
5 | 0.0002 | enabled | cached | 7147 | SELECT * FROM wp_posts WHERE ID = 12807 LIMIT 1
6 | 0.0002 | enabled | cached | 10761 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date ASC LIMIT 0, 1
7 | 0.0035 | enabled | not cached | 6395 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (2590) ORDER BY t.name ASC
8 | 0.0009 | disabled (Query is rejected) | not cached | 0 | DELETE FROM wp_t09_sb_jobs WHERE done=1
9 | 0.0001 | enabled | cached | 513 | SELECT MAX(id) FROM wp_t09_sb_log
10 | 0.0001 | disabled (Query is rejected) | not cached | 0 | DELETE FROM wp_t09_sb_log WHERE id<15785
11 | 0.0002 | enabled | cached | 19202 | SELECT field,`data` FROM wp_t09_sb WHERE pageid=0
12 | 0.0003 | disabled (Query is rejected) | not cached | 0 | UPDATE wp_t09_sb SET `data`='1' WHERE pageid=0 AND field='nonce'
13 | 0.0002 | enabled | cached | 3589 | SELECT pageid FROM wp_t09_sb WHERE field='post_random' AND data='1' GROUP BY pageid
14 | 0.0001 | enabled | cached | 1741 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=10
15 | 0.0001 | enabled | cached | 1665 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=12
16 | 0.0001 | enabled | cached | 1664 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=14
17 | 0.0001 | enabled | cached | 1659 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=16
18 | 0.0001 | enabled | cached | 1734 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=18
19 | 0.0001 | enabled | cached | 1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=20
20 | 0.0001 | enabled | cached | 1681 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=22
21 | 0.0001 | enabled | cached | 1683 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=24
22 | 0.0001 | enabled | cached | 1668 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=36
23 | 0.0001 | enabled | cached | 1667 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=40
24 | 0.0001 | enabled | cached | 1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=46
25 | 0.0001 | enabled | cached | 1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=48
26 | 0.0001 | enabled | cached | 1665 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=62
27 | 0.0001 | enabled | cached | 1663 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=64
28 | 0.0001 | enabled | cached | 1668 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=66
29 | 0.0001 | enabled | cached | 1668 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=68
30 | 0.0001 | enabled | cached | 1667 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=70
31 | 0.0001 | enabled | cached | 1667 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=72
32 | 0.0001 | enabled | cached | 1669 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=76
33 | 0.0001 | enabled | cached | 1747 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=78
34 | 0.0001 | enabled | cached | 1740 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=80
35 | 0.0001 | enabled | cached | 1750 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=82
36 | 0.0001 | enabled | cached | 1750 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=84
37 | 0.0001 | enabled | cached | 1748 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=86
38 | 0.0001 | enabled | cached | 1748 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=88
39 | 0.0001 | enabled | cached | 1752 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=90
40 | 0.0001 | enabled | cached | 1683 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=92
41 | 0.0001 | enabled | cached | 1690 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=94
42 | 0.0001 | enabled | cached | 1662 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=112
43 | 0.0001 | enabled | cached | 1660 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=114
44 | 0.0001 | enabled | cached | 1662 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=116
45 | 0.0001 | enabled | cached | 1661 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=118
46 | 0.0001 | enabled | cached | 1662 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=120
47 | 0.0001 | enabled | cached | 1657 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=122
48 | 0.0001 | enabled | cached | 1659 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=124
49 | 0.0001 | enabled | cached | 1666 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=140
50 | 0.0001 | enabled | cached | 1666 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=142
51 | 0.0001 | enabled | cached | 1665 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=144
52 | 0.0001 | enabled | cached | 1664 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=146
53 | 0.0001 | enabled | cached | 1666 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=148
54 | 0.0001 | enabled | cached | 1663 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=150
55 | 0.0001 | enabled | cached | 1660 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=152
56 | 0.0001 | enabled | cached | 1729 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=164
57 | 0.0001 | enabled | cached | 1730 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=166
58 | 0.0001 | enabled | cached | 1734 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=168
59 | 0.0001 | enabled | cached | 1734 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=170
60 | 0.0001 | enabled | cached | 1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=172
61 | 0.0001 | enabled | cached | 1733 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=174
62 | 0.0001 | enabled | cached | 1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=176
63 | 0.0001 | enabled | cached | 1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=178
64 | 0.0001 | enabled | cached | 1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=180
65 | 0.0001 | enabled | cached | 1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=182
66 | 0.0001 | enabled | cached | 1817 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=184
67 | 0.0001 | enabled | cached | 1824 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=186
68 | 0.0001 | enabled | cached | 1827 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=188
69 | 0.0001 | enabled | cached | 1733 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=190
70 | 0.0001 | enabled | cached | 1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=192
71 | 0.0001 | enabled | cached | 1729 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=194
72 | 0.0001 | enabled | cached | 1725 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=196
73 | 0.0001 | enabled | cached | 1727 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=198
74 | 0.0001 | enabled | cached | 1728 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=200
75 | 0.0001 | enabled | cached | 1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=202
76 | 0.0001 | enabled | cached | 1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=204
77 | 0.0001 | enabled | cached | 1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=206
78 | 0.0001 | enabled | cached | 1808 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=210
79 | 0.0001 | enabled | cached | 1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=214
80 | 0.0001 | enabled | cached | 1266 | SELECT id,string,accountid FROM wp_t09_sb_jobs WHERE done=0 LIMIT 0,1
81 | 0.0002 | disabled (Query is rejected) | not cached | 0 | UPDATE wp_t09_sb_jobs SET done=1 WHERE id=17176
82 | 0.0001 | enabled | cached | 1683 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=92
83 | 0.0001 | enabled | cached | 5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'
84 | 0.0001 | enabled | cached | 5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'
85 | 0.0001 | enabled | cached | 1384 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&lcpt=0&lcpf=0'
86 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501QH'
87 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501QH'
88 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501QH'
89 | 0.1353 | enabled | not cached | 1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A38Z&summary=0&truncate=5000&v=2&sig=k%2FPBUDRhB8vnP5dYASu7jTEu2Y4bQCSA69YVbEBm7HY%3D'
90 | 0.0007 | disabled (Query is rejected) | not cached | 0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A38Z&summary=0&truncate=5000&v=2&sig=k%2FPBUDRhB8vnP5dYASu7jTEu2Y4bQCSA69YVbEBm7HY%3D','/hiddendeals/ju0W','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')
91 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501QH'
92 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH00'
93 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH00'
94 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH00'
95 | 0.1634 | enabled | not cached | 1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A39Z&summary=0&truncate=5000&v=2&sig=rJg7CubgRKpXE0c8LtZcDQ1QTaNGKSGl9%2F2oRt356Qk%3D'
96 | 0.0007 | disabled (Query is rejected) | not cached | 0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A39Z&summary=0&truncate=5000&v=2&sig=rJg7CubgRKpXE0c8LtZcDQ1QTaNGKSGl9%2F2oRt356Qk%3D','/hiddendeals/vdkQ','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')
97 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH00'
98 | 0.0001 | enabled | cached | 5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'
99 | 0.0002 | enabled | cached | 5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'
100 | 0.0001 | enabled | cached | 1384 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&lcpt=0&lcpf=0'
101 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501QH'
102 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501QH'
103 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501QH'
104 | 0.1583 | enabled | not cached | 1336 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=aC5qSrxvcx8WZfD6P%2Fe%2B%2FUJbfVBfQ3WrvrvA1o45t90%3D'
105 | 0.0004 | disabled (Query is rejected) | not cached | 0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=aC5qSrxvcx8WZfD6P%2Fe%2B%2FUJbfVBfQ3WrvrvA1o45t90%3D','/hiddendeals/5KmS','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')
106 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501QH'
107 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH00'
108 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH00'
109 | 0.0001 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH00'
110 | 0.2249 | enabled | not cached | 1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=wgopq97z0SWQpAANpIq6cFTtWjRw9aEDEuHIk%2B0p9hY%3D'
111 | 0.0005 | disabled (Query is rejected) | not cached | 0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=wgopq97z0SWQpAANpIq6cFTtWjRw9aEDEuHIk%2B0p9hY%3D','/hiddendeals/q0Xk','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')
112 | 0.0002 | enabled | cached | 1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH00'
113 | 0.0003 | disabled (Query is rejected) | not cached | 0 | INSERT INTO wp_t09_sb_log(url,msg,type) VALUES('http://delicious.com/Minigrovy','Posting to delicious.com/Minigrovy','1')
114 | 0.0005 | enabled | not cached | 1386 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&lcpt=0&lcpf=0'
115 | 0.0021 | enabled | not cached | 9696 | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2011-11-02 08:31:55' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT 1
116 | 0.0001 | enabled | cached | 503 | SELECT `post_parent` FROM wp_posts WHERE ID = 12807 LIMIT 1
117 | 0.0027 | enabled | not cached | 8082 | SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2011-11-02 08:31:55' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1
118 | 0.0001 | enabled | cached | 503 | SELECT `post_parent` FROM wp_posts WHERE ID = 12807 LIMIT 1
119 | 0.0002 | enabled | cached | 885 | SELECT DISTINCT widget_id FROM wp_dynamic_widgets
WHERE maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')
120 | 0.0002 | enabled | cached | 1746 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
WHERE widget_id LIKE 'text-25'
AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name
121 | 0.0002 | enabled | cached | 2015 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
WHERE widget_id LIKE 'text-23'
AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name
122 | 0.0002 | enabled | cached | 2015 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
WHERE widget_id LIKE 'text-26'
AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name
123 | 0.0002 | enabled | cached | 1746 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
WHERE widget_id LIKE 'text-15'
AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name
124 | 0.0002 | enabled | cached | 1750 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
WHERE widget_id LIKE 'execphp-3'
AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name
125 | 0.0002 | enabled | cached | 3143 | SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('2824') ORDER BY tr.object_id ASC
126 | 0.001 | enabled | cached | 48124 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (10733,10734,10736,10737,10739,10740,10742,10743,10745,10746,10747,10748,10753,10754,10755,10756,10758,10759,10760,10761,10763,10764,10765,10766,10767,10768,10769,10770,10771,10772,10773,10775,12033,12034,12035,12052,12053,12054,12055,12056,12794,12808,13510,13511,13512,13918,15246,15270) AND wp_posts.post_type = 'nav_menu_item' AND (wp_posts.post_status = 'publish') ORDER BY menu_order ASC
127 | 0.0011 | enabled | not cached | 884 | SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (2590) ORDER BY t.name ASC
128 | 0.0002 | enabled | cached | 5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'
129 | 0.0002 | enabled | cached | 1386 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&lcpt=0&lcpf=0'
130 | 0.0005 | enabled | not cached | 1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3C'
131 | 0.0002 | enabled | cached | 1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3C'
132 | 0.0002 | enabled | cached | 1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3C'
133 | 0.2199 | enabled | not cached | 1334 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B000VDCT3C&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A42Z&summary=0&truncate=5000&v=2&sig=vI9p%2BbFW7LAEIEzXlWcX50PK%2BKCYFDedoOcgykuDceo%3D'
134 | 0.0004 | disabled (Query is rejected) | not cached | 0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B000VDCT3C&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A42Z&summary=0&truncate=5000&v=2&sig=vI9p%2BbFW7LAEIEzXlWcX50PK%2BKCYFDedoOcgykuDceo%3D','/hiddendeals/27oN','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')
135 | 0.0001 | enabled | cached | 1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3C'
136 | 0.0007 | enabled | not cached | 4900 | SELECT * FROM wp_comments WHERE comment_approved = '1' AND comment_post_ID = 2590 ORDER BY comment_date_gmt ASC
137 | 0.0001 | enabled | cached | 632 | SELECT term_taxonomy_id
FROM wp_term_taxonomy
WHERE taxonomy = 'category'
AND term_id IN (1)
138 | 0.0005 | disabled (Query is rejected) | not cached | 0 | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (1) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 20
139 | 0.0002 | disabled (Query is rejected) | not cached | 0 | SELECT FOUND_ROWS()
-->
RE: Help and advice greatly appreciated. - pmeenan - 11-17-2011 11:33 PM
Look through the Time (s) column and see which queries are taking a long time. The ones that jump out in this case are:
Code:
89 | 0.1353 | enabled | not cached | 1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A38Z&summary=0&truncate=5000&v=2&sig=k%2FPBUDRhB8vnP5dYASu7jTEu2Y4bQCSA69YVbEBm7HY%3D'
95 | 0.1634 | enabled | not cached | 1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A39Z&summary=0&truncate=5000&v=2&sig=rJg7CubgRKpXE0c8LtZcDQ1QTaNGKSGl9%2F2oRt356Qk%3D'
104 | 0.1583 | enabled | not cached | 1336 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=aC5qSrxvcx8WZfD6P%2Fe%2B%2FUJbfVBfQ3WrvrvA1o45t90%3D'
110 | 0.2249 | enabled | not cached | 1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=wgopq97z0SWQpAANpIq6cFTtWjRw9aEDEuHIk%2B0p9hY%3D'
I don't know much about the CloakPig plugin but it looks like it is probably responsible for most of your performance issues. You can add a database index to the url column of the wp_cloakPig_cloaks table if one doesn't already exist or if the plugin isn't critical to your site you can also disable it.
Since it is a commercial product you could also reach out to the developer and see if they have any updates that can address performance issues.
RE: Help and advice greatly appreciated. - mylemonhead - 11-18-2011 12:01 AM
ur right pmeenam, ive installed wordpress debug and it seems this plugin is the main culprit. Thanks again for your time and patience.
You gave me a direction, now im better aware of the situation and nt as clueless.
|