Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 76.73 KB | None | 0 0
  1. ubuntu@ip-172-31-38-34:~$ tail -n 100 -f /tmp/zabbix_server.log
  2. 1422:20180123:121003.957 server #22 started [unreachable poller #1]
  3. 1421:20180123:121003.958 server #21 started [poller #5]
  4. 1420:20180123:121003.959 server #20 started [poller #4]
  5. 1425:20180123:121003.963 server #25 started [trapper #3]
  6. 1424:20180123:121003.964 server #24 started [trapper #2]
  7. 1426:20180123:121003.965 server #26 started [trapper #4]
  8. 1427:20180123:121003.967 server #27 started [trapper #5]
  9. 1428:20180123:121003.968 server #28 started [icmp pinger #1]
  10. 1429:20180123:121003.968 server #29 started [alert manager #1]
  11. 1430:20180123:121003.974 server #30 started [preprocessing manager #1]
  12. 1431:20180123:121003.975 server #31 started [preprocessing worker #1]
  13. 1432:20180123:121003.978 server #32 started [preprocessing worker #2]
  14. 1433:20180123:121003.978 server #33 started [preprocessing worker #3]
  15. 1421:20180123:121004.461 Zabbix agent item "system.swap.size[,pfree]" on host "Zabbix server" failed: first network error, wait for 15 seconds
  16. 1412:20180123:121010.279 slow query: 3.456023 sec, "select clock,ns,value from history_uint where itemid=29753 and clock>1514347545 and clock<=1516731006"
  17. 1411:20180123:121012.924 slow query: 3.486103 sec, "select clock,ns,value from history where itemid=29514 and clock>1514346963 and clock<=1516731009"
  18. 1409:20180123:121013.031 slow query: 4.066016 sec, "select clock,ns,value from history where itemid=24011 and clock>1514346980 and clock<=1516731008"
  19. 1410:20180123:121018.740 slow query: 6.572639 sec, "select clock,ns,value from history_uint where itemid=29536 and clock>1514349046 and clock<=1516731012"
  20. 1422:20180123:121019.566 Zabbix agent item "system.cpu.util[,idle]" on host "Zabbix server" failed: another network error, wait for 15 seconds
  21. 1411:20180123:121023.607 slow query: 10.625530 sec, "select clock,ns,value from history_uint where itemid=29716 and clock>1514347271 and clock<=1516731012"
  22. 1410:20180123:121025.987 slow query: 7.244476 sec, "select clock,ns,value from history_uint where itemid=29611 and clock>1514349052 and clock<=1516731018"
  23. 1409:20180123:121032.536 slow query: 19.503633 sec, "select clock,ns,value from history where itemid=23999 and clock>1514346975 and clock<=1516731013"
  24. 1410:20180123:121032.853 slow query: 5.315166 sec, "select clock,ns,value from history_uint where itemid=29572 and clock>1514349047 and clock<=1516731027"
  25. 1422:20180123:121034.583 Zabbix agent item "system.cpu.switches" on host "Zabbix server" failed: another network error, wait for 15 seconds
  26. 1410:20180123:121037.808 slow query: 4.954565 sec, "select clock,ns,value from history_uint where itemid=29374 and clock>1514349050 and clock<=1516731032"
  27. 1410:20180123:121043.954 slow query: 4.633250 sec, "select clock,ns,value from history_uint where itemid=29599 and clock>1514349051 and clock<=1516731039"
  28. 1409:20180123:121046.857 slow query: 14.294783 sec, "select clock,ns,value from history where itemid=24006 and clock>1514346978 and clock<=1516731032"
  29. 1422:20180123:121049.600 temporarily disabling Zabbix agent checks on host "Zabbix server": host unavailable
  30. 1410:20180123:121052.741 slow query: 6.053986 sec, "select clock,ns,value from history_uint where itemid=29656 and clock>1514349054 and clock<=1516731046"
  31. 1410:20180123:121059.847 slow query: 6.413431 sec, "select clock,ns,value from history_uint where itemid=29691 and clock>1514349056 and clock<=1516731053"
  32. 1411:20180123:121103.373 slow query: 39.684807 sec, "select clock,ns,value from history_uint where itemid=29543 and clock>1514347265 and clock<=1516731023"
  33. 1410:20180123:121106.401 slow query: 6.552580 sec, "select clock,ns,value from history_uint where itemid=29404 and clock>1514349045 and clock<=1516731059"
  34. 1401:20180123:121107.710 slow query: 3.522676 sec, "select i.itemid,i.hostid,i.status,i.type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.trapper_hosts,i.logtimefmt,i.params,i.state,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,i.snmpv3_authprotocol,i.snmpv3_privprotocol,i.snmpv3_contextname,i.lastlogsize,i.mtime,i.history,i.trends,i.inventory_link,i.valuemapid,i.units,i.error,i.jmx_endpoint,i.master_itemid from items i,hosts h where i.hostid=h.hostid and h.status in (0,1) and i.flags<>2"
  35. 1410:20180123:121109.610 slow query: 3.207569 sec, "select clock,ns,value from history_uint where itemid=29601 and clock>1514349051 and clock<=1516731066"
  36. 1401:20180123:121111.737 slow query: 3.752487 sec, "select i.itemid,f.functionid,f.function,f.parameter,t.triggerid from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0,1) and t.flags<>2"
  37. 1410:20180123:121115.455 slow query: 5.820055 sec, "select clock,ns,value from history_uint where itemid=29586 and clock>1514349049 and clock<=1516731069"
  38. 1401:20180123:121118.922 slow query: 5.346350 sec, "select pp.item_preprocid,pp.itemid,pp.type,pp.params,pp.step from item_preproc pp,items i,hosts h where pp.itemid=i.itemid and i.hostid=h.hostid and h.status in (0,1) and i.flags<>2 order by pp.itemid"
  39. 1410:20180123:121121.121 slow query: 5.663842 sec, "select clock,ns,value from history_uint where itemid=29541 and clock>1514349046 and clock<=1516731075"
  40. 1410:20180123:121127.893 slow query: 6.771248 sec, "select clock,ns,value from history_uint where itemid=29662 and clock>1514349054 and clock<=1516731081"
  41. 1409:20180123:121131.271 slow query: 44.377587 sec, "select clock,ns,value from history_uint where itemid=23998 and clock>1514347275 and clock<=1516731046"
  42. 1410:20180123:121133.408 slow query: 5.512216 sec, "select clock,ns,value from history_uint where itemid=29571 and clock>1514349047 and clock<=1516731087"
  43. 1411:20180123:121133.692 slow query: 30.317653 sec, "select clock,ns,value from history where itemid=29545 and clock>1514346965 and clock<=1516731063"
  44. 1411:20180123:121140.137 slow query: 6.431365 sec, "select clock,ns,value from history_uint where itemid=29556 and clock>1514347265 and clock<=1516731093"
  45. 1410:20180123:121140.272 slow query: 5.082618 sec, "select clock,ns,value from history_uint where itemid=29616 and clock>1514349052 and clock<=1516731095"
  46. 1410:20180123:121144.962 slow query: 4.688017 sec, "select clock,ns,value from history_uint where itemid=29629 and clock>1514349053 and clock<=1516731100"
  47. 1411:20180123:121146.867 slow query: 6.727558 sec, "select clock,ns,value from history_uint where itemid=29526 and clock>1514347263 and clock<=1516731100"
  48. 1412:20180123:121147.613 slow query: 97.332303 sec, "select clock,ns,value from history where itemid=154655 and clock>1514347295 and clock<=1516731010"
  49. 1411:20180123:121152.213 slow query: 5.343626 sec, "select clock,ns,value from history_uint where itemid=29706 and clock>1514347264 and clock<=1516731106"
  50. 1410:20180123:121152.563 slow query: 4.529426 sec, "select clock,ns,value from history_uint where itemid=29377 and clock>1514349050 and clock<=1516731108"
  51. 1410:20180123:121157.753 slow query: 5.176392 sec, "select clock,ns,value from history_uint where itemid=29421 and clock>1514349046 and clock<=1516731112"
  52. 1410:20180123:121202.316 slow query: 4.561896 sec, "select clock,ns,value from history_uint where itemid=29602 and clock>1514349051 and clock<=1516731117"
  53. 1409:20180123:121204.816 slow query: 33.530050 sec, "select clock,ns,value from history_uint where itemid=24004 and clock>1514347278 and clock<=1516731091"
  54. 1410:20180123:121215.109 slow query: 5.680551 sec, "select clock,ns,value from history_uint where itemid=29676 and clock>1514349055 and clock<=1516731129"
  55. 1410:20180123:121222.723 slow query: 7.585572 sec, "insert into history_uint (itemid,clock,ns,value) values (32340,1514349056,995618913,0),(32328,1514349056,995618913,0),(32429,1514349056,995618913,0),(32344,1514349056,995618913,0),(32314,1514349056,995618913,0),(32436,1514349056,995618913,0),(32428,1514349056,995618913,0),(32330,1514349056,995618913,0),(32362,1514349056,995618913,0),(32422,1514349056,995618913,0),(32315,1514349056,995618913,0),(32468,1514349056,995618913,0),(32516,1514349057,995257730,0),(32520,1514349057,995257730,0),(32568,1514349057,995257730,0),(32515,1514349057,995257730,720608),(32583,1514349057,995257730,0),(32576,1514349057,995257730,0),(32563,1514349057,995257730,0),(29389,1514349057,995257730,38),(29392,1514349057,995257730,5),(29387,1514349057,995257730,1),(29386,1514349057,995257730,11513531),(29390,1514349057,995257730,58603316),(29391,1514349057,995257730,11513646),(32578,1514349057,995257730,0),(32574,1514349057,995257730,0),(32507,1514349057,995257730,0),(32580,1514349057,995257730,0),(32572,1514349057,995257730,6728),(32518,1514349057,995257730,0),(32531,1514349057,995257730,0),(32502,1514349057,995257730,4344),(32589,1514349057,995257730,0),(32584,1514349057,995257730,0),(32565,1514349057,995257730,0),(32570,1514349057,995257730,0),(32590,1514349057,995257730,0),(32564,1514349057,995257730,0),(32587,1514349057,995257730,0),(32577,1514349057,995257730,0),(32582,1514349057,995257730,0),(32579,1514349057,995257730,11504),(32505,1514349057,995257730,0),(32529,1514349057,995257730,0),(32591,1514349057,995257730,0),(32508,1514349057,995257730,0),(32504,1514349057,995257730,0),(32588,1514349057,995257730,0),(32522,1514349057,995257730,0),(32569,1514349057,995257730,19824),(32512,1514349057,995257730,168),(32530,1514349057,995257730,0),(32567,1514349057,995257730,0),(32575,1514349057,995257730,13976),(32521,1514349057,995257730,0),(32519,1514349057,995257730,12769320),(32513,1514349057,995257730,0),(32509,1514349057,995257730,1576),(32514,1514349057,995257730,0),(32585,1514349057,995257730,0),(32510,1514349057,995257730,0),(32528,1514349057,995257730,0),(32526,1514349057,995257730,32752),(32511,1514349057,995257730,168),(32562,1514349057,995257730,48),(32525,1514349057,995257730,0),(32517,1514349057,995257730,0),(32566,1514349057,995257730,0),(32573,1514349057,995257730,0),(32524,1514349057,995257730,0),(32503,1514349057,995257730,0),(32506,1514349057,995257730,0),(32581,1514349057,995257730,0),(32527,1514349057,995257730,0),(32571,1514349057,995257730,6728),(32523,1514349057,995257730,0),(32696,1514349059,70329322,0),(32794,1514349059,70329322,0),(32752,1514349059,70329322,0),(32779,1514349059,70329322,0),(29436,1514349059,70329322,8262041),(32758,1514349059,70329322,0),(32648,1514349059,70329322,0),(32671,1514349059,70329322,0),(32673,1514349059,70329322,0),(32668,1514349059,70329322,0),(32678,1514349059,70329322,0),(32656,1514349059,70329322,0),(32796,1514349059,70329322,0),(32775,1514349059,70329322,0),(32803,1514349059,70329322,704),(32693,1514349059,70329322,0),(32669,1514349059,70329322,0),(32801,1514349059,70329322,0),(32697,1514349059,70329322,5504),(32651,1514349059,70329322,0),(32767,1514349059,70329322,0),(32686,1514349059,70329322,0),(32771,1514349059,70329322,0),(32795,1514349059,70329322,0),(32653,1514349059,70329322,0),(32660,1514349059,70329322,0),(32777,1514349059,70329322,0),(32661,1514349059,70329322,0),(32688,1514349059,70329322,0),(32788,1514349059,70329322,0),(32683,1514349059,70329322,0),(32692,1514349059,70329322,16130736),(32797,1514349059,70329322,16129896),(32663,1514349059,70329322,0),(32650,1514349059,70329322,0),(32757,1514349059,70329322,0),(32647,1514349059,70329322,0),(32791,1514349059,70329322,0),(32664,1514349059,70329322,0),(32776,1514349059,70329322,0),(32764,1514349059,70329322,0),(32687,1514349059,70329322,0),(32665,1514349059,70329322,0),(32789,1514349059,70329322,0),(32787,1514349059,70329322,0),(32802,1514349059,70329322,0),(32657,1514349059,70329322,0),(32799,1514349059,70329322,0),(32768,1514349059,70329322,0),(32672,1514349059,70329322,0),(32695,1514349059,70329322,0),(32783,1514349059,70329322,0),(32753,1514349059,70329322,0),(32654,1514349059,70329322,0),(32800,1514349059,70329322,0),(32765,1514349059,70329322,0),(32782,1514349059,70329322,0),(32798,1514349059,70329322,106176),(32670,1514349059,70329322,0),(32769,1514349059,70329322,0),(32658,1514349059,70329322,0),(32780,1514349059,70329322,0),(32751,1514349059,70329322,0),(32666,1514349059,70329322,0),(32646,1514349059,70329322,0),(32689,1514349059,70329322,0),(32690,1514349059,70329322,0),(32793,1514349059,70329322,0),(32781,1514349059,70329322,0),(32760,1514349059,70329322,0),(32645,1514349059,70329322,0),(32759,1514349059,70329322,0),(32790,1514349059,70329322,0),(32754,1514349059,70329322,0),(32675,1514349059,70329322,0),(32680,1514349059,70329322,0),(32677,1514349059,70329322,0),(32682,1514349059,70329322,0),(32662,1514349059,70329322,0),(32652,1514349059,70329322,0),(32786,1514349059,70329322,0),(32778,1514349059,70329322,0),(32756,1514349059,70329322,0),(32674,1514349059,70329322,0),(32763,1514349059,70329322,0),(32681,1514349059,70329322,0),(32676,1514349059,70329322,0),(32755,1514349059,70329322,0),(32659,1514349059,70329322,0),(32667,1514349059,70329322,0),(32694,1514349059,70329322,0),(32762,1514349059,70329322,0),(32649,1514349059,70329322,0),(32784,1514349059,70329322,0),(32691,1514349059,70329322,106784),(32774,1514349059,70329322,0),(32679,1514349059,70329322,0),(32655,1514349059,70329322,56),(32770,1514349059,70329322,0),(32685,1514349059,70329322,0),(32684,1514349059,70329322,0),(32792,1514349059,70329322,0),(32772,1514349059,70329322,0),(32773,1514349059,70329322,0),(32785,1514349059,70329322,0),(32766,1514349059,70329322,0),(32761,1514349059,70329322,6432),(32862,1514349060,69869883,0),(32915,1514349060,69869883,14008),(32842,1514349060,69869883,0),(32849,1514349060,69869883,615104),(29447,1514349060,69869883,1),(29451,1514349060,69869883,8261967),(29449,1514349060,69869883,43),(29446,1514349060,69869883,8258172),(29452,1514349060,69869883,6),(29450,1514349060,69869883,58570736),(32854,1514349060,69869883,0),(32918,1514349060,69869883,16121464),(32901,1514349060,69869883,0),(32845,1514349060,69869883,168),(32907,1514349060,69869883,14024),(32900,1514349060,69869883,14624),(32898,1514349060,69869883,26608),(32894,1514349060,69869883,40),(32835,1514349060,69869883,168),(32921,1514349060,69869883,0),(32861,1514349060,69869883,0),(32834,1514349060,69869883,4304),(32917,1514349060,69869883,0),(32855,1514349060,69869883,637672),(32895,1514349060,69869883,6728),(32852,1514349060,69869883,8360),(32843,1514349060,69869883,0),(32914,1514349060,69869883,0),(32850,1514349060,69869883,744872),(32904,1514349060,69869883,0),(32857,1514349060,69869883,0),(32911,1514349060,69869883,0),(32896,1514349060,69869883,6208),(32844,1514349060,69869883,0),(32847,1514349060,69869883,719672),(32916,1514349060,69869883,0),(32840,1514349060,69869883,12778208),(32839,1514349060,69869883,0),(32838,1514349060,69869883,5480),(32906,1514349060,69869883,0),(32841,1514349060,69869883,0),(32903,1514349060,69869883,0),(32860,1514349060,69869883,0),(32897,1514349060,69869883,6728),(32899,1514349060,69869883,0),(32858,1514349060,69869883,106040),(32853,1514349060,69869883,864),(32922,1514349060,69869883,0),(32848,1514349060,69869883,609720),(32856,1514349060,69869883,0),(32920,1514349060,69869883,0),(32909,1514349060,69869883,13968),(32908,1514349060,69869883,14000),(32902,1514349060,69869883,0),(32837,1514349060,69869883,168),(32912,1514349060,69869883,28176),(32836,1514349060,69869883,784),(32923,1514349060,69869883,0),(32859,1514349060,69869883,0),(32846,1514349060,69869883,0),(32919,1514349060,69869883,0),(32905,1514349060,69869883,6728),(32910,1514349060,69869883,14016),(32851,1514349060,69869883,0),(32913,1514349060,69869883,19800),(32863,1514349060,69869883,0),(29481,1514349061,107555245,466585),(29476,1514349061,107555245,466469),(29477,1514349061,107555245,1),(29482,1514349061,107555245,6),(29479,1514349061,107555245,36),(33047,1514349061,107555245,0),(33041,1514349061,107555245,43880),(33023,1514349061,107555245,0),(32964,1514349061,107555245,0),(32976,1514349061,107555245,864),(32960,1514349061,107555245,0),(32965,1514349061,107555245,0),(32971,1514349061,107555245,0),(33037,1514349061,107555245,0),(32969,1514349061,107555245,0),(32984,1514349061,107555245,142664),(32966,1514349061,107555245,0),(32980,1514349061,107555245,104),(33026,1514349061,107555245,0),(32982,1514349061,107555245,0),(32959,1514349061,107555245,1312),(33020,1514349061,107555245,0),(33024,1514349061,107555245,0),(33035,1514349061,107555245,0),(32983,1514349061,107555245,0),(32967,1514349061,107555245,168),(32974,1514349061,107555245,0),(32961,1514349061,107555245,0),(33040,1514349061,107555245,0),(33017,1514349061,107555245,40),(32963,1514349061,107555245,0),(33021,1514349061,107555245,19464),(33030,1514349061,107555245,6704),(33045,1514349061,107555245,0),(33042,1514349061,107555245,35984),(32985,1514349061,107555245,0),(32962,1514349061,107555245,0),(33029,1514349061,107555245,6704),(32979,1514349061,107555245,1426248),(32975,1514349061,107555245,0),(32970,1514349061,107555245,0),(33036,1514349061,107555245,0),(32978,1514349061,107555245,0),(33034,1514349061,107555245,0),(33022,1514349061,107555245,0),(33028,1514349061,107555245,0),(33046,1514349061,107555245,2057880),(33019,1514349061,107555245,0),(32968,1514349061,107555245,168),(33031,1514349061,107555245,0),(33033,1514349061,107555245,0),(32981,1514349061,107555245,0),(32958,1514349061,107555245,0),(32977,1514349061,107555245,629528),(32973,1514349061,107555245,0),(33038,1514349061,107555245,19464),(32972,1514349061,107555245,0),(33043,1514349061,107555245,0),(33027,1514349061,107555245,0),(33032,1514349061,107555245,0),(32957,1514349061,107555245,0),(33039,1514349061,107555245,66448),(32956,1514349061,107555245,0),(33018,1514349061,107555245,0),(32955,1514349061,107555245,4344),(33025,1514349061,107555245,0),(33044,1514349061,107555245,0),(33143,1514349062,122920773,0),(33082,1514349062,122920773,0),(33096,1514349062,122920773,620472),(33170,1514349062,122920773,0),(33097,1514349062,122920773,0),(33084,1514349062,122920773,0),(33100,1514349062,122920773,0),(33157,1514349062,122920773,0),(33155,1514349062,122920773,21368),(33089,1514349062,122920773,168),(33144,1514349062,122920773,0),(33085,1514349062,122920773,0),(33088,1514349062,122920773,0),(33107,1514349062,122920773,0),(33152,1514349062,122920773,0),(33142,1514349062,122920773,0),(33102,1514349062,122920773,0),(33099,1514349062,122920773,0),(33101,1514349062,122920773,0),(33164,1514349062,122920773,0),(33163,1514349062,122920773,0),(33105,1514349062,122920773,0),(33079,1514349062,122920773,4328),(33167,1514349062,122920773,0),(33158,1514349062,122920773,31232),(33103,1514349062,122920773,0),(33149,1514349062,122920773,0),(33080,1514349062,122920773,0),(33106,1514349062,122920773,0),(33160,1514349062,122920773,0),(33156,1514349062,122920773,0),(33162,1514349062,122920773,0),(33094,1514349062,122920773,0),(33093,1514349062,122920773,3728),(33165,1514349062,122920773,0),(33090,1514349062,122920773,0),(33154,1514349062,122920773,0),(33169,1514349062,122920773,0),(33171,1514349062,122920773,0),(33166,1514349062,122920773,629456),(33109,1514349062,122920773,0),(33153,1514349062,122920773,26112),(33087,1514349062,122920773,0),(33108,1514349062,122920773,0),(33147,1514349062,122920773,0),(33092,1514349062,122920773,0),(33146,1514349062,122920773,0),(33161,1514349062,122920773,0),(33168,1514349062,122920773,0),(33151,1514349062,122920773,6696),(33098,1514349062,122920773,0),(33081,1514349062,122920773,0),(33095,1514349062,122920773,0),(33083,1514349062,122920773,0),(33086,1514349062,122920773,0),(33141,1514349062,122920773,40),(33145,1514349062,122920773,0),(33148,1514349062,122920773,0),(33159,1514349062,122920773,0),(33150,1514349062,122920773,0),(33104,1514349062,122920773,66424),(33091,1514349062,122920773,5280),(33252,1514349063,207977915,8),(33371,1514349063,207977915,0),(33331,1514349063,207977915,0),(33262,1514349063,207977915,0),(33343,1514349063,207977915,0),(33273,1514349063,207977915,0),(33266,1514349063,207977915,0),(33373,1514349063,207977915,43800),(33255,1514349063,207977915,0),(33356,1514349063,207977915,0),(33236,1514349063,207977915,0),(33354,1514349063,207977915,0),(33342,1514349063,207977915,0),(33353,1514349063,207977915,0),(33370,1514349063,207977915,0),(33368,1514349063,207977915,0),(33357,1514349063,207977915,0),(33225,1514349063,207977915,0),(33264,1514349063,207977915,0),(33336,1514349063,207977915,0),(33259,1514349063,207977915,0),(33376,1514349063,207977915,0),(33228,1514349063,207977915,0),(33277,1514349063,207977915,22432),(33272,1514349063,207977915,43920),(33238,1514349063,207977915,0),(33232,1514349063,207977915,0),(33237,1514349063,207977915,0),(33341,1514349063,207977915,0),(33249,1514349063,207977915,0),(33365,1514349063,207977915,0),(33227,1514349063,207977915,0),(33268,1514349063,207977915,0),(33247,1514349063,207977915,0),(33257,1514349063,207977915,0),(33276,1514349063,207977915,0),(33375,1514349063,207977915,0),(33361,1514349063,207977915,0),(33340,1514349063,207977915,0),(33243,1514349063,207977915,0),(33244,1514349063,207977915,0),(33258,1514349063,207977915,0),(33352,1514349063,207977915,0),(33241,1514349063,207977915,0),(33337,1514349063,207977915,0),(33260,1514349063,207977915,0),(33348,1514349063,207977915,0),(33382,1514349063,207977915,0),(33349,1514349063,207977915,0),(33377,1514349063,207977915,0),(33246,1514349063,207977915,0),(33335,1514349063,207977915,0),(33332,1514349063,207977915,0),(33339,1514349063,207977915,0),(33274,1514349063,207977915,0),(33333,1514349063,207977915,0),(33359,1514349063,207977915,0),(33380,1514349063,207977915,0),(33254,1514349063,207977915,0),(33251,1514349063,207977915,0),(33378,1514349063,207977915,1427528),(33267,1514349063,207977915,1427408),(33351,1514349063,207977915,0),(33374,1514349063,207977915,0),(33270,1514349063,207977915,0),(33229,1514349063,207977915,0),(33256,1514349063,207977915,0),(33381,1514349063,207977915,0),(33344,1514349063,207977915,0),(33269,1514349063,207977915,0),(33234,1514349063,207977915,0),(33231,1514349063,207977915,0),(33372,1514349063,207977915,0),(33338,1514349063,207977915,0),(33379,1514349063,207977915,0),(33360,1514349063,207977915,0),(33367,1514349063,207977915,0),(33346,1514349063,207977915,0),(33235,1514349063,207977915,0),(33364,1514349063,207977915,0),(33230,1514349063,207977915,0),(33366,1514349063,207977915,0),(33369,1514349063,207977915,0),(33347,1514349063,207977915,0),(33350,1514349063,207977915,0),(33355,1514349063,207977915,0),(33240,1514349063,207977915,0),(33250,1514349063,207977915,0),(33233,1514349063,207977915,0),(33363,1514349063,207977915,0),(33263,1514349063,207977915,0),(33345,1514349063,207977915,0),(33242,1514349063,207977915,0),(33358,1514349063,207977915,23656),(33265,1514349063,207977915,0),(33383,1514349063,207977915,704),(33362,1514349063,207977915,0),(33271,1514349063,207977915,0),(33248,1514349063,207977915,0),(33275,1514349063,207977915,0),(33261,1514349063,207977915,0),(33239,1514349063,207977915,0),(33334,1514349063,207977915,0),(33245,1514349063,207977915,0),(33253,1514349063,207977915,0),(33226,1514349063,207977915,0),(33567,1514349064,222983327,0),(33464,1514349064,222983327,0),(33466,1514349064,222983327,0),(33440,1514349064,222983327,0),(33474,1514349064,222983327,0),(33460,1514349064,222983327,0),(33547,1514349064,222983327,0),(33454,1514349064,222983327,0),(33481,1514349064,222983327,0),(33569,1514349064,222983327,0),(33487,1514349064,222983327,0),(33457,1514349064,222983327,0),(33470,1514349064,222983327,0),(33562,1514349064,222983327,0),(33584,1514349064,222983327,0),(33576,1514349064,222983327,0),(33589,1514349064,222983327,0),(33585,1514349064,222983327,0),(33446,1514349064,222983327,0),(33459,1514349064,222983327,0),(33480,1514349064,222983327,0),(33452,1514349064,222983327,0),(33573,1514349064,222983327,0),(33467,1514349064,222983327,0),(33587,1514349064,222983327,0),(33448,1514349064,222983327,0),(33588,1514349064,222983327,0),(33581,1514349064,222983327,0),(33594,1514349064,222983327,0),(33455,1514349064,222983327,0),(33559,1514349064,222983327,0),(33442,1514349064,222983327,0),(33555,1514349064,222983327,0),(33463,1514349064,222983327,0),(33571,1514349064,222983327,0),(33546,1514349064,222983327,0),(33447,1514349064,222983327,0),(33486,1514349064,222983327,0),(33554,1514349064,222983327,0),(33484,1514349064,222983327,35960),(33476,1514349064,222983327,0),(33583,1514349064,222983327,0),(33483,1514349064,222983327,0),(33564,1514349064,222983327,0),(33489,1514349064,222983327,5696),(33438,1514349064,222983327,0),(33468,1514349064,222983327,0),(33593,1514349064,222983327,0),(33458,1514349064,222983327,0),(33590,1514349064,222983327,104),(33557,1514349064,222983327,0),(33478,1514349064,222983327,0),(33545,1514349064,222983327,0),(33473,1514349064,222983327,0),(33451,1514349064,222983327,0),(33439,1514349064,222983327,0),(33477,1514349064,222983327,0),(33485,1514349064,222983327,0),(33556,1514349064,222983327,0),(33552,1514349064,222983327,0),(33582,1514349064,222983327,0),(33462,1514349064,222983327,0),(33437,1514349064,222983327,0),(33578,1514349064,222983327,0),(33449,1514349064,222983327,0),(33579,1514349064,222983327,0),(33445,1514349064,222983327,0),(33443,1514349064,222983327,0),(33456,1514349064,222983327,0),(33543,1514349064,222983327,0),(33577,1514349064,222983327,0),(33482,1514349064,222983327,0),(33575,1514349064,222983327,0),(33558,1514349064,222983327,0),(33563,1514349064,222983327,0),(33560,1514349064,222983327,0),(33561,1514349064,222983327,0),(33544,1514349064,222983327,0),(33444,1514349064,222983327,0),(33488,1514349064,222983327,0),(33441,1514349064,222983327,0),(33572,1514349064,222983327,0),(33595,1514349064,222983327,104),(33580,1514349064,222983327,0),(33472,1514349064,222983327,0),(33479,1514349064,222983327,0),(33592,1514349064,222983327,0),(33453,1514349064,222983327,0),(33548,1514349064,222983327,0),(33450,1514349064,222983327,0),(33586,1514349064,222983327,0),(33461,1514349064,222983327,0),(33551,1514349064,222983327,0),(33591,1514349064,222983327,0),(33465,1514349064,222983327,0),(33471,1514349064,222983327,0),(33565,1514349064,222983327,0),(33550,1514349064,222983327,0),(33574,1514349064,222983327,0),(33570,1514349064,222983327,0),(33568,1514349064,222983327,0),(33566,1514349064,222983327,0),(33553,1514349064,222983327,0),(33469,1514349064,222983327,0),(33549,1514349064,222983327,0),(33475,1514349064,222983327,0),(33628,1514349065,228572100,16132600),(33689,1514349065,228572100,0),(33678,1514349065,228572100,0),(33677,1514349065,228572100,0),(33646,1514349065,228572100,6296),(33626,1514349065,228572100,0),(33630,1514349065,228572100,13500368),(33674,1514349065,228572100,66120),(33693,1514349065,228572100,0),(33699,1514349065,228572100,0),(33623,1514349065,228572100,0),(33625,1514349065,228572100,0),(33642,1514349065,228572100,0),(33631,1514349065,228572100,0),(33681,1514349065,228572100,0),(33692,1514349065,228572100,0),(33643,1514349065,228572100,0),(33694,1514349065,228572100,0),(33627,1514349065,228572100,0),(33640,1514349065,228572100,0),(33637,1514349065,228572100,0),(33675,1514349065,228572100,0),(33634,1514349065,228572100,0),(33636,1514349065,228572100,0),(33691,1514349065,228572100,0),(33676,1514349065,228572100,140560),(33622,1514349065,228572100,10792),(33690,1514349065,228572100,0),(33638,1514349065,228572100,0),(33635,1514349065,228572100,0),(33696,1514349065,228572100,0),(33639,1514349065,228572100,0),(33683,1514349065,228572100,0),(33688,1514349065,228572100,0),(33684,1514349065,228572100,0),(33647,1514349065,228572100,0),(33629,1514349065,228572100,0),(33632,1514349065,228572100,0),(33680,1514349065,228572100,106616),(33645,1514349065,228572100,337888),(33685,1514349065,228572100,0),(33687,1514349065,228572100,0),(33686,1514349065,228572100,0),(33698,1514349065,228572100,3696),(33695,1514349065,228572100,0),(33633,1514349065,228572100,0),(33641,1514349065,228572100,0),(33682,1514349065,228572100,33480),(33679,1514349065,228572100,0),(33644,1514349065,228572100,0),(33817,1514349071,357379401,31925728),(33741,1514349071,357379401,0),(33814,1514349071,357379401,2317712),(33739,1514349071,357379401,0),(33731,1514349071,357379401,0),(33803,1514349071,357379401,0),(33794,1514349071,357379401,0),(33730,1514349071,357379401,4336),(33749,1514349071,357379401,0),(33759,1514349071,357379401,0),(33800,1514349071,357379401,6536),(33733,1514349071,357379401,168),(33810,1514349071,357379401,6712),(33811,1514349071,357379401,20464),(33793,1514349071,357379401,6712),(33796,1514349071,357379401,6536),(33753,1514349071,357379401,0),(33744,1514349071,357379401,0),(33815,1514349071,357379401,0),(33735,1514349071,357379401,168),(33750,1514349071,357379401,168),(33809,1514349071,357379401,6536),(33797,1514349071,357379401,0),(33790,1514349071,357379401,40),(33795,1514349071,357379401,6712),(33748,1514349071,357379401,0),(33746,1514349071,357379401,1720),(33754,1514349071,357379401,2088752),(33736,1514349071,357379401,0),(33747,1514349071,357379401,9520),(33734,1514349071,357379401,0),(33755,1514349071,357379401,0),(33756,1514349071,357379401,0),(33792,1514349071,357379401,0),(33816,1514349071,357379401,0),(33745,1514349071,357379401,160),(33732,1514349071,357379401,0),(33758,1514349071,357379401,0),(33743,1514349071,357379401,0),(33802,1514349071,357379401,6712),(33740,1514349071,357379401,0),(33813,1514349071,357379401,0),(33791,1514349071,357379401,0),(33819,1514349071,357379401,0),(33742,1514349071,357379401,168),(33807,1514349071,357379401,32608),(33751,1514349071,357379401,2232),(33798,1514349071,357379401,0),(33804,1514349071,357379401,0),(33805,1514349071,357379401,6696),(33806,1514349071,357379401,20040),(33808,1514349071,357379401,0),(33757,1514349071,357379401,2404696),(33738,1514349071,357379401,0),(33801,1514349071,357379401,0),(33818,1514349071,357379401,0),(33812,1514349071,357379401,85240),(33799,1514349071,357379401,0),(33737,1514349071,357379401,0),(33886,1514349072,430072002,0),(34004,1514349072,430072002,0),(33910,1514349072,430072002,0),(34009,1514349072,430072002,0),(33906,1514349072,430072002,40),(33883,1514349072,430072002,29805048),(34017,1514349072,430072002,0),(33991,1514349072,430072002,0),(33894,1514349072,430072002,0),(33989,1514349072,430072002,55912),(34010,1514349072,430072002,0),(33998,1514349072,430072002,0),(33905,1514349072,430072002,0),(33993,1514349072,430072002,23496),(33921,1514349072,430072002,0),(33985,1514349072,430072002,0),(33879,1514349072,430072002,0),(34029,1514349072,430072002,0),(33898,1514349072,430072002,0),(33923,1514349072,430072002,0),(34022,1514349072,430072002,0),(33903,1514349072,430072002,0),(33896,1514349072,430072002,0),(33880,1514349072,430072002,0),(34027,1514349072,430072002,0),(33984,1514349072,430072002,0),(34015,1514349072,430072002,0),(33907,1514349072,430072002,0),(34031,1514349072,430072002,1024),(33888,1514349072,430072002,0),(33915,1514349072,430072002,0),(33916,1514349072,430072002,0),(33874,1514349072,430072002,0),(33875,1514349072,430072002,0),(34016,1514349072,430072002,0),(33885,1514349072,430072002,0),(33918,1514349072,430072002,0),(33988,1514349072,430072002,0),(34018,1514349072,430072002,0),(34003,1514349072,430072002,0),(33914,1514349072,430072002,0),(33909,1514349072,430072002,0),(34020,1514349072,430072002,0),(33987,1514349072,430072002,0),(33912,1514349072,430072002,0),(33881,1514349072,430072002,0),(34008,1514349072,430072002,0),(34011,1514349072,430072002,0),(33895,1514349072,430072002,0),(33979,1514349072,430072002,0),(33904,1514349072,430072002,0),(33919,1514349072,430072002,0),(33986,1514349072,430072002,0),(34028,1514349072,430072002,0),(33901,1514349072,430072002,0),(33996,1514349072,430072002,0),(34021,1514349072,430072002,0),(33997,1514349072,430072002,0),(33882,1514349072,430072002,0),(34025,1514349072,430072002,0),(33897,1514349072,430072002,0),(33887,1514349072,430072002,56),(34007,1514349072,430072002,0),(34001,1514349072,430072002,0),(34019,1514349072,430072002,0),(34013,1514349072,430072002,0),(33900,1514349072,430072002,0),(33878,1514349072,430072002,0),(34002,1514349072,430072002,0),(34005,1514349072,430072002,0),(33891,1514349072,430072002,0),(33982,1514349072,430072002,0),(33893,1514349072,430072002,0),(33920,1514349072,430072002,85112),(33899,1514349072,430072002,0),(33992,1514349072,430072002,0),(34012,1514349072,430072002,23440),(33980,1514349072,430072002,0),(34023,1514349072,430072002,0),(34000,1514349072,430072002,0),(34030,1514349072,430072002,0),(33876,1514349072,430072002,0),(33999,1514349072,430072002,0),(33873,1514349072,430072002,0),(33884,1514349072,430072002,0),(34006,1514349072,430072002,0),(33995,1514349072,430072002,0),(33877,1514349072,430072002,0),(33889,1514349072,430072002,0),(33908,1514349072,430072002,0),(33924,1514349072,430072002,0),(34014,1514349072,430072002,0),(33892,1514349072,430072002,0),(33983,1514349072,430072002,0),(33990,1514349072,430072002,0),(33917,1514349072,430072002,0),(33902,1514349072,430072002,0),(33890,1514349072,430072002,0),(33925,1514349072,430072002,22440),(33922,1514349072,430072002,0),(33994,1514349072,430072002,0),(34024,1514349072,430072002,0),(33913,1514349072,430072002,0),(33981,1514349072,430072002,0),(33911,1514349072,430072002,0),(34138,1514349073,550266211,30960),(34136,1514349073,550266211,0),(34086,1514349073,550266211,2318160),(34141,1514349073,550266211,0),(34077,1514349073,550266211,0),(34074,1514349073,550266211,52464),(34080,1514349073,550266211,743496),(34063,1514349073,550266211,0),(34061,1514349073,550266211,0),(34075,1514349073,550266211,0),(34082,1514349073,550266211,650544),(34084,1514349073,550266211,629464),(34122,1514349073,550266211,0),(34139,1514349073,550266211,0),(34135,1514349073,550266211,0),(34120,1514349073,550266211,0),(34142,1514349073,550266211,30944),(34130,1514349073,550266211,0),(34069,1514349073,550266211,0),(34087,1514349073,550266211,0),(34146,1514349073,550266211,0),(34128,1514349073,550266211,0),(34140,1514349073,550266211,30912),(34065,1514349073,550266211,0),(34079,1514349073,550266211,0),(34124,1514349073,550266211,0),(34068,1514349073,550266211,168),(34076,1514349073,550266211,0),(34072,1514349073,550266211,0),(34145,1514349073,550266211,0),(34134,1514349073,550266211,0),(34125,1514349073,550266211,0),(34126,1514349073,550266211,7032),(34137,1514349073,550266211,0),(34085,1514349073,550266211,0),(34127,1514349073,550266211,0),(34081,1514349073,550266211,0),(34071,1514349073,550266211,0),(34121,1514349073,550266211,0),(34062,1514349073,550266211,0),(34083,1514349073,550266211,0),(34088,1514349073,550266211,0),(34129,1514349073,550266211,0),(34132,1514349073,550266211,2249352),(34144,1514349073,550266211,2088840),(34066,1514349073,550266211,0),(34070,1514349073,550266211,0),(34067,1514349073,550266211,0),(34119,1514349073,550266211,0),(34064,1514349073,550266211,0),(34143,1514349073,550266211,0),(34131,1514349073,550266211,0),(34073,1514349073,550266211,0),(34147,1514349073,550266211,0),(34133,1514349073,550266211,0),(34078,1514349073,550266211,0),(34089,1514349073,550266211,0),(34123,1514349073,550266211,0),(34167,1514349083,483867363,0),(34164,1514349083,483867363,0),(34182,1514349083,483867363,0),(34166,1514349083,483867363,4396168),(34163,1514349083,483867363,0),(34185,1514349083,483867363,0),(34183,1514349083,483867363,0),(34178,1514349083,483867363,6676680),(34184,1514349083,483867363,0),(34158,1514349083,483867363,4552992),(34187,1514349083,483867363,0),(34161,1514349083,483867363,48),(34186,1514349083,483867363,2276552),(34179,1514349083,483867363,125440),(34180,1514349083,483867363,46104),(34165,1514349083,483867363,0),(34181,1514349083,483867363,0),(34159,1514349083,483867363,2164424),(34162,1514349083,483867363,0),(34160,1514349083,483867363,72728),(34215,1514349087,507909812,12108920),(34201,1514349087,507909812,0),(34221,1514349087,507909812,0),(34222,1514349087,507909812,0),(34220,1514349087,507909812,0),(34205,1514349087,507909812,0),(34199,1514349087,507909812,0),(34219,1514349087,507909812,0),(34216,1514349087,507909812,0),(34202,1514349087,507909812,0),(34223,1514349087,507909812,0),(34217,1514349087,507909812,0),(34200,1514349087,507909812,0),(34204,1514349087,507909812,0),(34218,1514349087,507909812,0),(34198,1514349087,507909812,0),(34203,1514349087,507909812,0),(30186,1514349642,602712071,40),(30260,1514349642,602712071,0),(30264,1514349642,602712071,0),(30181,1514349642,602712071,104),(30192,1514349642,602712071,0),(30273,1514349642,602712071,0),(30268,1514349642,602712071,0),(30246,1514349642,602712071,0),(30198,1514349642,602712071,618640),(30206,1514349642,602712071,555432),(30244,1514349642,602712071,32),(30185,1514349642,602712071,384),(30196,1514349642,602712071,0),(30265,1514349642,602712071,0),(30195,1514349642,602712071,0),(30263,1514349642,602712071,0),(30204,1514349642,602712071,0),(30267,1514349642,602712071,0),(30251,1514349642,602712071,0),(30184,1514349642,602712071,19512),(30248,1514349642,602712071,16976),(30249,1514349642,602712071,7680),(30261,1514349642,602712071,34248),(30255,1514349642,602712071,0),(30182,1514349642,602712071,0),(30271,1514349642,602712071,0),(30197,1514349642,602712071,12776),(30183,1514349642,602712071,2879800),(30245,1514349642,602712071,8),(30258,1514349642,602712071,6920),(30274,1514349642,602712071,0),(30205,1514349642,602712071,200),(30256,1514349642,602712071,0),(30193,1514349642,602712071,16),(30210,1514349642,602712071,0),(30254,1514349642,602712071,0),(30208,1514349642,602712071,0),(30252,1514349642,602712071,0),(30247,1514349642,602712071,155032),(30202,1514349642,602712071,134488),(30190,1514349642,602712071,0),(30203,1514349642,602712071,0),(30266,1514349642,602712071,28608),(30201,1514349642,602712071,0),(30200,1514349642,602712071,0),(30194,1514349642,602712071,0),(30199,1514349642,602712071,0),(30180,1514349642,602712071,4584),(30191,1514349642,602712071,0),(30270,1514349642,602712071,3684848),(30262,1514349642,602712071,347528),(30211,1514349642,602712071,0),(30253,1514349642,602712071,0),(30275,1514349642,602712071,0),(30259,1514349642,602712071,0),(30187,1514349642,602712071,0),(30269,1514349642,602712071,6744),(30207,1514349642,602712071,0),(30209,1514349642,602712071,0),(30188,1514349642,602712071,0),(30257,1514349642,602712071,6928),(30189,1514349642,602712071,0),(30272,1514349642,602712071,0),(30250,1514349642,602712071,6944),(30306,1514349643,624601244,0),(30308,1514349643,624601244,0),(30310,1514349643,624601244,804968),(30360,1514349643,624601244,0),(30307,1514349643,624601244,0),(30382,1514349643,624601244,0),(30326,1514349643,624601244,0),(30361,1514349643,624601244,0),(30325,1514349643,624601244,0),(30378,1514349643,624601244,0),(30305,1514349643,624601244,0),(30387,1514349643,624601244,0),(30321,1514349643,624601244,0),(30324,1514349643,624601244,0),(30369,1514349643,624601244,17744),(30376,1514349643,624601244,782488),(30330,1514349643,624601244,0),(30312,1514349643,624601244,0),(30316,1514349643,624601244,0),(30379,1514349643,624601244,0),(30367,1514349643,624601244,29552),(30370,1514349643,624601244,0),(30311,1514349643,624601244,10312),(30373,1514349643,624601244,0),(30309,1514349643,624601244,0),(30380,1514349643,624601244,0),(30363,1514349643,624601244,10552);
  56. "
  57. 1401:20180123:121222.855 slow query: 3.667851 sec, "select i.itemid,i.hostid,i.status,i.type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.trapper_hosts,i.logtimefmt,i.params,i.state,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,i.snmpv3_authprotocol,i.snmpv3_privprotocol,i.snmpv3_contextname,i.lastlogsize,i.mtime,i.history,i.trends,i.inventory_link,i.valuemapid,i.units,i.error,i.jmx_endpoint,i.master_itemid from items i,hosts h where i.hostid=h.hostid and h.status in (0,1) and i.flags<>2"
  58. 1412:20180123:121227.739 slow query: 40.090914 sec, "select clock,ns,value from history_uint where itemid=29363 and clock>1514347551 and clock<=1516731107"
  59. 1411:20180123:121229.677 slow query: 37.463724 sec, "select clock,ns,value from history where itemid=29469 and clock>1514346961 and clock<=1516731112"
  60. 1401:20180123:121230.181 slow query: 3.106856 sec, "select pp.item_preprocid,pp.itemid,pp.type,pp.params,pp.step from item_preproc pp,items i,hosts h where pp.itemid=i.itemid and i.hostid=h.hostid and h.status in (0,1) and i.flags<>2 order by pp.itemid"
  61. 1410:20180123:121231.120 slow query: 8.394146 sec, "select clock,ns,value from history_uint where itemid=29436 and clock>1514349059 and clock<=1516731142"
  62. 1409:20180123:121231.896 slow query: 27.078459 sec, "select clock,ns,value from history where itemid=24008 and clock>1514346978 and clock<=1516731124"
  63. 1411:20180123:121235.709 slow query: 6.030601 sec, "select clock,ns,value from history_uint where itemid=29722 and clock>1514347271 and clock<=1516731149"
  64. 1410:20180123:121236.849 slow query: 5.726598 sec, "select clock,ns,value from history_uint where itemid=29386 and clock>1514349057 and clock<=1516731151"
  65. 1410:20180123:121243.301 slow query: 6.449892 sec, "select clock,ns,value from history_uint where itemid=29476 and clock>1514349061 and clock<=1516731156"
  66. 1410:20180123:121249.687 slow query: 4.684719 sec, "select clock,ns,value from history_uint where itemid=29446 and clock>1514349060 and clock<=1516731164"
  67. 1422:20180123:121249.690 enabling Zabbix agent checks on host "Zabbix server": host became available
  68. 1410:20180123:121252.999 slow query: 3.310442 sec, "select clock,ns,value from history_uint where itemid=29449 and clock>1514349060 and clock<=1516731169"
  69. 1410:20180123:121303.466 slow query: 4.323824 sec, "insert into history_uint (itemid,clock,ns,value) values (30327,1514349643,624601244,2391864),(30317,1514349643,624601244,0),(30331,1514349643,624601244,0),(30319,1514349643,624601244,1088),(30315,1514349643,624601244,0),(30329,1514349643,624601244,0),(30313,1514349643,624601244,696),(30377,1514349643,624601244,0),(30386,1514349643,624601244,0),(30328,1514349643,624601244,7792),(30320,1514349643,624601244,726832),(30362,1514349643,624601244,0),(30371,1514349643,624601244,0),(30322,1514349643,624601244,0),(30381,1514349643,624601244,0),(30368,1514349643,624601244,0),(30314,1514349643,624601244,0),(30375,1514349643,624601244,11488),(30372,1514349643,624601244,0),(30323,1514349643,624601244,0),(30364,1514349643,624601244,0),(30365,1514349643,624601244,0),(30318,1514349643,624601244,0),(30366,1514349643,624601244,2601904),(30384,1514349643,624601244,4296),(30385,1514349643,624601244,0),(30304,1514349643,624601244,0),(30383,1514349643,624601244,548768),(30374,1514349643,624601244,0),(30485,1514349644,655203050,3326856),(30499,1514349644,655203050,9728),(30503,1514349644,655203050,0),(30445,1514349644,655203050,0),(30417,1514349644,655203050,16),(30432,1514349644,655203050,944),(30441,1514349644,655203050,7728),(30435,1514349644,655203050,0),(30498,1514349644,655203050,559432),(30484,1514349644,655203050,0),(30434,1514349644,655203050,0),(30423,1514349644,655203050,758776),(30440,1514349644,655203050,3694216),(30500,1514349644,655203050,0),(30427,1514349644,655203050,11288),(30476,1514349644,655203050,10624),(30421,1514349644,655203050,0),(30431,1514349644,655203050,0),(30495,1514349644,655203050,0),(30497,1514349644,655203050,329344),(30443,1514349644,655203050,0),(30490,1514349644,655203050,11672),(30438,1514349644,655203050,0),(30424,1514349644,655203050,0),(30477,1514349644,655203050,0),(30433,1514349644,655203050,787968),(30436,1514349644,655203050,16),(30481,1514349644,655203050,443504),(30420,1514349644,655203050,0),(30502,1514349644,655203050,0),(30493,1514349644,655203050,10560),(30422,1514349644,655203050,1014280),(30494,1514349644,655203050,10560),(30492,1514349644,655203050,10560),(30444,1514349644,655203050,0),(30442,1514349644,655203050,0),(30480,1514349644,655203050,1833984),(30418,1514349644,655203050,168),(30437,1514349644,655203050,0),(30488,1514349644,655203050,10560),(30479,1514349644,655203050,10560),(30426,1514349644,655203050,0),(30478,1514349644,655203050,10560),(30429,1514349644,655203050,114312),(30487,1514349644,655203050,12999368),(30491,1514349644,655203050,730424),(30475,1514349644,655203050,10560),(30419,1514349644,655203050,0),(30425,1514349644,655203050,331720),(30501,1514349644,655203050,0),(30428,1514349644,655203050,82112),(30489,1514349644,655203050,0),(30430,1514349644,655203050,0),(30496,1514349644,655203050,0),(30482,1514349644,655203050,0),(30628,1514349645,662144173,0),(30571,1514349645,662144173,14239832),(30647,1514349645,662144173,1143904),(30569,1514349645,662144173,0),(30562,1514349645,662144173,0),(30574,1514349645,662144173,2355744),(30626,1514349645,662144173,0),(30625,1514349645,662144173,45272),(30547,1514349645,662144173,17133152),(30639,1514349645,662144173,8672328),(30559,1514349645,662144173,19033144),(30549,1514349645,662144173,8534816),(30638,1514349645,662144173,0),(30557,1514349645,662144173,12988872),(30566,1514349645,662144173,6778736),(30623,1514349645,662144173,7653096),(30620,1514349645,662144173,540200),(30633,1514349645,662144173,332296),(30618,1514349645,662144173,96),(30548,1514349645,662144173,0),(30570,1514349645,662144173,0),(30544,1514349645,662144173,0),(30627,1514349645,662144173,0),(30635,1514349645,662144173,13792),(30641,1514349645,662144173,0),(30651,1514349645,662144173,0),(30558,1514349645,662144173,14883808),(30556,1514349645,662144173,3326528),(30561,1514349645,662144173,6864),(30553,1514349645,662144173,0),(30542,1514349645,662144173,112),(30615,1514349645,662144173,48),(30637,1514349645,662144173,0),(30622,1514349645,662144173,0),(30554,1514349645,662144173,0),(30551,1514349645,662144173,41560),(30545,1514349645,662144173,0),(30634,1514349645,662144173,0),(30630,1514349645,662144173,11376),(30649,1514349645,662144173,0),(30575,1514349645,662144173,0),(30568,1514349645,662144173,0),(30565,1514349645,662144173,10354416),(30644,1514349645,662144173,0),(30617,1514349645,662144173,8216),(30631,1514349645,662144173,114312),(30543,1514349645,662144173,12928),(30650,1514349645,662144173,0),(30642,1514349645,662144173,0),(30643,1514349645,662144173,0),(30616,1514349645,662144173,16),(30621,1514349645,662144173,13815936),(30576,1514349645,662144173,0),(30632,1514349645,662144173,82208),(30629,1514349645,662144173,0),(30619,1514349645,662144173,0),(30550,1514349645,662144173,226408),(30560,1514349645,662144173,0),(30567,1514349645,662144173,0),(30640,1514349645,666283256,5143576),(30646,1514349645,666283256,258496),(30563,1514349645,666283256,0),(30541,1514349645,666283256,5144),(30552,1514349645,666283256,0),(30636,1514349645,666283256,0),(30572,1514349645,666283256,8634896),(30577,1514349645,666283256,0),(30564,1514349645,666283256,0),(30555,1514349645,666283256,0),(30746,1514349646,676516114,17132472),(30701,1514349646,676516114,8667144),(30759,1514349646,676516114,34808),(30752,1514349646,676516114,0),(30760,1514349646,676516114,0),(30688,1514349646,676516114,0),(30693,1514349646,676516114,928),(30694,1514349646,676516114,1280),(30747,1514349646,676516114,0),(30695,1514349646,676516114,0),(30697,1514349646,676516114,144),(30712,1514349646,676516114,17130344),(30698,1514349646,676516114,0),(30758,1514349646,676516114,0),(30684,1514349646,676516114,13813112),(30683,1514349646,676516114,4616),(30703,1514349646,676516114,0),(30773,1514349646,676516114,0),(30757,1514349646,676516114,0),(30767,1514349646,676516114,0),(30689,1514349646,676516114,0),(30709,1514349646,676516114,0),(30765,1514349646,676516114,0),(30769,1514349646,676516114,0),(30707,1514349646,676516114,0),(30756,1514349646,676516114,21600),(30766,1514349646,676516114,0),(30772,1514349646,676516114,0),(30687,1514349646,676516114,0),(30686,1514349646,676516114,0),(30706,1514349646,676516114,0),(30685,1514349646,676516114,0),(30768,1514349646,676516114,0),(30771,1514349646,676516114,0),(30700,1514349646,676516114,0),(30702,1514349646,676516114,5145968),(30755,1514349646,676516114,20824),(30751,1514349646,676516114,0),(30761,1514349646,676516114,0),(30748,1514349646,676516114,0),(30762,1514349646,676516114,0),(30699,1514349646,676516114,0),(30691,1514349646,676516114,0),(30692,1514349646,676516114,0),(30749,1514349646,676516114,0),(30710,1514349646,676516114,0),(30745,1514349646,676516114,40),(30763,1514349646,676516114,10356352),(30770,1514349646,676516114,0),(30705,1514349646,676516114,0),(30750,1514349646,676516114,0),(30775,1514349646,676516114,0),(30753,1514349646,676516114,0),(30711,1514349646,676516114,0),(30708,1514349646,676516114,0),(30754,1514349646,676516114,6984),(30690,1514349646,676516114,0),(30764,1514349646,676516114,6776120),(30696,1514349646,676516114,0),(30713,1514349646,676516114,0),(30704,1514349646,676516114,0),(30856,1514349647,682212255,0),(30985,1514349647,682212255,0),(30939,1514349647,752806798,0),(30959,1514349647,752806798,0),(30859,1514349647,752806798,0),(30863,1514349647,752806798,0),(30955,1514349647,752806798,0),(30968,1514349647,752806798,0),(30869,1514349647,752806798,0),(30948,1514349647,752806798,24024),(30943,1514349647,752806798,0),(30987,1514349647,752806798,1992),(30841,1514349647,752806798,0),(30936,1514349647,752806798,0),(30963,1514349647,752806798,24280),(30942,1514349647,752806798,0),(30858,1514349647,752806798,0),(30977,1514349647,752806798,0),(30846,1514349647,752806798,0),(30849,1514349647,752806798,0),(30874,1514349647,752806798,24280),(30961,1514349647,752806798,0),(30880,1514349647,752806798,0),(30970,1514349647,752806798,0),(30949,1514349647,752806798,0),(30940,1514349647,752806798,0),(30831,1514349647,752806798,112),(30947,1514349647,752806798,0),(30864,1514349647,752806798,0),(30981,1514349647,752806798,0),(30951,1514349647,752806798,0),(30982,1514349647,752806798,225960),(30875,1514349647,752806798,0),(30855,1514349647,752806798,0),(30972,1514349647,752806798,0),(30848,1514349647,752806798,0),(30950,1514349647,752806798,0),(30986,1514349647,752806798,0),(30847,1514349647,752806798,226072),(30879,1514349647,752806798,0),(30870,1514349647,752806798,0),(30851,1514349647,752806798,0),(30983,1514349647,752806798,0),(30845,1514349647,752806798,0),(30967,1514349647,752806798,0),(30860,1514349647,752806798,0),(30850,1514349647,752806798,336),(30881,1514349647,752806798,23592),(30971,1514349647,752806798,0),(30837,1514349647,752806798,0),(30877,1514349647,752806798,0),(30842,1514349647,752806798,496),(30844,1514349647,752806798,0),(30941,1514349647,752806798,0),(30865,1514349647,752806798,0),(30964,1514349647,752806798,0),(30854,1514349647,752806798,0),(30878,1514349647,752806798,0),(30937,1514349647,752806798,24304),(30974,1514349647,752806798,0),(30957,1514349647,752806798,0),(30965,1514349647,752806798,0),(30954,1514349647,752806798,0),(30962,1514349647,752806798,0),(30980,1514349647,752806798,40),(30829,1514349647,752806798,0),(30866,1514349647,752806798,0),(30836,1514349647,752806798,0),(30871,1514349647,752806798,0),(30833,1514349647,752806798,0),(30958,1514349647,752806798,0),(30835,1514349647,752806798,0),(30966,1514349647,752806798,0),(30945,1514349647,752806798,0),(30935,1514349647,752806798,0),(30973,1514349647,752806798,0),(30952,1514349647,752806798,0),(30832,1514349647,752806798,0),(30853,1514349647,752806798,0),(30862,1514349647,752806798,0),(30830,1514349647,752806798,0),(30960,1514349647,752806798,0),(30979,1514349647,752806798,24528),(30976,1514349647,752806798,0),(30956,1514349647,752806798,24536),(30872,1514349647,752806798,0),(30857,1514349647,752806798,40),(30938,1514349647,752806798,0),(30969,1514349647,752806798,0),(30867,1514349647,752806798,0),(30975,1514349647,752806798,0),(30978,1514349647,752806798,0),(30839,1514349647,752806798,0),(30834,1514349647,752806798,0),(30946,1514349647,752806798,24272),(30843,1514349647,752806798,0),(30944,1514349647,752806798,0),(30861,1514349647,752806798,0),(30873,1514349647,752806798,160),(30984,1514349647,752806798,0),(30868,1514349647,752806798,0),(30852,1514349647,752806798,0),(30840,1514349647,752806798,0),(30838,1514349647,752806798,0),(31045,1514349648,701820624,0),(31087,1514349648,701820624,7176),(31032,1514349648,701820624,0),(31043,1514349648,701820624,176),(31023,1514349648,701820624,176),(31036,1514349648,701820624,4096),(31110,1514349648,701820624,0),(31082,1514349648,701820624,88),(31085,1514349648,701820624,7176),(31088,1514349648,701820624,6992),(31034,1514349648,701820624,0),(31098,1514349648,701820624,92848),(31106,1514349648,701820624,8639368),(31038,1514349648,701820624,0),(31103,1514349648,701820624,34360),(31044,1514349648,701820624,260112),(31028,1514349648,701820624,1048),(31090,1514349648,701820624,20904),(31039,1514349648,701820624,168),(31042,1514349648,701820624,8072),(31104,1514349648,701820624,58248),(31025,1514349648,701820624,176),(31029,1514349648,701820624,952),(31096,1514349648,701820624,0),(31102,1514349648,701820624,0),(31091,1514349648,701820624,20904),(31111,1514349648,701820624,0),(31109,1514349648,701820624,0),(31094,1514349648,701820624,0),(31105,1514349648,701820624,7176),(31046,1514349648,701820624,0),(31033,1514349648,701820624,8611544),(31089,1514349648,701820624,7176),(31107,1514349648,701820624,0),(31083,1514349648,701820624,0),(31097,1514349648,701820624,7168),(31024,1514349648,701820624,11232),(31101,1514349648,701820624,7168),(31084,1514349648,701820624,0),(31047,1514349648,701820624,0),(31027,1514349648,701820624,176),(31031,1514349648,701820624,0),(31099,1514349648,701820624,7176),(31035,1514349648,701820624,168),(31021,1514349648,701820624,0),(31037,1514349648,701820624,176),(31100,1514349648,701820624,0),(31092,1514349648,701820624,7176),(31030,1514349648,701820624,176),(31040,1514349648,701820624,0),(31095,1514349648,701820624,76736),(31049,1514349648,701820624,0),(31026,1514349648,701820624,0),(31081,1514349648,701820624,24),(31108,1514349648,701820624,0),(31019,1514349648,701820624,4560),(31020,1514349648,701820624,7960),(31093,1514349648,701820624,0),(31086,1514349648,701820624,38136),(31048,1514349648,701820624,0),(31022,1514349648,701820624,0),(31041,1514349648,701820624,176),(31212,1514349649,719747481,6960),(31220,1514349649,719747481,0),(31143,1514349649,719747481,4624),(31230,1514349649,719747481,39531296),(31169,1514349649,719747481,14205848),(31171,1514349649,719747481,0),(31158,1514349649,719747481,0),(31226,1514349649,719747481,0),(31173,1514349649,719747481,0),(31165,1514349649,719747481,0),(31146,1514349649,719747481,0),(31144,1514349649,719747481,13312),(31162,1514349649,719747481,0),(31153,1514349649,719747481,39320),(31221,1514349649,719747481,0),(31166,1514349649,719747481,0),(31219,1514349649,719747481,6976),(31229,1514349649,719747481,14280792),(31235,1514349649,719747481,0),(31215,1514349649,719747481,40056),(31216,1514349649,719747481,0),(31213,1514349649,719747481,0),(31227,1514349649,719747481,0),(31151,1514349649,719747481,0),(31168,1514349649,719747481,44640),(31160,1514349649,719747481,0),(31209,1514349649,719747481,0),(31205,1514349649,719747481,40),(31170,1514349649,719747481,0),(31147,1514349649,719747481,0),(31222,1514349649,719747481,0),(31228,1514349649,719747481,0),(31163,1514349649,719747481,0),(31161,1514349649,719747481,0),(31145,1514349649,719747481,0),(31218,1514349649,719747481,0),(31207,1514349649,719747481,0),(31150,1514349649,719747481,16),(31214,1514349649,719747481,0),(31148,1514349649,719747481,16),(31225,1514349649,719747481,0),(31164,1514349649,719747481,0),(31149,1514349649,719747481,0),(31211,1514349649,719747481,0),(31156,1514349649,719747481,0),(31159,1514349649,719747481,0),(31154,1514349649,719747481,0),(31217,1514349649,719747481,0),(31232,1514349649,719747481,0),(31210,1514349649,719747481,6960),(31206,1514349649,719747481,8232),(31234,1514349649,719747481,0),(31223,1514349649,719747481,0),(31155,1514349649,719747481,0),(31172,1514349649,719747481,0),(31152,1514349649,719747481,0),(31208,1514349649,719747481,6976),(31157,1514349649,719747481,24),(31233,1514349649,719747481,0),(31224,1514349649,719747481,0),(31282,1514349650,734463058,0),(31330,1514349650,734463058,0),(31290,1514349650,734463058,0),(31352,1514349650,734463058,0),(31289,1514349650,734463058,0),(31344,1514349650,734463058,0),(31333,1514349650,734463058,7184),(31297,1514349650,734463058,0),(31280,1514349650,734463058,0),(31341,1514349650,734463058,0),(31337,1514349650,734463058,0),(31275,1514349650,734463058,0),(31281,1514349650,734463058,168),(31340,1514349650,734463058,0),(31291,1514349650,734463058,0),(31342,1514349650,734463058,0),(31336,1514349650,734463058,7352),(31345,1514349650,734463058,7080),(31269,1514349650,734463058,168),(31353,1514349650,734463058,0),(31338,1514349650,734463058,21464),(31273,1514349650,734463058,0),(31286,1514349650,734463058,0),(31276,1514349650,734463058,2088),(31329,1514349650,734463058,32),(31270,1514349650,734463058,0),(31343,1514349650,734463058,7136),(31349,1514349650,734463058,0),(31287,1514349650,734463058,0),(31354,1514349650,734463058,4192),(31348,1514349650,734463058,0),(31334,1514349650,734463058,0),(31271,1514349650,734463058,48),(31268,1514349650,734463058,0),(31332,1514349650,734463058,0),(31339,1514349650,734463058,0),(31267,1514349650,734463058,4600),(31346,1514349650,734463058,0),(31356,1514349650,734463058,0),(31285,1514349650,734463058,456),(31351,1514349650,734463058,0),(31279,1514349650,734463058,0),(31272,1514349650,734463058,0),(31358,1514349650,734463058,0),(31335,1514349650,734463058,0),(31296,1514349650,734463058,0),(31284,1514349650,734463058,0),(31274,1514349650,734463058,576),(31295,1514349650,734463058,0),(31293,1514349650,734463058,0),(31278,1514349650,734463058,0),(31355,1514349650,734463058,0),(31288,1514349650,734463058,0),(31357,1514349650,734463058,0),(31331,1514349650,734463058,7136),(31292,1514349650,734463058,22648),(31283,1514349650,734463058,96),(31350,1514349650,734463058,0),(31277,1514349650,734463058,0),(31359,1514349650,734463058,0),(31347,1514349650,734463058,7520),(31294,1514349650,734463058,0),(31412,1514349651,765228820,400),(31404,1514349651,765228820,0),(31476,1514349651,765228820,0),(31413,1514349651,765228820,1760),(31467,1514349651,765228820,7192),(31454,1514349651,765228820,0),(31460,1514349651,765228820,0),(31415,1514349651,765228820,70600),(31396,1514349651,765228820,176),(31451,1514349651,765228820,0),(31463,1514349651,765228820,23104),(31479,1514349651,765228820,0),(31469,1514349651,765228820,7248),(31419,1514349651,765228820,0),(31390,1514349651,765228820,4544),(31452,1514349651,765228820,7160),(31417,1514349651,765228820,0),(31406,1514349651,765228820,200),(31453,1514349651,765228820,0),(31397,1514349651,765228820,0),(31471,1514349651,765228820,0),(31392,1514349651,765228820,176),(31477,1514349651,765228820,0),(31402,1514349651,765228820,0),(31395,1514349651,765228820,176),(31394,1514349651,765228820,0),(31458,1514349651,765228820,0),(31405,1514349651,765228820,1704),(31462,1514349651,765228820,0),(31408,1514349651,765228820,0),(31400,1514349651,765228820,0),(31403,1514349651,765228820,4360),(31450,1514349651,765228820,32),(31414,1514349651,765228820,4192),(31475,1514349651,765228820,13016),(31474,1514349651,765228820,22656),(31473,1514349651,765228820,22544),(31416,1514349651,765228820,0),(31461,1514349651,765228820,7152),(31410,1514349651,765228820,104),(31478,1514349651,765228820,0),(31466,1514349651,765228820,7160),(31468,1514349651,765228820,0),(31470,1514349651,765228820,7064),(31465,1514349651,765228820,23840),(31399,1514349651,765228820,64),(31418,1514349651,765228820,0),(31464,1514349651,765228820,6976),(31401,1514349651,765228820,24),(31459,1514349651,765228820,7024),(31407,1514349651,765228820,256),(31398,1514349651,765228820,0),(31456,1514349651,765228820,7160),(31391,1514349651,765228820,0),(31472,1514349651,765228820,7296),(31455,1514349651,765228820,7160),(31393,1514349651,765228820,0),(31411,1514349651,765228820,0),(31409,1514349651,765228820,96),(31457,1514349651,765228820,0),(31972,1514349652,980997064,0),(32032,1514349652,980997064,0),(31967,1514349652,980997064,0),(32031,1514349652,980997064,0),(31982,1514349652,980997064,0),(31989,1514349652,980997064,0),(31987,1514349652,980997064,0),(32037,1514349652,980997064,0),(32025,1514349652,980997064,0),(32020,1514349652,980997064,0),(31984,1514349652,980997064,0),(31991,1514349652,980997064,0),(31978,1514349652,980997064,0),(32041,1514349652,980997064,7720),(31968,1514349652,980997064,0),(31986,1514349652,980997064,0),(32030,1514349652,980997064,0),(32046,1514349652,980997064,0),(31969,1514349652,980997064,0),(32043,1514349652,980997064,0),(31973,1514349652,980997064,0),(32033,1514349652,980997064,0),(32021,1514349652,980997064,21456),(31971,1514349652,980997064,0),(31980,1514349652,980997064,0),(32022,1514349652,980997064,0),(31985,1514349652,980997064,176),(32036,1514349652,980997064,0),(32023,1514349652,980997064,0),(32026,1514349652,980997064,0),(31979,1514349652,980997064,0),(32038,1514349652,980997064,0),(31974,1514349652,980997064,0),(31988,1514349652,980997064,22536),(31975,1514349652,980997064,0),(31965,1514349652,980997064,1688),(32047,1514349652,980997064,0),(32024,1514349652,980997064,0),(31966,1514349652,980997064,0),(32044,1514349652,980997064,1760),(31976,1514349652,980997064,0),(32027,1514349652,980997064,0),(32040,1514349652,980997064,0),(32034,1514349652,980997064,0),(31964,1514349652,980997064,0),(31981,1514349652,980997064,0),(31970,1514349652,980997064,0),(32028,1514349652,980997064,0),(32029,1514349652,980997064,0),(31983,1514349652,980997064,0),(32042,1514349652,980997064,0),(31990,1514349652,980997064,0),(32045,1514349652,980997064,0),(31977,1514349652,980997064,0),(32035,1514349652,980997064,0),(32039,1514349652,980997064,0),(31576,1514349653,78034673,7168),(31536,1514349653,78034673,139304),(31514,1514349653,78034673,176),(31528,1514349653,78034673,0),(31527,1514349653,78034673,0),(31579,1514349653,78034673,0),(31595,1514349653,78034673,0),(31583,1514349653,78034673,12376),(31593,1514349653,78034673,40488),(31584,1514349653,78034673,92976),(31515,1514349653,78034673,0),(31585,1514349653,78034673,0),(31534,1514349653,78034673,0),(31535,1514349653,78034673,0),(31517,1514349653,78034673,0),(31537,1514349653,78034673,0),(31590,1514349653,78034673,0),(31533,1514349653,78034673,0),(31598,1514349653,78034673,17657944),(31531,1514349653,78034673,24952),(31525,1514349653,78034673,176),(31574,1514349653,78034673,0),(31519,1514349653,78034673,176),(31597,1514349653,78034673,0),(31596,1514349653,78034673,0),(31523,1514349653,78034673,0),(31521,1514349653,78034673,542368),(31522,1514349653,78034673,4306160),(31600,1514349653,78034673,0),(31540,1514349653,78034673,0),(31578,1514349653,78034673,0),(31530,1514349653,78034673,0),(31591,1514349653,78034673,0),(31587,1514349653,78034673,7168),(31532,1514349653,78034673,0),(31582,1514349653,78034673,0),(31580,1514349653,78034673,0),(31539,1514349653,78034673,0),(31538,1514349653,78034673,0),(31513,1514349653,78034673,0),(31520,1514349653,78034673,0),(31594,1514349653,78034673,0),(31512,1514349653,78034673,0),(31529,1514349653,78034673,0),(31589,1514349653,78034673,0),(31603,1514349653,78034673,0),(31592,1514349653,78034673,0),(31588,1514349653,78034673,13920),(31516,1514349653,78034673,0),(31511,1514349653,78034673,4576),(31575,1514349653,78034673,0),(31586,1514349653,78034673,0),(31601,1514349653,78034673,0),(31577,1514349653,78034673,0),(31524,1514349653,78034673,0),(31602,1514349653,78034673,0),(31526,1514349653,78034673,12782792),(31599,1514349653,78034673,0),(31541,1514349653,78034673,0),(31518,1514349653,78034673,0),(31573,1514349653,78034673,16),(31581,1514349653,78034673,7168),(31695,1514349654,210883921,0),(31815,1514349654,210883921,384),(31791,1514349654,210883921,0),(31784,1514349654,210883921,0),(31768,1514349654,210883921,0),(31685,1514349654,210883921,0),(31798,1514349654,210883921,0),(31788,1514349654,210883921,0),(31793,1514349654,210883921,0),(31790,1514349654,210883921,0),(31697,1514349654,210883921,0),(31806,1514349654,210883921,0),(31764,1514349654,210883921,0),(31789,1514349654,210883921,0),(31682,1514349654,210883921,0),(31687,1514349654,210883921,0),(31808,1514349654,210883921,0),(31708,1514349654,210883921,0),(31765,1514349654,210883921,0),(31786,1514349654,210883921,0),(31767,1514349654,210883921,0),(31776,1514349654,210883921,0),(31771,1514349654,210883921,0),(31804,1514349654,210883921,0),(31684,1514349654,210883921,0),(31800,1514349654,210883921,0),(31668,1514349654,210883921,0),(31707,1514349654,210883921,0),(31658,1514349654,210883921,0),(31802,1514349654,210883921,0),(31692,1514349654,210883921,0),(31814,1514349654,210883921,0),(31774,1514349654,210883921,0),(31709,1514349654,210883921,5752),(31670,1514349654,210883921,0),(31667,1514349654,210883921,0),(31795,1514349654,210883921,0),(31703,1514349654,210883921,139864),(31809,1514349654,210883921,17643880),(31663,1514349654,210883921,0),(31699,1514349654,210883921,0),(31660,1514349654,210883921,0),(31704,1514349654,210883921,17645072),(31705,1514349654,210883921,0),(31706,1514349654,210883921,0),(31777,1514349654,210883921,0),(31781,1514349654,210883921,0),(31769,1514349654,210883921,0),(31661,1514349654,210883921,0),(31672,1514349654,210883921,0),(31675,1514349654,210883921,0),(31780,1514349654,210883921,0),(31666,1514349654,210883921,0),(31657,1514349654,210883921,0),(31792,1514349654,210883921,0),(31810,1514349654,210883921,139208),(31688,1514349654,210883921,0),(31785,1514349654,210883921,0),(31778,1514349654,210883921,0),(31700,1514349654,210883921,0),(31665,1514349654,210883921,0),(31766,1514349654,210883921,0),(31702,1514349654,210883921,0),(31803,1514349654,210883921,0),(31686,1514349654,210883921,0),(31680,1514349654,210883921,0),(31689,1514349654,210883921,0),(31796,1514349654,210883921,0),(31797,1514349654,210883921,0),(31782,1514349654,210883921,0),(31772,1514349654,210883921,0),(31659,1514349654,210883921,0),(31698,1514349654,210883921,0),(31691,1514349654,210883921,0),(31701,1514349654,210883921,0),(31799,1514349654,210883921,0),(31696,1514349654,210883921,0),(31693,1514349654,210883921,0),(31676,1514349654,210883921,0),(31801,1514349654,210883921,0),(31690,1514349654,210883921,0),(31679,1514349654,210883921,0),(31683,1514349654,210883921,0),(31678,1514349654,210883921,0),(31770,1514349654,210883921,0),(31664,1514349654,210883921,0),(31813,1514349654,210883921,0),(31674,1514349654,210883921,0),(31671,1514349654,210883921,0),(31779,1514349654,210883921,0),(31783,1514349654,210883921,0),(31763,1514349654,210883921,0),(31811,1514349654,210883921,0),(31694,1514349654,210883921,0),(31677,1514349654,210883921,0),(31681,1514349654,210883921,0),(31807,1514349654,210883921,0),(31805,1514349654,210883921,0),(31673,1514349654,210883921,0),(31787,1514349654,210883921,0),(31812,1514349654,210883921,0),(31794,1514349654,210883921,0),(31773,1514349654,210883921,0),(31775,1514349654,210883921,0),(31669,1514349654,210883921,0),(31662,1514349654,210883921,0),(31933,1514349655,271397634,0),(31922,1514349655,271397634,0),(31934,1514349655,271397634,17143496),(31860,1514349655,271397634,4734800),(31917,1514349655,271397634,31032),(31850,1514349655,271397634,184),(31868,1514349655,271397634,4714824),(31907,1514349655,271397634,4713768),(31921,1514349655,271397634,0),(31852,1514349655,271397634,184),(31863,1514349655,271397634,0),(31932,1514349655,271397634,0),(31861,1514349655,271397634,0),(31924,1514349655,271397634,31024),(31846,1514349655,271397634,4560),(31858,1514349655,271397634,0),(31908,1514349655,271397634,30992),(31929,1514349655,271397634,0),(31848,1514349655,271397634,1978376),(31853,1514349655,271397634,0),(31914,1514349655,271397634,31008),(31931,1514349655,271397634,0),(31927,1514349655,271397634,0),(31925,1514349655,271397634,7208),(31857,1514349655,271397634,1915968),(31855,1514349655,271397634,1953920),(31935,1514349655,271397634,0),(31859,1514349655,271397634,176),(31906,1514349655,271397634,32),(31869,1514349655,271397634,0),(31871,1514349655,271397634,0),(31872,1514349655,271397634,0),(31920,1514349655,271397634,193888),(31919,1514349655,271397634,7200),(31912,1514349655,271397634,7208),(31923,1514349655,271397634,0),(31875,1514349655,271397634,0),(31864,1514349655,271397634,728208),(31911,1514349655,271397634,0),(31918,1514349655,271397634,0),(31854,1514349655,271397634,752520),(31847,1514349655,271397634,183792),(31866,1514349655,271397634,0),(31913,1514349655,271397634,0),(31870,1514349655,271397634,180880),(31856,1514349655,271397634,184),(31867,1514349655,271397634,0),(31862,1514349655,271397634,0),(31849,1514349655,271397634,0),(31874,1514349655,271397634,13798184),(31909,1514349655,271397634,0),(31930,1514349655,271397634,8671744),(31926,1514349655,271397634,0),(31916,1514349655,271397634,7208),(31865,1514349655,271397634,184),(31928,1514349655,271397634,201944),(31910,1514349655,271397634,7208),(31873,1514349655,271397634,0),(31915,1514349655,271397634,30984),(31851,1514349655,271397634,0),(32106,1514349656,389426392,0),(32126,1514349656,389426392,0),(32137,1514349656,389426392,0),(32148,1514349656,389426392,8664080),(32145,1514349656,389426392,0),(32120,1514349656,389426392,0),(32248,1514349656,389426392,0),(32218,1514349656,389426392,0),(32214,1514349656,389426392,0),(32213,1514349656,389426392,0),(32130,1514349656,389426392,0),(32153,1514349656,389426392,22272),(32257,1514349656,389426392,0),(32223,1514349656,389426392,0),(32109,1514349656,389426392,0),(32103,1514349656,389426392,0),(32256,1514349656,389426392,0),(32117,1514349656,389426392,0),(32131,1514349656,389426392,0),(32216,1514349656,389426392,0),(32221,1514349656,389426392,0),(32116,1514349656,389426392,0),(32146,1514349656,389426392,0),(32119,1514349656,389426392,792),(32215,1514349656,389426392,0),(32118,1514349656,389426392,144),(32241,1514349656,389426392,0),(32141,1514349656,389426392,0),(32147,1514349656,389426392,0),(32259,1514349656,389426392,1288),(32234,1514349656,389426392,0),(32227,1514349656,389426392,4331072),(32104,1514349656,389426392,0),(32110,1514349656,389426392,0),(32121,1514349656,389426392,86280),(32129,1514349656,389426392,0),(32113,1514349656,389426392,0),(32115,1514349656,389426392,0),(32210,1514349656,389426392,0),(32107,1514349656,389426392,0),(32152,1514349656,389426392,0),(32140,1514349656,389426392,0),(32133,1514349656,389426392,0),(32151,1514349656,389426392,0),(32212,1514349656,389426392,0),(32136,1514349656,389426392,0),(32209,1514349656,389426392,0),(32143,1514349656,389426392,0),(32230,1514349656,389426392,0),(32220,1514349656,389426392,0),(32122,1514349656,389426392,0),(32112,1514349656,389426392,0),(32144,1514349656,389426392,0),(32207,1514349656,389426392,0),(32251,1514349656,389426392,0),(32250,1514349656,389426392,0),(32149,1514349656,389426392,0),(32111,1514349656,389426392,0),(32150,1514349656,389426392,0),(32134,1514349656,389426392,0),(32105,1514349656,389426392,0),(32245,1514349656,389426392,0),(32249,1514349656,389426392,0),(32255,1514349656,389426392,0),(32135,1514349656,389426392,0),(32102,1514349656,389426392,93408),(32244,1514349656,389426392,0),(32132,1514349656,389426392,0),(32242,1514349656,389426392,0),(32246,1514349656,389426392,0),(32217,1514349656,389426392,0),(32258,1514349656,389426392,0),(32235,1514349656,389426392,0),(32236,1514349656,389426392,0),(32232,1514349656,389426392,0),(32139,1514349656,389426392,0),(32219,1514349656,389426392,0),(32138,1514349656,389426392,0),(32211,1514349656,389426392,0),(32252,1514349656,389426392,0),(32128,1514349656,389426392,0),(32123,1514349656,389426392,0),(32247,1514349656,389426392,0),(32142,1514349656,389426392,0),(32101,1514349656,389426392,0),(32226,1514349656,389426392,0),(32222,1514349656,389426392,0),(32229,1514349656,389426392,0),(32124,1514349656,389426392,0),(32125,1514349656,389426392,0),(32127,1514349656,389426392,0),(32240,1514349656,389426392,0),(32114,1514349656,389426392,0),(32225,1514349656,389426392,24632),(32231,1514349656,389426392,0),(32238,1514349656,389426392,0),(32228,1514349656,389426392,0),(32208,1514349656,389426392,4328048),(32243,1514349656,389426392,0),(32108,1514349656,389426392,0),(32224,1514349656,389426392,23856),(32253,1514349656,389426392,0),(32233,1514349656,389426392,0),(32237,1514349656,389426392,0),(32254,1514349656,389426392,180720),(32239,1514349656,389426392,0),(32453,1514349657,507866775,0),(32334,1514349657,507866775,0),(32360,1514349657,507866775,13493312),(32447,1514349657,507866775,0),(32421,1514349657,507866775,0),(32335,1514349657,507866775,0),(32348,1514349657,507866775,0),(32451,1514349657,507866775,0),(32337,1514349657,507866775,0),(32340,1514349657,507866775,0),(32328,1514349657,507866775,0),(32429,1514349657,507866775,0),(32344,1514349657,507866775,0),(32314,1514349657,507866775,0),(32436,1514349657,507866775,0),(32428,1514349657,507866775,0),(32330,1514349657,507866775,0),(32362,1514349657,507866775,0),(32422,1514349657,507866775,0),(32315,1514349657,507866775,0),(32468,1514349657,507866775,0),(32355,1514349657,507866775,0);
  70. "
  71. 1411:20180123:121305.229 slow query: 29.519249 sec, "select clock,ns,value from history where itemid=29710 and clock>1514346971 and clock<=1516731155"
  72. 1410:20180123:121309.073 slow query: 3.744654 sec, "select clock,ns,value from history_uint where itemid=154412 and clock>1514350412 and clock<=1516731185"
  73. 1409:20180123:121312.807 slow query: 40.844672 sec, "select clock,ns,value from history_uint where itemid=29768 and clock>1514347273 and clock<=1516731151"
  74. 1412:20180123:121312.972 slow query: 45.196234 sec, "select clock,ns,value from history_uint where itemid=29738 and clock>1514347287 and clock<=1516731147"
  75. 1410:20180123:121318.015 slow query: 3.298665 sec, "select clock,ns,value from history_uint where itemid=154507 and clock>1514350207 and clock<=1516731194"
  76. 1410:20180123:121321.478 slow query: 3.461386 sec, "select clock,ns,value from history_uint where itemid=154438 and clock>1514350438 and clock<=1516731198"
  77. 1410:20180123:121324.947 slow query: 3.090469 sec, "select clock,ns,value from history_uint where itemid=154414 and clock>1514350414 and clock<=1516731201"
  78. 1410:20180123:121331.903 slow query: 3.620306 sec, "select clock,ns,value from history_uint where itemid=154473 and clock>1514350473 and clock<=1516731208"
  79. 1401:20180123:121333.978 slow query: 3.655713 sec, "select i.itemid,i.hostid,i.status,i.type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.trapper_hosts,i.logtimefmt,i.params,i.state,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,i.snmpv3_authprotocol,i.snmpv3_privprotocol,i.snmpv3_contextname,i.lastlogsize,i.mtime,i.history,i.trends,i.inventory_link,i.valuemapid,i.units,i.error,i.jmx_endpoint,i.master_itemid from items i,hosts h where i.hostid=h.hostid and h.status in (0,1) and i.flags<>2"
  80. 1410:20180123:121336.783 slow query: 4.781052 sec, "select clock,ns,value from history where itemid=154432 and clock>1514350132 and clock<=1516731211"
  81. 1410:20180123:121340.111 slow query: 3.326447 sec, "select clock,ns,value from history_uint where itemid=154409 and clock>1514350409 and clock<=1516731216"
  82. 1410:20180123:121343.308 slow query: 3.195952 sec, "select clock,ns,value from history_uint where itemid=154411 and clock>1514350111 and clock<=1516731220"
  83. 1410:20180123:121347.161 slow query: 3.852076 sec, "select clock,ns,value from history_uint where itemid=154470 and clock>1514350470 and clock<=1516731223"
  84. 1411:20180123:121348.683 slow query: 43.393434 sec, "select clock,ns,value from history_uint where itemid=29438 and clock>1514347261 and clock<=1516731185"
  85. 1410:20180123:121350.427 slow query: 3.264346 sec, "select clock,ns,value from history_uint where itemid=154505 and clock>1514350505 and clock<=1516731227"
  86. 1409:20180123:121354.062 slow query: 41.074879 sec, "select clock,ns,value from history_uint where itemid=23995 and clock>1514347275 and clock<=1516731192"
  87. 1412:20180123:121355.489 slow query: 42.311129 sec, "select clock,ns,value from history_uint where itemid=29528 and clock>1514347547 and clock<=1516731193"
  88. 1410:20180123:121404.658 slow query: 3.748574 sec, "select clock,ns,value from history_uint where itemid=154508 and clock>1514350507 and clock<=1516731240"
  89. 1411:20180123:121425.778 slow query: 37.093560 sec, "select clock,ns,value from history where itemid=24018 and clock>1514346969 and clock<=1516731228"
  90. 1409:20180123:121426.458 slow query: 32.381234 sec, "select clock,ns,value from history_uint where itemid=24007 and clock>1514347278 and clock<=1516731234"
  91. 1412:20180123:121432.976 slow query: 37.459789 sec, "select clock,ns,value from history_uint where itemid=29498 and clock>1514347543 and clock<=1516731235"
  92. 1409:20180123:121439.332 slow query: 12.836831 sec, "select clock,ns,value from history_uint where itemid=24001 and clock>1514347278 and clock<=1516731266"
  93. 1411:20180123:121443.093 slow query: 17.314394 sec, "select clock,ns,value from history where itemid=23982 and clock>1514346971 and clock<=1516731265"
  94. 1412:20180123:121501.661 slow query: 28.683499 sec, "select clock,ns,value from history where itemid=29755 and clock>1514347245 and clock<=1516731272"
  95. 1409:20180123:121501.971 slow query: 22.637310 sec, "select clock,ns,value from history where itemid=23996 and clock>1514346975 and clock<=1516731279"
  96. 1409:20180123:121516.546 slow query: 14.574006 sec, "select clock,ns,value from history where itemid=24000 and clock>1514346978 and clock<=1516731301"
  97. 1412:20180123:121517.523 slow query: 15.783300 sec, "select clock,ns,value from history where itemid=29604 and clock>1514347253 and clock<=1516731301"
  98. 1411:20180123:121522.347 slow query: 39.086362 sec, "select clock,ns,value from history_uint where itemid=29693 and clock>1514347265 and clock<=1516731283"
  99. 1409:20180123:121522.513 slow query: 5.913557 sec, "select clock,ns,value from history_uint where itemid=29781 and clock>1514347274 and clock<=1516731316"
  100. 1409:20180123:121528.615 slow query: 6.088840 sec, "select clock,ns,value from history where itemid=24003 and clock>1514346978 and clock<=1516731322"
  101. 1412:20180123:121531.144 slow query: 13.619660 sec, "select clock,ns,value from history where itemid=29499 and clock>1514347243 and clock<=1516731317"
  102. 1411:20180123:121534.036 slow query: 11.687984 sec, "select clock,ns,value from history where itemid=23979 and clock>1514346969 and clock<=1516731322"
  103. ^C
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement