Zabbix crashing all the time

[Diego Torres]

Hello friends! I'm having a problem on my Zabbix server and would like your help. Two Red Hat 7 Servers, 1 Isntaladao the database (Mysql) and 2 is Zabbix. To face flashing problem, it keeps catching of times and time. Check the zabbix log and see that it has many Slow query. Can anyone give me a light?




32767:20180628:165544.402 executing housekeeper
32767:20180628:165701.498 slow query: 4.107496 sec, "delete from events where clock<1530129344 and events.source=3 and events.object=0 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid)"
32767:20180628:165701.544 housekeeper [deleted 451728 hist/trends, 0 items/triggers, 21998 events, 11082 problems, 0 sessions, 0 alarms, 0 audit items in 77.139660 sec, idle for 1 hour(s)]
581:20180628:171101.096 slow query: 628.003758 sec, "update item_discovery set lastcheck=1530216033 where itemid in (54745,54746);
"
327:20180628:171101.112 slow query: 638.376425 sec, "update item_discovery set lastcheck=1530216022 where itemid in (52558,52559);
"
431:20180628:171101.114 slow query: 590.638257 sec, "update item_discovery set lastcheck=1530216070 where itemid in (55081,55082,55083,55084);
"
450:20180628:171101.114 slow query: 628.125307 sec, "update item_discovery set lastcheck=1530216032 where itemid in (29270,29271,29272,29273);
"
430:20180628:171101.114 slow query: 631.268751 sec, "update item_discovery set lastcheck=1530216029 where itemid in (54962,54963);
"
335:20180628:171101.114 slow query: 78.927484 sec, "update item_discovery set lastcheck=1530216582 where itemid between 56231 and 56260;
"
575:20180628:171101.118 slow query: 627.759710 sec, "update item_discovery set lastcheck=1530216033 where itemid between 29331 and 29357;
"
599:20180628:171101.124 slow query: 652.639436 sec, "update item_discovery set lastcheck=1530216008 where itemid in (56211,56212);
"
505:20180628:171101.125 slow query: 651.627103 sec, "update item_discovery set lastcheck=1530216009 where itemid in (51982,51983);
"
452:20180628:171101.126 slow query: 624.121565 sec, "update item_discovery set lastcheck=1530216036 where itemid in (60656,60657,60658,60659);
"
440:20180628:171101.126 slow query: 622.002297 sec, "update item_discovery set lastcheck=1530216039 where itemid between 60560 and 60565;
"
444:20180628:171101.127 slow query: 623.728465 sec, "update item_discovery set lastcheck=1530216037 where itemid between 30078 and 30125;
"
493:20180628:171101.127 slow query: 656.699797 sec, "update item_discovery set lastcheck=1530216004 where itemid in (56115,56116);
"
535:20180628:171101.127 slow query: 577.434227 sec, "update item_discovery set lastcheck=1530216083 where itemid in (52185,52186);
"
497:20180628:171101.130 slow query: 583.529299 sec, "update item_discovery set lastcheck=1530216077 where itemid in (52310,52311);
"
539:20180628:171101.131 slow query: 623.137352 sec, "update item_discovery set lastcheck=1530216037 where itemid in (30041,30042,30043,30044);
"
346:20180628:171101.131 slow query: 585.580012 sec, "update item_discovery set lastcheck=1530216075 where itemid in (55554,55555);
"
576:20180628:171101.131 slow query: 632.294607 sec, "update item_discovery set lastcheck=1530216028 where itemid in (55603,55604);
"
520:20180628:171101.132 slow query: 578.456890 sec, "update item_discovery set lastcheck=1530216082 where itemid in (56227,56228);
"
384:20180628:171101.132 slow query: 605.885720 sec, "update item_discovery set lastcheck=1530216055 where itemid in (58150,58151,58153,58155,58156,58157,58159,58161);
"
402:20180628:171101.132 slow query: 607.916375 sec, "update item_discovery set lastcheck=1530216053 where itemid in (56209,56210);
"
355:20180628:171101.132 slow query: 644.492529 sec, "update item_discovery set lastcheck=1530216016 where itemid in (56119,56120);
"
559:20180628:171101.132 slow query: 615.926684 sec, "update item_discovery set lastcheck=1530216045 where itemid between 30597 and 30623;
"
598:20180628:171101.133 slow query: 571.352416 sec, "update item_discovery set lastcheck=1530216089 where itemid in (52060,52061);
"
301:20180628:171101.136 slow query: 655.999534 sec, "update httptest set nextcheck=1530216065 where httptestid=12"
596:20180628:171101.140 slow query: 617.986490 sec, "update item_discovery set lastcheck=1530216043 where itemid in (30452,30453,30454,30455);
"
490:20180628:171101.143 slow query: 475.996314 sec, "update item_discovery set lastcheck=1530216185 where itemid in (58482,58483);
"
592:20180628:171101.143 slow query: 603.625021 sec, "update item_discovery set lastcheck=1530216057 where itemid in (58345,58346);
"
517:20180628:171101.143 slow query: 579.484552 sec, "update item_discovery set lastcheck=1530216081 where itemid in (56215,56216);
"
476:20180628:171101.144 slow query: 601.838215 sec, "update item_discovery set lastcheck=1530216059 where itemid in (56166,56167);
"
558:20180628:171101.145 slow query: 586.594625 sec, "update item_discovery set lastcheck=1530216074 where itemid in (56229,56230);
"
409:20180628:171101.146 slow query: 475.963117 sec, "update item_discovery set lastcheck=1530216185 where itemid between 58486 and 58548;
"
446:20180628:171101.146 slow query: 603.857339 sec, "update item_discovery set lastcheck=1530216057 where itemid in (56031,56032);
"
387:20180628:171101.149 slow query: 617.852625 sec, "update item_discovery set lastcheck=1530216043 where itemid between 30446 and 30451;
"
552:20180628:171101.152 slow query: 620.050144 sec, "update item_discovery set lastcheck=1530216041 where itemid in (54747,54748);
"
491:20180628:171101.154 slow query: 602.854720 sec, "update item_discovery set lastcheck=1530216058 where itemid in (58164,58165);
"
376:20180628:171101.155 slow query: 625.162293 sec, "update item_discovery set lastcheck=1530216035 where itemid between 29926 and 29931;
"
554:20180628:171101.155 slow query: 656.730056 sec, "update item_discovery set lastcheck=1530216004 where itemid in (52916,52917);
"
582:20180628:171101.155 slow query: 596.793688 sec, "update item_discovery set lastcheck=1530216064 where itemid in (53379,53380);
"
443:20180628:171101.157 slow query: 638.418485 sec, "update item_discovery set lastcheck=1530216022 where itemid in (56217,56218,56219,56220);
"
329:20180628:171101.158 slow query: 615.982213 sec, "update item_discovery set lastcheck=1530216045 where itemid between 30624 and 30671;
"
390:20180628:171101.158 slow query: 615.983241 sec, "update item_discovery set lastcheck=1530216045 where itemid between 30591 and 30596;
"
336:20180628:171101.166 slow query: 610.974998 sec, "update item_discovery set lastcheck=1530216050 where itemid in (55294,55295);
"
492:20180628:171101.166 slow query: 620.138320 sec, "update item_discovery set lastcheck=1530216041 where itemid in (55292,55293);
"
534:20180628:171101.173 slow query: 577.479257 sec, "update item_discovery set lastcheck=1530216083 where itemid in (55378,55379);
"
499:20180628:171101.188 slow query: 37.429898 sec, "update item_discovery set lastcheck=1530216623 where itemid between 56261 and 56295;
"
401:20180628:171101.188 slow query: 620.024692 sec, "update item_discovery set lastcheck=1530216041 where itemid in (30285,60699,60700,60701);
"
600:20180628:171101.189 slow query: 639.473473 sec, "update item_discovery set lastcheck=1530216021 where itemid in (55204,55205);
"
586:20180628:171101.189 slow query: 651.691998 sec, "update item_discovery set lastcheck=1530216009 where itemid in (55161,55162);
"
334:20180628:171101.189 slow query: 583.590136 sec, "update item_discovery set lastcheck=1530216077 where itemid in (55556,55557);
"
338:20180628:171101.190 slow query: 623.192995 sec, "update item_discovery set lastcheck=1530216037 where itemid between 30072 and 30077;
"
593:20180628:171101.190 slow query: 650.683896 sec, "update item_discovery set lastcheck=1530216010 where itemid in (56117,56118);
"
410:20180628:171101.191 slow query: 622.170166 sec, "update item_discovery set lastcheck=1530216038 where itemid in (30126,30127,30128,30129);
"
556:20180628:171101.191 slow query: 607.977102 sec, "update item_discovery set lastcheck=1530216053 where itemid in (56164,56165);
"
328:20180628:171101.192 slow query: 589.685085 sec, "update item_discovery set lastcheck=1530216071 where itemid in (55814,55815);
"
471:20180628:171101.192 slow query: 644.554000 sec, "update item_discovery set lastcheck=1530216016 where itemid in (56121,56122);
"
344:20180628:171101.192 slow query: 625.139100 sec, "update item_discovery set lastcheck=1530216036 where itemid in (55466,55467);
"
469:20180628:171101.199 slow query: 619.178340 sec, "update item_discovery set lastcheck=1530216042 where itemid in (53844,53845);
"
585:20180628:171101.200 slow query: 626.950374 sec, "update item_discovery set lastcheck=1530216034 where itemid in (53812,53813);
"
377:20180628:171101.201 slow query: 630.335727 sec, "update item_discovery set lastcheck=1530216030 where itemid in (55947,55948);
"
331:20180628:171101.205 slow query: 625.198478 sec, "update item_discovery set lastcheck=1530216035 where itemid between 60941 and 60967;
"
466:20180628:171101.206 slow query: 625.233170 sec, "update item_discovery set lastcheck=1530216035 where itemid in (60895,60896,60897,60898);
"
481:20180628:171101.206 slow query: 617.010716 sec, "update item_discovery set lastcheck=1530216044 where (itemid between 60824 and 60865 or itemid in (30529,30534,30539,30544,30549,30554));
"
341:20180628:171101.207 slow query: 478.272546 sec, "update item_discovery set lastcheck=1530216182 where itemid in (58551,58552);
"
350:20180628:171101.209 slow query: 570.409231 sec, "update item_discovery set lastcheck=1530216090 where itemid in (52779,52780);
"
374:20180628:171101.211 slow query: 476.070086 sec, "update item_discovery set lastcheck=1530216185 where itemid in (58484,58485);
"
485:20180628:171101.223 slow query: 578.544606 sec, "update item_discovery set lastcheck=1530216082 where itemid in (52767,52768);
"
533:20180628:171101.224 slow query: 643.574288 sec, "update item_discovery set lastcheck=1530216017 where itemid in (53465,53466);
"
572:20180628:171101.225 slow query: 608.009580 sec, "update item_discovery set lastcheck=1530216053 where itemid in (52959,52960);
"
573:20180628:171101.227 slow query: 572.449281 sec, "update item_discovery set lastcheck=1530216088 where itemid in (53002,53003);
"
378:20180628:171101.227 slow query: 654.762163 sec, "update item_discovery set lastcheck=1530216006 where itemid in (52787,52788);
"
588:20180628:171101.227 slow query: 646.628267 sec, "update item_discovery set lastcheck=1530216014 where itemid in (52783,52784);
"
487:20180628:171101.227 slow query: 597.878642 sec, "update item_discovery set lastcheck=1530216063 where itemid in (52785,52786);
"
530:20180628:171101.228 slow query: 632.386763 sec, "update item_discovery set lastcheck=1530216028 where itemid in (52775,52776);
"
574:20180628:171101.228 slow query: 584.648730 sec, "update item_discovery set lastcheck=1530216076 where itemid in (53422,53423);
"
553:20180628:171101.229 slow query: 637.488675 sec, "update item_discovery set lastcheck=1530216023 where itemid in (53467,53468);
"
465:20180628:171101.229 slow query: 619.556836 sec, "update item_discovery set lastcheck=1530216041 where (itemid between 60702 and 60710 or itemid in (30292,30294,30295,30297,30298,30300,30301,30303,3 0304,30306,30307,30309,30310,30312,30313,30315,303 16,30318));
"
561:20180628:171101.229 slow query: 620.121433 sec, "update item_discovery set lastcheck=1530216041 where itemid in (52724,52725);
"
501:20180628:171101.230 slow query: 616.083696 sec, "update item_discovery set lastcheck=1530216045 where itemid in (30589,30590,60809,60810);
"
536:20180628:171101.230 slow query: 622.104722 sec, "update item_discovery set lastcheck=1530216039 where itemid in (60504,60505,60969,60970);
"
571:20180628:171101.231 slow query: 616.957084 sec, "update item_discovery set lastcheck=1530216044 where itemid between 30562 and 30588;
"
436:20180628:171101.233 slow query: 649.673396 sec, "update item_discovery set lastcheck=1530216011 where itemid in (53473,53474);
"
468:20180628:171101.233 slow query: 617.056189 sec, "update item_discovery set lastcheck=1530216044 where itemid between 30555 and 30560;
"
348:20180628:171101.234 slow query: 617.108310 sec, "update item_discovery set lastcheck=1530216044 where itemid in (60820,60821,60822,60823);
"
373:20180628:171101.234 slow query: 620.148316 sec, "update item_discovery set lastcheck=1530216041 where itemid in (30442,30443,30444,30445,60867,60868,60869,60870);
"
521:20180628:171101.235 slow query: 619.855333 sec, "update item_discovery set lastcheck=1530216041 where itemid between 30286 and 30291;
"
527:20180628:171101.236 slow query: 478.301229 sec, "update item_discovery set lastcheck=1530216182 where itemid in (58549,58550);
"
369:20180628:171101.237 slow query: 619.146908 sec, "update item_discovery set lastcheck=1530216042 where itemid in (60715,60716,60717,60718);
"
357:20180628:171101.237 slow query: 617.767203 sec, "update item_discovery set lastcheck=1530216043 where (itemid between 60800 and 60808 or itemid in (30499,30500,30502,30503,30505,30506,30508,30509,3 0511,30512,30514,30515,30517,30518,30520,30521,305 23,30524));
"
372:20180628:171101.238 slow query: 606.996102 sec, "update item_discovery set lastcheck=1530216054 where itemid in (53469,53470);
"
442:20180628:171101.238 slow query: 602.944200 sec, "update item_discovery set lastcheck=1530216058 where itemid in (53471,53472);
"
434:20180628:171101.239 slow query: 614.102475 sec, "update item_discovery set lastcheck=1530216047 where itemid in (52777,52778);
"
445:20180628:171101.239 slow query: 478.251384 sec, "update item_discovery set lastcheck=1530216182 where itemid between 58553 and 58687;
"
531:20180628:171101.239 slow query: 627.312292 sec, "update item_discovery set lastcheck=1530216033 where itemid in (52769,52770);
"
597:20180628:171101.240 slow query: 584.661186 sec, "update item_discovery set lastcheck=1530216076 where itemid in (52771,52772);
"
394:20180628:171101.240 slow query: 619.140058 sec, "update item_discovery set lastcheck=1530216042 where itemid between 60794 and 60799;
"
567:20180628:171101.240 slow query: 625.284580 sec, "update item_discovery set lastcheck=1530216035 where itemid in (53295,53296);
"
570:20180628:171101.240 slow query: 606.000618 sec, "update item_discovery set lastcheck=1530216055 where itemid in (52781,52782);
"
379:20180628:171101.241 slow query: 619.107971 sec, "update item_discovery set lastcheck=1530216042 where itemid between 60767 and 60793;
"
522:20180628:171101.241 slow query: 616.127948 sec, "update item_discovery set lastcheck=1530216045 where itemid in (53127,53128);
"
382:20180628:171101.241 slow query: 591.766600 sec, "update item_discovery set lastcheck=1530216069 where itemid in (52773,52774);
"
339:20180628:171101.241 slow query: 617.944034 sec, "update item_discovery set lastcheck=1530216043 where itemid between 30456 and 30497;
"
512:20180628:171101.243 slow query: 620.138700 sec, "update item_discovery set lastcheck=1530216041 where (itemid between 60871 and 60894 or itemid in (30375,30382,30389,30396,30403,30410,60644,60646,6 0648,60650,60652,60654));
"
549:20180628:171101.243 slow query: 622.117812 sec, "update item_discovery set lastcheck=1530216039 where (itemid between 60980 and 61003 or itemid in (60508,60517,60526,60535,60544,60553));
"
562:20180628:171101.245 slow query: 623.209498 sec, "update item_discovery set lastcheck=1530216038 where (itemid between 60811 and 60819 or itemid in (30046,30047,30049,30050,30052,30053,30055,30056,3 0058,30059,30061,30062,30064,30065,30067,30068,300 70,30071));
"
605:20180628:171101.245 slow query: 620.157748 sec, "update item_discovery set lastcheck=1530216041 where itemid in (53475,53476,53477,53478);
"
590:20180628:171101.246 slow query: 622.211477 sec, "update item_discovery set lastcheck=1530216039 where (itemid between 60605 and 60613 or itemid in (30136,30138,30140,30142,30144,30146,30148,30150,3 0152));
"
326:20180628:171101.247 slow query: 576.524827 sec, "update item_discovery set lastcheck=1530216084 where itemid in (53211,53212);
"
583:20180628:171101.247 slow query: 620.139544 sec, "update item_discovery set lastcheck=1530216041 where itemid between 30367 and 30372;
"
475:20180628:171101.248 slow query: 622.211372 sec, "update item_discovery set lastcheck=1530216039 where itemid between 30130 and 30135;
"
540:20180628:171101.248 slow query: 154.624627 sec, "update item_discovery set lastcheck=1530216506 where (itemid between 60600 and 60604 or itemid in (58166,58168,58170,58172,58174));
"
386:20180628:171101.250 slow query: 619.869788 sec, "update item_discovery set lastcheck=1530216041 where itemid between 30319 and 30366;
"
473:20180628:171101.250 slow query: 622.222760 sec, "update item_discovery set lastcheck=1530216039 where itemid between 30154 and 30195;
"
589:20180628:171101.250 slow query: 624.170785 sec, "update item_discovery set lastcheck=1530216037 where (itemid between 60690 and 60698 or itemid in (29984,29985,29987,29988,29990,29991,29993,29994,2 9996,29997,29999,30000,30002,30003,30005,30006,300 08,30009));
"
411:20180628:171101.253 slow query: 624.219610 sec, "update item_discovery set lastcheck=1530216037 where itemid between 29978 and 29983;
"
478:20180628:171101.253 slow query: 624.214655 sec, "update item_discovery set lastcheck=1530216037 where (itemid between 60660 and 60689 or itemid in (30011,30014,30016,30019,30021,30024,30026,30029,3 0031,30034,30036,30039));
"
518:20180628:171101.255 slow query: 621.225894 sec, "update item_discovery set lastcheck=1530216040 where (itemid between 60971 and 60979 or itemid in (60473,60474,60476,60477,60479,60480,60482,60483,6 0485,60486,60488,60489,60491,60492,60494,60495,604 97,60498));
"
474:20180628:171101.261 slow query: 628.125360 sec, "update item_discovery set lastcheck=1530216033 where itemid between 29283 and 29330;
"
455:20180628:171101.262 slow query: 628.126597 sec, "update item_discovery set lastcheck=1530216033 where itemid between 29277 and 29282;
"
454:20180628:171101.262 slow query: 619.145846 sec, "update item_discovery set lastcheck=1530216042 where itemid between 60719 and 60766;
"
385:20180628:171101.302 slow query: 603.838549 sec, "update item_discovery set lastcheck=1530216057 where itemid in (58343,58344);
"
524:20180628:171101.305 slow query: 625.308628 sec, "update item_discovery set lastcheck=1530216035 where (itemid between 60899 and 60940 or itemid in (29959,29962,29965,29968,29971,29974));
"
511:20180628:171101.305 slow query: 620.166700 sec, "update item_discovery set lastcheck=1530216041 where itemid between 30415 and 30441;
"
342:20180628:171101.306 slow query: 603.739521 sec, "update item_discovery set lastcheck=1530216057 where itemid between 58347 and 58481;
"
319:20180628:171101.329 slow query: 658.958188 sec, "insert into history (itemid,clock,ns,value) values (57679,1530215999,575726822,0.001183),(59758,15302 15999,575726822,0.000000),(59759,1530215999,575726 822,0.031423),(59108,1530215999,575726822,0.000000 ),(59109,1530215999,575726822,0.000410),(58928,153 0215999,575726822,0.000000),(58929,1530215999,5757 26822,0.000390),(58006,1530215999,575726822,0.0015 23),(58005,1530215999,575726822,0.000000),(57678,1 530215999,575726822,0.000000),(60902,1530216002,36 8988178,0.000000);
"
314:20180628:171101.339 slow query: 658.811744 sec, "insert into history_uint (itemid,clock,ns,value) values (53642,1530216002,486441909,4600000512),(57812,153 0216002,501981301,1);
"
316:20180628:171101.339 slow query: 658.210456 sec, "insert into history (itemid,clock,ns,value) values (57681,1530216000,635165478,0.000000),(57682,15302 16000,635165478,0.001487),(59761,1530216000,635165 478,0.000000),(59762,1530216000,635165478,0.009610 ),(58009,1530216000,635165478,0.000490),(58008,153 0216000,635165478,0.000000),(58931,1530216000,6351 65478,0.000000),(58932,1530216000,635165478,0.0005 27),(59111,1530216000,635165478,0.000000),(59112,1 530216000,635165478,0.000440);
"
318:20180628:171101.339 slow query: 657.684418 sec, "insert into history (itemid,clock,ns,value) values (53582,1530216003,371892280,0.000000),(55563,15302 16003,387293014,99.966248),(52983,1530216003,38890 2422,78.462536),(55023,1530216003,389385478,0.0000 00),(54543,1530216003,390039256,99.961495),(56763, 1530216003,390095438,98.381360),(54603,1530216003, 390118369,96.497989),(55323,1530216003,390136890,0 .000000),(54243,1530216003,390591635,99.926376),(5 5683,1530216003,391187846,0.000000),(52503,1530216 003,391831893,0.000000),(55383,1530216003,39199052 8,72.647188),(56883,1530216003,392220350,50.993201 ),(53403,1530216003,392506735,84.926901),(56103,15 30216003,392628538,1.038352),(51963,1530216003,394 523067,0.067069),(55623,1530216003,395822467,29.15 8971),(55443,1530216003,396158600,0.050000),(53283 ,1530216003,397638531,17.565567),(55143,1530216003 ,398254772,0.000000),(52863,1530216003,398517569,1 6.967177),(54903,1530216003,398979363,0.016798),(5 6343,1530216003,399073669,91.822447),(52623,153021 6003,399127386,96.016386),(56643,1530216003,399338 089,99.926186),(54723,1530216003,399434832,0.00000 0),(54843,1530216003,399840877,99.621120),(60903,1 530216003,403144411,0.000000),(53763,1530216003,40 3256662,98.378808),(54363,1530216003,481515257,74. 534417);
"
320:20180628:171101.340 slow query: 655.685025 sec, "insert into history (itemid,clock,ns,value) values (53584,1530216005,398538578,1319010.624346),(53105 ,1530216005,416298372,0.285000),(54425,1530216005, 417873104,0.000196),(52505,1530216005,417919284,1. 856653),(52625,1530216005,418032393,0.002090),(546 05,1530216005,418338054,0.016762),(52205,153021600 5,418400200,0.030000),(60905,1530216005,418575355, 0.288079),(55445,1530216005,419028028,0.040000),(5 3405,1530216005,419239472,0.403142),(53645,1530216 005,420768797,74.781969),(55565,1530216005,4209754 52,98.355408),(51965,1530216005,421125044,0.033540 ),(55385,1530216005,421839443,99.966217),(52085,15 30216005,422681621,0.000000),(52745,1530216005,422 866324,0.040000),(52985,1530216005,422937798,0.480 970),(55925,1530216005,423451298,0.150000),(55145, 1530216005,424984512,0.000000),(56885,1530216005,4 25092631,66.180997),(55325,1530216005,425407052,0. 362969),(55025,1530216005,426056081,0.025075),(556 25,1530216005,428492378,84.094293),(54905,15302160 05,428562947,0.000000),(56645,1530216005,429462820 ,99.999121),(54245,1530216005,433206492,99.958740) ,(54365,1530216005,495345001,67.377264);
"
313:20180628:171101.341 slow query: 654.213103 sec, "insert into history (itemid,clock,ns,value) values (59121,1530216003,711290586,0.001403),(59120,15302 16003,711290586,0.000000),(59771,1530216003,711290 586,0.000000),(59770,1530216003,711290586,100.0000 00),(57690,1530216003,711290586,0.000000),(57691,1 530216003,711290586,0.001033),(58294,1530216003,71 1290586,0.000307),(58293,1530216003,711290586,0.00 0000),(58940,1530216003,711290586,0.000000),(58941 ,1530216003,711290586,0.000357),(59124,1530216004, 372549017,0.000360),(58943,1530216004,372549017,0. 000000),(57693,1530216004,372549017,0.000000),(576 94,1530216004,372549017,0.000937),(58944,153021600 4,372549017,0.000477),(59123,1530216004,372549017, 0.000000),(59774,1530216004,372549017,0.057807),(5 9773,1530216004,372549017,0.000000),(53585,1530216 006,420272223,7.998636),(52206,1530216006,42320379 9,0.085000),(52746,1530216006,425862572,0.040000), (52986,1530216006,427095511,0.000000),(56706,15302 16006,432788113,97.421854),(54606,1530216006,43347 7423,0.000000),(55206,1530216006,433888950,97.6237 74),(56886,1530216006,434389259,91.415738),(53406, 1530216006,435663910,0.000000),(51966,1530216006,4 36046237,0.000000),(56466,1530216006,436821297,99. 958955),(55026,1530216006,437106470,0.000000),(570 66,1530216006,437316699,99.966484),(55386,15302160 06,437609529,99.957275),(52086,1530216006,43773225 6,0.041755),(55626,1530216006,438250375,59.598362) ,(55926,1530216006,438590013,0.175000),(52386,1530 216006,438883095,95.945305),(54906,1530216006,4389 66646,0.000000),(57006,1530216006,439504605,99.958 281),(54726,1530216006,440249877,98.675386),(54366 ,1530216006,440710012,57.520880),(56526,1530216006 ,440885981,97.967225),(55566,1530216006,441507815, 99.621864),(55146,1530216006,442000665,0.083935),( 56646,1530216006,443165144,99.998496),(54426,15302 16006,443257035,40.532896),(53106,1530216006,44347 6394,0.180000),(52626,1530216006,445096870,0.00000 0),(53826,1530216006,445206552,74.750571),(54246,1 530216006,445493647,99.998848),(53646,1530216006,4 46286992,14.777252);
"
315:20180628:171101.341 slow query: 658.869342 sec, "insert into history (itemid,clock,ns,value) values (55022,1530216002,372651933,0.000000),(54902,15302 16002,372820160,98.504955),(55322,1530216002,37313 0158,0.008344),(54722,1530216002,373327043,0.05000 0),(58142,1530216002,375165038,100.000000),(56402, 1530216002,375238071,99.907684),(55982,1530216002, 375578216,84.970478),(56342,1530216002,375629949,6 7.159170),(51962,1530216002,375993007,0.000000),(5 5142,1530216002,376190041,98.858869),(56582,153021 6002,376602954,99.973770),(56102,1530216002,376786 465,0.586265),(56762,1530216002,377276498,97.43557 4),(54842,1530216002,377306250,98.388977),(52502,1 530216002,379014161,0.008363),(55562,1530216002,37 9239732,96.034887),(52082,1530216002,379250327,0.0 07500),(56882,1530216002,379352230,39.437890),(545 42,1530216002,379422302,99.982452),(52862,15302160 02,380759499,13.019952),(54782,1530216002,38087293 5,81.672230),(52382,1530216002,380960044,1.906036) ,(55382,1530216002,382065847,99.343125),(53762,153 0216002,382413897,86.250860),(60602,1530216002,384 195101,87.228486),(53942,1530216002,384221085,99.9 89238),(54002,1530216002,385152305,99.352220),(532 82,1530216002,387047791,1.948300),(54242,153021600 2,387359939,98.135937),(56642,1530216002,410694370 ,98.059603);
"
317:20180628:171101.342 slow query: 656.686464 sec, "insert into history (itemid,clock,ns,value) values (57615,1530216001,694327921,0.000000),(57616,15302 16001,694327921,0.000110),(59765,1530216001,694327 921,0.000000),(57684,1530216001,694327921,0.000000 ),(57685,1530216001,694327921,0.001303),(58329,153 0216001,694327921,0.000297),(58328,1530216001,6943 27921,0.000000),(58934,1530216001,694327921,0.0000 00),(58935,1530216001,694327921,0.001537),(59114,1 530216001,694327921,0.000000),(59115,1530216001,69 4327921,0.000390),(59764,1530216001,694327921,100. 000000),(57688,1530216002,245167629,0.000667),(576 87,1530216002,245167629,0.000000),(58938,153021600 2,245167629,0.001280),(58937,1530216002,245167629, 0.000000),(59117,1530216002,245167629,0.000000),(5 9118,1530216002,245167629,0.000723),(59767,1530216 002,245167629,0.000000),(59768,1530216002,24516762 9,0.009663),(53583,1530216004,386464741,0.000000), (52084,1530216004,400186114,98.175518),(60904,1530 216004,400559948,2.135615),(55384,1530216004,40398 0694,96.162835),(55324,1530216004,404279401,0.1084 73),(56884,1530216004,404860597,82.565925),(55024, 1530216004,405159574,0.000000),(55144,1530216004,4 05530988,0.000000),(56644,1530216004,406565408,99. 953750),(55564,1530216004,407585615,99.957275),(53 104,1530216004,407837463,0.155000),(52504,15302160 04,408362677,0.727607),(54244,1530216004,408584674 ,99.999414),(54604,1530216004,409691074,0.000000), (53404,1530216004,410024701,0.000000),(55924,15302 16004,410648262,0.120000),(55444,1530216004,410711 131,0.030000),(54544,1530216004,411833493,99.99579 2),(51964,1530216004,412028792,0.000000),(52624,15 30216004,412122470,0.000000),(54904,1530216004,412 674680,0.000000),(52984,1530216004,412926937,0.002 091),(52744,1530216004,413401531,0.050000),(54724, 1530216004,413456679,0.010000),(55624,1530216004,4 13457855,54.068728),(53764,1530216004,413640630,99 .314488),(54364,1530216004,434659509,40.002613);
"

