Arkadaşlar merhaba,

Sunucumun işlemcisinin aşırı yük altında olduğu zamanlarda yaptığım mysqwl processlist taramasında diğer işlemler dışında sıra dışı olarak şu query'nin işlemciye yük olduğunu düşünmeye başladım. Site biraz eski ve çok fazla kategori + post ve bu postlara etki eden özel alanlar olduğundan böyle bir soruna sebep olduğunu düşünüyorum gerçi tahmin yalnızca benimkisi fakat bu problemi tam olarak nasıl aşabilirim acaba fikir verebilecek var mı?

Sending to client | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158484,158497,158575,158573,158482,158481,158460,158560,158557,158555,158548,158505,158503,158501,158478,158463,158453,158545,158433,158469,158467,158544,158542,158445,158455,158451,158431,158535,158532,158418,158441,158439,158437,158530,158528,158428,158398,158412,158420,158391,158382,158378,158404,158380,158384,158312,158387,158310,158298,158295,158291,158274,158288,158283,158280,158265,158245,158247,158249,158223,158226,158229,158214,158238,158251,158216,158240,158207,158197,158202,158196,158179,158190,158188,158173,158133,158151,158153,158131,158125,158167,158127,158155,158076,158148,158144,158129,158079,158052,158118,158116,158109,158107,158071,158056,158050,158042,158065,158105,158063,158059,158046,158028,158103,158101,158004,158006,158035,158031,158094,158092,157985,158022,157991,158090,158088,158085,157989,157987,158014,158012,158010,157975,157999,157997,157977,157981,157926,157906,157963,157961,157951,157949,157946,157944,157924,157936,157934,157902,157959,157957,157932,157930,157922,157920,157918,157916,157914,157879,157890,157888,157955,157953,157877,157881,157896,157894,157875,157853,157855,157873,157829,157867,157865,157862,157860,157811,157830,157838,157837,157841,157842,157804,157822,157821,157819,157817,157788,157806,157786,157772,157770,157798,157796,157774,157790,157746,157763,157757,157744,157758,157734,157733,157753,157750,157715,157739,157729,157727,157722,157721,157683,157708,157681,157710,157660,157665,147845,147823,157693,157662,157668,157643,157658,157656,157639,157641,157610,157619,157608,157594,157580,157600,157597,157596,157591,147734,147732,157558,157556,157575,157573,157571,157540,157550,157548,157546,157537,157538,157533,157531,157526,157524,157493,157495,157518,157520,157503,157502,157513,157512,157485,157483,157462,157464,157478,157476,157427,157454,157449,157451,157447,157460,157425,157420,157445,157442,157440,157422,157436,157434,157402,157404,157432,157430,157378,157390,157408,157406,157268,157367,157283,157361,157384,157382,157294,157357,157295,157281,157279,157291,157352,157285,157267,157159,157305,157271,157258,157107,157255,157251,157249,157240,157177,157138,157204,157161,157182,157209,157211,157189,157178,157157,157173,157194,157171,157155,157146,157140,157150,157149,157120,157132,157130,157128,157126,157017,157116,157089,157052,157050,157091,157101,157099,157078,157016,157076,157047,157045,157015,157013,157025,157004,157018,157008,157006,157019,157034,156993,156986,156996,156998,156916,156989,156974,156969,156978,156881,156956,156965,156963,156879,156949,156920,156925,156918,156943,156898,156887,156895,156883,156933,156885,156864,156869,156871,156908,156906,156902,156875,156853,156848,156847,156804,156843,156827,156767,156769,156808,156765,156806,156733,156814,156771,156775,156799,156784,156731,156763,156794,156729,156756,156717,156754,156719,156753,156715,156653,156708,156706,156751,156745,156674,156678,156743,156681,156672,156679,156657,156641,156741,156739,156655,156664,156662,156637,156625,156644,156633,156618,156585,156566,156610,156605,156588,156593,156571,156579,156603,156601,156551,156574,156561,156553,156548,156544,156555,156541,156507,156466,156497,156484,156485,156500,156494,156464,156463,156481,156454,156474,156473,156428,156451,156447,156441,156417,156379,156392,156433,156431,156412,156421,156420,156400,156394,156388,156405,156403,156386,156312,156371,156363,156374,156368,156365,156325,156352,156327,156339,156316,156346,156291,156314,156333,156322,156319,156310,156308,156282,156306,156267,156280,156304,156227,156276,156272,156270,156302,156241,156260,156231,156252,156243,156299,156249,156218,156297,156238,156228,156295,156224,156222,156209,156214,156200,156206,156204,156196,156155,156173,156189,156185,156169,156149,156177,156157,156165,156163,156143,156131,156141,156138,156096,156105,156127,156125,156122,156089,156080,156023,156113,156109,156078,156011,155882,156094,156024,156084,156027,156069,156067,156034,155943,156019,155976,156008,155996,156064,156062,155880,155982,155987,155961,155954,155952,155878,155938,155869,155853,155944,156061,155947,156055,155957,156053,155876,155919,155847,155929,156050,155785,155924,155912,155828,155874,155907,155905,155903,155843,155866,156048,155845,155841,155776,155826,155814,156040,155834,156042,155771,155823,156038,155801,155819,155817,155796,155761,155807,155804,155752,155764,155686,155706,155727,155723,155741,155739,155769,155759,155743,155734,155688,155663,155658,155674,155708,155718,155716,155696,155667,155704,155694,155676,155678,155683,155625,155628,155585,155549,155642,155640,155614,155615,155597,155603,155598,155587,155591,155593,155577,155547,155571,155566,155513,155512,155561,155559,155502,155487,155491,155479,155500,155483,155461,155464,155357,155463,155469,155467,155410,155400,155447,155449,155373,155338,155351,155353,155428,155393,155426,155320,155326,155366,155391,155334,155310,155340,155322,155389,155301,155294,155380,155378,155298,155287,155313,155272,155278,155283,155259,155419,155417,155275,155219,155267,155265,155244,155254,155252,155230,155202,155415,155413,155231,155214,155204,155197,155226,155189,155200,155191,155209,155178,155172,155183,155181,155176,155174,155159,155157,155149,155147,155082,155127,155126,155075,155055,155071,155136,155072,155132,155120,155056,155118,155052,155050,155048,155044,155025,155117,155031,155038,154985,155016,155015,155003,155001,154991,155111,154983,154989,154987,154997,154995,154977,154979,154912,154972,154970,154968,154966,154947,154945,154959,155109,154931,154932,154925,154898,155105,154910,155103,154923,154914,154917,154900,155099,155097,154904,155092,155089,154843,154841,155088,154819,154822,154831,154811,154895,154787,154813,154890,154798,154777,154791,154789,154779,154760,154758,154749,154770,154711,154747,154755,154734,154713,154732,154725,154739,154705,154729,154709,154703,154719,154692,154715,154690,154888,154678,154697,154886,154665,154646,154684,154682,154667,154881,154634,154658,154878,154640,154649,154655,154638,154630,154626,154624,154877,154606,154620,154863,154609,154597,154595,154583,154579,154562,154581,154564,154551,154549,154574,154571,154570,154547,154540,154537,154529,154507,154861,154527,154510,154867,154535,154492,154487,154456,154517,154482,154489,154443,154417,154441,154462,154458,154439,154419,154473,154422,154411,154432,154413,154382,154403,154409,154391,154361,154393,154424,154407,154374,154380,154343,154389,154387,154321,154324,154359,154371,154367,154345,154328,154331,154292,154319,154293,154296,154300,154338,154297,154313,154248,154270,154287,154277,154267,154171,154237,154245,154221,154183,154225,154239,154219,154203,154154,154160,154199,154230,154205,154173,154193,154181,154137,154175,154169,154146,154162,154111,154156,154152,154166,154115,154095,154029,154093,154003,154091,154085,154106,154083,154058,154035,154056,154080,154021,154033,154027,154031,154002,154006,154009,153961,154000,154007,153960,153980,153919,153944,153904,153913,153857,153801,153851,153848,153869,153799,153863,153893,153891,153861,153828,153825,153790,153818,153758,153803,153776,153889,153896,153775,153805,153814,153812,153767,153883,153781,153749,153769,153881,153879,153748,153715,153665,153713,153702,153691,153735,153700,153733,153717,153876,153730,153640,153667,153693,153859,153638,153663,153661,153669,153697,153634,153835,153832,153608,153653,153632,153642,153636,153644,153617,153619,153587,153627,153613,153602,153611,153536,153540,153542,153585,153571,153512,153569,153508,153510,153537,153544,153505,153564,153561,153558,153504,153527,153514,153498,153496,153522,153457,153485,153418,153475,153460,153443,153473,153420,153425,153466,153400,153445,153422,153415,153392,153427,153402,153383,153394,153398,153360,153396,153362,153343,153363,153276,153380,153334,153314,153353,153302,153273,153231,153295,153319,153317,153283,153323,153300,153351,153222,153285,153378,153376,153374,153372,153370,153268,153259,153251,153233,153228,153235,153216,153220,153207,153212,153226,153204,153184,153174,153118,153198,153196,153194,153166,153154,153168,153182,153120,153137,153172,153161,153135,153114,153095,153144,153116,153093,153089,153084,153097,153087,153349,153347,153091,153109,153064,153069,153067,153310,153152,153308,153063,153021,153293,153050,153035,153019,153033,153291,152995,153039,152960,152980,152978,153014,152962,152976,152992,152958,153004,152882,152943,152966,152964,152986,152973,152969,152945,152926,152953,152930,152922,152914,152880,152937,152934,152919,152857,152912,152910,152899,152904,152855,152878,152894,152849,152822,152853,152851,152875,152838,152871,152832,152864,152846,152843,152841,152836,152834,152806,152827,152796,152781,152814,152747,152783,152799,152763,152792,152790,152746,152786,152765,152723,152775,152743,152691,152725,152759,152727,152729,152731,152713,152685,152711,152709,152721,152719,152706,152703,152666,152669,152683,152645,152653,152678,152605,152600,152661,152647,152639,152656,152641,152621,152607,152333,152611,152629,152616,152589,152572,152320,152591,152566,153150,152596,152562,152584,152559,153077,152543,152549,152511,152483,153075,152509,152537,153056,153054,153052,152507,152552,152513,152460,152489,152481,152479,152515,152485,152487,152447,152491,152475,152494,152454,152477,152473,152498,152445,152451,152428,152400,152431,152365,152419,152399,152395,152415,152397,152369,152411,152375,152371,152367,152326,152373,152363,152391,152356,152344,152351,152384,152337,152324,152330,152302,152278,152297,152304,152255,152282,152248,152276,152280,152228,152232,152257,152240,152250,152230,152226,152238,152081,152218,152079,152252,152223,152221,152215,152097,152170,152171,152052,152103,152108,152198,152101,152083,152168,152165,152120,152085,152064,152049,152077,152046,152034,152093,152054,152044,152087,152048,152073,151982,152005,152032,152018,151992,152020,152029,152016,152003,152013,151990,151978,151957,151961,151959,151980,151955,151939,151963,151934,151930,151936,151943,151913,151941,151915,151951,151892,151923,151922,151919,151908,151906,151888,151822,151882,151880,151852,151846,151873,151830,151816,151818,151820,151850,151756,151789,151824,151856,151854,151812,151814,151804,151808,151787,151810,151754,151796,151772,151777,151784,151761,151752,151707,151735,151766,151729,151748,151746,151741,151740,151725,151672,151706,151710,151666,151670,151668,151678,151619,151699,151645,151647,151658,151616,151653,151636,151634,151640,151623,151626,151590,151570,151554,151574,151533,151268,151547,151552,151568,151524,151464,151565,151563,151526,151535) ORDER BY meta_id ASC |