performance tunning / best practise?

[Gav]

Hi,

I am quite new to zabbix, so be patient :-)

Right now, I have zabbix 1.8.3 (host 1x intel xeon 5504, 4GB ram, 4x TB linux raid 5) and PostgreSQL 8.1.21

I have only 20 monitored hosts, some active checks via agent, some passive via SNMP

I have about 15 values per. sec (I am monitoring quite lot of thing per host in 30/60 sec interval)

Performance of web gui is so slow (dashboard is ok, but anything under hosts-config takes lot of time to display)

Is that problem of default config of Postgre?

This is more or less test enviroment, I am thinking about new instalation in production enviroment

We will monitor about 300hosts, each with approx. 50 items (combination of agent and snmp), values checked every 60 sec.

What you would recommand? Postgre? Mysql? saome tweaks?

Thanks & Regards

[Zaniwoop]

You might want to investigate the deflate module in apache to speed up the interface. (Really WOW!)

there are a number of posts about mysql tuning on the forums

[Gav]

You might want to investigate the deflate module in apache to speed up the interface. (Really WOW!)

there are a number of posts about mysql tuning on the forums

and for such installation would you recommand postgre or mysql (myisam or innodb?)

[Zaniwoop]

I use mysql. Just a personal preference and I am too old to change

I use innodb with per file tables, for performance.

423 hosts
17403 items
271 New Values per Second

[nth]

You can stick to postgres as well if you already have it up&running. But yes, you have to tweak the config to get better performance, as the defaults are pretty conservative. But the documentation is very well written so you shouldn't have problems modifying the configuration to suit your system.

I'd also recommend upgrading to a more recent version if you can (8.4.5 and 9.0.1 are out), there are official packages for a lot of platforms. Installing a pooler such as pgbouncer also helps, and of course running the sql backend, http server and zabbix server on separate machines does wonders. Depending on your setup, for the latter two it doesn't even have to be something fancy (I have zabbix_server and httpd running on an old P4 machine and there's no noticeable delay with an average load on the system of 0.3).