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.
