Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-2994

Modify value_avg type in trends_uint (MySQL)

    XMLWordPrintable

    Details

    • Type: Change Request
    • Status: Confirmed
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.4.6
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:

      Description

      Hi there,

      Zabbix stores value_avg as BIGINT(20) in mysql DB.
      It makes trends_uint almost unusable because of huge inaccuracy.
      In point of view it make a lot more sense to store value as DOUBLE(16,4).
      We've tried to modify column type in DB, but it haven't made any affect, because zabbix calculates avg value as integer.
      Could you please modify it on zabbix server side?

      Thanks in advance.
      Best Regards.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            Kos Kanstantin
            Votes:
            4 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: