Very slow query wp-seo

[mehdiraized]

Very slow query of site me
(
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1
AND wp_posts.ID NOT IN (260706)
AND ( ( wp_postmeta.meta_key = '_yoast_wpseo_focuskw'
AND wp_postmeta.meta_value = 'real madrid' ) )
AND wp_posts.post_type IN ('post', 'page', 'attachment')
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'future'
OR wp_posts.post_status = 'draft'
OR wp_posts.post_status = 'pending'
OR wp_posts.post_author = 306
AND wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 2
)

Technical info

• WordPress version: 4.7.2
• Yoast SEO version: 4.3

[CarolineGeven]

Thanks for reporting this issue. We've been able to reproduce the issue and have therefore labeled the issue as a bug.

Unfortunately we're not able to fix this at short notice. Currently we're focusing on issues that affect many users. We've concluded that this issue is not experienced by many users, therefore we are not able to fix this short-term. However, if more users are affected by this bug, we'll of course revisit this issue.

[karimdastyari]

+1

[babak15]

+1

[FARSHADFAR]

+1

[ozil20]

+1

[shadi07]

+1

[pamjadz]

+1

[PayteR]

+1

[h08831n]

+1

[GreenLondon]

Another slow query this time found on Dashboard -> Home

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_yoast_wpseo_focuskw' ) WHERE 1=1 AND ( wp_postmeta.post_id IS NULL ) 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, 24

