Activity of YOUR Zabbix Server

[fraenki]

Hi,

starting with Zabbix 1.6 there is this nice Dashboard giving usefull information about the overall status of your Zabbix Server. Maybe we could share these statistics here to see how others are using the Zabbix server.

I'm going to make a start... this is the statistic from my Zabbix Server Dashboard:

Number of hosts: 		318
Number of items:		4679
Number of triggers:		3268
Required server performance:	41.7325

Hardware: HP DL380 (Intel Xeon 5140, 4GB RAM, 10k HDD, RAID1)
OS: FreeBSD 7.x

Hope you like the idea of sharing the stats.


bye
- fraenki

[vrtareg]

Hi

Zabbix server 1.6.1

Number of hosts			271
Number of items  		13250
Number of triggers 		1911
Required server performance	150.0202

Areg

[Alexei]

This is one of our test servers running pre 1.6.2:

Number of hosts                    10024
Number of items                    100143
Number of triggers                 10042
Required server performance        376.5101

Note that the required server performance is quite low for this number of items. We do not keep the server busy all the time as we have only 100GB of free disk space there.

[trikke]

Hi

here are mine:

Number of hosts (monitored/not monitored/templates)        481 	  461 / 7 / 13
Number of items (monitored/disabled/not supported)         6890  6556 / 28 / 306
Number of triggers (enabled/disabled)[true/unknown/false]  6491  6211 / 280  [45 / 341 / 5825]
Required server performance, new values per second         36.8967 	-

Patrick

[nelsonab]

It's not the size of your install that matters... but what you monitor... ;-)

[bluelinq]

I added some extra information to display the size of the MySQL database.

Number of hosts (monitored/not monitored/templates) 65 22 / 0 / 43
Number of items (monitored/disabled/not supported) 580 552 / 5 / 23
Number of triggers (enabled/disabled)[true/unknown/false] 222 222 / 0 [0 / 8 / 214]
Number of users (online) 5 1
Required server performance, new values per second 18.1511 -
MySQL Database size 185.2 Mb
MySQL Index size 114.7 Mb

If anyone is interested the changes are in the block.inc.php and the file is attached to this post.

Regards,

Paul

[xs-]

Number of hosts 1182
Number of items 32006
Number of triggers 29849
new values per second 77.7898

[dotneft]

Number of hosts (monitored/not monitored/templates) 148
Number of items (monitored/disabled/not supported) 1714
Number of triggers (enabled/disabled)[true/unknown/false] 652
Required server performance, new values per second 43.3616666667

Gentoo 2.6.25 64bit, Oracle 10g2, 8GB RAM, 2 x Intel(R) Xeon(R) CPU E5420, RAID 2TB.

load average: 2.00, 1.59, 1.39
Mem: 8160416k total, 7459788k used, 700628k free, 284800k buffers
Swap: 15671284k total, 471524k used, 15199760k free, 5111028k cached

[alfiere]

ZABBIX server is running Yes -
Number of hosts (monitored/not monitored/templates) 63 51 / 2 / 10
Number of items (monitored/disabled/not supported) 4448 3626 / 402 / 420
Number of triggers (enabled/disabled)[true/unknown/false] 1423 1062 / 361 [1 / 0 / 1061]
Number of users (online) 5 1
Required server performance, new values per second 129.3191 -

[tchjts1]

I added some extra information to display the size of the MySQL database.

Regards,

Paul

Very nice! Thanks.

Jeff

[FarreUma]

Hi everyone!!

Great idea.

Number of hosts 29
Number of items 2199
Number of triggers 798

Required server performance 75

Farre

[cstackpole]

Number of hosts			92
Number of items	                1214
Number of triggers		421
Number of users			12
Required server performance 	30.0479

[ataylo13]

Number of hosts 2315
Number of items 51363
Number of triggers 28025

Required server performance, new values per second 554.4699

[krisjturn]

Number of hosts (monitored/not monitored/templates) 889
Number of items (monitored/disabled/not supported) 11400
Number of triggers (enabled/disabled)[true/unknown/false] 2148
Required server performance, new values per second 138.1367 -

[lamont]

i can't get this information off my servers where i've synchronized our users to LDAP. i've got servers that have users and sessions tables that are large:

mysql> select count(*) from users;
+----------+
| count(*) |
+----------+
|     2429 | 
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from sessions;
+----------+
| count(*) |
+----------+
|  3112412 | 
+----------+
1 row in set (0.84 sec)

this query is taking ages to return so far (590+ seconds):

mysql> explain SELECT DISTINCT u.userid, MAX(s.lastaccess) as lastaccess, MAX(u.autologout) as autologout, s.status  FROM users u  LEFT JOIN sessions s ON s.userid=u.userid AND s.status=0 WHERE  (u.userid div 100000000000000) in (0)  GROUP BY u.userid,s.status;
+----+-------------+-------+------+---------------+------+---------+------+---------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key  | key_len | ref  | rows    | Extra                                        |
+----+-------------+-------+------+---------------+------+---------+------+---------+----------------------------------------------+
|  1 | SIMPLE      | u     | ALL  | NULL          | NULL | NULL    | NULL |    2387 | Using where; Using temporary; Using filesort | 
|  1 | SIMPLE      | s     | ALL  | NULL          | NULL | NULL    | NULL | 3113254 |                                              | 
+----+-------------+-------+------+---------------+------+---------+------+---------+----------------------------------------------+
2 rows in set (0.00 sec)

i think zabbix is missing an index or two.

hmmm... 3.1 million sessions as guest... i think the automated scripts that i have hitting the zabbix server are creating millions of sessions for guest... not sure how to fix that one...