Ad Widget

Collapse

Maps & Screens with many hosts slow.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • maxlock
    Member
    • Mar 2005
    • 32

    #1

    Maps & Screens with many hosts slow.

    Hi Folks,

    Thought I'd bring this up for discussion. We've got 1000 monitored hosts in our deployment and all hosts are setup in various maps and screens.

    A big problem with this is the speed that zabbix takes to check the permissions of objects not only on maps being viewed but also any linked maps. In our case pretty much all 1000 hosts permissions are checked!

    Our workaround for this is to disable permission checks for anyone other than guest by doing the following in include/maps.inc.php:

    function sysmap_accessiable($sysmapid,$perm)
    {
    global $USER_DETAILS;

    //bypass permissions checks
    if($USER_DETAILS['userid'] != 2) {
    return true;
    }

    and the same in include/screens.inc.php

    function screen_accessiable($screenid,$perm)
    {
    global $USER_DETAILS;
    //echo "<pre>".print_r($USER_DETAILS,true)."</pre>";

    //bypass permissions checks
    if($USER_DETAILS['userid'] != 2) {
    return true;
    }

    Now this runs a _lot_ faster, but it's not ideal. is there a better way of doing this when rendering the maps/screens so that only those being directly shown are checked?

    -Cheers Max.
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    I think this has been resolved in 1.4.5.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • maxlock
      Member
      • Mar 2005
      • 32

      #3
      Hi Alexi.

      We're running 1.4.5 currently, so I guess it's at least being/been looked at

      -Cheers Max.

      Comment

      • teferi
        Member
        • Jul 2008
        • 93

        #4
        Originally posted by Alexei
        I think this has been resolved in 1.4.5.
        Sorry for bringing up this thread from the dead. But I had exactly the same problem and it resolved it exactly the same way.
        using 1.5.3 beta

        Comment

        • exkg
          Senior Member
          Zabbix Certified Trainer
          Zabbix Certified Specialist
          • Mar 2007
          • 718

          #5
          And what is your scenario ? We have the same problem and (try) the same workaround .... but with Oracle in backend, after change to MySQL things are working fine until now.

          Our scenario is:

          - Zabbix 1.5.3-5868
          - Oracle 10G (now is MySQL)
          - ~1300 hosts
          - ~9000 itens
          - ~3500 triggers
          - ~160 screens
          - ~120 maps
          - ~300 groups
          - ~250 insert/second
          - 8 CPUs
          - 32 GB of memory
          - single scsi discs



          []s,
          Luciano
          --
          Luciano Alves
          www.zabbix.com
          Brazil | México | Argentina | Colômbia | Chile
          Zabbix Performance Tuning

          Comment

          • teferi
            Member
            • Jul 2008
            • 93

            #6
            Sorry for not responding so long.
            I have about 1000 hosts with a total of about 40000 items and 1000 screens(1 for each host), MySQL-Innodb. Obviously function that determines user-permitions scans half the DB in my case. =(

            Comment

            Working...