Hi!
On http://zabbix.com/rn1.8.2.php
you can read the following advice:
but i think the correct way is:
otherwise it won't work
Karo
On http://zabbix.com/rn1.8.2.php
you can read the following advice:
...
If you are using Zabbix 1.8 with node-based distributed setup, please run the following SQL patch. It should improve performance of configuration syncing a lot.
MySQL:
DROP INDEX node_cksum_cksum_1 ON node_cksum;
CREATE INDEX node_cksum_1 on node_cksum (nodeid,cksumtype,tablename,recordid);
...
If you are using Zabbix 1.8 with node-based distributed setup, please run the following SQL patch. It should improve performance of configuration syncing a lot.
MySQL:
DROP INDEX node_cksum_cksum_1 ON node_cksum;
CREATE INDEX node_cksum_1 on node_cksum (nodeid,cksumtype,tablename,recordid);
...
MySQL:
ALTER TABLE `node_cksum` DROP INDEX `node_cksum_1` ;
CREATE INDEX node_cksum_1 on node_cksum (nodeid,cksumtype,tablename,recordid);
ALTER TABLE `node_cksum` DROP INDEX `node_cksum_1` ;
CREATE INDEX node_cksum_1 on node_cksum (nodeid,cksumtype,tablename,recordid);
Karo