0 Replies Latest reply on Oct 19, 2010 8:14 AM by semsup

    MySQL database missing index

    semsup Level 1

      Hi All,

       

      Thought I'd share this with the forum as someone else might have the same problem. We had CPU maxed out on our livecycle server a while ago. Traced it to MySQL and a query that livecycle was running that involved a complete table scan.

       

      mysql> use adobe;
      Database changed
      mysql> ALTER TABLE EDCREVOKATIONENTITY ADD index EDCREVOKATIONENTITY$ix$updatedate ( updatedate );
      Query OK, 267851 rows affected (15 min 32.22 sec)
      Records: 267851  Duplicates: 0  Warnings: 0

      Adding this index fixed the problem straight away.

      g.