zabbix_server.log slow query:
Некоторое время назад заметил в логе сообщения типа:
slow query: 3.795471 sec, "select distinct itemid from trends_uint where clock>=1516600800 and (itemid between 35328 and 35333 or itemid between 35358 and 35366 or itemid between 35400 and 35405 or itemid between 35411 and 35415 or itemid between 35627 and 35631 or itemid between 35636 and 35641 or itemid in (24650,24710,25490,32930,35233,35235,35236,35240,3 5241,35242,35245,35251,35252,35254,35256,35258,352 59,35260,35323,35324,35325,35326,35336,35341,35342 ,35343,35348,35350,35353,35370,35372,35373,35374,3 5376,35379,35381,35382,35383,35387,35391,35392,353 95,35409,35418,35419,35427,35430,35431,35434,35438 ,35440,35442,35443,35444,35446,35448,35451,35452,3 5453,35455,35456,35463,35464,35467,35469,35470,354 74,35475,35476,35477,35481,35482,35484,35485,35489 ,35490,35492,35494,35496,35499,35500,35501,35565,3 5566,35569,35572,35573,35574,35577,35578,35583,355 84,35586,35588,35589,35590,35591,35595,35596,35597 ,35598,35600,35608,35610,35611,35612,35613,35618,3 5621,35622,35625,35634,35643,35645,35647,35648,356 49,35652,35655,35661,35665,35666,35668,35669,35670 ,35672,35673,35676,35677,35678,35681,35682,35686,3 5690,35691,35692,35697,35700,35701,35702,35703,357 05,35706,35707,35708,35930,35989,36049,36290,44810 ,45050,45109,45110,45170,45685))"
Визуально на работу не влияет, однако вызывает опасения. Разумного описания влёт не нашёл.
Как быть, куда смотреть? Это что-то ненормальное или можно смело забить и не напрягаться?
slow query: 3.795471 sec, "select distinct itemid from trends_uint where clock>=1516600800 and (itemid between 35328 and 35333 or itemid between 35358 and 35366 or itemid between 35400 and 35405 or itemid between 35411 and 35415 or itemid between 35627 and 35631 or itemid between 35636 and 35641 or itemid in (24650,24710,25490,32930,35233,35235,35236,35240,3 5241,35242,35245,35251,35252,35254,35256,35258,352 59,35260,35323,35324,35325,35326,35336,35341,35342 ,35343,35348,35350,35353,35370,35372,35373,35374,3 5376,35379,35381,35382,35383,35387,35391,35392,353 95,35409,35418,35419,35427,35430,35431,35434,35438 ,35440,35442,35443,35444,35446,35448,35451,35452,3 5453,35455,35456,35463,35464,35467,35469,35470,354 74,35475,35476,35477,35481,35482,35484,35485,35489 ,35490,35492,35494,35496,35499,35500,35501,35565,3 5566,35569,35572,35573,35574,35577,35578,35583,355 84,35586,35588,35589,35590,35591,35595,35596,35597 ,35598,35600,35608,35610,35611,35612,35613,35618,3 5621,35622,35625,35634,35643,35645,35647,35648,356 49,35652,35655,35661,35665,35666,35668,35669,35670 ,35672,35673,35676,35677,35678,35681,35682,35686,3 5690,35691,35692,35697,35700,35701,35702,35703,357 05,35706,35707,35708,35930,35989,36049,36290,44810 ,45050,45109,45110,45170,45685))"
Визуально на работу не влияет, однако вызывает опасения. Разумного описания влёт не нашёл.
Как быть, куда смотреть? Это что-то ненормальное или можно смело забить и не напрягаться?
Comment