API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 24th, 2020
1,087
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.71 KB | None | 0 0
raw download clone embed print report
  1. Wygląda na to że problem jest spowodowany jest tym że konto przekracza limity CPU dla MySQL które są przydzielone do konta, uruchomiłem slow log mysql na serwerze, i jako najczęściej występujące pokazało się zapytanie jak poniżej. Takie zapytania latają około 30 razy na sekundę teraz (statystyki poniżej), podejrzewam że w godzinach szczytu (około 14) było ich dużo więcej. Myślę że trzeba sprawdzić który plugin powoduje takie zapytanie i je zoptymalizować oraz koniecznie uruchomić cache (bez tego aplikacja zje wszystkie zasoby które jej przydzielimy), najlepiej u nas działa Litespeed cache, ale w takim wypadku można przetestować również plugin W3 Total Cache, jesli będzie działał możemy do niego dopiąć Redisa.
  2.  
  3.  
  4. A tutaj przykładowe zapytanie których lata 30/sek
  5.  
  6. | 63327116 | world_akademia | localhost | world_akademia | Query | 1 | Sorting result | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (47,48,108,154,207,637,893,974,1035,1103,1158,1197,1252,1293,1334,10166,10167,1450,1536,2075,2091,2093,2095,2097,2099,2101,2103,2105,3090,3091,3109,8746,10195,10221,10271,10291,10304,10320,10338,10357,10371,10384,10579,10935,10938,11833,11841,11856,11857,22743,29633,23465,23825,23834,29885,24643,24752,24764,25150,25213,25234,25307,25337,25381,25591,25611,25626,25632,26319,27541,27593,27726,29316,30432,31866,32739,33443,34607,35261,36075,36676,36713,37112,37149,37420,37454,37509,37756,37782,37810,37836,37848,38409,43111,43122,45605,45928,45932,45938,45940,45942,46202,46203,46207,46211,47051,47054,47056,47058,47060,47062,47064,47066,48543,50557,50651,52323,52717,53022,53032,53043,53047,53058,53551,55357,55361,55803,55897,60185,56887,57145,57146,58804,59332,59579,59758,59898,60032,60247,60265,60279,60286,60294,60301,60308,60315,60369,60376,60383,60391,62229,62237,62251,67543,68135,68137,68146,68155,68164,68173,68182,68188,68197,69163,69670,69863,49,102,109,155,208,638,894,975,1036,1104,1159,1198,1253,1294,1335,10168,10161,1537,2074,2076,3092,3182,9496,10170,10200,10222,10272,10292,10305,10321,10339,10358,10372,10385,10580,10722,10936,11260,11641,11835,11840,11858,11892,12931,20743,22693,29634,23709,23744,23770,23826,23835,26264,29886,24644,24753,24765,25151,25214,25235,25308,25338,25382,25592,25612,25627,25633,26320,27542,28094,29317,30433,31867,32740,33444,35262,36657,36076,36677,36714,52763,37113,37150,37421,37455,37510,37783,37811,37837,37849,37984,38410,43112,43121,43123,45606,45929,46204,46206,46208,46212,48544,50558,51019,50652,50672,51064,50959,52718,53552,53800,55009,55739,55358,55421,55804,55898,56749,56760,56888,59113,58925,59333,59899,60033,60043,60162,60246,60248,60266,60280,60287,60295,60302,60309,60316,60370,60377,60384,60392,60663,61621,62230,62238,65090,67544,68136,68138,68147,68156,68165,68174,68183,68189,68198,69164,69671,69758,69864,50,103,110,157,209,639,895,976,1037,1105,1160,1199,1254,1295,1337,10169,2069,2077,2090,3093,3183,9497,10196,10201,10223,10273,10293,10306,10322,10340,10359,10373,10386,10581,10723,10937,11268,11642,11698,11836,11893,60848,20744,21168,22694,29635,23139,23710,23745,23771,23827,23836,29887,24645,24754,24766,25152,25215,25236,25309,25339,25383,25593,25613,25628,25634,26321,27543,28095,28203,28855,29318,30434,31868,32741,33445,35263,36077,36658,36678,36712,36715,37114,37151,37422,37456,37511,37758,37784,37812,37838,37850,38411,43113,43124,45604,45607,45930,46205,46213,46293,47050,48545,50559,50580,50653,50673,52719,52764,53553,53801,55010,55258,55359,55422,55740,55805,55899,56750,56761,56889,58926,59334,59900,60035,60044,60163,60765,60249,60264,60267,60281,60288,60296,60303,60310,60317,60371,60378,60385,60393,61622,62231,62239,65103,67545,68139,68145,68157,68166,68175,68184,68190,68199,69165,69672,69865,51,111,158,636,663,896,977,1038,1106,1161,1200,1255,1296,1338,1524,2070,2078,2092,3094,3184,9498,10202,10224,10270,10274,10294,10307,10323,10341,10360,10374,10387,10582,10724,11643,11694,11699,11759,11837,11894,18673,20745,21169,22695,29636,23372,23467,23711,23746,23772,23828,23837,29888,24646,24755,24767,25153,25216,25237,25310,25340,25384,25594,25614,25629,25635,26322,27544,28096,29319,30435,31869,32742,33446,35264,35266,36078,36659,36679,36716,36776,37115,37152,37423,37457,37512,37759,37785,37813,37839,37851,38412,43114,43125,46062,45608,46214,46266,46294,47057,48546,50560,50581,50654,52720,52765,53554,53802,53964,61598,55011,55377,55423,55741,55806,55900,56751,56762,56890,58927,59335,59901,60036,60045,60164,60250,60268,60278,60282,60289,60297,60304,60311,60318,60372,60379,60386,60394,61615,61623,62232,62240,64508,67546,68140,68149,68158,68167,68172,68176,68185,68191,68200,69166,69673,69866,52,112,159,664,892,897,978,1039,1107,1162,1201,1256,1525,2071,2079,2094,3095,3185,9499,10203,10225,10275,10290,10295,10308,10324,10342,10361,10375,10388,10583,10725,11695,11700,11760,11838,11895,20746,21170,22696,22967,29637,23373,23468,23712,23747,23773,23829,23838,29889,24647,24756,24768,25154,25217,25238,25311,25341,25385,25595,25615,25630,25639,26323,26654,27545,28097,29320,30436,31870,32743,33447,35265,36079,48542,36660,36680,36717,36777,37116,37153,37424,37458,37513,37760,37786,37814,37840,37852,38413,40391,43115,43126,45609,46215,46267,46295,47053,48547,50561,50582,52721,52766,53555,53803,55012,55378,55424,55742,55807,55901,56752,56891,58928,59336,59902,60046,60251,60269,60283,60285,60290,60298,60305,60312,60319,60373,60380,60387,60395,67374,61624,61972,62233,62241,67547,69424,68141,68150,68159,68168,68177,68187,68192,68201,69746,68632,69167,69674,69867,53,113,665,898,966,973,979,1040,1108,1163,1202,1257,2072,2080,2096,3096,3186,9500,10204,10226,10276,10296,10303,10309,10325,10343,10362,10376,10389,10584,10726,11696,11701,11761,11839,11896,20747,21171,22697,22968,23374,23469,23713,23748,23774,23830,23839,29890,24648,24757,24769,25155,25218,25239,25312,25342,25386,25596,25616,25636,26324,27400,27546,28098,29321,29638,30437,31871,32744,33448,36080,36661,36681,36718,36778,37117,37154,37425,37459,37514,37761,37787,37815,37841,37853,38414,43116,43127,43672,45610,46216,46268,46296,47055,48548,50556,50562,50583,52722,52767,53556,53804,53956,55013,55379,55425,55743,55808,55902,56753,56892,58929,59337,59903,60047,60252,60270,60284,60291,60293,60299,60306,60313,60320,60374,60381,60388,60396,61973,62234,62242,69431,67548,68142,68151,68154,68160,68169,68178,68193,68202,69168,69666,69675,69868,114,675,899,980,1034,1041,1087,1109,1203,1258,2073,2081,2098,3187,9501,10205,10227,10277,10297,10310,10319,10326,10344,10363,10377,10390,10585,10727,11702,11762,11897,20748,21172,22698,22969,23375,23470,23714,23749,23831,23840,29891,24649,24758,24770,25156,25219,25240,25313,25343,25387,25597,25617,25637,26325,27547,28099,28852,29322,29639,30438,31872,32745,33449,36081,36662,36682,36719,36779,37118,37426,37460,37515,37762,37788,37816,37842,40756,43117,43128,45611,46217,46269,46297,47059,48549,50563,50584,51007,52716,52723,52768,53557,53805,55100,55014,55380,55426,55744,55809,55903,56754,56893,58930,59338,59904,60048,60253,60292,60300,60389,61974,62235,62243,67549,68143,68152,68161,68163,68170,68179,68194,68203,69169,69667,69676,69869,115,676,981,1042,1102,1204,1259,1329,2082,2100,3188,9502,10206,10228,10278,10298,10311,10327,10337,10345,10364,10378,10586,10728,11703,11763,11898,20749,21173,22699,22970,23376,23471,23715,23750,23832,23841,29892,24650,24759,24771,25157,25220,25241,25314,25344,25388,25598,25618,25638,26326,27548,28100,29323,29640,30439,31873,32746,33450,35571,36082,36663,36683,36720,36780,37119,37427,37461,37516,37763,37789,37817,37843,39324,43118,43129,45612,46218,46270,46298,47061,48550,50564,50585,52724,52769,53550,53558,53806,55015,55255,55381,55427,55745,55810,55904,56755,56894,58931,59339,59905,60049,60254,60307,62244,67485,68032,67550,69743,68196,69745,69170,69744,69668,69694,69719,69742,69870,116,982,1043,1157,1205,1260,2083,2102,3189,3228,9503,10207,10229,10279,10299,10312,10328,10346,10356,10365,10379,10587,10729,11704,11764,11899,62413,20750,21174,22700,22971,23377,23472,23716,23751,23833,23842,29893,24651,24760,24772,25158,25221,25242,25315,25345,25389,25599,25619,26327,27549,28101,29324,29641,30440,31874,32747,33451,36083,36664,36684,36721,36781,37120,37428,37462,37517,37764,37790,37818,37844,39325,40787,43119,43130,45613,46219,46271,46299,47063,48551,50565,50586,52725,52770,53559,53807,55802,55016,55382,55428,55746,55811,55905,56756,56895,59340,59906,60050,60314,61602,62245,67551,68181,69171,69416,69610,69619,69630,69639,69648,69669,69871,117,1044,1196,1261,2084,2104,3190,9504,10208,10230,10280,10300,10313,10329,10347,10366,10370,10380,10588,10730,11276,11705,11765,11900,20751,21175,22701,22972,23378,23717,23752,23843,24220,29894,24652,24761,24773,25159,25222,25243,25316,25346,25390,25600,25620,26328,27550,28102,29325,29642,30441,31875,32748,33452,36084,36665,36685,36722,36782,37121,37429,37463,37518,37765,37791,37819,37845,39326,43120,43131,45080,45614,46220,46272,46300,47065,48552,50566,50587,52726,52771,53560,53808,55017,55383,55429,55747,55812,55906,56757,56886,56896,59341,59907,60051,60321,62246,67379,67552,69172,69528,69640,69872,70387,118,1251,2085,3191,8745,9505,10209,10231,10281,10301,10314,10330,10348,10367,10381,10383,10589,10731,11706,11766,11901,20752,21176,22702,22973,23379,23718,23753,23844,29895,24653,24762,24774,25160,25223,25244,25317,25347,25391,25601,25621,26329,27406,27551,28103,29326,29643,30442,31876,32749,33453,36085,36686,36723,36783,37122,37430,37464,37519,37766,37792,37820,37846,43192,43841,45615,46221,46273,46301,48553,50567,50588,54948,52355,52727,52772,53561,53809,55018,55384,55430,55748,55813,55907,56758,56918,59331,59342,59908,60052,60322,62247,67553,69184,69435,69862,1292,2086,3192,9509,10210,10232,10282,10302,10315,10331,10349,10368,10382,10578,10590,10732,11707,11786,11902,20753,21177,22703,23380,23719,23754,23845,29896,24654,24763,24775,25161,25224,25318,25348,25392,25602,25622,25631,26330,27552,28104,29327,29644,30443,31877,32750,33454,35291,36086,36687,36724,37123,37431,37465,37520,37767,37793,37821,37847,38408,40253,42756,43842,45616,46222,46274,46302,48554,50568,50589,52728,52773,53562,53810,55019,55356,55385,55431,55749,55814,56759,56919,59116,59343,59897,59909,60323,62248,67554,69185,69529,60822,1333,2087,3193,9506,10211,10283,10316,10332,10350,10369,10733,11616,11708,11903,20754,21178,22704,22738,23720,23755,23846,29897,24655,24776,25162,25225,25319,25349,25393,25603,25623,26331,27553,28105,29328,29645,29690,30444,31878,32751,33455,34606,36087,36688,36725,37124,37432,37466,37521,37768,37794,37822,40397,46361,43843,45617,46223,46275,46303,48555,50569,50590,52729,53563,55020,55360,55386,55432,55750,55815,56921,59344,59910,60031,60324,62249,67555,69186,206,2088,3194,9507,10212,10284,10317,10333,10351,10734,11904,20755,21179,22705,23721,23756,23847,29898,24656,24777,25163,25226,25320,25350,25394,25604,25625,26332,27554,28106,29310,29329,31879,32752,32814,33456,36088,55150,36689,37125,37433,37467,37522,37795,43676,43844,45618,45931,46224,46276,46304,48556,50570,50591,52730,53564,55021,55387,55433,55816,56922,59345,59911,62228,67540,65132,69162,69187,2089,3195,9508,10213,10285,10318,10334,10352,10735,11905,20756,21180,22706,23722,23848,29899,24657,24778,25164,25227,25321,25351,25395,25605,25624,26333,27555,28107,29330,31880,32753,33457,35580,36089,51013,36690,37126,37434,37468,37523,41881,43845,45619,46225,46277,48557,50571,52731,53021,53565,55388,55434,55817,59124,59346,59912,62236,69188,69439,3196,9510,10214,10286,10335,10353,10736,11906,20757,21181,22707,23849,29900,24658,24779,25228,25352,25396,25606,26334,27556,27594,28108,29331,31881,32754,33458,36090,36691,37127,37435,37469,40783,43846,45075,45620,46226,46278,48558,50572,52733,53566,55252,55389,55435,55818,59347,59913,60905,62250,69189,3197,9511,10215,10287,10336,10354,10737,11907,20758,21182,22708,23850,29901,24659,24780,25229,25353,25397,25607,26335,27557,28109,29332,31882,32755,33459,36091,52343,36692,37128,37436,37470,43847,45084,45621,46227,48559,50573,50650,52734,61610,53567,55390,55436,55819,58803,59348,59914,60906,69190,3198,9512,10216,10288,10355,10738,11908,20759,21183,22709,23851,29902,24660,24781,25230,25354,25398,25608,26336,27558,29333,31883,33460,36092,36693,43848,46228,50574,52348,52736,53031,53568,55391,55437,55820,59108,59578,59915,67382,62089,69191,9513,10217,10289,10739,28666,11909,20760,21184,22710,29903,24661,24782,25231,25355,25399,25609,26337,27559,31884,33461,36093,43849,50575,52735,53042,53569,55392,55438,55821,60791,59119,59757,59916,69450,69192,9514,10218,28667,11910,20761,21185,29904,24662,24783,25232,25356,25400,25610,26338,27560,31885,33462,60805,65121,43850,45937,50576,53289,53570,55393,55439,55822,59917,9515,10219,11911,21186,24663,24784,25233,25357,27561,31886,43851,52737,53057,53571,55394,55440,55823,59918,65128,69452,9516,21187,24664,24785,25358,27562,31887,43852,45939,52738,53572,55824,59919,69445,9517,24665,27563,31888,43853,45941,53573,55825,9518,53046,53574,55826,9519,53575,55827,55896,9520,52322,53576,55828,9521,53577,55829,9522,53578,53579,69337,1456,1464,1469,11001,60776,60778,60780,60782,60783,60806,60807,60809,60810,60811,1455,1457,1465,1470,42490,58879,58886,60831,61530,61537,62763,1458,1463,1466,1471,11002,42486,58880,60832,61531,68338,1459,1467,1468,1472,58881,60786,61532,61761,61858,1460,1473,58882,60773,61521,61533,61762,1461,58883,59789,61527,61763,1462,58878,58884,61528,61764,42485,61516,61765,58887,61766,59787,61767,60781,61760,58885,61768,11000,61769,62806,68134,67861,61029,60208,57101,1373,1374,1378,1400,3292,3293,3295,3303,28695,28696,28698,28730,28740,28747,28800,28809,28817,28825,28834,28839,29225,29226,29228,29234,29273,32906,33239,33245,33259,35837,35869,35899,36982,36997,38538,38566,38588,48216,48217,48263,48264,48354,48355,1377,1379,3294,3296,28697,28714,28721,28731,28741,28748,28801,28810,28818,28826,28835,29227,29229,32895,32907,33240,33246,33260,35838,35870,35900,36983,36998,38539,38567,38589,48218,48265,48356,1380,1399,3297,3302,28699,28715,28722,28732,28742,28749,28802,28811,28819,28827,28836,29230,29233,32896,32908,33241,33247,33261,35839,35871,35901,36984,36999,38542,38568,38590,48219,48266,48357,1381,3390,28700,28716,28723,28733,28743,28750,28803,28812,28820,28828,28837,29231,32897,32909,33242,33248,33262,35840,35872,35902,36985,37000,38543,38569,38591,48220,48267,48358,1382,3299,28701,28717,28724,28734,28744,28751,28804,28813,28821,28829,28838,29232,32898,32910,33243,33249,33263,35841,35873,35903,36986,37001,38544,38570,48221,48268,48359,1383,3300,28702,28718,28725,28735,28745,28752,28805,28814,28822,28830,32899,32911,33244,33250,33264,35842,35874,35904,36987,37002,38545,38571,48222,48269,48360,1384,3301,28703,28726,28736,28753,28806,28815,28823,28831,32900,32912,33251,33265,35843,35875,35905,36988,37003,38546,38572,48223,48270,48361,1385,28704,28727,28737,28754,28807,28816,28824,28832,32901,32913,33252,33266,35844,35876,35906,36989,37004,38547,38573,48362,1386,28705,28728,28738,28755,28808,28833,32902,33253,33267,35845,35877,35907,36990,37005,38548,38574,48363,1387,28706,32903,33254,33268,35846,35878,35908,36991,37006,38549,38575,48364,1388,28707,32904,33255,33269,35847,35879,35909,36992,37007,38550,38576,1389,32905,33256,33270,35848,35880,35910,36993,37008,38551,1390,33257,35849,35881,35911,36994,37009,38552,1391,33258,35850,35882,35912,36995,37010,38553,1392,35851,35883,35913,36996,37011,1393,35914,35978,37012,1394,35852,35915,37013,1395,35916,1396,35917,1397,35918,1398,35919,35920,35921,48353,48262,48215,46201,40559,37675,34913,29272,29224,28694,27592,1372,11,63,3089,12,3110,3111,3112,3113,3114,3115,3291,12876,18,94,10,82,1580,11855,1369,3108,10165,11832,46,19,1454,9) ORDER BY meta_id ASC | 0.000 |
  7.  
  8.  
  9. A w statystykach wygląda to tak:
  10.  
  11. # Query 1: 30.70 QPS, 0.46x concurrency, ID 0xE0ED4FC901A011EE7D18C5C503757896 at byte 32339
  12. # This item is included in the report because it matches --limit.
  13. # Scores: V/M = 0.74
  14. # Time range: 2020-01-24 20:51:29 to 20:54:17
  15. # Attribute pct total min max avg 95% stddev median
  16. # ============ === ======= ======= ======= ======= ======= ======= =======
  17. # Count 3 5157
  18. # Exec time 35 77s 108us 1s 15ms 3ms 105ms 224us
  19. # Lock time 5 585ms 37us 108ms 113us 84us 2ms 57us
  20. # Rows sent 50 6.69M 0 73.79k 1.33k 271.23 9.48k 5.75
  21. # Rows examine 11 13.39M 0 147.58k 2.66k 537.02 18.76k 9.83
  22. # Rows affecte 0 0 0 0 0 0 0 0
  23. # Query size 4 1.78M 95 14.41k 361.80 151.03 1.79k 97.36
  24. # Query_time distribution
  25. # 1us
  26. # 10us
  27. # 100us ################################################################
  28. # 1ms #########
  29. # 10ms #
  30. # 100ms #
  31. # 1s #
  32. # 10s+
  33. # Tables
  34. # SHOW TABLE STATUS FROM `world_akademia` LIKE 'wp_postmeta'\G
  35. # SHOW CREATE TABLE `world_akademia`.`wp_postmeta`\G
  36. # EXPLAIN /*!50100 PARTITIONS*/
  37. SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (47,48,108,154,207,637,893,974,1035,1103,1158,1197,1252,1293,1334,10166,10167,1450,1536,2075/*... omitted 2485 items ...*/) ORDER BY meta_id ASC\G
  38.  
  39. W TOP20 pojawiły się też dwa inne zapytania, ale one raczej nie wpływają aż tak na powolne działanie:
  40.  
  41. # Query 9: 0.35 QPS, 0.06x concurrency, ID 0xACA5990805037E9570D5F85B7258740B at byte 49653991
  42. # This item is included in the report because it matches --limit.
  43. # Scores: V/M = 0.17
  44. # Time range: 2020-01-24 20:53:05 to 20:54:17
  45. # Attribute pct total min max avg 95% stddev median
  46. # ============ === ======= ======= ======= ======= ======= ======= =======
  47. # Count 0 25
  48. # Exec time 1 4s 31ms 675ms 164ms 356ms 169ms 46ms
  49. # Lock time 0 5ms 156us 248us 182us 224us 27us 167us
  50. # Rows sent 0 68 1 14 2.72 4.96 2.68 0.99
  51. # Rows examine 0 579.82k 2.81k 77.70k 23.19k 54.03k 23.15k 4.71k
  52. # Rows affecte 0 0 0 0 0 0 0 0
  53. # Query size 0 42.58k 1.70k 1.70k 1.70k 1.70k 0 1.70k
  54. # String:
  55. # Databases world_akademia
  56. # Hosts localhost
  57. # Users world_akademia
  58. # Query_time distribution
  59. # 1us
  60. # 10us
  61. # 100us
  62. # 1ms
  63. # 10ms ################################################################
  64. # 100ms ##########################################
  65. # 1s
  66. # 10s+
  67. # Tables
  68. # SHOW TABLE STATUS FROM `world_akademia` LIKE 'wp_usermeta'\G
  69. # SHOW CREATE TABLE `world_akademia`.`wp_usermeta`\G
  70. # SHOW TABLE STATUS FROM `world_akademia` LIKE 'wp_posts'\G
  71. # SHOW CREATE TABLE `world_akademia`.`wp_posts`\G
  72. # SHOW TABLE STATUS FROM `world_akademia` LIKE 'wp_options'\G
  73. # SHOW CREATE TABLE `world_akademia`.`wp_options`\G
  74. # EXPLAIN /*!50100 PARTITIONS*/
  75. SELECT
  76. t.product_id
  77. FROM
  78. (
  79. SELECT
  80. um.user_id,
  81. p.ID product_id,
  82. um_buy.meta_value buy_time_raw,
  83. FROM_UNIXTIME(um_buy.meta_value) buy_time,
  84. um_access.meta_value access_time_raw,
  85. FROM_UNIXTIME(um_access.meta_value) access_time,
  86. um_total.meta_value total_time_raw,
  87. um_last.meta_value last_time_raw,
  88. FROM_UNIXTIME(um_last.meta_value) last_time,
  89. um_price.meta_value price_id,
  90. op.option_value gmt_offset,
  91. IF(um_access.meta_value IS NULL OR um_access.meta_value = '', 1, IF(UNIX_TIMESTAMP() < um_access.meta_value + IFNULL(op.option_value, 0) * 3600, 1, 0)) access_valid
  92. FROM
  93. wp_usermeta um
  94. JOIN wp_posts p ON um.meta_key = '_bpmj_eddpc_access_to_download'
  95. AND um.meta_value = p.ID
  96. LEFT JOIN wp_usermeta um_buy ON um_buy.user_id = um.user_id
  97. AND um_buy.meta_key = CONCAT('_bpmj_eddpc_', um.meta_value, '_buy_time')
  98. LEFT JOIN wp_usermeta um_access ON um_access.user_id = um.user_id
  99. AND um_access.meta_key = CONCAT('_bpmj_eddpc_', um.meta_value, '_access_time')
  100. LEFT JOIN wp_usermeta um_total ON um_total.user_id = um.user_id
  101. AND um_total.meta_key = CONCAT('_bpmj_eddpc_', um.meta_value, '_total_time')
  102. LEFT JOIN wp_usermeta um_last ON um_last.user_id = um.user_id
  103. AND um_last.meta_key = CONCAT('_bpmj_eddpc_', um.meta_value, '_last_time')
  104. LEFT JOIN wp_usermeta um_price ON um_price.user_id = um.user_id
  105. AND um_price.meta_key = CONCAT('_bpmj_eddpc_', um.meta_value, '_price_id')
  106. LEFT JOIN wp_options op ON op.option_name = 'gmt_offset') t
  107. WHERE
  108. t.user_id = 2305\G
  109.  
  110. Oraz takie zapytanie :
  111.  
  112. # Query 10: 1.18 QPS, 0.05x concurrency, ID 0x2A210DA28803C27D3505E256EA221A1A at byte 48544433
  113. # This item is included in the report because it matches --limit.
  114. # Scores: V/M = 0.00
  115. # Time range: 2020-01-24 20:53:01 to 20:54:17
  116. # Attribute pct total min max avg 95% stddev median
  117. # ============ === ======= ======= ======= ======= ======= ======= =======
  118. # Count 0 90
  119. # Exec time 1 4s 32ms 61ms 39ms 51ms 7ms 34ms
  120. # Lock time 0 8ms 61us 122us 88us 108us 11us 84us
  121. # Rows sent 1 220.25k 2.45k 2.45k 2.45k 2.45k 0 2.45k
  122. # Rows examine 0 440.51k 4.89k 4.89k 4.89k 4.89k 0 4.89k
  123. # Rows affecte 0 0 0 0 0 0 0 0
  124. # Query size 0 13.36k 152 152 152 152 0 152
  125. # String:
  126. # Databases world_akademia
  127. # Hosts localhost
  128. # Users world_akademia
  129. # Query_time distribution
  130. # 1us
  131. # 10us
  132. # 100us
  133. # 1ms
  134. # 10ms ################################################################
  135. # 100ms
  136. # 1s
  137. # 10s+
  138. # Tables
  139. # SHOW TABLE STATUS FROM `world_akademia` LIKE 'wp_posts'\G
  140. # SHOW CREATE TABLE `world_akademia`.`wp_posts`\G
  141. # EXPLAIN /*!50100 PARTITIONS*/
  142. SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC\G
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!