Hi,
Thank you for your product. Zabbix is very great. The only issue i have is the high load on the database server.I'm installed a freshzabbix 1.6.1 on our server.I have created a kvm image for the
php GUI (centos 5) and the postgresql 8.1/8.3 is running directly ( no virtualization ) but the Load is always very high.
some hardware details
2x quadcore Intel(R) Xeon(R) CPU E5335 @ 2.00GHz
8GB Ram
hdparm -tT /dev/md4
/dev/md4:
Timing cached reads: 10008 MB in 2.00 seconds = 5008.79 MB/sec
Timing buffered disk reads: 248 MB in 3.02 seconds = 82.03 MB/sec
top - 16:29:32 up 8 days, 20:10, 1 user, load average: 2.49, 2.29, 2.35
Tasks: 136 total, 2 running, 133 sleeping, 0 stopped, 1 zombie
Cpu(s): 30.9%us, 4.5%sy, 0.0%ni, 61.0%id, 3.4%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 8312900k total, 8078536k used, 234364k free, 272772k buffers
Swap: 1060272k total, 64k used, 1060208k free, 6409536k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11366 postgres 20 0 41056 20m 18m S 58 0.2 541:26.62 postmaster
11365 postgres 20 0 41056 20m 18m S 53 0.2 550:03.55 postmaster
11364 postgres 20 0 40920 20m 18m S 50 0.2 540:40.02 postmaster
11363 postgres 20 0 42116 20m 18m R 50 0.3 545:54.96 postmaster
32480 root 20 0 981m 659m 17m S 37 8.1 2192:34 qemu-kvm
11368 postgres 20 0 40796 19m 18m S 10 0.2 5:19.43 postmaster
29431 root 20 0 980m 498m 17m S 8 6.1 1682:04 qemu-kvm
11318 postgres 20 0 39216 9280 8876 S 5 0.1 2:50.88 postmaster
30525 zabbix 25 5 2732 832 700 S 3 0.0 38:45.37 zabbix_agentd
11324 postgres 20 0 8648 2224 544 S 3 0.0 38:53.96 postmaster
11323 postgres 20 0 8260 1820 408 S 3 0.0 32:53.53 postmaster
11362 postgres 20 0 41224 20m 18m S 1 0.3 547:09.88 postmaster
11379 postgres 20 0 40752 19m 18m S 1 0.2 18:42.15 postmaster
11378 postgres 20 0 40104 19m 18m S 1 0.2 13:45.70 postmaster
28069 root 20 0 6272 1984 1592 S 0 0.0 0:04.27 sshd
with
zabbix=# select * from pg_stat_activity;
i see only 2 connections that not are idle:
2651910 | zabbix | 11364 | 16564 | zabbix | select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns,i.para ms,i.trends,h.useipmi,h.ipmi_port,h.ipmi_authtype, h.ipmi_privilege,h.ipmi_username,h.ipmi_password,i .ipmi_sensor from hosts h, items i where i.nextcheck<=1227799945 and i.status in (0,3) and i.type not in (2,7,9,12) and h.status=0 and h.disable_until<=1227799940 and h.errors_from=0 and h.hostid=i.hostid and (h.proxy_hostid=0 or i.type in (5)) and mod(i.itemid,5)=2 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid between 000000000000000 and 099999999999999 order by i.nextcheck | 2008-11-27 16:32:45.136194+01 | 2008-11-26 13:25:01.377404+01 | 10.7.100.8 | 56804
2651910 | zabbix | 11365 | 16564 | zabbix | <IDLE> | 2008-11-27 16:32:47.4397+01 | 2008-11-26 13:25:01.37735+01 | 10.7.100.8 | 56805
2651910 | zabbix | 11363 | 16564 | zabbix | select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns,i.para ms,i.trends,h.useipmi,h.ipmi_port,h.ipmi_authtype, h.ipmi_privilege,h.ipmi_username,h.ipmi_password,i .ipmi_sensor from hosts h, items i where i.nextcheck<=1227799947 and i.status in (0,3) and i.type not in (2,7,9,12) and h.status=0 and h.disable_until<=1227799942 and h.errors_from=0 and h.hostid=i.hostid and (h.proxy_hostid=0 or i.type in (5)) and mod(i.itemid,5)=1 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid between 000000000000000 and 099999999999999 order by i.nextcheck | 2008-11-27 16:32:47.213952+01 | 2008-11-26 13:25:01.378015+01 | 10.7.100.8 | 56803
Status of ZABBIX
ZABBIX server is running Yes -
Number of hosts (monitored/not monitored/templates) 54 7 / 0 / 47
Number of items (monitored/disabled/not supported) 738 674 / 0 / 64
Number of triggers (enabled/disabled)[true/unknown/false] 9 9 / 0 [0 / 0 / 9]
Number of users (online) 4 1
Required server performance, new values per second 7 -
i have changed default update intervall to > 60 seconds in any template
any suggestion / help ?
Thank you for your product. Zabbix is very great. The only issue i have is the high load on the database server.I'm installed a freshzabbix 1.6.1 on our server.I have created a kvm image for the
php GUI (centos 5) and the postgresql 8.1/8.3 is running directly ( no virtualization ) but the Load is always very high.
some hardware details
2x quadcore Intel(R) Xeon(R) CPU E5335 @ 2.00GHz
8GB Ram
hdparm -tT /dev/md4
/dev/md4:
Timing cached reads: 10008 MB in 2.00 seconds = 5008.79 MB/sec
Timing buffered disk reads: 248 MB in 3.02 seconds = 82.03 MB/sec
top - 16:29:32 up 8 days, 20:10, 1 user, load average: 2.49, 2.29, 2.35
Tasks: 136 total, 2 running, 133 sleeping, 0 stopped, 1 zombie
Cpu(s): 30.9%us, 4.5%sy, 0.0%ni, 61.0%id, 3.4%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 8312900k total, 8078536k used, 234364k free, 272772k buffers
Swap: 1060272k total, 64k used, 1060208k free, 6409536k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11366 postgres 20 0 41056 20m 18m S 58 0.2 541:26.62 postmaster
11365 postgres 20 0 41056 20m 18m S 53 0.2 550:03.55 postmaster
11364 postgres 20 0 40920 20m 18m S 50 0.2 540:40.02 postmaster
11363 postgres 20 0 42116 20m 18m R 50 0.3 545:54.96 postmaster
32480 root 20 0 981m 659m 17m S 37 8.1 2192:34 qemu-kvm
11368 postgres 20 0 40796 19m 18m S 10 0.2 5:19.43 postmaster
29431 root 20 0 980m 498m 17m S 8 6.1 1682:04 qemu-kvm
11318 postgres 20 0 39216 9280 8876 S 5 0.1 2:50.88 postmaster
30525 zabbix 25 5 2732 832 700 S 3 0.0 38:45.37 zabbix_agentd
11324 postgres 20 0 8648 2224 544 S 3 0.0 38:53.96 postmaster
11323 postgres 20 0 8260 1820 408 S 3 0.0 32:53.53 postmaster
11362 postgres 20 0 41224 20m 18m S 1 0.3 547:09.88 postmaster
11379 postgres 20 0 40752 19m 18m S 1 0.2 18:42.15 postmaster
11378 postgres 20 0 40104 19m 18m S 1 0.2 13:45.70 postmaster
28069 root 20 0 6272 1984 1592 S 0 0.0 0:04.27 sshd
with
zabbix=# select * from pg_stat_activity;
i see only 2 connections that not are idle:
2651910 | zabbix | 11364 | 16564 | zabbix | select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns,i.para ms,i.trends,h.useipmi,h.ipmi_port,h.ipmi_authtype, h.ipmi_privilege,h.ipmi_username,h.ipmi_password,i .ipmi_sensor from hosts h, items i where i.nextcheck<=1227799945 and i.status in (0,3) and i.type not in (2,7,9,12) and h.status=0 and h.disable_until<=1227799940 and h.errors_from=0 and h.hostid=i.hostid and (h.proxy_hostid=0 or i.type in (5)) and mod(i.itemid,5)=2 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid between 000000000000000 and 099999999999999 order by i.nextcheck | 2008-11-27 16:32:45.136194+01 | 2008-11-26 13:25:01.377404+01 | 10.7.100.8 | 56804
2651910 | zabbix | 11365 | 16564 | zabbix | <IDLE> | 2008-11-27 16:32:47.4397+01 | 2008-11-26 13:25:01.37735+01 | 10.7.100.8 | 56805
2651910 | zabbix | 11363 | 16564 | zabbix | select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns,i.para ms,i.trends,h.useipmi,h.ipmi_port,h.ipmi_authtype, h.ipmi_privilege,h.ipmi_username,h.ipmi_password,i .ipmi_sensor from hosts h, items i where i.nextcheck<=1227799947 and i.status in (0,3) and i.type not in (2,7,9,12) and h.status=0 and h.disable_until<=1227799942 and h.errors_from=0 and h.hostid=i.hostid and (h.proxy_hostid=0 or i.type in (5)) and mod(i.itemid,5)=1 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid between 000000000000000 and 099999999999999 order by i.nextcheck | 2008-11-27 16:32:47.213952+01 | 2008-11-26 13:25:01.378015+01 | 10.7.100.8 | 56803
Status of ZABBIX
ZABBIX server is running Yes -
Number of hosts (monitored/not monitored/templates) 54 7 / 0 / 47
Number of items (monitored/disabled/not supported) 738 674 / 0 / 64
Number of triggers (enabled/disabled)[true/unknown/false] 9 9 / 0 [0 / 0 / 9]
Number of users (online) 4 1
Required server performance, new values per second 7 -
i have changed default update intervall to > 60 seconds in any template
any suggestion / help ?
Attached Files
Comment