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

Modify value_avg type in trends_uint (MySQL)

    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: