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

    MySQL database missing index

    semsup

      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.