Performance FRONTEND

[dunbart]

Hi all,

I am monitoring about 600 hosts, ZABBIX has no problem gathering and storing the collected data, housekeeping takes about 15 seconds. The automated 30 seconds refreshment of the "Triggers" page takes way to much time. A "top" tells me that during that particular action the mysqld process claims 99,9 % of the CPU. So I started tuning the my.cnf, but not even the slightest improvement! Someone any ideas?

Using ZABBIX 1.1.4, AS4, MySQL 4.1.12, Dual Xeon, 4 GB of memory.

Greetings, dunbart

[Alexei]

How many triggers you have?

[dunbart]

Hi Alexei,

Tomorrow, when I am in the office I shall give you the exact numbers. I guess there are at this moment about 6000 triggers, the number of triggers varies per host. Browsing the "Latest Data" has the same effect on the CPU usage. Browsing the "Configuration" part of the frontend gives less problems.

Thanks for so far, dunbart

[Alexei]

What storage engine do you use for MySQL? I think that MyISAM may slow down things quite significantly on busy systems.

The Status of Triggers page refreshes in 0.3-1 second on our test MySQL InnoDB and PostgreSQL servers having 2K of triggers.

[dunbart]

Alexei, thanks for the response. Here's the requested information

ZABBIX server is running Yes
Number of hosts 961(601/353/7/0)
Number of items 10720(4224/6494/2)[1]
Number of triggers 3915(3912/3)[134/0/3778]

I have used the Bulkloader to add hosts. The hosts are imported with the "Not Monitored" option. After I imported the last 400 hosts, the performance instantly went down! But they are not monitored at that particular time. I have enabled them later. Im am using out of the box MySQL which comes with AS4, it uses innodb.

Greetings, dunbart

[Alexei]

It is quite difficult to say why it works slow without seeing detailed statistics of disk/CPU usage and MySQL configuration file.

Make sure that innodb_buffer_pool_size is set to some high value (say, 2-3GB) in my.cnf.

[dunbart]

Alexei,

Seems like ZABBIX has trouble finding the right data to create the "Latest Data" and "Trigger" overviews. Gonna start with a fresh database and importing all my hosts again with the Bulkloader. I will keep you informed. Thanks for so far.

Greetings, dunbart

[dunbart]

Alexei,

First of all, best wishes for 2007!

I have found a workaround for the poor performance of the ZABBIX frontend on my server. I have decreased the number of hostgroups. I started with about 220 hostgroups for my 600 hosts. At the moment I am monitoring about 700 hosts, 5000 items, 4500 triggers, using about 50 hostgroups and the performance is quite good. It is easy to reproduce the problem, just import the 600 hosts combined with the 220 hostgroups using the bulkloader. In my particular case the performance instantly became worse, the hosts were not even monitored at that time. Have I ran into a bug? Hope this is usefull information for you.

Greetings, dunbart

[Alexei]

Thanks!

Does it affect all pages of the frontend or only specific ones?

[dunbart]

Alexei,

As I have mentioned before it this problem particulary affects browsing the "Latest Data" and the autorefreshment of the "Triggers" overview. Using the frontend in "Configuration" mode gives less problems.

Greetings, dunbart

[Alexei]

Thanks for the additional info!

[exkg]

Hi,

I think that the number of hosts groups is the 'villain'. We have the same behavior here .... but we cant decrease the host groups



[]s,
Luciano

[Aly]

I've created 500+ host groups with monitored hosts in it and currently I don't see any performance issues..

[exkg]

Thanks Aly,

What plataform are u using ?
We have here a good server (8CPUs, 32GB and FC storage).
Our 'Stauts of ZABBIX':

===
ZABBIX server is running Yes -
Number of hosts 1171 997 / 138 / 36 / 0
Number of items 12354 11112 / 1137 / 105 [570]
Number of triggers 2728 2728 / 0 [53 / 285 / 2390]
Number of users (online) 24 6
Required server performance, new values per second 173.5924 -
===

We have tuned MySQL (after tried ORACLE). All plataform (Database, ZABBIX Server an GUI) are in de same server. Some operations in GUI are slow when GUI needs to check permissions (screens, maps, triggers).

Our plataform uses:
- SuSe Linux ES 9
- Apache2
- MySQL 5.1
- PHP 4.2

So ... I dont know where put hands to better performance (in next week we will try a SO upgrade).

Have u information about somebody using 'PHP Accelerator / Turck MMCache / Apache mod_proxy' or something similar to increase performance ? But I'm doubt because the contents of ZABBIX can bring from 'cache' and we get 'mistakes' in GUI.




[]s,
Luciano

[xs-]

Check the following tips (if you haven't done so already)
- Seperate webserver from database server
- Run either eaccelerator or APC (alternative php cache), both php cachers/accelerators