Ad Widget

Collapse

Average Values for UINT items

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alex_lakustov
    Junior Member
    • Jun 2012
    • 1

    #1

    Average Values for UINT items

    Hi guys,

    I see strange thing for average value for uint items

    CREATE TABLE `trends_uint` (
    `itemid` bigint unsigned NOT NULL,
    `clock` integer DEFAULT '0' NOT NULL,
    `num` integer DEFAULT '0' NOT NULL,
    `value_min` bigint unsigned DEFAULT '0' NOT NULL,
    `value_avg` bigint unsigned DEFAULT '0' NOT NULL,
    `value_max` bigint unsigned DEFAULT '0' NOT NULL,
    PRIMARY KEY (itemid,clock)
    ) ENGINE=InnoDB;

    Is it mean, that there are integer for float data?
    I think better to use float for average values.
  • richlv
    Senior Member
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Oct 2005
    • 3112

    #2
    that's probably https://support.zabbix.com/browse/ZBX-3643
    Zabbix 3.0 Network Monitoring book

    Comment

    Working...