Zabbix performance optimizing

[Colttt]

how many db_syncers do you use??

please post you hardware enviroment and you postgresql.conf!

[avecsi]

how many db_syncers do you use??

please post you hardware enviroment and you postgresql.conf!

Hi,

I use 4 db syncers - I think thats the default settings

All box are Vm and running Ubuntu 12.04 TLS and using FC SAN
Always 1 vritual socket and 1vcpu is 2000MHz

Webinterface:
2vcpu and 8GB ram

Zabbix server
4vcpu 8GB ram

DB box:
4vcpu and 16GB ram


My postgressql config is the default config file with:
datestyle = 'iso, dmy'
default_text_search_config = 'pg_catalog.english'

Package: postgresql-9.1
New: yes
State: installed
Automatically installed: yes
Version: 9.1.11-0ubuntu0.12.04

I didnt do any optimization on the postgresql yet.

[avecsi]

I changed
MaxHousekeeperDelete=200 to MaxHousekeeperDelete=40

Housekeeper still running for 3hours.

Is that possible to turn off HK and do it manually?

[avecsi]

zabbix=> SELECT pg_database.datname, pg_database_size(pg_database.datname), pg_size_pretty(pg_database_size(pg_database.datnam e)) FROM pg_database ORDER BY pg_database_size DESC;
datname | pg_database_size | pg_size_pretty
-----------+------------------+----------------
zabbix | 149852889912 | 140 GB

zabbix=> SELECT nspname || '.' || relname AS "relation",
zabbix-> pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
zabbix-> FROM pg_class C
zabbix-> LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
zabbix-> WHERE nspname NOT IN ('pg_catalog', 'information_schema')
zabbix-> AND C.relkind <> 'i'
zabbix-> AND nspname !~ '^pg_toast'
zabbix-> ORDER BY pg_total_relation_size(C.oid) DESC
zabbix-> LIMIT 20;
relation | total_size
---------------------------+------------
public.history | 74 GB
public.history_uint | 55 GB
public.trends_uint | 4931 MB
public.trends | 2395 MB
public.alerts | 1932 MB
public.items | 593 MB
public.events | 391 MB
public.sessions | 69 MB
public.history_str | 47 MB
public.history_text | 33 MB


My histroy table is a little bit big

[avecsi]

I disabled unnecessary items and triggers for one of my biggest template
Before:
Required server performance, new values per second 213.17

After:
Required server performance, new values per second 130.08

I should start with this