[Diego Torres]

Someone please

[LenR]

What version of Zabbix? What are the values from "Status of Zabbix", how many hosts/items/triggers/nvps? Does housekeeping ever finish? What kind of hardware and disk?

[kloczek]

What kind of storage is using DB backend?
Type of the SQL engine?
How much memory is using DB engine?

10 min hanging SQL query .. generally you have issues with slow DB operations and whatever you need to do is related to improve performance of this part of the whole zabbix stack.

[Diego Torres]

Firstly, thanks for the support.

The servers are virtual. The following is the conf

The Zabbix version is 4.0
OS Red Hat Enterprise Linux 7 (64-bit)
CPU: 4 vCPU
Memory: 4098 MB
Disk: 160 GB
Number of hosts (enabled / disabled / templates): 352
Number of items (enabled / disabled / not supported): 19194
Number of triggers (enabled / disabled [incident / ok]) 9380


Bank: Mysql (mariadb)

OS Red Hat Enterprise Linux 7 (64-bit)
CPU: 4 vCPU
Memory: 4098 MB
Disk: 100 GB

The lock does not remain all the time, it stops to come back. It takes about 10 to 15 minutes to stand still

[kloczek]

4GB RAM .. weakest point (+99%) is to small memory footprint for SQL engine which is causing that many/most of the DB data (MRU/MFU) needs to be read from storage.
Next in order of priorities is probably storage IOs latency (check type of virtualisation and or move DB backend to physical host or at least LXC zone.
Just after add more memory with already >=100GB database you should add at least history* tables partitioning (to do this you may need less than two times more disk space).
If you will have proper storage and SQL engine monitoring what exactly needs to be done first will be possible to read from those things monitoring data.

[Diego Torres]

Good morning mate. Looking at some problems similar to mine, I found something and managed to minimize my problem but not 100%. I noticed that the Zabbix configuration file needed some adjustments because of the data load and SNMP services that are monitored in my environment. Several services, before settling, ran into 100% use and locked my Zabbix for 10 to 15 minutes. Now, I'm having trouble with Zabbix busy history syncer processes. I configured the StartDBSyncers = 4 plus it runs every hour and consumes 100% and hangs my Server. Can you help me?

[Diego Torres]

First I want to graduate thanks to the speed of the support and that was posted here gave me a north until I get the main problem. Actually, this Zabbix server was already installed and they put me to administer it. Since there was a lot done, I did not want to make one from scratch. in the end ... The problem of the locking was in a Scrpt of backup of the bank that was executed by hour, every time that it initiated, zabbix history syncer process consumed 100% and the server stopped in the period of the exeception.