Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-22146

create host,mysql used high cpu

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • None
    • None
    • None
    • None

    Description

      When I create host, mysql used high cpu

                                                          • 1. row ***************************

           ID: 215372200

         USER: zbxuser

         HOST: 172.16.250.17:17832

           DB: zabbix

      COMMAND: Query

         TIME: 3479

        STATE: executing

         INFO: select t.triggerid,t.description,t.expression,t.recovery_expression from triggers t where t.triggerid in (select distinct t.triggerid from triggers tg,functions f,items i where tg.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=11494 and tg.description in ('macs110 TCP 丢包 异常','macs110 UDP 丢包 异常')) and not t.triggerid in (691136,691140,691142,691145,691149,691151,727658,727659,732923,732924,740004,740005,741871,741872,748820,748821,756731,756732,757841,757842,759344,759345,759471,759472,763647,763648,763686,763687,763946,763947,763949,763950,767206,767208,786127,786128,786134,786135,786144,786145,786151,786152,787409,787411,787413,787414,787416,787417,787418,787421,787422,787426,787430,787432,787434,787435,787437,787438,787439,787442,787443,787447,806305,806307,806649,806660,812453,812454,825157,825158,825634,825635,825636,825637,825638,825639,825640,825641,825642,825643,825644,825645,825646,825647,825648,825649,825650,825651,825652,825653,825654,825655,825656,825657,825658,825659,825660,825661,825662,825663,825664,825665,825666,825667,825668,825669,825670,825671,825672,825673,825674,825675,825676,825677,825678,825679,825680,825681,827461,827462,827463,827464,873365,873366,875988,875989,876034,876035,876310,876311,876363,876364,876823,876824,876825,876826,876827,876828,876829,876830,876831,876832,876833,876834,876835,876836,876837,876838,881763,881764,881808,881809,881810,881811,881812,881813,881814,881815,882333,882334,882335,882336,882337,882338,882339,882340,882341,882342,882343,882344,882345,882346,882347,882348,882349,882350,882351,882352,882353,882354,882355,882356,882357,882358,882359,882360,882361,882362,882363,882364,883390,883391,883392,883393,883394,883395,883396,883397,883398,883399,883400,883401,883402,883403,883404,883405,883406,883407,884043,884044,890288,890289,890290,890291,890292,890293,890294,890295,890296,890297,890298,890299,890300,890301,890302,890303,890304,890305,890306,890307,890308,890309,890310,890311,890312,890313,890314,890315,890316,890317,890318,890319,890320,890321,890322,890323,890324,890325,890326,890327,891994,891995,891996,891997,891998,891999,892000,892001,892002,892003,892004,892005,892006,892007,892008,892009,892010,892011,892012,892013,892014,892015,892016,892017,892018,892019,892020,892021,892022,892023,892024,892025,892026,892027,892028,892029,892030,892031,892032,892033,895652,895653,895654,895655,895656,895657,896194,896195,896196,896197,896198,896199,896200,896201,896202,896203,896204,896205,896206,896207,896208,896209,896210,896211,896212,896213,896214,896215,896216,896217,896218,896219,896640,896641,896642,896643,896644,896645,896646,896647,896648,896649,896650,896651,896652,896653,896654,896655,896656,896657,896658,896659,896660,896661,896662,896663,896664,896665,896666,896667,901721,901722,901723,901724,901725,901726,901727,901728,901729,901730,901731,901732,901733,901734,901735,901736,901737,901738,901739,901740,901741,901742,901743,901744,901745,901746,901747,901748,901749,901750,901751,901752,901753,901754,901755,901756,901757,901758,901759,901760,901761,901762,901763,901764,901765,901766,901767,901768,901769,901770,901771,901772,901773,901774,901775,901776,901777,901778,901779,901780,903332,903333,903334,903335,903336,903337,903338,903339,903340,903341,903342,903343,904052,904053,904054,904055,904056,904057,904058,904059,904060,904066,904067,904068,904069,904070,904071,904072,904073,904074,904616,904617,904618,904619,904620,904621,904622,904623,904624,904625,904626,904627,904628,904629,904630,904631,904632,904633,904634,904635,904636,904637,905025,905026,905027,905028,905034,905035,905036,905037,909086,909087,909088,909089,909090,909091,909092,909093,909094,909095,909096,909097,909098,909099,909100,909101,909102,909103,909104,909105,909106,909107,909108,909109,910072,910073,910074,910075,910076,910077,910078,910079,910080,910081,910082,910083,910084,910085,910086,910087,910088,910089,910090,910091,910092,910093,910094,910095,910096,910097,910098,910099,910100,910101,910102,910103,910104,910105,910592,910593,910594,910595,910596,910597,910598,910599,910600,910601,910602,910603,910604,910605,910606,910607,910608,910609,910610,910611,910612,910613,912523,912524,912525,912526,912527,912528,912922,912923,912924,912925,912926,912927,912928,912929,912930,912931,912932,912933,912934,912935,912936,912937,912938,912939,912940,912941,912942,912943,912944,912945,912946,912947,912948,912949,912950,912951,913566,913567,913568,913569,913570,913571,913572,913573,913574,913575,913576,913577,913578,913579,913580,913581,913582,913583,913584,913585,913586,913587,913588,913589,913590,913591,913592,913593,913594,913595,913596,913597,913598,913599,914060,914061,914062,914063,914064,914065,914066,914067,914068,914069,917781,917782,917783,917784,919812,919813,919814,919815,919816,919817,919818,919819,919820,919821,919822,919823,919824,919825,919826,919827,919828,919829,919830,919831,919832,919833,919834,919835,919836,919837,919838,919839,922820,922821,922822,922823,922824,922825,922826,922827,922828,922829,922830,922831,922832,922833,922834,922835,922836,922837,922838,922839,922840,922841,922842,922843,922844,922845,922846,922847,922848,922849,922850,922851,922852,922853,922854,922855,922856,922857,922858,922859,922860,922861,922862,922863,922864,922865,922866,922867,929232,929233,929234,929235,929236,929237,929238,929239,929240,929241,929242,929243,929244,929245,929246,929247,929248,929249,929250,929251,929252,929253,929254,929255,929256,929257,929258,929259,929260,929261,929262,929263,929264,929265,929266,929267,929268,929269,929270,929271,929272,929273,929274,929275,929276,929277,929278,929279,929280,929281,929282,929283,929284,929285,929286,929287,929288,929289,929290,929291,929292,929293,929294,929295,929296,929297,929298,929299,929300,929301,929302,929303,929304,929305,929306,929307,929308,929309,929310,929311,931148,931149,931150,931151,931152,931153,931154,931155,931156,931157,931158,931159,931160,931161,931162,931163,931164,931165,931166,931167,931168,931169,931170,931171,931172,931173,931174,931175,931176,931177,931178,931179,931180,931181,931182,931183,931184,931185,931186,931187,932222,932223,932224,932225,932226,932227,932228,932229,932230,932231,932232,932233,932234,932235,932721,932722,932723,932724,932725,932726,932727,932728,932729,932730,932731,932732,932733,932734,932735,932736,932737,932738,932739,932740,932741,932742,932743,932744,932745,932746,937177,937178,937179,937180,937181,937182,937183,937184,937185,937186,937187,937188,937189,937190,937191,937192,937450,937451,937452,937453,937454,937455,937456,937457,937458,937459)

                                                          • 2. row ***************************

           ID: 215372159

         USER: zbxuser

         HOST: 172.16.250.17:17752

           DB: zabbix

      COMMAND: Query

         TIME: 3456

        STATE: executing

         INFO: select t.triggerid,t.description,t.expression,t.recovery_expression from triggers t where t.triggerid in (select distinct t.triggerid from triggers tg,functions f,items i where tg.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=11499 and tg.description in ('macs110 TCP 丢包 异常','macs110 UDP 丢包 异常','macs111 TCP 丢包 异常','macs111 UDP 丢包 异常','macs112 TCP 丢包 异常','macs112 UDP 丢包 异常','macs113 TCP 丢包 异常','macs113 UDP 丢包 异常','macs114 TCP 丢包 异常','macs114 UDP 丢包 异常','macs115 TCP 丢包 异常','macs115 UDP 丢包 异常')) and not t.triggerid in (691153,691157,691159,691161,691165,691167,727667,727668,732912,732913,739970,739971,741861,741862,748832,748833,756745,756746,757837,757838,759339,759340,759460,759461,763658,763659,763701,763702,764021,764022,764028,764029,767226,767228,786953,786954,786958,786959,786960,786966,786967,786978,786979,786983,786984,786985,786991,786992,788059,788061,788063,788064,788066,788067,788068,788076,788078,788080,788081,788083,788084,788085,806372,806374,806380,806382,812475,812476,825177,825178,825179,825180,826066,826067,826068,826069,826070,826071,826072,826073,826074,826075,826076,826077,826078,826079,826080,826081,826082,826083,826084,826085,826086,826087,826088,826089,826090,826091,826092,826093,826094,826095,826096,826097,826098,826099,826100,826101,826102,826103,826104,826105,826106,826107,826108,826109,826110,826111,827403,827404,827405,827406,873383,873384,876006,876007,876094,876095,876328,876329,876381,876382,877235,877236,877237,877238,877239,877240,877241,877242,877248,877249,877250,877251,877252,877253,877254,877255,881104,881105,881921,881922,881923,881924,881925,881926,881927,881928,881929,881930,881931,881932,881933,881934,881935,881936,881937,881938,881939,881940,881941,881942,881943,881944,881945,881946,882673,882674,882675,882676,882677,882678,882679,882680,882681,882682,882683,882684,882685,882686,882687,882688,882689,882690,882691,882692,882693,882694,882695,882696,882697,882698,882699,882700,882701,882702,882703,882704,884082,884083,890056,890057,890058,890059,890060,890061,890062,890063,890064,890065,890066,890067,890068,890069,890070,890071,890072,890073,890074,890075,890076,890077,890078,890079,890080,890081,890082,890083,890084,890085,890086,890087,890088,890089,890090,890091,890092,890093,890094,890095,891751,891752,891753,891754,891755,891756,891757,891758,891759,891760,891761,891762,891763,891764,891765,891766,891767,891768,892326,892327,892328,892329,892330,892331,892332,892333,892334,892335,892336,892337,892338,892339,892340,892341,892342,892343,892344,892345,892346,892347,895563,895564,895565,895566,895567,895568,895903,895904,895905,895906,896363,896364,896365,896366,896367,896368,896369,896370,896371,896372,896373,896374,896375,896376,896377,896378,896379,896380,896381,896382,896383,896384,896385,896386,896387,896388,896389,896390,896391,896392,896393,896394,896395,896396,896832,896833,896834,896835,896836,896837,896838,896839,896840,896841,896842,896843,896844,896845,896846,896847,901661,901662,901663,901664,901665,901666,901667,901668,901669,901670,901671,901672,901673,901674,901675,901676,901677,901678,901679,901680,901681,901682,901683,901684,901685,901686,901687,901688,901689,901690,901691,901692,901693,901694,901695,901696,901697,901698,901699,901700,901701,901702,901703,901704,901705,901706,901707,901708,901709,901710,901711,901712,901713,901714,901715,901716,901717,901718,901719,901720,903504,903505,903506,903507,903508,903509,903510,903511,903512,903513,903514,903515,903516,903517,903518,903519,903520,903521,903522,903523,903524,903525,903526,903527,903528,903529,903530,903531,903532,903533,904402,904403,904409,904410,904850,904851,904852,904853,904854,904855,904856,904857,904858,904859,904860,904861,904862,904867,904868,904869,904870,904871,904872,904873,904874,904875,904876,904877,904878,904879,908970,908971,908972,908973,909931,909932,909933,909934,909935,909936,909937,909938,909939,909940,909941,909942,909943,909944,909945,909946,909947,909948,909949,909950,909951,909952,909953,909954,909955,909956,909957,909958,909959,909960,909961,909962,909963,909964,910266,910267,910268,910269,910270,910271,910272,910273,910274,910275,910276,910277,910278,910279,910280,910281,910282,910283,910284,910285,910286,910287,910288,910289,910290,910291,910292,910293,910294,910295,910296,910297,910298,910299,910300,910301,910302,910303,910304,910305,910306,910307,912565,912566,912567,912568,912569,912570,913233,913234,913235,913236,913237,913238,913239,913240,913241,913242,913243,913244,913830,913831,913832,913833,913834,913835,913836,913837,913838,913839,913840,913841,913842,913843,913844,913845,913846,913847,913848,913849,913850,913851,913852,913853,913854,913855,913856,913857,913858,913859,913860,913861,914192,914193,914194,914195,914196,914197,914198,914199,914200,914201,914202,914203,914204,914205,914206,914207,914208,914209,914210,914211,914212,914213,914214,914215,914216,914217,914218,914219,914220,914221,917785,917786,917787,917788,919912,919913,919914,919915,919916,919917,919918,919919,919920,919921,922868,922869,922870,922871,922872,922873,922874,922875,922876,922877,922878,922879,922880,922881,922882,922883,922884,922885,922886,922887,922888,922889,922890,922891,922892,922893,922894,922895,922896,922897,922898,922899,922900,922901,922902,922903,922904,922905,922906,922907,922908,922909,922910,922911,922912,922913,922914,922915,922916,922917,922918,922919,922920,922921,922922,922923,922924,922925,922926,922927,922928,922929,922930,922931,922932,922933,928592,928593,928594,928595,928596,928597,928598,928599,928600,928601,928602,928603,928604,928605,928606,928607,928608,928609,928610,928611,928612,928613,928614,928615,928616,928617,928618,928619,928620,928621,928622,928623,928624,928625,928626,928627,928628,928629,928630,928631,928632,928633,928634,928635,928636,928637,928638,928639,928640,928641,928642,928643,928644,928645,928646,928647,928648,928649,928650,928651,928652,928653,928654,928655,928656,928657,928658,928659,928660,928661,928662,928663,928664,928665,928666,928667,928668,928669,928670,928671,930988,930989,930990,930991,930992,930993,930994,930995,930996,930997,930998,930999,931000,931001,931002,931003,931004,931005,931006,931007,931008,931009,931010,931011,931012,931013,931014,931015,931016,931017,931018,931019,931020,931021,931022,931023,931024,931025,931026,931027,932128,932129,932130,932131,932132,932133,932134,932135,932136,932137,932138,932139,932140,932141,932142,932143,932144,932145,932146,932147,932148,932149,932150,932151,932152,932153,932154,932155,932156,932157,932592,932593,932594,932595,932596,932597,932598,932599,932600,932601,937067,937068,937069,937070,937071,937072,937073,937074,937075,937076,937077,937078,937079,937080,937081,937082,937370,937371,937372,937373,937374,937375,937376,937377,937378,937379)

      Attachments

        Activity

          People

            zabbix.support Zabbix Support Team
            yinyaliang yinyaliang
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: