https://wiki.jasig.org/display/CASUM/JpaTicketRegistry
Hi everyone,
Anyone using MySQL as their Jpa Ticket Registry DB? How can I create the
indexes to avoid deadlocks in Mysql?
CREATE INDEX "ST_TGT_FK_I"
ON SERVICETICKET ("TICKETGRANTINGTICKET_ID")
COMPUTE STATISTICS;
/** Create index on TGT self-referential foreign-key constraint */
CREATE INDEX "TGT_TGT_FK_I"
ON TICKETGRANTINGTICKET ("TICKETGRANTINGTICKET_ID")
COMPUTE STATISTICS;
Source: https://wiki.jasig.org/display/CASUM/JpaTicketRegistry
Thank you,
Francisco
--
You are currently subscribed to cas-user@lists.jasig.org as:
arch...@mail-archive.com
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
