Performance on Zabbix Server

[ZABFLD]

Hi Everybody
We create Zabbix infrastructure with 2 Zabbix server build on cluster active - passive mode. Before this cluster we have 2 zabbix proxy server. How requirements for zabbix server and zabbix proxy we have following ressource

Zabbix Server
8 vCPU / 32 Gb RAM
HD 500 Go
Ubuntu 16.04

Zabbix Proxy
4 vCPU / 8 Gb RAM
HD 100 Go
Ubuntu 16.04

On zabbix dashboard I have following informations :

Zabbix server is running	Yes	localhost:10051
Number of hosts (enabled/disabled/templates)	1988	1851 / 22 / 115
Number of items (enabled/disabled/not supported)	114421	35467 / 77907 / 1047
Number of triggers (enabled/disabled [problem/ok])	50432	19205 / 31227 [427 / 18778]
Number of users (online)	5	1
Required server performance, new values per second	386.92

With that we have bad performance and display is very slow . My first question is : configuration for zabbix proxy and server are correct ?.

Is it necessary to adapt some .conf file ?

Tell me if you need more information , file , screencopy for help us

Thanks in advance

[ZABFLD]

That's mean our Zabbix server configuration is ok ? What do you wants to mean by how many agents and how many action ?

[ingus.vilnis]

Database performance is the key. From the description looks like that is the first thing to start with.

8CPU / 32GB is fully sufficient for <400 nvps you have now. Throwing more hardware resources to it will not solve the root cause of your slowness problems.

[bienhv]

Hi all,
I am writing an API to return System information data. I am using get_status() it return null data when the dashboard have the data as below.
System information

Zabbix server is running	Yes	127.0.0.1:10051
Number of hosts (enabled/disabled/templates)	111	15 / 8 / 88
Number of items (enabled/disabled/not supported)	706	138 / 552 / 16
Number of triggers (enabled/disabled [problem/ok])	395	91 / 304 [5 / 86]
Number of users (online)	17	1
Required server performance, new values per second	17.11

I using SQL query to select data from database. But the data for number of items, number of triggers, number of users and server performance doesn't math with the dashboard. My code as below:
// Items
select count(itemid) as numberOfItems from items; => 2630
select count(itemid) as numberOfItems from items JOIN hosts on hosts.hostid = items.hostid where hosts.`status`=0; => 228
select count(itemid) as numberOfItemEnabled from items JOIN hosts on hosts.hostid = items.hostid where items.STATUS = 0 AND hosts.`status`=0; => 228
select count(itemid) as numberOfItemDisabled from items JOIN hosts on hosts.hostid = items.hostid where items.STATUS = 1 AND hosts.`status`=0; => 0
select count(itemid) as numberOfItemNotSupported from items JOIN hosts on hosts.hostid = items.hostid where items.state = 1 AND hosts.`status`=0; => 16

My reslult:

Number of items (enabled/disabled/not supported)

228

228/ 0/ 6

Web Dashboard:

Number of items (enabled/disabled/not supported)

706

138 / 552 / 16

// Trigger
select count(triggerid) as numberOfTrigger from triggers; => 1329 select count(triggerid) as numberOfTriggerEnabled from triggers where status = 0; => 1328 select count(triggerid) as numberOfTriggerDisabled from triggers where status = 1; => 1 select count(triggerid) as numberOfTriggerOn from triggers where value = 0; => 1273 select count(triggerid) as numberOfTriggerOff from triggers where value = 1; => 56

My reslult:

Number of triggers (enabled/disabled [problem/ok])

1391

1390/ 1[1332/ 59]

Web Dashboard:

Number of triggers (enabled/disabled [problem/ok])

395

91 / 304 [5 / 86]

// Number user online
//Number of users (online) $numberOfUser = DBfetch(DBselect('select count(userid) as numberOfUser from users')); $numberOfUserSessions = DBfetchArray(DBselect('select distinct(userid) from sessions')); $numberOfUserOnline = 0; foreach ($numberOfUserSessions as $userSession) { $sessionStatus = DBfetchArray(DBselect('select * from sessions where userid = '.$userSession['userid'].' order by lastaccess desc limit 2')); if($sessionStatus[0]['status'] !== $sessionStatus[1]['status']) { $numberOfUserOnline = $numberOfUserOnline + 1; } }

My reslult:

Number of users (online)

17

2

Web Dashboard:

Number of users (online)

17

1

// Server performance
$vps_total = DBfetch(DBselect( 'SELECT sum(vps) AS vps FROM ( SELECT count(*),count(*)/i.delay as vps FROM items i JOIN hosts h ON i.hostid=h.hostid WHERE i.status=0 AND h.status=0 AND i.type=0 GROUP BY i.type,i.delay ORDER BY i.type, i.delay ) as data' )); $server_performance = round($vps_total['vps'], 2);

My reslult:

Required server performance, new values per second

8.78

Web Dashboard:

Required server performance, new values per second

17.11

Please suggest help me the right SQL query for the result same as the web dashboard.

Thank & best regards,
BienHV