search

zensqlmonitor / influxdb-zabbix

Gather data from Zabbix back-end and load to InfluxDB in near real-time for enhanced performance and easier usage with Grafana.
MIT License
71 stars 26 forks source link

mysql problems generating indexes #21

Open RandomReaper opened 3 years ago

RandomReaper commented 3 years ago

Those commands fails because some indexes are not unique:

 CREATE UNIQUE INDEX idx_history_clock_ns_itemid
    ON history (clock) USING btree;
 CREATE UNIQUE INDEX idx_history_uint_clock_ns_itemid
    ON history_uint (clock) USING btree;

Should I run them without "UNIQUE"?