Thank you`

[llpereiras]

Hi Guys, in the new relic of my job, I saw this slow query.

Does anybody has anything to do resolve this issue ?

[lreisoliveira]

+1

[gikApp]

I got this issue in WP Dashboard and then got 504 error because myssql took over 100% CPU.
It's very slow query.
Hope you fix it soon!

[mmikhan]

Another slow 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_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id AND mt1.meta_key = ‘_yoast_wpseo_primary_category’ ) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (1,67,71,123,125,126,127,129,130)
) AND (
( wp_postmeta.meta_key = ‘_yoast_wpseo_primary_category’ AND wp_postmeta.meta_value LIKE ‘%1%’ )
OR
mt1.post_id IS NULL
) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4

[sneader]

+1

[mmikhan]

Please inform the customer of conversation # 215321 when this conversation has been closed.

[brad13x]

+1

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
LEFT JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
LEFT JOIN wp_postmeta AS mt1
ON (wp_posts.ID = mt1.post_id
AND mt1.meta_key = 'yst_prominent_words_version' )
WHERE 1=1
AND ( ( wp_postmeta.meta_key = 'yst_prominent_words_version'
AND wp_postmeta.meta_value != '1' )
OR mt1.post_id IS NULL )
AND wp_posts.post_type = 'page'
AND ((wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'future'
OR wp_posts.post_status = 'draft'
OR wp_posts.post_status = 'pending'
OR wp_posts.post_status = 'private'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 10

[ClickITDev]

+1

[brad13x]

I paid for Yoast SEO Premium and it's broken on that too.

[dandr69]

Same problem, brokes my site.
We can deactivate something to stop it from running? Or disable Yoast?

[brad13x]

Any word on this?

[mmikhan]

Please inform the customer of conversation # 280600 when this conversation has been closed.

[brad13x]

Can you link us @iamazik ? This is a major problem for me and I have spoken with reps at Yoast and they have no plan to fix it in the foreseeable future.

[mmikhan]

These following slow queries appear in the WooCommerce edit products page while using the WooCommerce and Yoast SEO:

SELECT t.*, tt.*, tm.meta_value
FROM wp_terms AS t 
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
LEFT JOIN wp_termmeta AS tm
ON (t.term_id = tm.term_id
AND tm.meta_key = 'order') 
WHERE tt.taxonomy IN ('product_cat') 
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC

SELECT term_id, meta_key, meta_value
FROM wp_termmeta
WHERE term_id IN (9384,9386,9387,9385,9388,6795,2032,3856,2797,2033,8768,2798,2158,4299,2814,2799,2138,3551,2800,2218,2807,4476,4625,5378,5229,5079,4925,4777,4634,2030,3857,2801,2034,8769,2804,2159,4300,2803,4014,2042,2815,2805,2130,2802,2219,2806,2443,2808,4477,4626,5379,5230,5080,4926,4778,4635,2417,3858,3876,4216,8770,4217,2810,5689,2434,4255,4301,2816,5669,3731,4174,3732,2811,2419,2812,2446,4478,4627,5380,5231,5081,4927,4779,4636,2809,7067,7926,1173,1971,2820,3873,1420,1631,1528,1456,1492,2813,722,3897,8740,4218,3293,5943,2822,6805,5690,877,1707,4256,1738,998,2828,1887,6270,4302,2817,9040,2006,5667,5821,3228,1059,2826,4175,1682,1172,3552,2821,2220,2823,9147,6922,6921,1338,4015,1316,2829,1933,2827,1030,2824,2440,2818,1262,2825,6934,2297,1171,4479,4628,5381,5232,5082,4928,4780,4637,7066,7927,2418,3859,3875,2830,5691,2435,4257,4303,5670,5671,2831,2420,2832,2463,3736,3737,4480,4629,5382,5233,5083,4929,4781,4638,7068,7928,1174,1972,2837,1421,1632,1529,1493,1457,2833,723,8771,3294,2839,6806,5692,1176,1708,4258,1739,1888,4304,2834,9096,2007,5668,5832,3229,1175,2845,2089,3553,2838,2221,2840,4016,1339,7277,7278,1317,2841,1934,2844,1031,2842,2456,2836,1263,2843,2298,4481,4630,5383,5234,5084,4930,4782,4639,7069,7929,2062,2067,3860,3877,2846,8772,2075,2847,2436,2160,4305,3434,3435,2848,2223,2849,6946,2301,4482,4631,5384,5235,5085,4931,4783,4640,7090,7930,2069,3861,3878,2851,8773,2077,2850,2437,2161,4306,2852,2224,2853,2302,4483,4632,5385,5236,5086,4932,4784,4641,7091,7932,2068,2854,8774,2076,2857,2438,2162,4307,5672,5673,2855,2225,2856,4484,5527,5386,5237,5087,4933,4785,4642,7092,7933,2061,2070,2859,8775,2078,2858,2439,2163,4308,2860,2226,2861,2307,4485,5528,5387,5238,5088,4934,4786,4643,7098,7934,947,1990,2862,8776,2863,2164,4309,6053,6054,3564,3565,2864,2227,6985,6986,4486,5529,5388,5239,5089,4935,4787,4644,1988,3862,2865,8777,2866,2165,4310,3436,8438,3437,6052,3563,3566,2867,2228,2868,2490,6989,6998,6990,4487,5530,5389,5240,5090,4936,4788,4645,1981,2869,8778,8380,2871,2166,4311,3442,8437,3443,3562,3567,2870,2229,4488,5531,5390,5241,5091,4937,4789,4646,1984,8439,8440,2872,8779,2873,2167,4312,3561,3568,2874,2230,4489,5532,5391,5242,5092,4938,4790,4647,1986,2875,8780,2876,2168,4313,3440,8441,3441,3560,3569,2877,2231,2878,7024,7023,2310,4490,5533,5392,5243,5093,4939,4791,4648,1882,2879,8781,4297,2883,2169,4314,3438,8431,8432,8433,8434,3439,6055,3558,3559,2880,2232,2881,4017,1883,2882,7032,7031,2314,4491,5534,5393,5244,5094,4940,4792,4649,1260,8435,8436,3570,3571,2884,8782,1261,2886,2170,4315,2885,2233,4492,5535,5394,5245,5095,4941,4793,4650,2395,2887,8783,3225,6796,6797,4316,6056,6057,3556,3557,2888,2397,2889,4018,2394,6949,6950,4493,5536,5395,5246,5096,4942,4794,4651,1877,2890,8784,1960,3297,2152,2894,6807,5693,4259,2041,1889,6274,4317,5678,9247,8425,5679,5942,6061,3744,3745,2892,2234,2893,1878,1879,2153,2897,2392,2895,2464,2043,2896,7040,2311,4494,5537,5396,5247,5097,4943,4795,4652,7133,7935,1995,2898,8785,2140,2903,6808,5694,4260,2171,6276,4318,6882,3508,9161,5677,5941,3509,2904,2141,3555,2900,2235,2905,2155,6830,2901,2468,2902,2313,4495,5538,5397,5248,5098,4944,4796,4653,7135,7936,1177,2909,3879,1422,1633,1530,1494,1458,2906,8786,727,3299,1822,1823,1824,3896,8669,8670,8660,8668,8667,5944,2911,6809,5695,4132,872,1709,4261,1740,1001,1890,6275,4319,6883,2917,9160,8426,8429,8430,5674,5675,5676,5892,3444,2005,6062,1060,2915,4176,4131,7006,1683,870,3554,2910,2236,2912,1340,1318,2154,1935,2916,1032,2913,2478,1101,2908,1264,2914,6974,2312,881,4496,5539,5398,5249,5099,4945,4797,4654,7134,7937,7121,7126,7124,8787,7125,7122,7938,7123,943,2424,7065,6416,6417,5945,2919,5696,3982,2428,2429,2433,3572,4000,3574,2918,2427,4320,4497,5540,5399,5250,5100,4946,4798,4655,2425,5946,2921,5697,3983,2431,2430,2432,4321,3573,4001,4203,3575,2920,2426,4498,5541,5400,5251,5101,4947,4799,4656,2601,1973,3863,6422,2922,8788,5947,3984,3985,4322,3719,4002,4250,3720,2923,2237,4499,5542,5401,5252,5102,4948,4800,4657,7162,7939,1178,2927,3880,1423,1634,1531,1495,1459,2924,8789,737,2107,3974,1803,5948,2928,5698,3977,1843,839,1371,1710,4271,993,1891,4323,3268,3287,2932,4003,1183,1684,1180,4251,2929,2238,2930,1341,1319,855,1915,2934,1033,2931,2552,1181,2925,1265,2933,2358,1179,4500,5543,5402,5253,5103,4949,4801,4658,7163,7940,1182,2938,3881,1424,1635,1532,1496,1460,2935,8790,738,3976,1804,5995,5996,5949,2939,5699,3978,1844,840,1379,1711,4264,1742,994,1892,4324,3269,3288,2944,4004,1685,1191,4252,3576,2940,2239,2941,1342,1320,857,1916,2945,1034,2942,2554,1185,2937,1266,2943,2359,1184,4501,5544,5403,5254,5104,4950,4802,4659,7164,7941,1186,2949,3882,1425,1636,1533,1497,1461,2946,8791,734,2108,3975,1805,5815,5814,3219,5950,2950,5700,3979,1845,838,1377,1712,4265,1743,995,1893,4325,3270,3289,2956,8450,5680,5681,5682,5683,5684,6004,3430,6044,1063,2953,4005,1188,1686,1190,4204,3577,2951,2240,2952,1343,1321,852,1914,2957,1035,2954,2558,1192,2948,1267,2955,2360,1189,4502,5545,5404,5255,5105,4951,4803,4660,7165,7942,1968,2970,8792,2109,5951,3980,3981,4326,3273,4207,4208,2971,2241,4503,5546,5405,5256,5106,4952,4804,4661,7166,7943,1193,2961,1426,1637,1534,1498,1462,2958,8793,742,1806,3218,5952,2962,5701,3986,1846,841,1378,1713,1744,996,1894,4327,3272,3290,2968,5686,6010,3431,3231,1078,2967,4127,1688,1195,3578,2963,2242,2964,1344,1322,856,1910,2969,1036,2965,2513,2960,1268,2966,6102,1194,4504,5547,5406,5257,5107,4953,4805,4662,6636,6637,6638,8990,8989,6647,6639,6767,6640,6641,7365,6642,6645,6888,7998,6644,9288,9289,1199,2976,3883,1427,1638,1535,1499,1463,2973,8794,732,2110,3972,1807,5953,2977,5702,3987,1847,844,1380,1714,1003,1895,4328,3271,3291,2983,3232,3425,1064,2980,4006,1687,4210,3579,2982,2243,2978,1345,1323,1906,2981,2588,1200,2975,1269,2979,9294,2361,4505,5548,5407,5258,5108,4954,4806,4663,7167,7944,1312,2986,1428,1639,1536,1500,1464,2984,8795,1313,2987,3988,1848,1314,1381,1715,1896,4329,3274,3292,3426,3427,3580,3581,2989,2244,2988,1346,1324,2990,2597,9290,9291,4506,5549,5408,5259,5109,4955,4807,4664,7168,7945,6395,1196,2993,3884,1429,1640,1537,1501,1465,2991,8796,743,2111,1809,3224,5954,2994,5703,3989,1849,2055,1382,1716,4269,1004,1897,4330,3275,2999,4007,1689,1198,4206,3582,2995,2245,2996,1347,1909,2997,2530,3000,1270,2998,2362,1197,4507,5550,5409,5260,5110,4956,4808,4665,7169,7946,1201,3004,1430,1641,1538,1502,1466,3001,8797,735,2112,1810,3222,5955,3005,5704,3990,1850,845,1383,1717,1005,1898,4331,3276,3010,3432,3233,1080,3011,1690,4197,3583,3006,2246,3007,1348,1325,1907,3008,2536,3003,1271,3009,1202,4508,5551,5410,5261,5111,4957,4809,4666,7170,7947,1203,3015,1431,1642,1539,1503,1467,3012,8798,736,2113,1811,3223,5956,3016,5705,3991,1851,1204,1384,1718,4270,1006,1899,4332,3277,3021,3433,3235,1079,3019,1691,4198,3584,3020,3017,1349,1326,1908,3022,2537,3014,1272,3018,1205,4509,5552,5411,5262,5112,4958,4810,4667,7171,7948,2247,2149,3864,3023,8799,2529,2151,3855,2664,3024,3992,2655,2157,2172,4333,3278,3585,3588,3027,2248,3025,2150,3026,2508,4510,5553,5412,5263,5113,4959,4811,4668,7172,7949,1842,3865,3279,3028,8800,2056,2114,3854,2765,3030,3993,1854,2057,2064,1900,4334,3586,3587,3033,2249,3031,1862,7274,7275,7276,1965,3032,2509,9292,9293,4511,5554,5413,5264,5114,4960,4812,4669,7173,7950,1207,3036,3885,1432,1643,1540,1504,1468,3034,8801,741,5957,3037,5706,3994,1385,1719,1007,1901,4335,3280,3040,4008,1692,4253,3589,3041,2250,3038,1912,3035,1302,4512,5555,5414,5265,5115,4961,4813,4670,7174,7951,1350,2756,1206,3046,1433,1644,1541,1505,1469,3042,8802,740,2115,1813,5958,3043,5707,3995,1852,842,1720,1008,1902,4336,3282,3044,2004,3429,1083,3049,4128,1208,1693,1209,3590,3048,1354,1327,853,1911,3051,1259,1040,3050,2523,2209,3045,1273,4513,5556,5415,5266,5116,4963,4814,4671,7175,7952,2251,2755,7336,5800,8803,6658,5798,5801,5802,5803,5799,4446,6042,7996,6043,6090,4515,5416,5267,5117,4962,4815,4816,7176,7953,2762,1210,3060,3886,1434,1645,1542,1506,1470,3052,8804,1139,2116,1814,3227,2660,2657,2766,5959,3053,5708,3996,1839,1140,1387,1706,4266,1746,1211,1816,1820,1819,1885,4337,3283,3058,2003,6002,3307,3054,8154,4205,4129,3333,3332,3591,3055,1351,1328,1142,1904,3061,1141,3056,2498,3057,1274,3062,2363,4212,4514,5557,5417,5268,5118,4964,4817,4672,7177,7954,2252,1825,6174,6222,6175,8805,6176,6177,6265,6264,6179,6235,6180,6183,6181,6184,6185,6182,6186,6187,6188,6189,6190,6191,6192,6193,6194,6195,6196,8155,6198,6199,6200,6197,6201,6202,6203,6204,6205,6206,6207,6208,6209,6210,6211,6212,6213,6214,6215,6216,6217,6218,6219,7178,7955,7018,3072,1435,1646,1543,1507,1471,3063,8806,733,2117,1815,3226,2659,2658,2767,5960,3064,5709,3997,1838,836,1388,1705,4267,1747,1009,1817,1821,1818,1884,4338,3284,3069,2002,6001,3308,3065,8156,4209,4130,1212,1213,3592,3066,1352,1329,854,1905,3073,1041,3067,2499,3068,1275,3071,2364,1216,4516,5558,5418,5269,5119,4965,4818,4673,7179,7956,2253,1826,2763,3321,3300,8807,3304,3305,6263,6262,2768,5961,3310,5710,3999,3323,3311,3312,3325,4268,3324,3313,3314,3315,3316,3326,4339,3285,3301,3327,5999,3309,3302,8157,3317,3318,3593,3266,3267,3328,4294,6269,3322,3329,3330,3331,4213,4214,4517,5559,5419,5270,5120,4966,4819,4674,7180,7957,2757,2758,9110,8442,8449,5805,8808,6253,5813,3866,5962,4285,6257,4286,4340,3594,4202,3721,3533,4019,3540,6033,6038,6034,4518,5560,5420,5271,5121,4967,4820,4675,2759,9111,8443,8448,5806,8809,6254,5812,3867,5963,4282,6258,4287,4341,3595,4201,3722,3534,4020,3539,6032,6039,6035,4519,5561,5421,5272,5122,4968,4821,4676,2760,9112,8444,8447,5807,8810,6255,5811,3868,5964,4283,6259,4288,4342,3596,4200,3723,3535,4021,3538,6031,6040,6036,4520,5562,5422,5273,5123,4969,4822,4677,2761,9113,8445,8446,5808,8811,6256,5810,3869,5965,4284,6260,4289,4343,3597,4199,3724,3536,4022,3537,6030,6041,6037,4521,5563,5423,5274,5124,4970,4823,4678,1214,3077,6745,1436,1647,1544,1508,1472,3074,8812,739,2118,3973,1876,3220,5966,3078,5711,1853,843,1389,3998,1721,4272,1748,1010,1886,4344,3286,3083,5685,6003,3428,1084,3082,4009,1694,1215,4254,3598,3079,1353,1330,858,1913,3084,1042,3080,2583,1218,3076,1276,3081,2365,1217,4522,5564,5424,5275,5125,4971,4824,4679,7181,7958,2254,9078,9083,9084,9081,9215,9082,9079,9080,9213,9114,2652,2653,3085,2654,4345,4523,5565,5425,5276,5126,4972,4825,4680,6794,1222,3087,3887,1437,1648,1545,1509,1473,3086,8813,6527,745,6261,3904,3905,3906,5967,3088,5712,4134,1722,4293,1749,1628,6306,4346,3522,8451,8452,8453,3523,6066,3090,4180,4133,3599,1223,1695,3089,4023,1357,1331,3092,3091,2625,2626,2627,2628,1277,7045,7055,7046,4524,5566,5426,5277,5127,4973,4827,4826,7230,7959,2255,3516,3517,3518,4347,4525,5567,5427,5278,5128,4974,4828,4681,7231,7960,3519,4348,3520,3521,7232,7961,4526,5568,5428,5279,5129,4975,4829,4682,3334,3335,8814,3908,3336,4118,4273,4119,4349,3689,8454,3690,6063,3600,3605,4527,5569,5429,5280,5130,4976,4830,4683,7233,7962,3525,1224,3094,3888,1438,1649,1546,1510,1474,3093,8815,6266,1165,3900,3901,3902,3337,5968,3095,5713,1723,4274,4117,2173,4350,3510,3511,6064,3097,4177,3604,1226,1696,3096,1358,4024,3098,1166,1278,4528,5570,5430,5281,5131,4977,4831,4684,7234,7963,2256,1221,3100,3889,1439,1650,1547,1511,1475,3099,8816,6267,746,4012,4222,5969,3101,6307,5714,4275,4116,2174,4351,3514,8455,6011,3515,6065,3103,4178,3603,1220,1697,3102,4025,1359,1332,3104,1167,1279,4529,5571,5431,5282,5132,4978,4832,4685,7235,7964,2257,1225,3106,3890,1440,1651,1548,1512,1476,3105,8817,6268,1164,4013,4223,5970,3109,6308,5715,4276,4115,2175,4352,3512,8460,3513,3601,4179,3602,3107,1360,4026,1333,3108,1168,4530,5572,5432,5283,5133,4979,4833,4686,7236,7965,2258,8457,8818,8819,8461,8462,6800,2707,8820,8821,4353,3453,8464,3464,6067,3340,2708,4027,4531,5573,5433,5284,5134,4980,4834,4687,2709,8822,8823,3836,5716,3849,4354,3454,8463,3465,6068,3606,3752,3341,2710,4028,4532,5574,5434,5285,5135,4981,4835,4688,2703,8824,8825,4355,3342,2704,4029,4533,5575,5435,5286,5136,4982,4836,4689,2705,8826,8827,4356,3343,2706,4030,4534,5576,5436,5287,5137,4983,4837,4690,2711,8828,8829,4357,3838,5717,3847,3459,8472,3466,6084,3607,3761,3344,2712,4031,4535,5577,5437,5288,5138,4984,4838,4691,2713,8830,8831,8473,8474,5752,5769,4358,3608,3762,3345,2714,4032,4536,5578,5438,5289,5139,4985,4839,4692,2673,8594,8595,4359,3919,8836,7074,3920,3839,5718,3846,4447,4114,3756,3757,3349,2679,4033,4537,5579,5439,5290,5140,4986,4840,4693,7531,7966,2683,5997,8837,7080,5998,3840,5719,3845,4448,4360,3461,8596,6013,3470,3612,3755,3350,2696,4034,4538,5580,5440,5291,5141,4987,4841,4694,7532,7967,2665,3215,8838,7137,2054,3921,3922,3923,3217,5720,3850,4295,4113,2176,4361,3447,8475,6014,3448,6085,3616,3758,3353,2672,4035,4539,5581,5441,5292,5142,4988,4842,4695,7533,7968,2259,2682,8839,8840,3841,5721,3844,4296,4362,3455,8593,3472,3613,3759,3354,2695,4036,4540,5582,5442,5293,5143,4989,4843,4696,7534,7969,2681,8841,8842,4093,5722,4112,4363,3457,8470,3473,3614,3780,3355,2693,4037,4541,5583,5443,5294,5144,4990,4844,4697,2680,8843,8844,4094,5723,4111,4364,3462,8471,3474,3621,3781,3356,2694,4038,4542,5584,5444,5295,5145,4991,4845,4698,2684,3909,8845,4224,3911,3912,3913,3914,5971,3851,6324,5724,3852,4135,4450,4110,4365,3449,3452,3623,4181,4136,3754,3360,2689,4039,4543,5585,5445,5296,5146,4992,4846,4699,7535,2697,8846,8847,4451,5725,4452,4366,3627,3763,3361,2698,4040,4544,5586,5446,5297,5147,4993,4847,4700,7536,2769,8662,3199,8848,8661,1940,3915,3916,3917,3918,4225,4226,4227,5972,3200,6910,6325,5726,4449,4137,4109,1961,2177,4367,3458,6012,3476,6086,3631,4182,4138,3753,3201,1962,4041,4545,5587,5447,5298,5148,4994,4848,4701,7537,2260,4291,8849,7579,4368,4292,4546,5588,5448,5299,5149,4995,4849,4702,7538,2699,8850,8851,8597,8598,3842,5727,4453,3843,4369,3632,3764,3365,2700,4042,4547,5589,5449,5300,5150,4996,4850,4703,7539,2701,8852,8853,8465,8466,3837,5728,3848,4370,3633,3760,3366,2702,4043,4548,5590,5450,5301,5151,4997,4851,4704,7540,950,2413,8854,8855,8599,8600,4371,3634,3785,4549,5591,5451,5302,5152,4998,4852,4705,7546,2421,2414,8856,8857,4372,3635,3786,4621,5592,5452,5303,5153,4999,4853,4706,7547,2422,1227,3204,1441,1652,1549,1513,1477,3203,8858,754,5973,3205,5729,868,4454,2178,4373,3526,3527,3207,4184,3784,1698,1228,3206,2087,1337,4044,1281,4550,5593,5453,5304,5154,5000,4854,4707,7548,2261,1229,8859,8860,3209,1442,1653,1550,1514,1478,3208,755,5974,3214,5730,4457,2179,4374,3477,3478,3210,4183,3787,1230,4551,5594,5454,5305,5155,5001,4855,4708,7549,2262,2065,8861,8862,3213,5731,4455,2180,4375,3211,2146,6015,6162,3636,3212,2088,2066,4552,5595,5455,5306,5156,5002,4856,4709,7550,2263,2063,2072,8864,8867,2079,2264,2181,4376,3479,3528,4553,5596,5456,5307,5157,5003,4857,4710,7556,2074,8866,8868,2081,4377,2182,4554,5597,5457,5308,5160,5159,4858,5158,7557,2265,2073,8865,8869,2086,2266,4378,2183,4555,5598,5458,5309,5161,5004,4859,4711,7558,953,1231,2753,3970,1443,1654,1551,1515,1479,3110,8870,7144,766,2119,2142,5975,3111,6375,4108,1296,2184,4379,3244,6017,6029,3483,3251,3637,4211,3788,3112,1361,2092,3113,2398,1283,4556,5599,5459,5310,5162,5005,4860,4712,7565,2267,2083,3114,8871,7143,2084,2120,2143,5976,3115,6372,4172,4107,2106,2185,4380,3245,6018,3250,6045,3482,3638,4173,3789,3117,2093,3116,9303,2399,4557,5600,5460,5311,5163,5006,4861,4713,7566,2268,1232,3120,1444,1655,1552,1516,1480,3118,8872,763,2121,3125,5977,3121,6327,4145,1297,1737,4458,1754,2186,4381,3240,6019,3241,3123,4146,3790,1234,1233,3122,1362,2101,3119,1284,3124,2400,4558,5601,5461,5312,5164,5007,4862,4714,7567,2269,1237,6371,3129,1445,1656,1553,1517,1481,3126,8873,764,2122,5978,3128,6328,4147,1299,1729,2187,4382,3239,6020,3242,3639,4148,3791,3130,1363,2102,3127,1285,2270,4559,5602,5462,5313,5165,5008,4863,4715,7568,2094,3131,8874,7155,6757,2123,2144,5979,3132,6373,4149,2104,2188,4383,3246,3249,6048,3640,4150,3792,3133,2095,2271,4560,5603,5463,5314,5166,5009,4864,4716,7569,2090,3134,8875,7186,2124,2145,5980,3135,4151,2103,2189,4384,3247,3248,6049,3480,3641,4152,3808,3136,2091,2272,4561,5604,5464,5315,5167,5010,4865,4717,7570,2096,8876,8877,3137,2105,2190,4385,6050,6051,3642,3793,3138,2097,2273,4562,5605,5465,5316,5168,5011,4866,4718,7571,1235,8683,3139,1446,1657,1554,1518,1482,2795,8878,7142,762,2125,2082,5981,3140,6374,850,4153,1730,1756,1021,2191,4386,3238,6016,3243,6046,3481,3143,4186,4154,3794,1236,3141,1365,1336,2098,3142,9302,2405,4563,5606,5466,5317,5169,5012,4867,4719,7572,2274,1238,3145,1447,1658,1555,1519,1483,2796,8879,760,2126,2080,5982,3146,6326,849,4171,1731,4459,1757,1022,2192,4387,3147,4185,4170,3796,1239,2128,3148,4046,3144,1287,2275,9304,9305,4564,5607,5467,5318,5170,5013,4868,4720,7573,1241,8684,3150,1448,1556,1659,1520,1484,3149,8880,761,4215,2127,5983,3151,4169,1298,1732,1023,2193,4388,4010,6047,4011,3153,4168,3795,863,3152,1364,4047,2276,4565,5608,5468,5319,5171,5014,4869,4721,7574,2211,3367,8881,8882,4389,3810,3812,3389,3410,4048,4566,5609,5469,5320,5172,5015,4870,4722,7622,3368,8883,8884,4390,3809,3813,3387,3408,4049,4567,5610,5470,5321,5173,5016,4871,4723,7623,3369,8885,8886,4391,3811,3814,3388,3409,4050,4568,5611,5471,5322,5174,5017,4872,4724,7624,3370,4462,5732,4463,4392,6231,6232,3643,3815,3386,4051,3407,4569,5612,5472,5323,5175,5018,4873,4725,7604,3371,8887,8888,4393,3644,3816,3390,3411,4052,4570,5613,5473,5324,5176,5019,4874,4726,7610,3372,8889,8890,8603,8604,4394,3645,3817,3391,3412,4053,4571,5614,5474,5325,5177,5020,4875,4727,7609,3373,8892,8893,4395,3487,8605,3490,3646,3818,3392,3413,4054,4572,5615,5475,5326,5178,5021,4876,4728,7608,3374,4228,8896,4229,4396,3488,8606,3491,3647,3819,3393,4055,3414,4573,5616,5476,5327,5179,5022,4877,4729,7607,3383,8897,8898,5770,5771,4397,6233,8607,6234,3394,4056,3415,4574,5617,5477,5328,5023,4878,4730,7605,3384,8899,8900,4398,3395,4057,3416,4575,5618,5478,5329,5180,5024,4879,4731,7606,3375,8902,8903,5984,4466,5733,4467,4399,3648,4187,3820,3396,4058,3417,4576,5619,5479,5330,5181,5025,4880,4732,7611,3378,8904,8905,8615,8616,5754,5772,4400,3649,3821,3397,4059,3418,4577,5620,5480,5331,5182,5026,4881,4733,7612,3379,8906,8907,5755,5773,4401,6236,8614,6237,3650,3822,3398,4060,3419,4578,5621,5481,5332,5183,5027,4882,4734,7613,3376,8908,8909,8612,8613,5753,5774,4402,3651,3823,3399,4061,3420,4579,5622,5482,5333,5184,5028,4883,4735,7614,3377,8910,8911,5756,5775,4403,6238,8611,6239,3652,3824,3400,4062,3421,4580,5623,5483,5334,5185,5029,4884,4736,7615,3382,8912,8913,8656,8657,5757,5776,4404,3653,3825,3401,4063,3422,4581,5624,5484,5335,5186,5030,4885,4737,7616,3380,8914,8915,8601,8602,5758,5777,4405,3654,3826,3402,4064,3423,4582,5625,5485,5336,5187,5031,4886,4738,7617,3381,8916,8917,4406,3655,3827,3403,4065,3424,4583,5626,5486,5337,5188,5032,4887,4739,7618,2212,3924,8918,7191,3925,3928,3931,3932,4230,4231,4232,4233,5985,4092,6388,5734,4468,4106,4407,3486,8610,6240,3492,3656,4189,3828,3404,4066,2215,4584,5627,5487,5338,5189,5033,4888,4740,7619,2277,2213,3926,8919,7192,3927,3929,3930,3933,4234,4237,4236,4235,5986,4091,6389,5735,4469,4105,4408,3485,8609,6241,3493,3657,4190,3829,3405,4067,2216,4585,5628,5488,5339,5190,5034,4889,4741,7620,2278,2214,3934,8920,7201,3935,3936,3937,3938,4238,4241,4240,4239,5987,4090,5736,4470,4155,4104,4409,3484,8608,6023,3494,6242,3658,4188,4156,3830,3406,4068,2217,4586,5629,5489,5340,5191,5035,4890,4742,7621,2279,6801,1922,8921,8922,2280,4410,1927,4587,5630,5490,5341,5192,5036,4891,4743,7639,1919,8923,8924,5759,5778,2281,4411,1924,4588,5631,5491,5342,5193,5037,4892,4744,7640,1925,8925,8927,2282,5760,5779,4412,1926,4589,5632,5492,5343,4893,5194,4745,5038,7641,1920,8928,8929,5761,5780,2283,4413,1928,4590,5633,5493,5344,5195,5039,4894,4746,7642,2210,1943,3156,1945,1959,1958,1957,1956,3155,8930,7259,1944,4242,5988,3157,6812,1949,5737,1951,4471,2194,4144,1946,4414,3529,3530,6243,3161,1950,1954,4192,4143,3159,1947,1948,1953,3160,1952,2368,4591,5634,5494,5345,5196,5040,4895,4747,7630,2285,1242,3163,1449,1660,1557,1521,1485,6024,8658,6025,6244,3162,8931,7260,773,4243,5989,3166,1247,1758,6810,2195,5738,1025,4142,4415,3165,1251,4193,4141,3164,1366,1334,874,3167,2367,1244,2286,4592,5635,4748,5495,5346,5197,5041,4896,7631,1315,1249,3169,1450,1486,1661,1558,1522,3168,8932,803,3170,5739,2196,4416,3171,1250,2287,4593,5636,5496,5347,5198,5044,5043,5042,1923,8933,8934,5762,5781,2288,4417,9300,9301,4622,5497,5637,5348,5199,5047,5046,5045,7644,1929,1921,8935,8936,2289,4418,1930,4623,5200,5048,4897,5638,4749,5498,5349,7643,1243,3174,1451,1662,1559,1523,1487,3172,9073,9074,7109,7110,7111,7403,7404,5990,3175,5740,4473,4103,865,1027,2197,4419,3180,8659,3489,3259,1085,3178,4194,1700,1252,3176,1367,8340,859,3179,8624,1051,3173,1291,3177,2369,1245,4624,5639,5499,5350,5201,5049,4898,4750,7632,2290,1734,1759,1253,6890,3182,1452,1524,1488,1663,1560,3181,9076,9075,6764,7119,6763,4244,4245,4246,5993,3183,6811,5741,4472,4102,1248,1028,2198,4420,3257,8706,6026,3258,3186,4191,1701,1255,3184,1368,1335,873,3185,2370,1254,2291,4594,5640,5500,5351,5202,5050,4899,4751,7633,7449,8937,8938,7450,7451,9295,9296,7634,1931,5763,5782,2292,4421,1932,4595,5641,5501,5352,5203,5051,4900,4752,7385,8939,8940,7386,7387,9298,9299,7635,1257,8941,8942,3187,1453,1664,1561,1525,1489,1293,2293,4596,5052,5642,5502,5353,5204,5054,5053,3188,2199,4422,3189,1091,2415,8943,8945,8713,8714,5764,5783,2423,4423,3659,4597,5643,5503,5354,5205,5055,4901,4753,7636,1860,8946,8947,8707,8708,2202,5765,5784,2294,4424,3660,4598,5355,5206,5056,4902,4754,5644,5504,7637,1861,1258,8948,8949,8709,8710,3193,5742,2200,3190,1454,1665,1562,1526,1490,4425,3192,1702,3191,1370,876,2295,4599,5645,5505,5356,5207,5057,4903,4755,7638,1256,8711,8712,3195,1455,1666,1563,1527,1491,3196,1369,875,4426,6245,6246,3197,1053,3194,8950,808,3198,5743,2201,4600,5646,5506,5058,5357,4904,5208,4756,2296,2416,2715,8951,8952,4429,3952,2777,4602,5359,5210,5060,5648,5508,4906,4758,2716,8953,8954,4428,3951,2776,4601,5647,5507,5358,5209,5059,4905,4757,2717,8955,8956,4430,3953,2778,4603,5649,5509,5360,5211,5061,4907,4759,2719,8957,8958,4431,3954,2779,4604,5650,5510,5361,5212,5062,4908,4760,2720,8959,8960,4432,3955,2780,4605,5651,5511,5362,5213,5063,4909,4761,2718,8961,8962,4433,3956,2781,4606,5512,5652,5363,5214,5064,4910,4762,2725,8963,8964,5766,6803,4427,3531,8736,3532,3957,2782,4081,4607,5653,5513,5364,5215,5065,4911,4763,7911,2724,8965,8966,3669,3958,2783,4080,5767,6798,5785,3497,3506,4434,4608,5365,5066,5216,4912,4764,5654,5514,7912,2727,8967,8968,4087,5744,4101,4435,3500,8730,3503,3959,4079,2784,3668,4609,5515,5655,5366,5217,5067,4913,4765,7913,2730,8969,8970,4089,5745,4100,4436,3498,8731,3505,3960,2785,4078,3667,4610,5516,5367,5218,5068,5656,4914,4766,7914,2731,8971,8972,4088,5746,4099,4437,3499,3504,3666,3961,2786,4077,4611,5368,5219,5069,4915,4767,5657,5517,7915,2728,8973,8974,3665,3962,2787,4076,4086,5747,4098,4438,4612,5658,5518,5369,5220,5070,4916,4768,7916,5793,5795,8975,5796,6799,6802,5794,5797,7917,2732,8991,8992,4439,3664,3963,4075,2788,4613,5071,4917,4769,5659,5519,5370,5221,7918,2726,8976,8977,4085,5748,4440,6247,8732,6248,3964,2789,4074,4614,5520,5371,5222,5072,4918,4770,5660,7919,2729,8978,8979,4084,4097,6804,5749,4441,6249,8733,6250,3965,2790,4073,6058,6060,6059,3949,3950,4615,5661,5521,5372,5223,5073,4919,4771,7920,7204,8980,8982,8734,8735,8622,7205,7206,7921,2733,8983,8984,5768,5786,4442,3966,2791,4072,4616,4772,5522,4920,5662,5373,5224,5074,7922,2721,8985,8986,8737,8738,4443,3663,3967,2792,4071,4617,5663,5523,5374,5225,5075,4921,4773,7923,2722,3939,8987,6006,6009,6007,6008,3940,3941,3942,4279,4280,4281,5991,4083,4475,4139,4096,6350,5750,6814,4444,3501,9037,6028,3502,6252,3662,4196,4140,3968,2793,4070,4618,5664,5524,5375,5226,5076,4922,4774,7924,2723,8621,3943,8988,5687,3945,3946,3947,3948,4247,4248,4249,3496,9260,9038,6027,3507,6251,3661,4195,5992,4082,6813,6351,5751,4474,4095,8191,4445,3969,2794,4069,4619,5665,5525,5376,5227,5077,4923,4775,7925,1966,4620,5666,5526,5377,5228,5078,4924,4776,1703,2050,2044,1704,798,2045,2046,2051,2047,2052,2048,2053,799,801,800)
ORDER BY meta_id ASC

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts 
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 
AND wp_posts.ID NOT IN (80022)
AND ( ( wp_postmeta.meta_key = '_yoast_wpseo_focuskw'
AND wp_postmeta.meta_value = 'Ducabike Ducati Multistrada 1200 DVT Frame Plug Caps Bicolour' ) )
AND wp_posts.post_type IN ('post', 'page', 'attachment', 'product', 'portfolio', 'documentation')
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'wc-freeze-dividebuy'
OR wp_posts.post_status = 'future'
OR wp_posts.post_status = 'draft'
OR wp_posts.post_status = 'pending'
OR wp_posts.post_author = 333
AND wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 2

[mmikhan]

Please inform the customer of conversation # 282974 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 295740 when this conversation has been closed.

[dandr69]

Only solution is to use a bigger server. All the promises for a fix were just promises :-)

[payperpro]

Same problem. Very hight load on my MYSQL server after last updates...

[jdevalk]

SQL_CALC_FOUND_ROWS is what WordPress does internally, we don't do that in our code. In fact, we didn't write any of the queries mentioned in this issue, as we just use WordPress internal functions and that spits out these queries.

This entire set of queries being mentioned here is a result of WordPress database handling being poor. There is one major underlying issue that creates the problem for 90% of the queries mentioned above:

The wp_postmeta table has an index that isn't working on older versions of MySQL because the index length is not identical to the field length, see this comment on WP Trac. There are several issues related to that on core Trac, but this is unfortunately not something we can fix in Yoast SEO.

What we can and will fix is how we deal with our own data. We've got a project lined up to store our post meta in a separate table which will be LOADS faster. So, no, I can't promise you fixes on these queries, as we don't generate them. Which is also why I'm closing this issue now.

[tony47]

We are running several heavy loaded sites and we were also experiencing those performance issues. As @jdevalk mentioned, the problem is not related to Yoast itself, but to the way Wordpress builds some queries.

The fix for us was adding a composite index to wp_postmeta table, as this:

CREATE INDEX post_id_meta_key ON wp_postmeta (post_id, meta_key(191));

We lowered the execution time from 7 seconds to 0,5 seconds on those queries.

Hope it helps.

[Pcosta88]

related #9998

[jsumali]

Thanks @tony47 , your comment helped in 2020 🎉

[PixiBixi]

Still useful in 2021 ! o/

[PecceG2]

Middle of 2021 and create index is the magic solution. ¡Wow! 3 years later. Thanks @tony47

[AlexBantiuc]

thanks @tony47, your comment helped in 2021 also 🎉 🎉 🎉

[rochebleue]

Helped in 2022.

[adeleyeayodeji]

We are running several heavy loaded sites and we were also experiencing those performance issues. As @jdevalk mentioned, the problem is not related to Yoast itself, but to the way Wordpress builds some queries.

The fix for us was adding a composite index to wp_postmeta table, as this:

CREATE INDEX post_id_meta_key ON wp_postmeta (post_id, meta_key(191));

We lowered the execution time from 7 seconds to 0,5 seconds on those queries.

Hope it helps.

This worked for me

[Whroxx]

Eu procurava uma solução pra isso a anos! O Load do meu DB que tem mais de 520k posts viviva em 3/4 ate picos de 8. Agora está em 0.29.

Sensacional.

Obrigado.

[spicybeefnoodle]

Thank you Mr. Tony!

[DenisFlorin]

Has anyone experienced any issues with this query?

SELECT  t.term_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
			WHERE tt.taxonomy IN ('post_tag') AND tt.count > 0
			ORDER BY t.name ASC
			LIMIT 53000,1000

It is not always happening, only when the site gets more visits on tag sitemaps. The website gets stuck with the above queries and returns a 504 error.

Stack trace:
[0x00007f6e77214a40] wp_cache_get() /app/web/wp-includes/cache-compat.php:93
[0x00007f6e77214980] wp_cache_get_multiple() /app/web/wp-includes/functions.php:6978
[0x00007f6e772148b0] _get_non_cached_ids() /app/web/wp-includes/taxonomy.php:4019
[0x00007f6e772147d0] _prime_term_caches() /app/web/wp-includes/class-wp-term-query.php:827
[0x00007f6e77214370] get_terms() /app/web/wp-includes/class-wp-term-query.php:308
[0x00007f6e77214300] query() /app/web/wp-includes/taxonomy.php:1308
[0x00007f6e772141d0] get_terms() /app/web/wp-content/plugins/wordpress-seo/inc/sitemaps/class-taxonomy-sitemap-provider.php:100
[0x00007f6e77213ff0] get_index_links() /app/web/wp-content/plugins/wordpress-seo/inc/sitemaps/class-sitemaps.php:392
[0x00007f6e77213ee0] build_root_map() /app/web/wp-content/plugins/wordpress-seo/inc/sitemaps/class-sitemaps.php:346
[0x00007f6e77213e20] build_sitemap() /app/web/wp-content/plugins/wordpress-seo/inc/sitemaps/class-sitemaps.php:261
[0x00007f6e77213d60] redirect() /app/web/wp-includes/class-wp-hook.php:308
[0x00007f6e77213c80] apply_filters() /app/web/wp-includes/class-wp-hook.php:332
[0x00007f6e77213c10] do_action() /app/web/wp-includes/plugin.php:565
[0x00007f6e77213b50] do_action_ref_array() /app/web/wp-includes/class-wp-query.php:1833
[0x00007f6e77213310] get_posts() /app/web/wp-includes/class-wp-query.php:3749
[0x00007f6e772132a0] query() /app/web/wp-includes/class-wp.php:663
[0x00007f6e77213230] query_posts() /app/web/wp-includes/class-wp.php:783
[0x00007f6e772131a0] main() /app/web/wp-includes/functions.php:1332
[08-Jan-2023 09:01:01] NOTICE: finished trace of 4163428
[08-Jan-2023 09:01:01] NOTICE: child 4163350 stopped for tracing
[08-Jan-2023 09:01:01] NOTICE: about to trace 4163350

I have around 74k tags.

Thanks,