Hi all,
I would like to ask the reason why tables history, history_str and history_uint don't have primary keys. We are partitioning theese tables and in the original zabbix appliance we can see as they haven' t primary keys.
I also would like to know why in the HOW-TO's about zabbix database partitioning primary keys are deleted in the partitioned tables. We are trying to configure primary keys in those tables and it probably works ok.
Our partitioned tables are:
acknowledges, alerts, auditlog, events, history, history_log, history_str, history_text, history_uint, service_alarms, trends, trends_uint and sessions.
We are currently using Zabbix v2.2.2.
Thanks in advance. Best regards!
I would like to ask the reason why tables history, history_str and history_uint don't have primary keys. We are partitioning theese tables and in the original zabbix appliance we can see as they haven' t primary keys.
I also would like to know why in the HOW-TO's about zabbix database partitioning primary keys are deleted in the partitioned tables. We are trying to configure primary keys in those tables and it probably works ok.
Our partitioned tables are:
acknowledges, alerts, auditlog, events, history, history_log, history_str, history_text, history_uint, service_alarms, trends, trends_uint and sessions.
We are currently using Zabbix v2.2.2.
Thanks in advance. Best regards!