Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

MySQL database missing index

Avatar

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.

0 Replies