Skip navigation
semsup
Currently Being Moderated

MySQL database missing index

Oct 19, 2010 8:14 AM

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.

 

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points