jvpress themed wordpress site running EXTREMELY SLOW
my site at bengreenfieldfitness dot com forward slash inner circle
is running WAY SLOW. There is a bunch of CPU Throttling, and my SQL slow queries look like this all over:
# Wed Jan 26 15:00:37 2011
# Query_time: 1.777703 Lock_time: 0.050240 Rows_sent: 856 Rows_examined: 856
use trainfo2_wpbgf;
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4143,4063,4029,4000,3971,3964,3953,3922,3819,3798 ,3768,3751,3706,3694,3630,3508,3483,3460,3438,3292 ,3269,3210,3200,3072,3008,2971,2959,2943,2952,2898 ,2864,2872,2840,2821,2791,2772,2736,2710,2676,2644 ,2630,2606,2596,2565,2544,2520,2499,2308,2341,2333 ,2317,2290,2241,2222,2182,2096,2046,2011,1983,1925 ,1900,1796,1847,1827,1813,1799,1779,1763,1729,1706 ,1674,1633,1648,1609,1589,1542,1513,1504,1486,1423 ,1452,1440,1409,1397,1385,1377,1335,1313,1238,1275 ,1248,1208,1182,1132,1110,1088,1077,1050,1046,994)
# Wed Jan 26 15:00:46 2011
# Query_time: 1.087899 Lock_time: 0.000190 Rows_sent: 8 Rows_examined: 40
use trainfo2_wpbgf;
SELECT t.*, tt.*, tr.object_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', 'post_tag') AND tr.object_id IN (3938) ORDER BY t.name ASC
# Wed Jan 26 15:00:53 2011
# Query_time: 1.899714 Lock_time: 0.434021 Rows_sent: 19 Rows_examined: 97
use trainfo2_wpbgf;
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 (2791) ORDER BY t.name ASC
# Wed Jan 26 15:00:58 2011
# Query_time: 1.574858 Lock_time: 0.000179 Rows_sent: 1 Rows_examined: 4
use trainfo2_wrd4;
SELECT t.term_id, tt.parent, tt.count FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC
# Wed Jan 26 15:00:58 2011
# Query_time: 2.888461 Lock_time: 0.050309 Rows_sent: 1277 Rows_examined: 6385
use trainfo2_wpbgf;
SELECT t.*, tt.*, tr.object_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', 'post_tag') AND tr.object_id IN (4143, 4063, 4029, 4000, 3971, 3964, 3953, 3922, 3819, 3798, 3768, 3751, 3706, 3694, 3630, 3508, 3483, 3460, 3438, 3292, 3269, 3210, 3200, 3072, 3008, 2971, 2959, 2943, 2952, 2898, 2864, 2872, 2840, 2821, 2791, 2772, 2736, 2710, 2676, 2644, 2630, 2606, 2596, 2565, 2544, 2520, 2499, 2308, 2341, 2333, 2317, 2290, 2241, 2222, 2182, 2096, 2046, 2011, 1983, 1925, 1900, 1796, 1847, 1827, 1813, 1799, 1779, 1763, 1729, 1706, 1674, 1633, 1648, 1609, 1589, 1542, 1513, 1504, 1486, 1423, 1452, 1440, 1409, 1397, 1385, 1377, 1335, 1313, 1238, 1275, 1248, 1208, 1182, 1132, 1110, 1088, 1077, 1050, 1046, 994) ORDER BY t.name ASC
# Wed Jan 26 15:01:01 2011
# Query_time: 1.591090 Lock_time: 0.050667 Rows_sent: 8 Rows_examined: 44
use trainfo2_wpbgf;
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 (2011) ORDER BY t.name ASC
# Wed Jan 26 15:01:12 2011
# Query_time: 1.365425 Lock_time: 0.050228 Rows_sent: 0 Rows_examined: 4
use trainfo2_wpbgf;
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 (1208) ORDER BY t.name ASC
# Wed Jan 26 15:01:12 2011
# Query_time: 1.443651 Lock_time: 0.050260 Rows_sent: 13 Rows_examined: 69
use trainfo2_wpbgf;
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 (2864) ORDER BY t.name ASC
does ANYBODY have any ideas or can help me? It's causing my itunes feed to run incredibly slow (i.e. a 40mb download is taking about 35 minutes from my site)
-
phpbbxpert -
Thanks - 1 reply
{{ DiscussionBoard.errors[3256686].message }}-
pacificfit -
Thanks
{{ DiscussionBoard.errors[3257576].message }} -
-
-
n7 Studios -
Thanks
SignatureTHE Web Development Guru - Bespoke WordPress Theme, Plugin + iPhone Apps [HTML5, CSS3, PHP, MySQL].{{ DiscussionBoard.errors[3257682].message }} -