Ad Widget

Collapse

Wrong SQL in performance advice ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • karo2k9
    Junior Member
    • Jan 2009
    • 27

    #1

    Wrong SQL in performance advice ?

    Hi!

    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);
    ...
    but i think the correct way is:
    MySQL:
    ALTER TABLE `node_cksum` DROP INDEX `node_cksum_1` ;
    CREATE INDEX node_cksum_1 on node_cksum (nodeid,cksumtype,tablename,recordid);
    otherwise it won't work

    Karo
Working...