Hello,
Yesterday, i have upgrade my zabbix server / sql / agent from 5.0.5 to 5.2.
After start my server and database update, i have a lot of slow query database command... and zabbix history syncer alert...
Yesterday, i have upgrade my zabbix server / sql / agent from 5.0.5 to 5.2.
After start my server and database update, i have a lot of slow query database command... and zabbix history syncer alert...
16376:20201027:202811.054 slow query: 3.472589 sec, "delete from history_uint where itemid=110248 and clock<1603199021"
16381:20201027:202812.277 slow query: 3.373498 sec, "insert into history_uint (itemid,clock,ns,value) values (30415,1603826885,900252612,1),(32875,1603826885,9 00252612,1),(134770,1603826885,900252612,1),(81492 ,1603826887,888065379,0),(81459,1603826887,8880653 79,0),(82284,1603826887,888065379,2),(81833,160382 6887,888065379,0),(120075,1603826887,888065379,1), (81889,1603826887,888065379,0),(82215,1603826887,8 88065379,1),(81820,1603826887,888065379,0),(81809, 1603826887,888065379,0),(82287,1603826887,88806537 9,2),(82267,1603826887,888065379,2),(82231,1603826 887,888065379,2),(128039,1603826887,888353282,0),( 81835,1603826887,888656697,0),(81642,1603826887,88 8656697,0),(81501,1603826887,888656697,0),(82294,1 603826887,888656697,2),(82270,1603826887,888656697 ,2),(82612,1603826887,888656697,3),(81540,16038268 87,888656697,0),(82235,1603826887,888656697,2),(82 272,1603826887,888656697,1),(81812,1603826887,8886 56697,0),(81534,1603826887,888656697,0),(82608,160 3826887,888656697,3),(81520,1603826887,888656697,0 ),(81546,1603826887,888656697,0),(82309,1603826887 ,888656697,2),(81517,1603826887,888656697,0),(8147 8,1603826887,888656697,0),(81549,1603826887,888656 697,0),(126117,1603826887,888656697,1),(82227,1603 826887,888656697,1),(82255,1603826887,888656697,1) ,(82320,1603826887,888656697,2),(81830,1603826887, 888656697,0),(82274,1603826887,888656697,1),(81823 ,1603826887,888656697,0),(82290,1603826887,8886566 97,2),(82282,1603826887,888656697,2),(81844,160382 6887,888656697,0),(82273,1603826887,888656697,2),( 82252,1603826887,888656697,2),(81876,1603826887,88 8656697,0),(82219,1603826887,888656697,1),(82310,1 603826887,888656697,2),(82275,1603826887,888656697 ,2),(119099,1603826887,889244604,12288),(33659,160 3826887,891066466,1),(32519,1603826887,891115180,1 ),(128579,1603826887,892248295,159024),(31411,1603 826887,894416184,2391378),(82850,1603826887,916862 893,0),(83299,1603826887,916862893,0),(83064,16038 26887,916862893,0),(82606,1603826887,916862893,1), (82831,1603826887,916862893,0),(82886,1603826887,9 16862893,0),(83036,1603826887,916862893,0),(83005, 1603826887,916862893,0),(82691,1603826887,91686289 3,0),(82815,1603826887,916862893,0),(83237,1603826 887,916862893,8080),(82747,1603826887,916862893,0) ,(82719,1603826887,916862893,0),(82746,1603826887, 916862893,0),(82841,1603826887,916862893,0),(82900 ,1603826887,916862893,0),(83161,1603826887,9168628 93,0),(83041,1603826887,916862893,0),(83065,160382 6887,916862893,0),(83021,1603826887,916862893,0),( 83038,1603826887,916862893,0),(83040,1603826887,91 6862893,0),(82710,1603826887,916862893,0),(82868,1 603826887,916862893,0),(82964,1603826887,916862893 ,0),(82857,1603826887,916862893,0),(83177,16038268 87,916862893,0),(82806,1603826887,916862893,0),(82 887,1603826887,916862893,0),(83181,1603826887,9168 62893,0),(83163,1603826887,916862893,0),(82937,160 3826887,916862893,0),(82947,1603826887,916862893,0 ),(82875,1603826887,916862893,0),(83077,1603826887 ,916862893,0),(82732,1603826887,916862893,0),(8321 3,1603826887,916862893,0),(83264,1603826887,916862 893,0),(83503,1603826887,916862893,2),(82767,16038 26887,916862893,0),(83187,1603826887,916862893,0), (83517,1603826887,916862893,2),(83458,1603826887,9 16862893,1),(83039,1603826887,916862893,0),(83232, 1603826887,916862893,0),(83449,1603826887,91686289 3,2),(82865,1603826887,916862893,0),(82651,1603826 887,916862893,3),(83451,1603826887,916862893,1),(8 3231,1603826887,916862893,0),(82797,1603826887,916 862893,0),(83171,1603826887,916862893,0),(120084,1 603826887,916862893,1),(83042,1603826887,916862893 ,0),(83284,1603826887,916862893,0),(83235,16038268 87,916862893,0),(82813,1603826887,916862893,0),(82 783,1603826887,916862893,0),(82973,1603826887,9168 62893,0),(82934,1603826887,916862893,1496),(82906, 1603826887,916862893,0),(82737,1603826887,91717591 3,0),(82796,1603826887,917175913,0),(83066,1603826 887,917175913,0),(83244,1603826887,917175913,0),(8 3090,1603826887,917175913,0),(129288,1603826887,91 7175913,1248),(83013,1603826887,917175913,0),(8293 6,1603826887,917175913,0),(82935,1603826887,917175 913,0),(83210,1603826887,917175913,0),(83211,16038 26887,917175913,0),(83068,1603826887,917175913,0), (82827,1603826887,917175913,0),(82924,1603826887,9 17175913,0),(83144,1603826887,917175913,0),(82904, 1603826887,917175913,0),(82740,1603826887,91717591 3,0),(82627,1603826887,917175913,3),(83168,1603826 887,917175913,0),(82760,1603826887,917175913,0),(8 2941,1603826887,917175913,14032),(83203,1603826887 ,917175913,0),(83253,1603826887,917175913,8056),(8 2982,1603826887,917175913,224),(82731,1603826887,9 17175913,0),(83018,1603826887,917175913,0),(82976, 1603826887,917175913,2008),(83082,1603826887,91717 5913,0),(83269,1603826887,917175913,0),(83263,1603 826887,917175913,0),(82818,1603826887,917175913,0) ,(82697,1603826887,917175913,0),(82864,1603826887, 917175913,0),(82688,1603826887,917175913,0),(82965 ,1603826887,917175913,0),(82637,1603826887,9171759 13,3),(83084,1603826887,917175913,0),(82694,160382 6887,917175913,0),(82842,1603826887,917175913,0),( 83185,1603826887,917175913,0),(82912,1603826887,91 7175913,0),(83095,1603826887,917175913,0),(83491,1 603826887,917175913,2),(82768,1603826887,917175913 ,0),(82834,1603826887,917175913,0),(83271,16038268 87,917175913,0),(83109,1603826887,917175913,0),(83 113,1603826887,917175913,0),(82961,1603826887,9171 75913,0),(82953,1603826887,917175913,0),(83218,160 3826887,917175913,0),(82942,1603826887,917175913,0 ),(83010,1603826887,917175913,0),(83162,1603826887 ,917175913,0),(82764,1603826887,917175913,0),(8300 8,1603826887,917175913,0),(82823,1603826887,917175 913,0),(83118,1603826887,917175913,0),(82877,16038 26887,917175913,0),(83220,1603826887,923631159,0), (82717,1603826887,923631159,0),(83467,1603826887,9 23631159,2),(83420,1603826887,923631159,2),(83125, 1603826887,923631159,0),(83228,1603826887,92363115 9,0),(82713,1603826887,923631159,0),(83414,1603826 887,923631159,1),(83152,1603826887,923631159,0),(8 2649,1603826887,923631159,3),(83438,1603826887,923 631159,2),(83425,1603826887,923631159,2),(82618,16 03826887,923631159,12543188),(136625,1603826887,92 3631159,3),(83427,1603826887,923631159,2),(82704,1 603826887,923631159,0),(83500,1603826887,923631159 ,2),(83105,1603826887,923631159,0),(83489,16038268 87,923631159,2),(82989,1603826887,923631159,0),(82 730,1603826887,923631159,0),(83487,1603826887,9236 31159,1),(82987,1603826887,923631159,0),(83461,160 3826887,923631159,2),(82952,1603826887,923631159,0 ),(83430,1603826887,923631159,2),(82729,1603826887 ,923631159,0),(83028,1603826887,923631159,0),(8343 7,1603826887,923631159,2),(83285,1603826887,923631 159,7776),(83497,1603826887,923631159,2),(83423,16 03826887,923631159,2),(133340,1603826887,923631159 ,3),(83454,1603826887,923631159,2),(82638,16038268 87,923631159,3),(83483,1603826887,923631159,2),(83 486,1603826887,923631159,2),(83459,1603826887,9236 31159,1),(82775,1603826887,923631159,0),(82705,160 3826887,923631159,0),(83191,1603826887,923631159,0 ),(82819,1603826887,923631159,0),(83266,1603826887 ,92363115
16381:20201027:202812.277 slow query: 3.373498 sec, "insert into history_uint (itemid,clock,ns,value) values (30415,1603826885,900252612,1),(32875,1603826885,9 00252612,1),(134770,1603826885,900252612,1),(81492 ,1603826887,888065379,0),(81459,1603826887,8880653 79,0),(82284,1603826887,888065379,2),(81833,160382 6887,888065379,0),(120075,1603826887,888065379,1), (81889,1603826887,888065379,0),(82215,1603826887,8 88065379,1),(81820,1603826887,888065379,0),(81809, 1603826887,888065379,0),(82287,1603826887,88806537 9,2),(82267,1603826887,888065379,2),(82231,1603826 887,888065379,2),(128039,1603826887,888353282,0),( 81835,1603826887,888656697,0),(81642,1603826887,88 8656697,0),(81501,1603826887,888656697,0),(82294,1 603826887,888656697,2),(82270,1603826887,888656697 ,2),(82612,1603826887,888656697,3),(81540,16038268 87,888656697,0),(82235,1603826887,888656697,2),(82 272,1603826887,888656697,1),(81812,1603826887,8886 56697,0),(81534,1603826887,888656697,0),(82608,160 3826887,888656697,3),(81520,1603826887,888656697,0 ),(81546,1603826887,888656697,0),(82309,1603826887 ,888656697,2),(81517,1603826887,888656697,0),(8147 8,1603826887,888656697,0),(81549,1603826887,888656 697,0),(126117,1603826887,888656697,1),(82227,1603 826887,888656697,1),(82255,1603826887,888656697,1) ,(82320,1603826887,888656697,2),(81830,1603826887, 888656697,0),(82274,1603826887,888656697,1),(81823 ,1603826887,888656697,0),(82290,1603826887,8886566 97,2),(82282,1603826887,888656697,2),(81844,160382 6887,888656697,0),(82273,1603826887,888656697,2),( 82252,1603826887,888656697,2),(81876,1603826887,88 8656697,0),(82219,1603826887,888656697,1),(82310,1 603826887,888656697,2),(82275,1603826887,888656697 ,2),(119099,1603826887,889244604,12288),(33659,160 3826887,891066466,1),(32519,1603826887,891115180,1 ),(128579,1603826887,892248295,159024),(31411,1603 826887,894416184,2391378),(82850,1603826887,916862 893,0),(83299,1603826887,916862893,0),(83064,16038 26887,916862893,0),(82606,1603826887,916862893,1), (82831,1603826887,916862893,0),(82886,1603826887,9 16862893,0),(83036,1603826887,916862893,0),(83005, 1603826887,916862893,0),(82691,1603826887,91686289 3,0),(82815,1603826887,916862893,0),(83237,1603826 887,916862893,8080),(82747,1603826887,916862893,0) ,(82719,1603826887,916862893,0),(82746,1603826887, 916862893,0),(82841,1603826887,916862893,0),(82900 ,1603826887,916862893,0),(83161,1603826887,9168628 93,0),(83041,1603826887,916862893,0),(83065,160382 6887,916862893,0),(83021,1603826887,916862893,0),( 83038,1603826887,916862893,0),(83040,1603826887,91 6862893,0),(82710,1603826887,916862893,0),(82868,1 603826887,916862893,0),(82964,1603826887,916862893 ,0),(82857,1603826887,916862893,0),(83177,16038268 87,916862893,0),(82806,1603826887,916862893,0),(82 887,1603826887,916862893,0),(83181,1603826887,9168 62893,0),(83163,1603826887,916862893,0),(82937,160 3826887,916862893,0),(82947,1603826887,916862893,0 ),(82875,1603826887,916862893,0),(83077,1603826887 ,916862893,0),(82732,1603826887,916862893,0),(8321 3,1603826887,916862893,0),(83264,1603826887,916862 893,0),(83503,1603826887,916862893,2),(82767,16038 26887,916862893,0),(83187,1603826887,916862893,0), (83517,1603826887,916862893,2),(83458,1603826887,9 16862893,1),(83039,1603826887,916862893,0),(83232, 1603826887,916862893,0),(83449,1603826887,91686289 3,2),(82865,1603826887,916862893,0),(82651,1603826 887,916862893,3),(83451,1603826887,916862893,1),(8 3231,1603826887,916862893,0),(82797,1603826887,916 862893,0),(83171,1603826887,916862893,0),(120084,1 603826887,916862893,1),(83042,1603826887,916862893 ,0),(83284,1603826887,916862893,0),(83235,16038268 87,916862893,0),(82813,1603826887,916862893,0),(82 783,1603826887,916862893,0),(82973,1603826887,9168 62893,0),(82934,1603826887,916862893,1496),(82906, 1603826887,916862893,0),(82737,1603826887,91717591 3,0),(82796,1603826887,917175913,0),(83066,1603826 887,917175913,0),(83244,1603826887,917175913,0),(8 3090,1603826887,917175913,0),(129288,1603826887,91 7175913,1248),(83013,1603826887,917175913,0),(8293 6,1603826887,917175913,0),(82935,1603826887,917175 913,0),(83210,1603826887,917175913,0),(83211,16038 26887,917175913,0),(83068,1603826887,917175913,0), (82827,1603826887,917175913,0),(82924,1603826887,9 17175913,0),(83144,1603826887,917175913,0),(82904, 1603826887,917175913,0),(82740,1603826887,91717591 3,0),(82627,1603826887,917175913,3),(83168,1603826 887,917175913,0),(82760,1603826887,917175913,0),(8 2941,1603826887,917175913,14032),(83203,1603826887 ,917175913,0),(83253,1603826887,917175913,8056),(8 2982,1603826887,917175913,224),(82731,1603826887,9 17175913,0),(83018,1603826887,917175913,0),(82976, 1603826887,917175913,2008),(83082,1603826887,91717 5913,0),(83269,1603826887,917175913,0),(83263,1603 826887,917175913,0),(82818,1603826887,917175913,0) ,(82697,1603826887,917175913,0),(82864,1603826887, 917175913,0),(82688,1603826887,917175913,0),(82965 ,1603826887,917175913,0),(82637,1603826887,9171759 13,3),(83084,1603826887,917175913,0),(82694,160382 6887,917175913,0),(82842,1603826887,917175913,0),( 83185,1603826887,917175913,0),(82912,1603826887,91 7175913,0),(83095,1603826887,917175913,0),(83491,1 603826887,917175913,2),(82768,1603826887,917175913 ,0),(82834,1603826887,917175913,0),(83271,16038268 87,917175913,0),(83109,1603826887,917175913,0),(83 113,1603826887,917175913,0),(82961,1603826887,9171 75913,0),(82953,1603826887,917175913,0),(83218,160 3826887,917175913,0),(82942,1603826887,917175913,0 ),(83010,1603826887,917175913,0),(83162,1603826887 ,917175913,0),(82764,1603826887,917175913,0),(8300 8,1603826887,917175913,0),(82823,1603826887,917175 913,0),(83118,1603826887,917175913,0),(82877,16038 26887,917175913,0),(83220,1603826887,923631159,0), (82717,1603826887,923631159,0),(83467,1603826887,9 23631159,2),(83420,1603826887,923631159,2),(83125, 1603826887,923631159,0),(83228,1603826887,92363115 9,0),(82713,1603826887,923631159,0),(83414,1603826 887,923631159,1),(83152,1603826887,923631159,0),(8 2649,1603826887,923631159,3),(83438,1603826887,923 631159,2),(83425,1603826887,923631159,2),(82618,16 03826887,923631159,12543188),(136625,1603826887,92 3631159,3),(83427,1603826887,923631159,2),(82704,1 603826887,923631159,0),(83500,1603826887,923631159 ,2),(83105,1603826887,923631159,0),(83489,16038268 87,923631159,2),(82989,1603826887,923631159,0),(82 730,1603826887,923631159,0),(83487,1603826887,9236 31159,1),(82987,1603826887,923631159,0),(83461,160 3826887,923631159,2),(82952,1603826887,923631159,0 ),(83430,1603826887,923631159,2),(82729,1603826887 ,923631159,0),(83028,1603826887,923631159,0),(8343 7,1603826887,923631159,2),(83285,1603826887,923631 159,7776),(83497,1603826887,923631159,2),(83423,16 03826887,923631159,2),(133340,1603826887,923631159 ,3),(83454,1603826887,923631159,2),(82638,16038268 87,923631159,3),(83483,1603826887,923631159,2),(83 486,1603826887,923631159,2),(83459,1603826887,9236 31159,1),(82775,1603826887,923631159,0),(82705,160 3826887,923631159,0),(83191,1603826887,923631159,0 ),(82819,1603826887,923631159,0),(83266,1603826887 ,92363115
Comment