I'm using zabbix 1.5.3 with 1 server and 3 proxies. Server itself only monitors 3 hosts where proxies run everything else - via proxies. Proxies monitor about 350 hosts each to a total of about 1000 hosts. All hosts are linked to one template with 18 items (9 of them are refreshed every minute, others once a much longer period of time). More than that some are disabled as the are not supported by agents. Anyway the Dashboard reports that there are 18411 monitored items and "Required server performance, new values per second" is only 160.5525.
But everything is terribly slow! There are gaps in graphs, and it seems like server stops receiveing data at some point. Triggers with nodata() function applied to agent.ping key become TRUE althow I can manually telnet to those hosts. zabbix_server.log and zabbix_proxy.log does not give any clue to why that's happening. (except for zabbix_proxy.log containes smth like "Query failed: [create table items_itemid_tmp (itemid bigint unsigned)] Table 'items_itemid_tmp' already exists [1050]", but I do not think it's the problem.)
On server machine mysqld uses almost all prcoessor time avaliable.
Can you suggest any solutions? Or maybe at least point me where I could search for them(e.g. tuning mysql, althow I already did this, or smth.).
Few words about server machine:
FreeBSD 7.0 , AMD Athlon 64 X2 Dual Core Processor 4800, with 4 Gigs of physical memory. Right now it runs only mysql+zabbix_server+apache(for the frontend) I do not think it's slow hardware or smth.
But everything is terribly slow! There are gaps in graphs, and it seems like server stops receiveing data at some point. Triggers with nodata() function applied to agent.ping key become TRUE althow I can manually telnet to those hosts. zabbix_server.log and zabbix_proxy.log does not give any clue to why that's happening. (except for zabbix_proxy.log containes smth like "Query failed: [create table items_itemid_tmp (itemid bigint unsigned)] Table 'items_itemid_tmp' already exists [1050]", but I do not think it's the problem.)
On server machine mysqld uses almost all prcoessor time avaliable.
Can you suggest any solutions? Or maybe at least point me where I could search for them(e.g. tuning mysql, althow I already did this, or smth.).
Few words about server machine:
FreeBSD 7.0 , AMD Athlon 64 X2 Dual Core Processor 4800, with 4 Gigs of physical memory. Right now it runs only mysql+zabbix_server+apache(for the frontend) I do not think it's slow hardware or smth.
Comment