Ad Widget

Collapse

ZABBIX database size prediction

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dron
    Junior Member
    • Sep 2007
    • 3
    #1

    ZABBIX database size prediction

    I made small script which can show visually how will be your ZABBIX database grow in future.

    1) put these files somewhere near your ZABBIX frontend.
    2) put ARIAL.TTF and ARIALBD.TTF into /fonts directory
    3) change/set your db values
    4) use your browser to view "prediction_graph.php"
    5) you can change behaviour of this script by changing GET values prediction_graph.php?tr=1&hi=1&sum=1
    tr - trends on/off
    hi - history on/off (default)
    sum - sum on/off
    dmin - date from
    dmax - date to (it use time() format, default is from now to 2 years in future)

    prediction for my ZABBIX (now about 5000 items)...
    Attached Files
    Tags: None
    • xaeth
      Member
      • Nov 2004
      • 67
      #2
      I'm not getting anything when I view this in a browser, so I ran it at the cli to see what was erroring. I'm getting a segfault. Here is the output:

      Code:
      PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 976
PHP Warning:  array_merge(): Argument #2 is not an array in /usr/share/zabbix/graph.php on line 976
PHP Warning:  array_merge(): Argument #1 is not an array in /usr/share/zabbix/graph.php on line 976
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 725
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 727
PHP Notice:  Undefined offset:  2 in /usr/share/zabbix/graph.php on line 736
Segmentation fault
      here is what i'm running:
      Code:
      # rpm -qa | egrep -i '(release|zabbix|http|php|mysql)' | sort
fedora-release-8-5
httpd-2.2.8-1.fc8
mysql-5.0.45-6.fc8
mysql-libs-5.0.45-6.fc8
mysql-server-5.0.45-6.fc8
php-5.2.4-3
php-bcmath-5.2.4-3
php-cli-5.2.4-3
php-common-5.2.4-3
php-gd-5.2.4-3
php-ldap-5.2.4-3
php-mysql-5.2.4-3
php-pdo-5.2.4-3
php-pear-1.6.2-2.fc8
zabbix-1.4.4-1.fc8
zabbix-agent-1.44-0.rhel3
zabbix-web-1.4.4-1.fc8
      need anything else from me?

        Comment

        • dron
          Junior Member
          • Sep 2007
          • 3
          #3
          I tested it on CentOS (4.2 and 5) and debian. There were no problems. Well, I wrote it in a hurry, so it could be my mistake but it looks like some problem in graph class. I used it because I looked for something simple to draw graphs... maybe it is simply too much :-(

          In a case textual output is enough for you, put these on line 170
          Code:
          print "<pre>";
print_r($allitems);
print "</pre>";
          and comment out
          Code:
          $chart->draw();
          btw. I use

          Code:
          centos-release-5-1.0.el5.centos.1
httpd-2.2.3-11.el5_1.centos.3
mysql-5.0.22-2.2.el5_1.1
mysql-server-5.0.22-2.2.el5_1.1
php-5.1.6-15.el5
php-common-5.1.6-15.el5
php-gd-5.1.6-15.el5
php-mysql-5.1.6-15.el5
...

            Comment

            • xaeth
              Member
              • Nov 2004
              • 67
              #4
              fixed

              thanks for the heads up... i played with it a big and while we both have v5 of php, and technically the data was already of type Array i tried typesetting the values on that line 976 like this:

              Code:
              $dataLeft = array_merge((array)$dataLeft, (array)$this->y_data[$set]);
              and now it works *shrug*.

              thanks

                Comment

                Previous template Next
                Working...