-
Incident report
-
Resolution: Won't fix
-
Critical
-
None
-
1.8.9
-
Server: Red Hat 4.1.2-46,16 cores, 32G.
3 Proxy:Red Hat 4.1.2-46, 4 cores, 8G,
Oracle server: Red Hat 4.1.2-46, 16 cores, 16G, 10 SATA disk, Oracle 11.2.0.3.0
========================================================
Zabbix Performance:
Number of hosts (monitored/not monitored/templates) 4751 3445 / 1194 / 112
Number of items (monitored/disabled/not supported) 569221 530812 / 24719 / 13690
Number of triggers (enabled/disabled)[problem/unknown/ok] 196589 128102 / 68487 [1119 / 42324 / 84659]
Number of users (online) 73 12
Required server performance, new values per second 1411.19 -Server: Red Hat 4.1.2-46,16 cores, 32G. 3 Proxy:Red Hat 4.1.2-46, 4 cores, 8G, Oracle server: Red Hat 4.1.2-46, 16 cores, 16G, 10 SATA disk, Oracle 11.2.0.3.0 ======================================================== Zabbix Performance: Number of hosts (monitored/not monitored/templates) 4751 3445 / 1194 / 112 Number of items (monitored/disabled/not supported) 569221 530812 / 24719 / 13690 Number of triggers (enabled/disabled)[problem/unknown/ok] 196589 128102 / 68487 [1119 / 42324 / 84659] Number of users (online) 73 12 Required server performance, new values per second 1411.19 -
I've read release notes after 1.8.8 and these problems have not been fixed.
1. There is a place that curosr open in DB will not be closed in some logic. I read the code and fix it.
2. get-rowid-method is very low performance in zabbix-1.8.8. As we use oracle, we remove the function in source code and use Sequence of oracle to get id.It will solve the TX lock problem in oracle in high scalability. PHP of frontend needs to be modify as well.
3. For oracle, zabbix made a method to compose sql into a large sql, and add 'begin' & 'end'. This will make oracle can not share cursors. Because of that, Oracle will CRASH due to share pool issue.
================================
source code patched is in the attachment